Content Comparison

...

Table of Contents

The General Accounting Export allow to account manager to have more control and capacity to solve issues immediately.

...

Create an export interface of type "Accounting"

New Interface → → Exports → → AccountingImage Removed

...

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.

New schedule:

Generate CSV accounting file

Image Added

...

Image Added

Generate PNM accounting file

...

Schedule fields

s

Name	Possible value or definition (if apply)	Default value	Mandatory
Cash desk closes from (dd/MM/yy hh:mm) *	01/01/2023 00:00	-	No
Cash desk closes to (dd/MM/yy hh:mm)	30/06/2023 00:00	-	No
(Prendre en compte la date de clôture des caisses)	checked: only exports cashdesks that are closed “accounting” Not checked: exports all cashdesks
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
Decimal separator	. ,	.	Yes
Computed fields

Formula

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
Filename prefix	CSV → 'Ex PNM → 'ExportComptable_'yyMMdd_HHmm'.pnm'	CSV → 'ExportComptable_'yyMMdd_HHmm'.csv' PNM → 'ExportComptable_'yyMMdd_HHmm'.pnm'	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
Header line	The file will be created with the especific header	COMPTABILITE	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

* If this field is empty, when executing the schedule twice straight away, the result field will be empty, because the default behavior take the last execution date and there isn't data.

Available formulas and how to write it for "Computed fields"

Name	Syntax	Explanation
Constant	"Constant text"	returns any text contained within " " to include brackets () as part of constant text, each bracket must be preceded by - , e.g. " -(part á "&FORMAT(_vat_rate;0.00)&"% -)" & symbol should be avoided as literal text wherever possible
Variable	_field_value	returns value of field_value
Mandatory	MANDATORY(_field_value)	field_value is mandatory and if no value given in raw data, file is not created and error is logged
Format	FORMAT(field;format)	value of field will be formatted according to format Available Formats (for FORMAT() formula) 0.00 az09 → abcdefghijklmnopqrstuvwxyz1234567890 ddmmyy ddmmyyyy dd/MM/yy dd/MM/yyyy dd.MM.yy dd.MM.yyyy
If	IF(logical_test;value_if_true;else)	if logical_test returns true, value_if_true will be returned (and analysed if it is a formula), otherwise else will be returned (and analysed if it is a formula)
If error	IFERROR(value;value_if_error)	returns value if not empty/null, and if value=empty/null, value_if_error
Or	OR(value_1;value_2;…;value_n);true_value;false_value	if any of the conditions (value_1, value_2, etc.) return true, returns true_value; if all of the conditions return false, returns false_value
Concatenate	value_1&value_2&value_n	concatenates value_1 with value_2, etc
Equal	value_a=value_b	returns true if value_a is evalue_b, else returns false

Default CSV formula

Code Block

Code journal="ID"
N de compte=IF(_line_type=SALE;_accounting_code_1;_line_type=VAT;_vat_accounting_code_1;_payment_method_internal_name)
Piece="Ventes-"&FORMAT(_order_date;dd-MM-yyyy)
Libelle=IF(_line_type=SALE;_name&" -(part à "&FORMAT(_vat_rate;0.00)&"%-)";IF(_line_type=VAT;"TVA collectée à "&FORMAT(_vat_rate;0.00)&"%";"Paiement "&_payment_method_internal_name))
Debit=IF(_credit_debit=D;_amount;0.00)
Credit=IF(_credit_debit=C;_amount;0.00)
Analytique=IF(_line_type=SALE;_accounting_code_2;"")

...