Forum Discussion

Graham1's avatar
Graham1
5 years ago

Importing Item Sales Pricing error

We have a very large volume of Item sales so I am trying to test out importing a CSV file of the data. The data imported fine, however the Pricing did not show on the invoice. I did not import the pr...
  • Mike_James's avatar
    Mike_James
    5 years ago

    Hi Graham1 , in that case ask your developers to extract and use the customers and items data from MYOB when preparing the invoice in the new system. That will be far more effective than manipulating CSVs.

Neil_M's avatar
Neil_M
Former Staff

Hi Graham1 

 

When importing sales, we do recommend including as many fields as possible, including the price for each line. If this information is not included, then AccountRight will assume a zero value for that line. This in turn can cause importing errors around the total of the invoice being imported.

Graham1's avatar
Graham1
5 years ago

Hi Neil, Thanks for the response, but is this the only solution? We have different pricing for different clients and about 60 item categories on each line item, over 200 invoices a wekk - this would mean a huge amount of data entry prior to import.

  • Neil_M's avatar
    Neil_M
    Former Staff
    5 years ago

    HI Graham1 

     

    You would need to have the information within the import file prior to importing that file, so that the information can be brought into AccountRight. Currently there’s no way that I am aware of to circumvent having the information within the import file

Looking for something else?

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

Community home

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