Announcements
No record found.
Client is looking for a report that will list items that were invoiced and shipped from stock. If they had to be back ordered then they would not appear on the list.I was looking at the fields in the SOP30300 and I do not see any combinations of values will give you this. I was then thinking about using the master number and then find the first invoice generated off the order and then look for any invoices generated after that date. The only problem I see here is that perhaps the end user client did not want to receive any partial shipments. Has any one been asked to create a report like this? If so, would you mind sharing your ideas?
Hi Richard,
I wish I had something to provide on this, however I have unfortunately not done a report of this nature before but I hope that someone in the community has and can share some of their insight into how they went about it. I can see how this would be challenging to pull together given the various scenarios that could be encountered with partial shipments, back orders, or back orders that have been transferred to new orders, etc.
What should work for this client is to use the master number and the date of the first invoice generated. If there are any invoices generated after that date that would tell them that the invoices were filled from back orders. They do not have any clients that do not specify no partial shipments so this should work.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 660
André Arnaud de Cal... 654 Super User 2026 Season 1
Subra 489
