Forum Discussion

ghendo's avatar
ghendo
Member
3 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

Replies have been turned off for this discussion
  • 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.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.