Linking entries for managing offsetting between customer and vendor.                                                                                                                                                                                

Module Description

This module allows to manage compensations between customer and vendor, by indicating their code in the masterdata.

Setup

Setup Origins

On the Origins setup you will need to fill in the following fields:

• Journal Compensations: template on which the compensation will be inserted
• Batch Compensation: batch on which the compensation will be inserted, related to the Journal setting on the previous field
  

Customer/Vendor card

To manage the link between the masterdata, the Related vendor No. field must be filled in on the customer master data. The system will automatically fill in the Related Customer No. field on vendor.

The fields can be editing either by the customer or by the vendor.

Functionality

Compensation

To carry out the compensation between customer and vendor, it is necessary to use the “Compensate entries” function present in the customer (or supplier) card.

A screen will open from which it is possible to select the documents to be balance. On the left side it's visible the customer's open entries, on the right side those of the vendor:

The fields shown are the following:

• Select: flag to select documents to link
• Vendor/Customer: indicates the vendor/customer number of the document
• Company name: customer/supplier's company name
• Document type: indicates the type of document
• document: document protocol
• Posting date: date of registration of the document
• Description: description associated with the document registration
• External document number
• Expiration date
• Amount: total amount of the document
• Amount (LCY): total amount of the document in local currency
• Remaining amount
• Outstanding amount (LCY)
• Amount to connect: if the amount to connect is different (smaller) than the document amount, you can manually change it in the “Amount to connect” field.
• currency: indicates the currency of the document if different from euros.

After selecting the entries to be linked, using the “Suggest compensation” function will open the journal batch previously set up in the Origins setup.

The fields will be pre-populated with the information display on the compensation page, the only field that will need to be updated is the offset in case the compensation does not add up exactly therefore it becomes necessary to detect a payment or a receipt.

After checking it, you will be able to posting the batch.

General aging

For customers/Vendor with compensation setup active, it's available a printout of open entries: Origins Print General aging.

The report can be filtered by:

• Payment Method
• Posting date
• Expiration date
• Print type: due, No./due or Cust/Vend due

Below is an example of this print: