Sage 100

Purchases Clearing bug when PO Invoice has sales tax or landed cost MAS 200 4.4.8 Customer ordered 3000 each. Received into Stock 2655, Invoiced 2654, Backordered 345. Unit price is $15.85. Purchases clearing should show $15.85, the one piece that was received but not yet invoiced. Purchases clearing shows a negative $2063.49. It appears that Fields 48 and 49 are screwed up. To get the -$2063.49 showing on the Purchases Clearing report, take Field 48 ($386.35) plus the one unit not yet invoiced in the above paragraph ($15.85) minus Field 49 ($2465.69). If Landed Costs and /or Sales tax is not invloved, both Fields 48 and 49 should be 0.00. If they are involved, Field 48 should match Field 49, in this case $2465.69. The solution is to manually change Field 48 in DFDM to equal Field 49. After discovering this one transaction, quite by mistake, the Customer has found more than 30 additional wrong entries on the PC Report. Since starting this case on Aug 8th, Sage engineering still doesn't have a clue. The CASE # is 8002142791 The AP Utility, Sales tax Calculation which should fix this problem has no affect nor does upgrading to 4.4 PU 10 Sorry for the extra attachment. I can't find a way to delete the rtf

Has it been determined whether it is EITHER of the two or BOTH that are causing the problem. What was the PO cost vs. the actual invoice cost? A problem with the program 10 years ago (see my writeup attached to another post) is that purchase price variances are TRAPPED in purchases clearing account UNTIL the entire line is received and invoiced. Only then did the PPV get posted to the GL. I suspect that something similar is happening to you here.

In my case, all the problem records involve sales tax allocation but Sage says it could happen with landed Costs also. Sage has looked at the data and admitted it is not a WAD. PO Cost equaled Invoice cost in all cases. Sage says the Allocations are not working but do not know why.

How long has this case been open?

Since Aug 8

What did Sage say at the Summit?