AP Voucher GL Distribution Tax Problem

nwilson

Member
Hello all,

In Standard voucher Entry - GL distribution is there a way to input just the goods amount into the line item and have JDE calculate the tax afterwards?

We are using Tax Expl Code C and a Tax Area/Rate with two items: one moves the VAT to a seperate account (which is working well) and another to calculate the sales tax which we want to go directly into the expense accont. The total being 13%. This is for Ontario, Canada which has a GST(VAT) of 5% and PST of 8%.

Currently if a voucher is entered for $1000 Gross, JDE will calulate the taxable amount to be $884.96 ($1000 less 13%). When you get to the GL distribution screen the PST(Sales tax of 8%) is added to the "amount to distribute" to total $955.75. If we want the invoice to be coded to 2 seperate accounts, one for $400 and another for $484.96, we need to manually calculate the tax on those amounts to get our total of $955.75.

Our goal will be to have the clerks enter the taxable amounts and have the system calculate the taxes based on the Tax Area/Rate that is selected.

Any help or advice on how to properly configure this or even if it is possible would be a great help.

Regards,
Nick

OneWorld XE 7.333 SP23_U
 
Back
Top