Tax calculation error on expense reports

[Former Member]

Hi! If somebody can help me resolve that problem, it would be greatly appreciated. I'm working for a Canadian company and we have people expensing in Quebec province (CAQC). I noticed last week that the calculation of GST/PST on expense reports doesn't calculate correctly.  Even though I maintained right tax percentage rate on FTXP for ''T1'' Tax code; ''CAQC'' Jurisdiction code, SAP doesn't consider them.  It's always a litlle bit off. Right now, we are not asking the right deduction to the government.

Every tax code are created with "V" tax type. The calculation level is from "100 to 110" for Base Amount. We duplicated the Flat Tax on Employee section and created Z condition type based on populated SAP condition type (JC1T and JC2T).  We have ZC1T at 3.846% and ZC2T at 8.257%.

Here's an example of what we get for an expense report.

Person X  : 100.00 CAD

Expense  :   88.49 CAD

GST (ZC1T)    3.54 CAD

PST (ZC2T)    7.97 CAD

If you have any clue that could explain that situation, I'd be grateful.

Thanks in advance.

[Former Member]

Hi Isabelle,

you have not explained what is the calculation result from SAP. But SAP calculation should be correct. If not I would open an OSS message to get a fix from SAP.

Best regards,

Sigi

[Former Member]

Hello!

I logged the problem with SAP last week but no answer yet...

Sincerely,

[former_member131723]

Hopefully we can provide some update on this soon Isabelle!

[Former Member]

Hello!

Looks like I find what was the problem. In 2010, we implemented note

#1435870 that creates an include (RV64A955). That include calculates the

tax perfectly. However, that include is not called by any specific

program. To activate that include, we should execute RV80HGEN. That

program modifies RV64ANNN that activates the include to access the new

program (RV64A955). I had a copy of that note and read it more than once but that part was not clearly explaining in the note, so we probably missed it then.

Many thanks to all of you who take time to try to help me

isabelle

[Former Member]

Can you provide the screenshots for above explanation? If so it will be easier to understand well about your issue.

[Former Member]

Good morning Venkat!

Unfortunately, my issue is not solved. Here's the snaspshots for FTXP:

The final posting entry (in FK10N):

I don't know if more snapshots could help.  Do not hesitate to ask for more if needed.

Have a great day!

[Former Member]

Have you maintained the tax code entries in the tables V_T706B1 and V_T702N_A ---> Other settlement --> 18 column.

I have attached screenshots for reference.

V_T706B1:

V_T702N_A:

Lets try once and let me know

Regards,

Narayana

[Former Member]

Yes, both tables are maintained.

18th column of Other Settlement  (V_T702N_A) is at "No chg to accounting procedure"

The mystery is still there...

Thank you in advance for your support!

[Former Member]

Hmmm, it's strange. We will wait for some other experts input on this.