The accounting interface helps export ticketing data to 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 the isolation of products on accounting interface exports, it would not be possible to extract such 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 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.They also want to isolate the donation sales in order to export this data to another sales channel SC_DONATION."

  • 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

  • NEW:

   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:

  1. The improvement only supports below configuration of the Accounting interface:
    • Interface type "Accounting exports"
    • Enable aggregation (?aggregate=true)
    • Interface version: V3




      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 following this syntax "&productLink=productCode1->externalCode1, productCode2→externalCode2,...")


      3. Interface function and exported file:

    • The interface function to run is "Export file treasury"
    • The only affected export file is "Encaissements_AgV3"



         

© SecuTix 2023 - Login