| Table of Contents |
|---|
...
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.
...
| 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. Notes: line type must be in capital letters: LINE_TYPE To put in descending order: field_name(DESC) | Ascending order by default for the specified field | 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 | ||
...
| 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 |
| _file_number | 4578 |
| _audience_category | FULL |