Error 4346 An unbalanced transaction Sales Invoice Batch Import

SharonMaguire

Please see below columns for import, not sure what I'm missing? Plus it seems to be trying to bring it in in 1 line?

 

Card ID	Invoice No.	Date	Item Number	Quantity	Price	Description	Inc Tax Total
2820060	S18602	1/01/2023	OpAdjP	-3	-143.67	Guitar - Classical tuition - Term 4, 2022 ; Individual 30, -3 lessons Wks 3,4 & 5 TA no make-ups available	-143.67
6141812	S18511	1/01/2023	OpAdjP	-2	-95.78	Trumpet tuition - Term 4, 2022 ; Individual 30, -2 lessons Credit due to teacher absences	-95.78
3506589	S18511	1/01/2023	OpAdjP	1	1.92	Trumpet tuition - Term 4, 2022 ; 2022 WollCon Loyalty Discount reversal due to credits	1.92
3174393	S19048	1/01/2023	OpAdjP	4	-47.89	Vocal - Contemporary tuition - Term 4, 2022 ; Individual 30, -1 lessons TA	-47.89
6142438	S18516	1/01/2023	OpAdjP	4	-95.78	Baritone Horn tuition - Term 4, 2022 ; Individual 30, -2 lessons Credit due to teacher absences	-95.78
2332351	S18516	1/01/2023	OpAdjP	4	1.92	Baritone Horn tuition - Term 4, 2022 ; 2022 WollCon Loyalty Discount reversal due to credit	1.92

importlog Sales Batch Inv Import few columns.txt

gavin12345

Hi @SharonMaguire 

 

The solution to most importing problems can be solved by first manually entering 2-3 invoices of the type you want to import. Export them (more than one). Study the export file and replicate it with your import file.

 

One thing you will see is that there needs to be a blank line between each invoice, otherwise MYOB tries to import as one invoice.

 

Regards

Gavin