Hi All,
I'm using a Jet Report with Navision and trying to design a report which returns all transactions in an account who's offset is a specific Cash Account. I had hoped that the "Bal. Account No." field in the G/L Entry table would consistently show the offsetting account for each transaction, but I find that this field is often blank or contains some other piece of information and not the offsetting account's number. In Navision I am able to "navigate" and determine the offset account for any transaction, but I'm not sure what I can use as a filter in Jet Reports to determine this same information.
Does anyone with Navision have any suggestions they can make? Thanks in advance for any ideas!
Date
Votes
1 comment
-
Jet Reports Historic Posts Quick Note: I may have found a way to do this using the Document No. The report returns all document no listed in the cash account being used as an offset and then that list of numbers is used to return a list of all transactions in other accounts which have the same doc no. Looks like it's working so far.
Please sign in to leave a comment.