We have a ready-to-use integration with Twinfield. You can find on the page ‘Export formats’ under ‘Company settings’.
Flexible mapping
Twinfield offers as a the first connection a more flexible configuration of the content of the XML.
For the Twinfield connection, we offer the following fields. Report values are booked on a ‘total’ level, expense values can be booked on ‘detail’ level.
Where to find the information?
SRXP | Twinfield
Category | Accounting > Dimensions > Winst & verlies (PNL) Profit and Loss
Establishment | Accounting > Dimensions > Kostenplaatsen (KPL) Cost Center
Creditor ID | Accounting > dimensions > Crediteuren (CRD) Account Payable
Payment methods | Accounting > Pay & Collect > Types
VAT codes | General > Company > VAT
Division | General > Company Settings > Code.
Journal Code | General > Company > Transaction Types
Projects | Projects > Manage projects > Time & expenses – Project Dimension Manager
Audit Code | General> transaction types > Inkoopfactuur
Make the free fields allowed + Document imaging : Name Audit Trail https://audit.srxp.com/$FreeText2$ = available in free field 2
Account Payable | General > Company > Settings > System accounts -> Crediteuren / Accounts payable (Open the lock) (on the report section, needed for dimension 1)
Currency | General > Company > Currencies
(!) if you want to export the expense currency, make sure that all currencies are existing in Twinfield,
------------------------------------------------------
The mapping of our generic export format with Twinfield
Purchase
Report values
Name XML code
Division / company code <office>
Journal code <code>
Currency <currency>
Booking date (per export file) <date>
Booking due date (per export file) <duedate>
Invoice number <invoicenumber>
Credit side description <description>
Credit side dim1 (creditor role) <dim1>
Credit side dim2 (cost centre) <dim2>
Credit side dim2 - no_reimbursement or to_pay <dim2>
Credit side total <value>
Credit side free text field 1 on 'total' line <freetext1>
Credit side free text field 2 on 'total' line <freetext2>
Credit side free text field 3 on 'total' line <freetext3>
Expense values
Debit side dim1 (ledger) <dim1>
Debit side dim2 (cost centre) <dim2>
Debit side dim3 (project / assets) <dim3>
Debit description per subamount <description>
Debit line value<value>Debit VAT code per subamount <vatcode>
Debit VAT value per subamount <vatvalue>
Debit side free text field 1 on 'detail' line <freetext1>
Debit side free text field 2 on 'detail' line <freetext2>
Debit side free text field 3 on 'detail' line <freetext3>
------------------------------------------------------
Memorial
Report values
Name XML code
Division / company code <Office>
Journal code <Code>
Export Currency <Currency>
Booking date <Date>
Due date <Duedate>
Invoice number <Invoice number>
REPORT DEBIT
Debit side dim1 (Balance) <dim1>
Debit side dim2 (Creditor) <dim2>
Debit side dim3 (Project / Assets) <dim3>
Debit description per subamount <description>
Debit line value <value>
Debit side free text field 1 on 'detail' line <freetext1>
Debit side free text field 2 on 'detail' line <freetext2>
Debit side free text field 3 on 'detail' line <freetext3>
REPORT CREDIT
Credit side dim1 (Balance) <dim1>
Credit side dim2 (Creditor) <dim2>
Credit side dim3 (Project / Assets) <dim3>
Credit description per subamount <description>
Credit line value <value>
Credit side free text field 1 on 'detail' line <freetext1>
Credit side free text field 2 on 'detail' line <freetext2>
Credit side free text field 3 on 'detail' line <freetext3>
Expense values
EXPENSE DEBIT
Debit side dim1 (ledger) <dim1>
Debit side dim2 (cost centre) <dim2>
Debit side dim3 (project / assets) <dim3>
Debit description per subamount <description>
Debit line value <value>
Debit VAT code per subamount <vatcode>
Debit VAT value per subamount <vatvalue>
Debit side free text field 1 on 'detail' line <freetext1>
Debit side free text field 2 on 'detail' line <freetext2>
Debit side free text field 3 on 'detail' line <freetext3>
EXPENSE CREDIT
Credit side dim1 (ledger) <dim1>
Credit side dim2 (cost centre) <dim2>
Credit side dim3 (project / assets) <dim3>
Credit description per subamount <description>
Credit line value <value>
Credit VAT code per subamount <vatcode>
Credit VAT value per subamount <vatvalue>
Credit side free text field 1 on 'detail' line <freetext1>
Credit side free text field 2 on 'detail' line <freetext2>
Credit side free text field 3 on 'detail' line <freetext3>
------------------------------------------------------
Cash
Report values
Name XML code
Company code <office>
Transaction type code <code>
Currency <currency>
Dimension - Cash code <dim1>
Amount <value>
Date <currencydate>
Description <description>
Invoice Number <invoicenumber>
Free Text 1 <freetext1>
Free Text 2 <freetext2>
Free Text 3 <freetext3>
Expense values
GL Account <dim1>
Cust./supp. /Ccr. <dim2>
Project/asset <dim3>
Amount <value>
Date <currencydate>
Description <description>
Invoice Number <invoicenumber>
VAT Code <vatcode>
VAT Amount <vatvalue>
Free Text 1 <freetext1>
Free Text 2 <freetext2>
Free Text 3 <freetext3>