Start a Post

Importing stock quantities and average cost

This thread is now archived and closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please post a new topic.
1 Post

Importing stock quantities and average cost

Hi all,

I have imported the item master fields from an old database.

Is it possible to do a mass export from the old database and upload into the new database.


Ultimate Partner Mike_James
3,204 Posts
Ultimate Partner
New Zealand

Re: Importing stock quantities and average cost [

To transfer stock (on-hand) quantities and average cost, you can produce an item list summary to Excel, then turn it into an inventory adjustment for import to the new file.


Export a dummy adjustment from the new file and open it in Excel to see the format. Change all dollar values to exclude $ sign and commas.

Regards Mike (
DataWise Limited (, developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)
Trusted User Bob
84 Posts
Trusted User

Re: Importing stock quantities and average cost [

Hi Johnnie,

As an adjunct to Mikes response you will need to convert this data file to a Text file .txt, (tab delimitted I would sugget) before importing,

If you have any changes after importing, you can export again (it will be a Text file), open in Excel, make the adjustmemts, save as a Text file again, then import again.



Contributing Partner Tisnat
6 Posts
Contributing Partner

Re: Importing stock quantities and average cost [

Can I export last cost and average cost - as well the standard cost (which is a standard export)

MYOB Moderator AnnaRidley
809 Posts
MYOB Moderator

Re: Importing stock quantities and average cost [

Hi Tisnat,


You are not able to export Last Cost and Average Cost through the export process in MYOB.


However as described above you are able to run the Item List Summary and send this to excel to obtain your Average Cost figures in an excel spreadsheet.

Kind Regards,

MYOB Client Support

Accept as SolutionGot an answer that solves your issue?
Mark it as an Accepted Solution

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
Get the conversation started and make a new post Start a Post