FormerMember

Import general journal entries

SUGGESTED
Posted By FormerMember

Hi,
i need help with import general journal entries
I would like to import a text file containing two transactions an invoice and a payment but I have the error below:

------------------------------------------------------------------------------------------------------
Import started...
Reading transactions...
Reading transaction 2071.
Import Error: Amount on line 6 is invalid. The amount must contain a number, a minus sign, or a decimal point, and can have up to 2 decimal place(s).

Import Error: Amount on line 8 is invalid. The amount must contain a number, a minus sign, or a decimal point, and can have up to 2 decimal place(s).

Import Error: Transaction 2071 not read.

Reading transaction 2071.
Transaction 2071 read successfully.

Checking for balanced transactions...
Transaction 2071 is balanced.

Recording transactions...
Transaction 2071 recorded.

Import file has been successfully processed.
Summary
Total Transactions in file: 2.
Transactions not read: 1.
Transactions successfully recorded: 1.

--------------------------------------------------------------------------------------------------------

and here is the contents of my text file:

11-13-18,"2071","Facture no 2071"
4160,-145.00,"Total sans rabais:166,71, 166,71xGravure - Inscription@145,00 "
4330,-800.00,"Total sans rabais:919,80, 919,80xConcession de lot 2 x 2@400,00 "
3010,1086.51,""
2012,-47.25,"TPS (101 074 953) Original:47,25 Taux:5,00000% Rabais:0,00%"
4164,00.00,"TPS (101 074 953) Rabais:0,00%"
2012,-94.26,"TVQ (10 0626) Original:94,26 Taux:9,97500% Rabais:0,00%"
4164,00.00,"TVQ (10 0626) Rabais:0,00%"
11-16-18,"2071","Comptant F:2071"
1011,1086.51,"Paiement Id : 2402 (Comptant)"
3010,-1086.51,"Balance des paiements"