450
I am trying to make a report that will show the GL aged receivables by regional divisions. Our company has three locations and the accounts receivable has a separate account for each location. I am trying to find a way to either make a Smartlist or other report that will show the GL aged receivables for each division.
*This post is locked for comments
Yes, makes sense but still have additional ?
I can be contacted at mbnet61@hotmail.com
Thank you
Most of our work is performed for a single customer, but individual jobs are given job numbers. Each job is assigned to an individual regional division. Invoices, materials, and labour are coded to the job numbers and we are able to keep track of the cost of goods sold based on each region.
What I am looking for is a way to create an aged trial balance that shows the separate individual GL AR accounts only for the last day of our fiscal year end. For example, on May 31, 2014 it would show an aged balance for 1420 North Division, 1430 East Division, and 1440 South Division.
I hope this makes sense.
Stacy,
A smartlist query or SmartlistBuilder (view) is a good direction as a reporting tool but
first couple of questions regarding setup and process
How are customers setup?
Are you using Customer Classes to group customers by location?
Do customers buy across locations?
Are you capturing any divisional information on the receivable transaction?
Let me know if can be of any further assistance
Thank you
Michael Bloom
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (