Bulk update stock take data

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.
Experienced Cover User Kelly81
260 Posts
Experienced Cover User
Kelly81
Experienced Cover User

260Posts

88Kudos

1Solutions

Bulk update stock take data

Hello,

 

Is there any way to import a file to update the stock on hand figures in AR?

 

I'm just setting up a company file and it is going to be a slow laborious task to manually enter them in.

 

Thanks. 

1 REPLY
MYOB Moderator Neil_M
6,011 Posts
MYOB Moderator
New Zealand
Neil_M
MYOB Moderator

6011Posts

632Kudos

819Solutions

Re: Bulk update stock take data

HI @Kelly81

 

Thanks for your question

 

When setting up the opening inventory in AccountRight the best way to enter this information, as per our help article Set up items, is to use the Count Inventory feature of AccountRight. This lets you enter in all of the on-hand quantity items and then generate an Inventory Adjustment transaction to bring all of the opening on hand quantities into your file.

 

Alternatively, if you have all of the on-hand inventory quantities saved into an Excel spreadsheet then you could create the inventory adjustment import file and import that into AccountRight. This will save you having to enter all of the on hand balances through the Count Inventory window.

 

To create the import file, the best way is to enter in one Inventory Adjustment transaction and then export that out as a template and enter in the rest of the on hand items using the formatting in the template file.

 

Do let us know how you get on with this,



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