Dynamics Community Forum Thread Details

Invoice line item quantity is cancelled, but extended price is calculated and added to total

We have a customer that just found something strange in their data - they have 22 invoice lines over the last few years where the quantity fulfilled is 0, quantity = quantity cancelled, however the extended price is not 0. What's even more interesting is that all of these items were actually shipped. No one knows how these came to be showing a 0 quantity fulfilled or something in the quantity cancelled, as they do not typically use that - they usually just delete the entire line if they are not going to invoice for it.

So the end result is that these are in the GL correctly - showing the sales, however, these never came out of inventory and never recorded COGS.

All 22 items are on different invoices. We suspect that most of these were added manually to the invoices after the rest of the line items were transferred from orders. However, not all - some where transferred from orders.

The environment is GP 2012 SP 3, SQL 2012, they are also using Myridas and a modified Sales Transaction Entry window (although the modifications were simply to move existing fields around on the window).

While this is a tiny percentage of their total volume (22 lines out of 3 million+), they would like to know how to prevent it from happening again. Has anyone seen this before or have any ideas about how this could happen?

Thanks,

Quick Links