5157840 Extended Lists and Reports
5157840_01: Customer open entry list
With this presentation you can show functionalities like "Output in Excel" and "Output in Excel Balance Ending Date" of the report "Customer - Open Entries".
Postings:
The system creates the Gen.-Journal 5157840_01 incl. entries. For the customer 50000 - William Shakespeare 4 invoices are created. The posting date and the document date is the 31.12. of the previous year (starting from work date):
- Invoice 0002: 1.000,00
- Invoice 0003: 500,00
- Invoice 0004: 250,00
- Invoice 0005: 125,00
Additional 3 payments:
Payment 0006: 750,00:
- Posting-/Document Date 1st day of the penultimate month starting from the work date
- Partial application invoice 0002
Payment 0007: 250,00:
- Posting-/Document Date 1st day of the last month starting from the work date
- Application remaining amount invoice 0002
Payment 0008: 250,00:
- Posting-/Document Date 1st day of the last month starting from the work date
- Partial application invoice 0003
5157840_01 - Test procedure in Demo Mode
Confirm with OK and the journal 5157840_01 opens:
Explain the postings and post the journal afterwards.
5157840_01 - Test procedure without Demo Mode
If you start the test without demo mode, the journal 5157840_01 will be automatically posted and the "Customer - Open Entries" report will be opened with the 31.12. of the previous year as a cut-off date.
Presentation of the Excel Output
If not done yet, start the report "Customer - Open Entries" and give a filter on the date saying 31.12. of the previous year. Choose additionally the option "Output in Excel":
Click on preview
After closing the preview, you get a message of what you would like to do with the Excel file. Open it and show the additional remaining amount columns:
Repeat the call up of the report and type in the payment dates in "Output in Excel Balance Ending Date" (here: 01.02., 01.03., 01.04.). Now show the differences of the remaining amount columns:
After partial payment invoice 002:
After payment of remaining amount invoice 002:
After partial payment invoice 003: