Purchase order report with tax details

(0) Share

Report

Posted on by Nakul

1,187

Hi ,

I made a purchase order report i tried adding tax details in that from taxtransjounral table but when i am trying to add tax code field then last tax code is printing only, only one value is printing only on that report even if there are more than one taxes .. I am using group for that tax code can anybody please help me to get all the tax code on that report ..

I tried relation journalrecid of purchpuchseordertmp and recid of taxjournaltrans.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi Nakul

The JournalRecid field of PurchPurchaseOrderTmp table is the Recid of VendPurchOrderJour table.

So, the right relation between PurchPurchaseOrderTmp and TaxJournalTrans table is by TaxJournalTrans.TransTableId = TableNum(VendPurchOrderJour) and TaxJournalTrans.TransRecId = PurchPurchaseOrderTmp.JournalRecid

Was this reply helpful? Yes No
Nakul 1,187 on at

Like (0)

Report
Copy link

Link copied!

Hi denis

Thank you , i tried using this relation but issue is same even after this relation only one value is printing for example if i am having 2 taxes for P.O.

1.abc

2bcd

then last one is printing on that report and in this case "bcd " is printing for my customized report i tried using debugger even that is getting only last value from table

my code is

TaxJournalTrans.TransTableId = TableNum(VendPurchOrderJour) and TaxJournalTrans.TransRecId = PurchPurchaseOrderTmp.JournalRecid

PurchPurchaseOrderTmp.customfield=taxjournaltrans.taxcode;

What my exact need is i want all applicable tax codes for that P.O.

Was this reply helpful? Yes No
janchen 650 on at

Like (0)

Report
Copy link

Link copied!

Hi Nakul,

You want to make a purchase order report and you are using a taxtransjournal.

Are the purchase orders already invoiced?

Regards,

Jan

Was this reply helpful? Yes No
Nakul 1,187 on at

Like (0)

Report
Copy link

Link copied!

Hi Jan,

Yes ,I am M trying my code on Invoiced P.O .

But problem is that i want tax codes from taxtransjournal table for that P.O only last tax code is reflecting from the list applicable for that po ,like i applied 10 taxes then ,only 10th number tax code is reflecting on my report i want all 10 tax codes on my report ..

Was this reply helpful? Yes No
Nakul 1,187 on at

Like (0)

Report
Copy link

Link copied!

Hello Experts ,

Please provide you suggestions ..

Was this reply helpful? Yes No
Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi Nakul

Let me understand better.

You have created a new Purchase Report starting from the standard Purchase Order report ( PurchPurchaseOrder) ?

For handle the tax details, in my opinion you have to add the TaxJournalTrans records on PurchPurchaseOrderTmp table and print through a Tablix on the body report, like Salesinvoice

Was this reply helpful? Yes No
Nakul 1,187 on at

Like (0)

Report
Copy link

Link copied!

Hi denis ,

I have created a new Purchase Report starting from the standard Purchase Order report and added taxjournaltrans table fields on that , i tried to show the problem i am facing through image , see in the example my P.O has two tax codes attached as per group but only one of them is reflecting on report under tablix.

Was this reply helpful? Yes No
Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi Nakul

In my opinion you have to avoid add taxjournaltrans table as Report Datasource.

Like "Tax" section on SalesInvoice, you have to add a custom field on PurchPurchaseOrderTmp table ( ShowTaxTrans ?!) and then create a custom method ( like insertTaxes on SalesInvoiceDP class ) that populate the records.

Finally, on the body report add a Tablix where handle the Tax entries.

This tablix will be conditioned by the new "ShowTaxTrans" field

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Denis,

This worked for me. Thanks for sharing.

Was this reply helpful? Yes No
Ismail Mohamed 576 on at

Like (0)

Report
Copy link

Link copied!

where i can add this relation ?

Was this reply helpful? Yes No