Start a Post

Bulk update stock take data

Experienced Cover User Kelly81
231 Posts
Experienced Cover User

Bulk update stock take data



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.



MYOB Moderator Neil_M
3,598 Posts
MYOB Moderator
New Zealand

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,

Kind regards,
MYOB Client Support
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