Hello!
I am trying to get the VAT Amount printed in the Journal Printout Report in General Journal.
Right now it does not show the VAT amount per line or in the total though VAT is being calculated and is visible in SalesTax Tab next to the journal line.
The remaining details like amount, transaction text etc are being printed from Table LedgerJournalTrans which is linked in the Data source for the report.
The VAT amount is being stored in table TaxTrans and I have linked the same in the report.
I added a new Real Field in the report called VAT Amount and I created a method to return the VAT Value for each line in the report.
The code is as follows:
display real VATAmt()
{
if (LedgerJournalTrans.Voucher==TaxTrans.Voucher)
Return TaxTrans.TaxAmount;
Else
Return 0
}
The report returns a 0.00 all the time. I cannot find another linking field other than Voucher that links both the LedgerJournalTrans and TaxTrans.
I appreciate your support on how to get the report display the sales tax per line correctly.
I am on a test environment.
