Purchase Order report seems to have incorrect calculations

(0) Share

Report

Posted on by Community Member

I have an issue with PO-C47164.

The net value of the order should be £1195.07. The VAT should be 20% of this i.e. £239.01 and total including VAT £1,434.08.

It seems as if the net value is getting calculated and then 20% is taken off it.

To recreate go to company ‘agl’.

Click Purchase Ledger > Common > Purchase Orders > All Purchase Orders.

Filter for PO-C47164.

Click the Purchase tab > Purchase Order Confirmations.

Click Print Preview > Use Print Management.

The values at the bottom are incorrect.

Attached is a screenshot of the report output. I've traced this as best I can and managed to find that the report is called PurchPurchaseOrder. It seems as if the PurchPurchaseOrderDP class gets the data for the report but I don't understand the code well enough to see where the VAT is getting calculated. Can anybody please advise?

1781.PO.jpg

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

On the header of the PO is a 'Prices include VAT' field. Is that ticked, by chance?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes. Please see attached.

Was this reply helpful? Yes No
Suggested answer

Kauto 2,699 on at

Like (0)

Report

Hi Paul,

Check the item tax group is assigned correctly on each line of the PO - should be in setup tab of the lines. If the item has been created without the item tax group assigned - the VAT will not calculate correctly.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Yes, it was ticked. It was also ticked on the vendor.

I unticked both and regenerated the PO. All calculations are now correct.

Thanks for the help.

Was this reply helpful? Yes No