Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by 22,768

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,

*This post is locked for comments

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.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans