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
Date
Votes
1 comment
-
Jet Reports Historic Posts Got it to work!
I deleted the entire Excel row and retyped everything and it worked.
Please sign in to leave a comment.