Forum Discussion

ghendo's avatar
ghendo
User
2 years ago

Sales import csv

I am wanting to import sales invoices where I have sales items

The item price has 4 decimal places but I get error 4345 unbalanced transaction

 

file is 

{}

Card ID,Invoice No.,Date,Description,Price,Tax Code,Quantity,Item Number

371,207379,27/06/2022,SECURITY SERVICES,$471.1600,GST,1.000000,SECURITY SERVICES

 

I must have 4 decimal places in the price or at least 3

1 Reply

Sort By
Replies have been turned off for this discussion
  • Yanike_S's avatar
    Yanike_S
    MYOB Moderator
    2 years ago

    Hi ghendo 

     

    Thanks for your post. When you import sales the Amount can have 15 characters (including 2 decimal places). More than 2 decimal places are rounded to 2 decimal places.

     

    You can find more about that here: Import and export fields.