0

Problem With GL Exclude Close Function

The fiscal year of our company goes from 12/01/15 to 11/30/16. However, we want to create sales reports based on the calendar year 01/01/16 through 12/31/16.

I have created the following GL function: =-GL("Balance","49990",B17,C17,,,,,,,,"Viking",,"True")

Where:
"49990" is the GL account for sales
B17 = 01/01/16
C17 = 12/31/16
"Viking" is the Navision database name for the company in question

The resulting value of the formula is including the closing transactions occurring on C11/30/16 that Navision creates during the "close year" function. How do I exclude the closing entries?

I know I am missing something very simple in the formula, I just can't see it. Any ideas? Thanks

1 comment

Please sign in to leave a comment.