Difference between FBL3N and S_ALR_87012357

[Former Member]

Hello Friends,

We have an issue as below.

We have an account  112233 with description as  VAT payable, output tax - 1. We have tried compare the balance in FBL3N and S_ALR_87012357.

In FBL3N it shows the balance as 25000, where as in S_ALR_87012357 report it shows the balance of 28000.  We found 3 documents for this difference.

All these 3 documents were got posted with transaction VF11.  But we can see many other documents posted with VF11 are appers in the report S_ALR_87012357, but these 3 document only not appearing.  We are having this difference for the month of Oct 2012.

Can you please give some ideas to identify the reason for this difference. 

Thanks in Advance.

Prasad

[Marssel700]

Hi Prasad,

The difference is the Transaction Key - T030K-KTOSL define in OB40:

Used to determine accounts or posting keys for line items which are created automatically by the system. The transaction keys are defined in the system and cannot be changed by the user.

In FBL3N all transaction keys are allowed while S_ALR_87012357 uses only:

Input tax VST

Output tax MWS

regards

[Former Member]

Hi Prasad ,

report S_Alr_87012357 is related to tranasaction with tax on it and FBL3N display all line item .whether have tax or not . Can you please look those 3 transaction whether they have tax amount or not ? and have any tax code on that or not

many Thanks

[Former Member]

Hello Preeti,

Yes, we have tax line items in those 3 missing documents also.  Hence we  are trying to find the reason why S_Alr_87012357 not considering those 3 document.

Thanks

Prasad

[former_member188063]

Did you check the tax code for the 3 missing documents. May be that's the issue.

Sudhakar*

[Former Member]

check the reporting county as well for those docuemnt. may be they are not for those for which you are running tax repor S_Alr_87012357. In This you need to select reporting country and currency as well. So please  check Currency & reporting country

Many thanks

[Former Member]

can you post one of the docuemnt screen shot with header and line item

[Former Member]

one more thing go to fb03 and display the docuemnt and click on button tax information this will give you Reporting country

[Former Member]

Hello Preeti,

Thanks for the response.  I have verified the tax code is existed in those 3 documents, in addition customer also belongs to same country Indonesia.

Please suggest me if u have any other thoughts to identify the difference.

Thanks

Prasad

[Former Member]

please give us screen shot if you can ...........