Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS Partner
VKZIMM
Posts: 767
Registered: 11-10-2008
0

Purchases Clearing Report Problem

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.

Moderator
Natasha
Posts: 180
Registered: 07-15-2009
0

Re: Purchases Clearing Report Problem

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.

Natasha Chang
Sr. Software Engineer
Sage 100 ERP
Moderator
skirmoochsage
Posts: 181
Registered: 07-09-2010
0

Re: Purchases Clearing Report Problem

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
Contributor
glrickert
Posts: 31
Registered: 02-24-2011
0

Re: Purchases Clearing Report Problem

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.