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

Test procedure in Demo Mode

Confirm with OK and the journal 5157840_01 opens:

5157840_01 Postings

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":

Customer - Open Entries

Click on preview

Customer OPListe Vorschau

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:

Excel Output Current Balance

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:

Excel balance 01.02.

After payment of remaining amount invoice 002:

Excel balance 01.03.

After partial payment invoice 003:

Excel blance 01.04.