Notifications
Announcements
No record found.
How to add item quantity sold to a RM customer statement?
*This post is locked for comments
To make modifications to the customer statement to include detail would require much more customization than simply adding a quantity sold field. This is not what this report was meant to do, but it can be done. First, sales-based reports handle inventory movements, and AR handles distributions to the GL. If you want to include inventory movements into an AR report, you are going to need to add all the related sales tables that originated the AR documents that feed to the customer statement.
There are so many faster / easier options:
You should consider making a Smart List for what you are asking. Creating a template in Excel using a formatting macro and Smart List exports is an elegant solution to not customizing Report Writer reports which everyone hates. If you installed SSRS with your GP 10, create a SQL report. SSRS reports are an excellent way to get customized reporting with no more expense than your time to create them. The other cool thing is SSRS reports are not unique to GP, so there is a wealth of information to be found on how to build and deploy them. Try a Google search on "SQL Report Builder," and see what kind of hits you get.
I agree. Customer statements show what they owe, not what they purchased. The separate sales orders show what they purchased.
Now, some people need something like this for commissions and rebates. This is best supported with a program by EthoTech out of Atlanta that handles commissions and such. Contact them if this is what you are looking for.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
