Dynamic field in S_ALR_87012172 - Customer Balances in Local Currency?

[Former Member]

Hi,

My problem is that we want to add the document Numnber field in the report S_ALR_87012172 - Customer Balances in Local Currency so that we can get the desired output. I have tried to add the Document number field under 'Documents' in the Dynamic Selection using table BSID. When we are adding it it is working fine for all other reports for customer balances but not showing anything here.

Please tell me the reason why it is happening if possible and tell me how to get that field added.

Please reply asap as it is quite urgent.

Thanks in advance

Regards

Pankaj

[Former Member]

Hi,

Please check S_ALR_87012069 - Transaction Figures: Account Balance , here you can select documents in dynamic selections.

Rgds

Arun

[former_member188028]

Hi,

Please check S_ALR_87012079 - Transaction Figures: Account Balance , here you can select documents in dynamic selections.

Rgds

Murali. N

[Former Member]

Hi,

Thanks to all for the replies!!!

I am sorry to say but Marssel but in F.23 as well the problem is same we can't add the Document date or Posting date field.

Ravi, I am sorry we don't want Document Journal report as we want the Daily Customer Balances.

I am sorry Murli but we want daily customer not vendor balances S_ALR_87012079 - Transaction Figures: Account Balance

Please suggest the way....

Thanks to all of you...

Regards

Pankaj

[former_member188028]

then please check S_ALR_87012169 - Transaction Figures: Account Balance

[former_member182098]

Unfortunately, you do not have any daily balance report.

Use report painter and draw a report.

See the following thread:

[Former Member]

Thanks alot Ravi...

Let me check and then I will get back to you..

Regards

Pankaj

[Former Member]

Thanks again Ravi,

I have tried that option and made the Form and Report but when I am trying to Excute the report S_ALR_87012172 - Customer Balances in Local Currency it is not coming with the desired output. Is it the link problem. Can you plz tell me we have made a form and then a report with the desired parameters but how to link that report with the desired T. Code.

Secondly, if I make the changes in the Standard reports which are mentioned below then system is taking the changes but when I am making the new form and report myself then system is giviing me the desired output. Can we make our own report and link it to the T. code we want or we only can make the changes in the standard reports .

0SAPFD10-01 Transaction Figures: Account Balance

0SAPFD10-02 Transaction Figures: Special Sales

0SAPFD10-03 Transaction Figures: Sales

Please help me as I don;t know much about the report painter.

Thanks in advance..

Regards

Pankaj

[Former Member]

Thanks to all

[former_member182098]

Not possible. When you are using a balance report, why you need document numbers in selection screen?

Instead try using S_ALR_87012287 and use the relevant document type and document number. (Here you have the option for totals as well as line items)

[Marssel700]

Dear,

Try easier entering t-code F.23.

About Document number, It isn't possible. Add BSID field isn't allowed for dinamic selections DDF.

Regards