Tax Report S_ALR_87012357 Tax on sales/purchase for Malaysia GST

[Former Member]

Dear Experts

We are implementing GST in malaysia. our requirement is to get the Tax Report S_ALR_87012357 Tax on sales/purchase  based on the transaction type. (.i.e.As per Filing form for tax there are multiple sections of total value of local zero-rated supplies, total value of export supplies, total value of exempt supplies etc.) we would like to see the above report in that way. how can i achieve this? please refer the tax filing form for details

[milind_joshi7]

Hi Vishal,

For Reporting you need to follow below steps.

Advance Return for Tax on Sales and Purchases (RFUMSV00) and the Asset Acquisitions (RAZUGA_ALV01) reports in the background. The Generate GST-03 Form (Malaysia) report fetches the data prepared by the RFUMSV00 and RAZUGA_ALV01 reports and generates the GST-03 form to be sent to Malaysian tax authorities.

Financial Accounting (New), under General Ledger Accounting (New) -> Periodic Processing -> Report -> Sales/Purchases Tax Returns -> Assign Tax Group Version Time-Dependent

Grouped tax balances in Customizing for Financial Accounting (New), under General Ledger Accounting (New) -> Periodic Processing -> Report -> Statutory Reporting: Malaysia -> Group Tax Balances

Grouped tax base balances in Financial Accounting (New), under General Ledger Accounting (New) -> Periodic Processing -> Report -> Statutory Reporting: Malaysia -> Group Tax Base Balances

Mapped tax codes to industry codes in Financial Accounting (New), under General Ledger Accounting (New) -> Periodic Processing -> Report -> Statutory Reporting: Malaysia -> Map Tax Codes

Further Selections group box, enter the following: - transaction type and depreciation area The RAZUGA_ALV01 report uses these values to get the total value of capital goods acquired and fills it in field 16 of the GST-03 form. By default, the depreciation area is set to 1. - taxes on sales/purchases group if you want to create a GST for group submission

Output List group box, ensure that the first four checkboxes are selected. Select the remaining checkboxes as per your business requirements.

GST-03 Parameters group box, enter the relevant details and select the Create GST-03 form checkbox.

SAP Easy Access screen, choose Accounting -> Financial Accounting -> Accounts Receivable -> Reporting -> Malaysia -> Generate GST-03 Form or Accounting -> Financial Accounting -> Accounts Payable -> Reporting -> Malaysia -> Generate GST-03.

FIMY_GST_IDENTIFY_CURRENCY)

Financial Accounting (FI) component.

Generate GST-03 Form (RPFIMY_GST) report.

GET_SET_CURR_AMOUNT method, which enables you to change the invoice amount from a foreign currency to Malaysian Ringgits (RM) for reporting purpose.

Enhancement Spot Element Definitions tab in the BAdI Builder (transaction SE18).

BAdIs as part of the Enhancement Concept, see SAP Library for SAP NetWeaver under BAdIs - Embedding in the Enhancement Framework.

You can also group tax balances based on sales tax code or a combination of sales tax code and transaction key based on business requirements.

Ensure you have created a tax grouping version in Assign Tax Group Version Time-Dependent (view V_T007Z).

You can also group tax base balances based on sales tax code or a combination of sales tax code and transaction key.

Ensure you have created a tax grouping version in Assign Tax Group Version Time-Dependent (view V_T007Z).

Ensure you have created a tax grouping version in Assign Tax Group Version Time-Dependent (view V_T007Z).

FIMY_AMENDMENT) Select this checkbox if you want to resubmit the GST-03 form, with a new set of values, to the tax authorities.

FIMY_CARRY_FRW) Select this checkbox only if you want to carry forward the Goods and Services Tax (GST) amount, refunded by the Malaysian government, for a particular period.

FIMY_NAMEOFBUSIN) Indicates the business name of the company as registered with the Malaysian authorities. The system eventually displays this value in field 2 of the GST-03 form. New Identity Card Number (FIMY_CARD_NO) Indicates an employee’s new identity card number. The system eventually displays this value in field 21 of the GST-03 form.

FIMY_CARD_OLD) Indicates an employee’s old identity card number. The system eventually displays this value in field 21 of the GST-03 form.

FIMY_PASS_NO) Indicates the passport number of the employee. The system eventually displays this value in field 22 of the GST-03 form.

FIMY_NATIONALITY) Indicates a code that uniquely identifies an employee’s nationality. The system eventually displays this value in field 23 of the GST-03 form.

FIMY_CREATE_FORM) Select this checkbox if you want to create a GST-03 form to submit to the tax authorities.

FIMY_GST_FIELD) Indicates a unique identifier of an information field in the GST-03 form.

FIMY_INDUSTRY_CODE) Indicates the code that identifies the industry in which the employer is active.

Thank you,

Milind Joshi

[katie_sap]

Hi guys,

how are you managing with the AP and AR bad debts processing and tracking of invoices more than 6 months. We have AP invoices which are more than 6 months.

I dont see any automated process in SAP to handle this.

How can we manually handle this. Can you help me on the accounting entries?

Also our company code currency is EUR and MYR is the 2nd currency. How do we handle this.

I see SAP has given badi FIMY_GST_IDENTIFY_CURRENCY which needs to be implemented. I see this in our system but it says "No Implementations found" do we need to put in this logic/code into this?

really appreciate your help.

cheers

viru

[Former Member]

Dear ,

I have finished setup "Grouped tax base balances in Financial Accounting (New),Grouped tax base balances in Financial Accounting (New)",But our company don't use industry codes,How to

Mapped tax codes to industry codes ?

Regards.

[mohdshazaly_ajamil]

Hi Viru,

Do you have the solution for FIMY_GST_IDENTIFY_CURRENCY BAdi? My client have their co. code currency is USD without any other local currency.

We already maintained OY01 with the exchange rates which we want but somehow there's no selection box to use nat crcy and tax return country live original program RFUMSV00.

Any workaround for this?

Regards

[mohdshazaly_ajamil]

Any registered GST company should have industrial code assigned, check with your user.

On the other hand you can map the GST Industrial Code like this:-

Regards

[Former Member]

Dear Vishal Somani,

Are you finished GST for your company ?

As you know in our Malaysia Government need to using on 1 Apr 2015, so our company need to do they ,would you have some files to sharing of me .My company on Petaling Jaya. thanks.

My email: shownbb@qq.com

thank you  Vishal somani.

Regards,Alex

2014/11/26

[Ajay_Uniyal]

Hi,

The solution to generate GST-03 is already delivered via oss note

2070289

2014530

Best Regards

Ajay

[Former Member]

is this solution from note can apply to ECC5.0. because as per pre requisite of that is  note 1932169 should be in place and its applicable for ECC 6.0. please advise.

I am trying to genrate the report on output list basis but it des not generate.

[Former Member]

hI ,

in this transaction you can chnage the output layout for each type of tax . please see below screen sho t.

These reort provides you a information to fill the form but doesnot genreate the form itself