The total amount shown as 'received' in the bottom part of the purchase order screen is significantly higher than the total amount of invoices applied against the purchase order. Any ideas?
The total amount shown as 'received' in the bottom part of the purchase order screen is significantly higher than the total amount of invoices applied against the purchase order. Any ideas?
Can you include a screenshot of the PO and of the list of invoices from the invoiced button?
I think I just figured it out. We have 9 invoices charged against this PO. Each time an invoice was entered, sales tax was included. You can see under "to date" that it looks like we have received 9 items entitled sales tax. I did the math and it works out. I think that if we enter a purchase order and use the Tax District for the sales tax versus including it as a line item it will work out better. I will be testing this theory.
Ah, yes, I can see from the picture sales tax was a line item. Using the sales tax district is a better idea. But if you choose to continue the old way, just switch the qty and price for the sales tax so that you can "receive" partials based on the invoice amount.
Switching quantity and price is a solution that has been recommended before. I would certainly hope that Sage would recognize this as not optimal and find a different solution. Switching price and quantity only adds confusion to the purchasing process, and it is hard enough as a contractor to ensure that the volume of goods and materials ordered/received is accurate without complicating the process like this. We switched to Sage 100 in January, and it has been a rocky transition for a number of reasons. At this point, I would not recommend this software.
The sales tax district at the top does not add a line item on the PO, it adds it to the totals at the bottom. So if you stop adding tax manually to your POs it will eliminate the issue.
Could there be any other reasons for the received amount to not match the subtotal/Total? We do not have sales tax line item.
click on the invoices button at the bottom and look at the qty received on the invoices. If it doesn't match, then someone is manually entering the value in the To Date column. Typically we do a qty at a price. If the price is a lump sum, you can reverse the qty to be the lump sum and change the price to 1.00 to allow multiple receipts at different values. When you use a qty of 1, you can only receive against that line once.
I am having the same issue, and I switched the quantity and price and the PO Audit report still does not show anything received after an A/P invoice is posted. What now?
*Community Hub is the new name for Sage City