Settles internal stock transfers between organizational units by creating matching sales invoices and purchase invoices between the source and destination units.
The action runs as a step in a SyncTool configuration. You configure the step's settings (e.g. server, login, path, format or SQL depending on the action) and run the configuration. The action fetches the data it needs from Sapera or the external source itself – you do not map source columns as you would for a regular import. Any parameters are described below.
The action reconciles internal stock transfers between departments: it creates matching sales and purchase invoices between the source and destination department, so the goods are settled correctly between them.
Direction: creates invoices between the departments in Sapera.
Line format: every transfer becomes one priced line on the document.
Settlement key: the key lives in the document’s subject. Settlements created before the key moved there carry it in the requisition number and still count as settled, so an old month is not invoiced twice.
Parameter | Explanation |
CreatePurchaseInvoice | Also creates the matching purchase invoice in the department mapped through OuCustomerMapping. Off by default, so only the sales invoice is created; turn it on to create both documents. |
DiscountPct | A percentage discount applied to every settlement line on both the sales invoice and the purchase invoice. Give it as a number between 0 and 100; both 2.5 and 2,5 are accepted. Blank or 0 means no discount, and a value outside 0-100 stops the step rather than settling at full price. The discount is calculated and rounded per line, so a document’s lines and its total agree. |
ExemptVat | Marks the settlement lines as exempt from VAT, and is on by default: an internal transfer only moves value between your own departments. Turn it off when the settlement is a real supply between two separate legal entities - the line then follows the VAT type on the account behind the invoice product. |
InvoiceProduct | Identifier of the product used for the settlement amount line. |
OptionalFromDate | Optional start date limiting which stock transfers are settled. |
OptionalToDate | Optional end date limiting which stock transfers are settled. |
OuCustomerMapping | Maps each destination organizational unit to the customer identifier used on the settlement invoice. |
OuSupplierMapping | Maps each source organizational unit to the supplier identifier used on the settlement purchase invoice. |
TextProduct | Identifier of the product used for the descriptive text lines. |
See also the overview SyncTool – actions.
Want to know more?
Read more in these related articles:
Standard parameters for all actions
The general parameters available on most SyncTool actions: step control, error handling, timeout, etc.
