Customer & Supplier Data Integration to Sage
Customer Maintenance
Create
Create messages are sent to Sage when a new customer is created in Vision Commerce in the ‘Customer Maintenance’ window. This posting updates Sage with the new customer information.
The first time a customer is set up in Vision Commerce, a posting will be made to Sage as a ‘Customer CREATE’ message. It is therefore important that all customers are first set up in Vision Commerce, for Sage to be automatically updated.
Edit
Edit messages are sent to Sage when an existing customer is edited in Vision Commerce in the ‘Customer Maintenance’ window. This posting updates Sage with the updated customer information.
Message
               A/C, Name, AddL1...etc
Supplier Maintenance
Create
Create messages are sent to Sage when a new supplier is created in Vision Commerce in the ‘Supplier Maintenance’ window. This posting updates Sage with the new supplier information.
The first time a supplier is set up in Vision Commerce, a posting will be made to Sage as a ‘Supplier CREATE’ message. It is therefore important that all suppliers are first set up in Vision Commerce, for Sage to be automatically updated.
Edit
Edit messages are sent to Sage when an existing supplier is edited in Vision Commerce in the ‘Supplier Maintenance’ window. This posting updates Sage with the updated supplier information.
Message
...
Overview |
|---|
Purchase Orders are input on to the system with different products, and product costs. Sometimes the cost specified on the order, is actually different to the value invoiced by the Supplier. In this instance, in the ‘Purchase Order’ window under the ‘Invoicing’ tab, the ‘Inv Value’ entered by the user would be different to the original expected cost input under the ‘Purchase Order Details’ tab. Please see section above which explains when a Purchase Order Invoice is posted to the finance system which is also when a PO Price Variance posting is sent to finance system. |
Purchase Order Price Variance |
Please see the table below for the debit/credit details posted to the finance system for this posting type. |
Posting Type | JD (Journal Debit) | JC (Journal Credit) |
1. PRODUCT COST (VARIANCE) | ||
 Purchase Invoice (Invoice Value > Order Value) | GRN Price Variance | Goods Received (GRN) Accrual |
 Purchase Invoice (Invoice Value < Order Value) | Goods Received (GRN) Accrual | GRN Price Variance |