Hi
Anyone know that where can pull out the data for taxable amount details for AP Bill? Please refer to below screenshot
I would like to pull out the report with taxable amount for AP bill where have involved for Taxable amount
Best answer by Naveen Boga
View original
+17
Hi @erin,
You can get the “Taxable Amount” from the APTaxTran DAC and I have created the simple Generic Inquiry and If you want to fetch the tax details from the database you can use “TaxTran” table. Please find the screenshots for reference.
And also, attached sample Generic Inquiry for your reference.
Hope this help!!
Hi Naveen
Sorry for my late feedback and thank you so much for the attachedment and such a good information for me.
Too bad , i am totally no idea about the generic how to created and should start from which section
Refer to your replied below
==If you want to fetch the tax details from the database you can use “TaxTran” table.==
Does it mean the “ TaxTran” table is existing database or we need to create by ourselve?
Search around my system there is no “ TaxTran” could you please give me a guide where should i extract from ?
Thank you very much and hope to hear from you soon.
+17
Hi
TaxTran table is the default Acumatica table, which holds the tax details. Please find the screenshot for reference. You can check this default Acumatica instance database.
Hi Naveen
Thank you very much for your prompt reply!!!
Could you please guide me how to get the screenshoot above? under Tax section? please refer to below what i have in my system right now.
Sorry for bother you as i am beginner for this system.
+17
Hi
For the TaxTran table, we do not have a separate screen, Acumatica internally maintaining this table to store the tax details in the database.
Above I have attached a generic inquiry screen to pull the tax amount for the specific document. Please import this GI into your instance and verify.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
