Finance | Project Operations, Human Resources, ...

How to create a report to show items were invoiced and shipped from stock

(0) Share

Report

Posted on by Richard Wheeler

75,730

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?

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: How to create a report to show items were invoiced and shipped from stock

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.
Suggested answer

Shannon Aune on at

Like (0)

Report

RE: How to create a report to show items were invoiced and shipped from stock

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.