Forum Discussion

SharonMaguire's avatar
SharonMaguire
Experienced User
2 years ago

Error 4346 An unbalanced transaction Sales Invoice Batch Import

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 IDInvoice No.DateItem NumberQuantityPriceDescriptionInc Tax Total
2820060S186021/01/2023OpAdjP-3-143.67Guitar - Classical tuition - Term 4, 2022 ; Individual 30, -3 lessons Wks 3,4 & 5 TA no make-ups available-143.67
6141812S185111/01/2023OpAdjP-2-95.78Trumpet tuition - Term 4, 2022 ; Individual 30, -2 lessons Credit due to teacher absences-95.78
3506589S185111/01/2023OpAdjP11.92Trumpet tuition - Term 4, 2022 ; 2022 WollCon Loyalty Discount reversal due to credits1.92
3174393S190481/01/2023OpAdjP4-47.89Vocal - Contemporary tuition - Term 4, 2022 ; Individual 30, -1 lessons TA-47.89
6142438S185161/01/2023OpAdjP4-95.78Baritone Horn tuition - Term 4, 2022 ; Individual 30, -2 lessons Credit due to teacher absences-95.78
2332351S185161/01/2023OpAdjP41.92Baritone Horn tuition - Term 4, 2022 ; 2022 WollCon Loyalty Discount reversal due to credit1.92
  • 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

  • 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