PurchPurchaseOrder Report not showing VAT Amount by line?

(0) Share

Report

Posted on by Rana Anees

1,813

Hii,

I run this report after Purchase Order confirmation from AP -> PO -> Purchase Tab -> Purchase order confirmations -> Preview/Print -> Original.

We have customized the design of this report in VS. After the new requirement, I added new column TaxAmount at the line level.

I added another row in the summary area at the bottom for SumTax from PurchPurchaseOrderDS and its showing correct value of VAT sum.

But VAT is not showing at Line level.

Can I get TaxAmount from TaxJournalTrans table in class PurchPurchaeOrderDP -> setPurchPurchaseOrderDetails and assign to purchPurchaseOrderTmp.TaxAmount = (TaxJournalTrans).SourceRegulateAmountCur but im not getting the relation. Cant find this table PurchLineAllVersions in AOT.

Any idea how to get TaxAmount at line level.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

István Orosz 2,137 on at

Like (0)

Report
Copy link

Link copied!

Hi Rana,
PurchLineAllVersions is a view, which gathers data from two other views, PurchLineArchivedVersions and PurchLineNotArchivedVersions (which goes back to PurchLine and PuchLineHistory tables). TaxJournalTrans table has a client static Amount taxAmount() method, isn't it something you can use?

Kind regards,

István

Was this reply helpful? Yes No