Support Off the Chain/Manuals/Inventory
Stock and Value Adjustments
Support Desk
posted this on January 18, 2011 17:40
Adjustments can be used to ensure your stock levels are accurate, along with their average costs
| • | To increase or decrease stock levels or to increase or decrease the value of your stock go to the Stock Adjustment List screen under the Inventory tab |
| • | To create a new adjustment click the Add Adjustment button |
| • | You can sort the list displayed by Adjustment Status by selecting it from the drop down |
| • | To edit an existing Active adjustment either click on the required adjustment line or the Edit button next to the required line |
| • | You will see a count of your adjustments at the bottom right |
| • | You can amend how many adjustments are shown on your screen by selecting the required number at the bottom of the data grid |
| • | You can organize the adjustments by column by double clicking the column name at the top |
| • | To create an adjustment select the product you wish to adjust by either using the Code or Description alpha search, or click the Search button for a more detailed search |
| • | Once the product is selected the stock on hand quantity and value will be shown in the data grid |
| • | Enter in the Adjustment Quantity or Adjustment Value you wish to add or remove in the appropriate field |
| • | The Adjustment Value is the value per unit times the number of units, making it total adjustment value |
| • | For negative adjustments place a minus (–) before the quantity or value |
| • | You cannot reduce the quantity or value of a product to negatives through an adjustment |
| • | Select a Reason for the adjustment from the line drop down. The available Adjustment Reasons are those you have created in your settings |
| • | Enter in any comments that will be useful for future reference in the Comments field |
| • | You can Delete any line of the adjustment if required by clicking the Delete button next to the required line |
| • | Once you have successfully entered the correct adjustment details click the Complete button |
| • | This will update your stock quantities and re-average your Landed Average Cost accordingly |
| • | If your adjustment includes value it will automatically send an adjustment journal interface to Xero for approval |
| • | You can print the adjustment by clicking the Preview button, Cancel the adjustment to start again by clicking the Cancel button or Delete the adjustment in full by clicking the Delete button |
| • | If your adjustment includes value it will automatically send an adjustment journal interface to Xero for approval |
| • | Journals show in Xero as nil value Accounts Payable drafts and should be Approved regularly, to keep the drafts list clear and to ensure your Balance Sheet and Profit and Loss stay accurate |
| • | It is very important to ensure your Xero Configuration account selections and setup for both Stock on Hand and Cost of Goods Sold are correct |
Comments latest first
This helps a lot, thanks.
Is there some kind of documentation about Unleashed ? Something like a user manual ? I haven't found any on the internet.
Hi Christopher,
When a product is ordered and you have it on a parked invoice the stock is allocated and the available amount is reduced (the physical stock on hand is unchanged). When you complete the invoice and send the goods out the stock on hand is reduced. The adjustment for this stock is not shown as a stock adjustment but as a sales invoice when looking at it in Unleashed.
A journal is sent to Accounts Payable drafts in Xero reducing the stock and increasing cost of goods sold.
Hope that helps!
When a product is ordered, and the stock is decremented by the amount of product quantity ordered, are these (automated) stock movements listed in the "Stock Adjustement List" ?
The adjustment value per the number of units you are adjusting is exactly what I needed to know. In this instance I am working in negatives so I take it is will be a minus value.
The adjustment value is the number of units you are adjusting by times the value of those units.
Thanks
The Unleashed Team
"• The Adjustment Value is the value per unit times the number of units, making it total adjustment value"
Is this the number of units you are making the adjustment by or the total number of units you will have in stock after you have made the adjustment?
Hi Graham,
Sorry seemed to have missed a few comments here and there. You will not be able to make stock adjustments retrospectively. The date used will be the current date.
Thanks for the question!
Can you make stock adjustments for a previous date. i.e. I want to change the stock figure as at 31 March but need to do so on the 2nd of April?