I have managed to pull the monthly trial balance into Excel via Jet in the normal table format, ie. with headers as follows:
Account No, Account Name, Account Type, Month 1, Month 2, Month 3 …. etc
However for other reasons, I would like to get the data in the following format - any ideas please as I am new to Jet:
Account No - Accounts Name - Account Type - Month - Balance
01000 - Account 1 - Posting - Month 1 - £xxx
01000 - Account 1 - Posting - Month 2 - £xxx
01000 - Account 1 - Posting - Month 3 - £xxx
etc
Thanks
Date
Votes
1 comment
-
Jet Reports Historic Posts I'm curious to see your report. Are you able to upload it for review? You can be in design mode so the data won't be shown but I'm curious how you got the months built out in Express.
Please sign in to leave a comment.