Reporting country not shown for Intercompany transaction in T code - S_ALR_87012357

[former_member674277]

Dear All,

When I am trying to run VAT report RFUMSV00 ( T code - S_ALR_87012357) for Intercompany transactions. The reporting country shown blank. We need to populate reporting country. Please help me.

Thanks in advance.

[sanilbhandari]

Hi sursarkar

The data for tax reporting is picked up from table BSET. For the sales and purchase invoice, check if the data is being captured correctly at the transactional level, ie, there is a tax code updated in the sales and purchase side invoices with a correct tax code that also has reporting country also filled in. Since you are asking for a field reporting country, I would assume you are using Plants Abroad solution for EU.

If the tax code itself does not have the right tax code and reporting country, than the report will not show the required data. You first need to check transactional data.

Thanks & Regards

Sanil Bhandari

[former_member674277]

Hi Sanil,

Thanks for your reply. I have checked BSET table and found no data shown for "Cntry for tax return" <BSET-LSTML> for intercompany document type entries. Please help.

Thanks & Regards,

Suraj

[sanilbhandari]

Hi sursarkar

The reason is very clear, that the transaction itself is not booking the right tax code and that is the reason why report is not showing the reporting country. However, before that - Are you using the Plants Abroad solution since that is when the reporting country would typically be used. If you do not have Plants Abroad active, it may not be feasible to use the field.

Coming specifically to Tax Code determination, the tax user should tell you specifically which tax code should be used for both sales and purchase ICo Invoices and with which reporting country (in case you are using Plants Abroad solution) and what are the criterion based on which such tax codes should be filled at transactional level. I do not see any technical issue, but more of missing business requirement on how tax codes should be populated !

Thanks & Regards

Sanil Bhandari

[former_member674277]

Hi Sanil,

Yes we are using Plants Abroad functionality and also we are using Thomson Reuters OneSource Tax determination for tax calculation. The Tax calculation is correct and we are having this issue for all the Inter Company transaction. While checking for OSS Note we have found 2390821 - Tax reporting country not displayed in output lists for RFUMSV00, is this applicable for this issue.

When check the S_ALR_87012357 report, we not found any results using country key CH. If we remove the CH then results are displayed. Tax code already maintained in CH and as well for reporting country.

Please help.

Thanks in advance.

Best Regards,

Suraj

[sanilbhandari]

Hi sursarkar

I do not know your application components. If the note can be implemented, please go ahead and implement in your dev/testing system and test the transaction.

However, if your tax codes are not created with tax reporting country, i am not sure, if the note would be helpful, because, you should have the required master data in place.

Thanks & Regards

Sanil Bhandari

[former_member674277]

Hi Sanil,

I have checked in the system, we have implemented the note earlier. But, still the Cntry for tax return filled is empty in BSET table field name is LSTML. I have noticed one thing that there are no values in Country currency tax <BSET-LWSTE> and Cntry curr.tax base <BSET-LWBAS> .

Could you please help to understand, why there are no values in these fields. The value is already there in BSET-HWBAS, BSET-FWBAS, BSET-HWSTE, BSET-FWSTE.

Thanks in advance,

Best Regards,

Suraj

[sanilbhandari]

Hi sursarkar

I had thought so as well, that the note might may not be helpful.

As i had pointed out earlier as well, the issue is with the tax code that has been used at the transactional level for Ico Sales and Purchase Invoices. It should have a tax code assigned with reporting country filled in. You should check with your business tax user on the right tax code set up as well the reporting country to be used in the tax code. Once you have that the data will show up in BSET and it would also show up in the report.

Hope this helps.

Thanks & Regards

Sanil Bhandari

[former_member735334]

Hi Sanil,

This is to inform you that we are getting this issue for all the Intercompany transaction having reverse change tax code for all the entity.

Is that the standard functionality? as we are using plants abroad functionality and have setup the tax code for reverse change correctly.

Thanks

Avijit Prasad

[sanilbhandari]

Hi avprasad

The below OSS note should explain you the set up of tax codes in Plants Abroad.

https://launchpad.support.sap.com/#/notes/63103

There are two ways of defining tax procedures in Plants Abroad. I do not know which option you have chosen, but you need to have the filter for reporting country in the tax code, to identify the tax codes are relevant for which country, other wise how would you expect the system to identify the reporting country. That's what i have been trying to explain !

Thanks & Regards

Sanil Bhandari