| Table of Contents |
|---|
The General Accounting Export allow to account manager to have more control and capacity to solve issues immediately.
...
The field "Accounting code required" is not taken into account (will disappear in the future, for the moment set the "No" value).
Fill the values on the previous image, only Interface name is needed.
Schedules
It is possible to generate two different reports, PNM or CSV formats.
...
Generate PNM accounting file
Schedule fields
| Name | Possible value or definition (if apply) | Default value | Mandatory |
|---|---|---|---|
| 01/01/2023 00:00 | - | No | |
| 30/06/2023 00:00 | - | No | |
| Line types | Sales, VAT, Payments, Analytic, Sales Compensation, Payments Compensation | Sales, VAT and Payments | Yes |
| Email recipient(s) | name@secutix.com | - | No |
| Ordering | Fields by which to order accounting lines in file created, separated by , | No | |
| Amount formatting | 0.00 0,00 | 0.00 | Yes |
. , | . | Yes | |
| Computed fields | Formulas to calculate values for each file column pasted one after another. Max capacity of the box 4.000 characters (Following custom parameter box format). See details below. (Default CSV formula or PNM formula, specified below) | - | No |
| Yes | |||
| Only order ids | Generate a file with only the specified orders | - | No |
| The file will be created with the especific header | Yes Only for PNM | ||
| With headers | The file will be created with headers | Marked | Yes Only for CSV |
| Encoding | UTF-8 | UTF-8 | No Only for CSV |
| End of line | Unix / Windows | Unix | No Only for CSV |
| Field separator | Separator of the values, example: ' ' space, ' ' tabulation | tabulation | No Only for CSV |
| File to upload | Ignore | ||
How to write Formulas for "Computed fields"
...
| Code Block |
|---|
code_journal="VTE" date_de_piece=FORMAT(_order_date;yyMMdd) compte_general=IF(OR(_line_type=SALE;_line_type=ANALYTIC);_accounting_code_1;_line_type=VAT;_vat_accounting_code_1;_accounting_code_1) type_de_compte=IF(_line_type=ANALYTIC;"A";"G") compte_auxiliaire_ou_analytique=IF(_line_type=ANALYTIC;_accounting_code_2;"") reference_ecriture=_invoice_number libelle=IF(OR(_line_type=SALE;_line_type=ANALYTIC);IF(_delayed_payment=Yes;"Vente "&IFERROR(_purchaser_structure_name;_purchaser_last_name&", "&_purchaser_first_name);_name);IF(_line_type=VAT;"TVA collectée à "&FORMAT(_vat_rate;0.00)&"%";_payment_method_internal_name)) mode_de_paiement="S" date_d_echeance=IFERROR(_invoice_date;IFERROR(_order_date;"")) sens=_credit_debit montant_en_monnaie_de_tenue_de_compte=_amount type_d_ecriture="N" zone_reservee=_sales_channel_code code_iso_de_la_monnaie="EUR" |
Available fields for formulas
| Field name | Example value |
| _order_date | 25.02.2023 |
| _payment_date | 25.02.2023 |
| _order_id | 20995 |
| _line_id | 10228546422575 |
| _type | DIRECT_PAYMENT / SALE / CREDIT_WAIT_ACCOUNT / DEBIT_WAIT_ACCOUNT / COMPENSATION_SALE / DEBIT_CREDIT_NOTE / REFUND / REFUND_CLIENT / VAT |
| _kind | COMPOSED_PRODUCT / CHARGES / SINGLE_ENTRY |
| _accounting_code_1 | Visa / Credit / Pending / Voucher |
| _accounting_code_2 | 700000 |
| _accounting_code_3 | CA9 |
| _accounting_code_4 | |
| _accounting_code_5 | |
| _name | Gift voucher / Championship / Cap / Season ticket |
| _product_family | INT_PRODFAM/SPORTING / INT_PRODFAM/GOODS / INT_PRODFAM/MEM |
| _item_date | 2022-10-14 18:30:00.0 |
| _amount | 48000.00 |
| _vat_rate | 5500 |
| _vatcode_id | 15255 |
| _operator_name | PLC_TS |
| _contact_number | 10228546376027 |
| _payment_sale | P / S |
| _line_type | PAYMENT / SALE / VAT / ANALYTIC / COMPENSATION_SALE / COMPENSATION_PAYMENT |
| _payment_currency | EUR |
| _payment_method_code | CB |
| _payment_method_internal_name | Carte Bancaire |
| _card_type | VISA |
| _amount_without_vat | 48000 |
| _credit_debit | C / D |
| _vat_accounting_code_1 | 44571402 |
| _vat_accounting_code_2 | |
| _vat_accounting_code_3 | |
| _vat_accounting_code_4 | |
| _vat_accounting_code_5 | |
| _invoice_number | SPORT-0000021 |
| _invoice_date | 08.01.2023 |
| _purchaser_contact_number | 38791 |
| _purchaser_structure_name | FEDERAL EXPRESS FRANCE |
| _purchaser_first_name | Joe |
| _purchaser_last_name | Bloggs |
| _sales_channel_code | TS |
| _sales_channel_internal_name | Ticketshop Grand Public |
| _sc_accounting_code_1 | CA9 |
| _sc_accounting_code_2 | 70121000 |
| _sc_accounting_code_3 | |
| _sc_accounting_code_4 | |
| _sc_accounting_code_5 | |
| _delayed_payment | Yes / No |
| _logical_seat_category_code | Cat1 / Cat2 / Cat3 / Cat4 / Visitor |
| _product_code | Park / Champ / Season |
| _season_code | Y |
...