Hello, I'm trying to write a custom report for a customer of mine using the Sage 50 SDK.
The premise of the report is that it should be the same as the Job Site > Income Statement report but with one key difference, to write out all lines including those with 0 values.
I've got this working for the most part but am seeing some weird results.
Lets say for a particular account for a particular project there are 4 values.
a) Active journal entries
b) Last Year journal entries
c) Balance Forward This Year
d) Balance Forward Last Year
Looking at the Job Site > Income Statement report it will sometimes take a + b, sometimes c and sometimes d. I've scoured the SDK documentation and I can't find what the logic dictating this could be.
Any assistance would be greatly appreciated.