Tax info in Excise documents

[Former Member]

In PLD of Excise Invoice i tried to bring in the tax information of BP from "Fiscal IDs for BP Master Data" table and also from "A/R Invoice - Tax Extension" table.

But i am not getting those field to be displayed in the invoices? what is the correct table to fetch the tax info into Excise Invoices?

Meera.

[former_member187989 · Accepted solution]

hi merra,

Pl find tax info in outgoing excise invoice PLD on following table

OEI12 - Outgoing excise invoice - Tax Extension.

Tax info will flow from CRD7(BP master) > INV11(AR invoice)>

OEI12(Outgoing excise invoice)

Hope above solution will solve your problem.

with regards,

A.Jeyakanthan

[Former Member · Accepted solution]

Thk U Jeyakanthan! it is solved.

[former_member583013]

Meera,

The tax information on AR Invoice is stored in tables INV4, INV5 and INV12. Please check which one of these has the info you are looking for.

Regards

Suda

[former_member186095]

Try to run this query :

select * from rdoc

to find out the report template. if maybe it is similar like batch no. printing. I mean when printing delivery that has batch managed item, there will appear 2 types of print preview i.e. for batch and non batch

Rgds,