web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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,769

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

I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans