cancel
Showing results for 
Search instead for 
Did you mean: 

Payments received on a particular Date

jignesh_mehta3
Active Contributor
0 Kudos

Dear Experts,

My client want a report which would show all the payments received from all the Customers on a particular day.

Is there any standard report for this purpose, or I will have to go for ABAP development?

Thanks,

Jignesh Mehta

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Jignesh,

How are you?

To check your requirement:

T. Code: FBL5N

Provide details like:

1. Customer Account (customer for which data needs to be checked or just keep it blanck for all customers)

2. Company Code (specific or all companies)

3. Cleared Item (i.e. Invoices, also provide date range)

4. Select types: Normal Item as well as Special G/L transactions

Compare your results on the Basis of DZ (collection) against BL (Billing).

Best Regards,

Amit

jignesh_mehta3
Active Contributor
0 Kudos

Dear Amit,

I have already tried the FBL5N option.

But the problem is that the movement I leave the Customer Number (in selection creteria) blank, in the List generated (for multiple customer) there is no Customer Code.

Thus I cannot segregate the list based on Customer Code. My client requires the Payment list Customer-wise...

Thanks,

Jignesh.

Former Member
0 Kudos

Dear Jignesh,

Try this:

T. Code: FBL5N

1. Don't key-in Customer Account (as need for all Customers)

2. Company Code (if for a specific Company then Key-in the Code, else leave blanck for all company data)

3. Check All Items (with specific data range, as desired)

4. Check type: Normal Item & SPecial G/L Transactions

and execute the report.

Now from Change Layout (Ctrl+F8), Select "Account" from Left and make it available in to right hand side.

Now, you will find Account (i.e. Customer Code) in to your report.

Further, Select column: Doc. Date and Click Sub-Total (Ctrl+F1)

Similary, you may further select "Type" and do sub-total.

This will certainly ful-fill your requirement.

Best Regards,

Amit

Former Member
0 Kudos

Hi,

Try with FBL5N, you can segregate list customer wise.

No need to enter customer code. Enter company code only.

Select the cleared items fields and enter date range.

Click on dynamic selections (Shift F4) Enter document type DZ.

System will give list of cleared items customer wise, In header it shows customer number and company code.

You can change header display as you want. In Menu click on settings>layout>current header rows.

By default customer and company code will come in 2 rows. if you want to show in single row.

Select the company code field and press F5 and move to first row and press F7 and save it.

Then system shows customer and company code in one row at header.

Regards,

Chandra

jignesh_mehta3
Active Contributor
0 Kudos

Thanks a lot Amit & Chandra.

Thanks again,

Jignesh

Mumbai

98700 10230

Answers (0)