Report NAV017 - Accounts Receivable Summary

Questions and Answers asked by users to users, about how others use Jet Express.

Report NAV017 - Accounts Receivable Summary

Postby backstreetboy » Wed Oct 26, 2016 7:58 am

Hello
I'd like to have the "Shipped not invoiced" field appear on the aforementioned report.
Is it also possible to let it show overdue amounts based on 31 day months eg:
1 - 31 days 32 - 62 days 63 - 92 days "More than \92 days"?
Attachment(s)
How it currently looks..PNG Image
How it should look..PNG Image
backstreetboy
 
Posts: 2
Joined: Wed Oct 26, 2016 7:48 am

Re: Report NAV017 - Accounts Receivable Summary

Postby MWilson » Wed Oct 26, 2016 8:33 am

Hello backstreetboy,

I have attached a modified copy of the report that includes the 'Shipped Not Invoiced' field and increased to 31 days.
If you need the date calculations changed you can switch the report into Design Mode and modify the formulas in columns C and D to whatever date ranges you desire.

Best regards,
MWilson
Attachments
NAV017 - Accounts Receivable Summary_Modified.xlsx
(59.27 KiB) Downloaded 58 times
MWilson
 
Posts: 157
Joined: Mon Mar 31, 2014 8:37 am

Re: Report NAV017 - Accounts Receivable Summary

Postby backstreetboy » Thu Oct 27, 2016 12:02 am

Thank you! You're doing the Lord's work.
backstreetboy
 
Posts: 2
Joined: Wed Oct 26, 2016 7:48 am


Return to Ask the Community

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron