- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Purchases Clearing Report Problem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-27-2012 02:35 PM
I have a client on Mas90 v4.4 Service pack 4
They have a line from a purchase order on the Purchases Clearing report that says
25 ordered 25 received and 9 invoice.
The problem is you can look it up and see that they did a combination Receipt of Goods with an Invoice Number for the 25 and the invoice is in Accounts Payable, General Ledger shows the invoice total and nothing in Purchases Clearing being posted.
How did the 9 get into the Invoice Quantity instead of 25?
I have tried multiple things, but I cannot figure it out. Any Ideas? It is Friday afternoon,
Thank you in advance.
Re: Purchases Clearing Report Problem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-27-2012 03:27 PM
Quantity Invoiced just comes from PO_PurchaseOrderDetail. There is no special or tricky calculation. I don't know why it is 9 when you invoiced 25.
Sr. Software Engineer
Sage 100 ERP
Re: Purchases Clearing Report Problem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-30-2012 08:26 AM
Reviewing the receipt history, if it's being retained is your best bet, Receipt of Goods and Invoice as well as Return of Goods data should be stored in the file. Maybe a call into support can provide some more investigative work that can be done.
Have an idea? Submit an enhancement request
Re: Purchases Clearing Report Problem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-30-2012 05:31 PM
Make sure the unit cost has not changed, I think the way the QI is calculated is total cost divided by unit cost.
I agree with last post that reviewing the receipt history might shed some light on what is happening also.


