The accounting interface helps to export ticketing data files to the accounting systems. The collected data includes orders and payments information, which the accounting systems can use for many purposes, including the following request (for example):
"I want to extract the sales of donation product only, in order to isolate it with other products to provide data for specific systems"
Without this new improvementthe isolation of products on accounting interface exports, it is would not able be possible to extract such a correct data because a information. The reason for that is a payment line (in the exported file) represents the total amount for orders purchasing multiple product families.
How does the feature help?
This improvement provides the additional lines, if the exported file contains the specific products , see below examples between old export file and new export file:to enable it.
"On Box office, a contact purchases an order with event ticket 60$ and Donation product 35$, paid by CASH. On Ticket shop, a contact purchases an order with a Donation product 10$, paid by CASH.
The organization exports the aggregate payment file using Accounting interface. Besides, they They also want to isolate the donation sales in order to export these this data to another sales channel SC_DONATIONS afterwardDONATION."
- OLD:
20181027;OPERATOR1;OPERATOR1;OPERATOR1;1726;USD;95000;Cash;Espèces;;DIRECT_PAYMENT
20181027;NIHON_TDC_TS;NIHON_TDC_TS;NIHON_TDC_TS;49;USD;10000;CrdtCard;Carte de crédit;;DIRECT_PAYMENT
...
20181027;OPERATOR1;OPERATOR1;OPERATOR1;1726;USD;95000;Cash;Espèces;;DIRECT_PAYMENT
20181027;SC_DONATIONS;SC_DONATIONS;SC_DONATIONS;1726;USD;35000;Cash;Espèces;;DIRECT_PAYMENT
20181027;NIHON_TDC_TS;NIHON_TDC_TS;NIHON_TDC_TS;49;USD;10000;CrdtCard;Carte de crédit;;DIRECT_PAYMENT
20181027;SC_DONATIONS;SC_DONATIONS;SC_DONATIONS;49;USD;10000;CrdtCard;Carte de crédit;;DIRECT_PAYMENT
How to
...
proceed:
- The improvements improvement only supports below configuration of the Accounting interface:
- Interface type "Accounting exports"
- Enable aggregation (
?aggregate=true) - Interface version: V3
Interface function: Export file treasury
2. Add a link between product_Code and specific code in URL parameter: "&productLink=DON→SC_DONATIONS"
- "DON": ticketing product_Code
- "SC_DONATIONS": external system specific code
- (You can add multiple product links follow the following this syntax "&productLink=productCode1->externalCode1, productCode2->externalCode2productCode2→externalCode2,...")
3. Interface function and exported file:
- The interface function to run is "Export file treasury"
- The only affected export file is "Encaissements_AgV3"
