# Stock level Adjustment Import

<span class="ts0">Please keep the following in mind:</span>

<table border="1" id="bkmrk-1-once-you-begin-wit" style="border-collapse: collapse; width: 100.864%;"><colgroup><col style="width: 4.57242%;"></col><col style="width: 95.4029%;"></col></colgroup><tbody><tr><td>1</td><td><span class="ts0">Once you begin with this procedure no source documents can be processed. Only a Stock Take freezes the inventory module.</span></td></tr><tr><td>2</td><td><span class="ts0">Do a backup.</span></td></tr></tbody></table>

![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1696).png)

<span class="ts25">Print an Inventory Valuation Report before starting a Stock Take</span>

<span class="ts25">IM – Report – Inventory Valuation</span>

![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1697).png)

<span class="ts25">If you don’t use any of the add on modules or Sales Orders then run a consolidated Valuation report per warehouse. However if you have the Bill of Materials add on module you will need to run a minimum of two reports.</span>

<span class="ts25">Example: A company is using Huge ERP and the Bill of Materials add on module.</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1698).png)

<span class="ts25">This will give you a complete overview of all stock on hand and value</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1699).png)

<span class="ts25">This report will give you all the stock that will appear in your BOM WIP account. </span><span class="ts76">Remember you can not affect this stock.</span>

<span class="ts77"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1700).png)

<span class="ts25">This is the stock that is to be counted.</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1701).png)

<span class="ts25">GL – Reports - Trial Balance</span>

<span class="ts25">Print a Trial Balance</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1702).png)

<span class="ts25">Inventory – Reports – Inventory Count</span>

<span class="ts25">Print an Inventory Count Report</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1703).png)

<span class="ts25">Print and export to excel</span>

<span class="ts25">Proceed with a manual stock take – See attachment </span><span class="ts78">‘Counted Qty.csv’</span>

![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1704).png)

<span class="ts25">Sort by Column Variance</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1705).png)

<span class="ts25">Now copy and paste the negative values onto a new excel worksheet and do the same for the positive. See attachments ‘</span><span class="ts78">Positive Stock’ </span><span class="ts25">and </span><span class="ts78">‘Negative Stock’.</span>

<span class="ts25">Remember that if the System Qty and Counted Qty are identical there is no reason to do a Stock Journal for these items.</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1706).png)

<span class="ts25">On the both import files create a new column called ‘Increase / Decrease’. This will allow the system to know whether the amount being import should increase or decrease the quantity on hand. To ‘Increase’ use a </span><span class="ts79">1 </span><span class="ts25">and to ‘Decrease’ use a </span><span class="ts79">0</span><span class="ts25">.</span>

<span class="ts25">Things to remember:</span>

<table border="1" id="bkmrk-1-you-cannot-import-" style="border-collapse: collapse; width: 75.8025%;"><colgroup><col style="width: 5.68463%;"></col><col style="width: 94.2907%;"></col></colgroup><tbody><tr><td>1</td><td><span class="ts25">You cannot import a negative figure, so re-evaluate the equation that you were using.</span></td></tr><tr><td>2</td><td><span class="ts25">The Variance column cannot have a 1000 comma separator.</span></td></tr></tbody></table>

![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1707).png)

<span class="ts25">IM - Activity – Stock Level Adjustment</span>

<span class="ts25">Click on the Upload button</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1708).png)

<span class="ts25">Browse button</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1709).png)

<span class="ts25">Browse for the first import file and click on ‘Open’</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1710).png)

<span class="ts25">Upload’</span>

<span class="ts24"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1711).png)

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1712).png)

![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1713).png)

<span class="ts24"> </span>

<span class="ts0"> </span>

<span class="ts0"> </span>

<span class="ts0"> </span>

<span class="ts0"> </span>

<span class="ts24"> </span>

<span class="ts0"> </span>

<span class="ts0"> </span>

<span class="ts30"></span>