Hi Richard,
It appears as though it's not including the qty of 446 (first line of the PO) to be included and as that's the quantity you are off. We know that last line is fully shipped and invoiced (or it appears so). The two first lines on the PO (16384 was shipped for 446, but not yet invoiced) and the second line was shipped for 3121 and invoiced for 2097 leaving 1024 yet to be invoiced. And 1024 is the amount that it's currently pulling in when you auto invoice. So, it appears as though something might be going wrong with that first line. I'm not sure if all of these lines were on one shipment receipt or separate. I'll assume separate for now.
These types of questions are hard to solve in Forums as there are so many variables so you might want to enter a request into support to investigate the data, but if I'll give you a couple things to look at.
Look to see what the column STATUS shows and if it's a 1 or a 0 in the POP10500. That will tell us if the shipment was posted or not. If it's 0 then it's unposted. In that case, look to see if there are work records in the POP10300, POP10310 etc. If there is, verify that that shipment is or is not posted through the rest of the POP history tables. If not, it might be just a situation where the document just isn't posted and therefore won't pull that shipment quantity. If it did post partially through or is damaged, then maybe there was an interruption and needs to be cleaned up. I'm not sure without seeing the data results from the ALL PO and Receipts scripts we have how to fix it or what options you have so I would suggestion to put in a case if you need assistance.
If it's just a saved receipt that someone forgot to post, you should be able to just post the receipt via the front end and then do the invoice matching, but it if it's an interrupted shipment then we need to look into the data to see how to solve it.
Hope this helps.
Thank you for using Microsoft Dynamics Communities,
Angela Ebensteiner
Sr Tecnical Advisor
Microsoft Dynamics GP
