Customer Rebate Import Journal

Description

For customers that generate rebates in an external system, the import journal allows those rebates to be brought into Business Central so they can be managed within iDynamics Rebates and included in all standard reporting, settlement, and processing workflows.

Entering Data in the Journal

Data may be entered:

• Manually, line by line.
• Using Edit in Excel.
• Through RapidStart for bulk loading.
• Through external integrations that write directly to the journal table.

By default, the following fields appear in the journal:

• Posting Date – Specifies the date on which the rebate was generated.
• Document No. – A reference identifying the source of the rebate. The same number may be used for multiple customers but can appear only once per customer.
• Customer No. – The customer receiving the rebate.
• Rebate Amount – The rebate amount assigned to the customer.
• Description – A brief explanation of the rebate or the reason it was entered through the journal. If left blank, the system requests a general description for all empty lines at posting time.

In addition to the required fields, the journal also supports optional data used in reports and analysis:

• Settlement Group Code – The settlement group assigned to the resulting rebate entry.
• Base Amount – The base amount on which the external system calculated the rebate.
• Sales Amount – The sales amount associated with the rebate.
• Dimensions – Analytical dimensions used for reporting, settlements, and grouping.

Posting the Journal

Once all data has been entered, the Post action creates one rebate entry for each line.
If selected during posting, a provision entry can also be created for each rebate.
After posting is complete, the journal is cleared to allow a new import batch to be started.