A/R Invoices/taxes Canadian User requirements

[KENNEY]

Our organization is located in Ontario Canada, we currently use the general A/R system 03B.

On our invoices we may have varying taxes based on the Federal(GST) and Provincial(PST) tax authorities.

By law we are required to report these amounts seperately on the invoices, however the invoice print report R03B505 only prints the taxes as one total.

I have looked at other invoice print reports from some of the other modules (service billing, sales orders etc. ) and they seem to do the same.

I would appreciate any feedback from Canadian users who have overcome this lack of functionallity.

 

[wzhong]

Under section “On Document Company” Level breaker footer, add following fields.

1) TXR1 – Tax Rate 1
2) TXR2 – Tax Rate 2
3) GL01 – G/L offset Tax Area 1
4) GL02 – G/L offset Tax Area 2
5) MATH01 – Tax Amount 1
6) MATH01 – Tax Amount 2


Change Code in Do Section:
1) Fetch Tax Rate and G/L offset Tax Area from F4008
2) Calculate Tax Amount based on Tax Rate and Tax Area
3) Hide or Show Objects if no tax available
4) Verify the new calculated Tax amount is the same as the amount in the table, show warning message if not.

--------------------
WZHONG From Montreal, Qc.
Environment: E810 with Tools Release 8.94.S1, Win 2K, SQL 2K, Citrix PS4

 

[sbrown]

When you set up the tax rate area make sure you have both tax Authority listed seperately each having thier own address number. Each with thier own rate. Then on the print tab on R42565 set the processing option #14 to a 3. This will print on the invoice seperately.