Export Factoring Ledger Entries

Factoring Ledger Entries and matching Detailed Factoring Ledger Entries are created by posting a Factoring Journal. These data are stored in a Factoring Register which is also created during the post-process. Depending on your factor there is different data required to export the register.

The export can either be done manually or automatically.

Manual Export

Export via Excel

For a manual export to your factoring partner, the Factoring Ledger Entries or Detailed Factoring Ledger Entries can be transferred to Excel. There the data can be further processed and/or formatted in order to save it afterwards and send it, for example, by e-mail to your contact person at your factoring partner.

  1. Select the search symbol and enter Factoring Registers.
  2. Select the journal you want to send.
  3. Depending on what data your factoring partner needs, choose either the Factoring Ledger Entries action or the Detailed Factoring Ledger Entries action.
  4. Select the action Open in Excel.
Tip

You can personalize the Factoring Ledger Entries page. When you select the Open in Excel action, the columns that are displayed to you in Business Central are transferred to Excel. The order of the columns is also adopted.

Export using the Data Exchange Framework

  1. Set up a factor and assign a created Data Exchange Definition.
  2. Select the search symbol and enter Factoring Registers.
  3. Choose the register to export and click on the Export action. The export will be started.

Automatic Export by using the Job Queue

You can automate the compilation, posting, and export for one factor at a time via a job queue entry. To do this, proceed as follows:

  1. Select the search symbol and search for Job Queue Entries.
  2. Select the New action.
  3. Enter number 5490538 in Object ID to Run. This is the number of report Post and Export Factoring Journal.
  4. Select the Report Request Page action.

  5. Enter your desired Factor.

    Tip

    The factor has to be assigned to a factoring journal template. A new journal batch is going to be created during runtime and deleted afterwards.

  6. Set the Export Factoring Ledger Entries switch if you want to send the posted factoring ledger entries to your factor by email.
  7. Set the Export Customers switch if you want to send the factor's customers by email.

If you do not set either of these switches, the report still creates a factoring journal and posts it to a register so that the user can export the data later manually. When compiling the customer items, the filters of the factor are used.

See also

Use Job Queues to Schedule Tasks
Set up Data Exchange Definitions