What do I do when SIMS stops updating because 'stock item value is not zero'?
Question: When posting transactions, why does the system stop updating and gives the error "Stock Item Value is Not Zero"?Answer: While posting Purchases, Return to Suppliers, Adjustment Add and related WIP Transactions, the system includes a validation to confirm that the stock valuation integrity is maintained throughout the system.
There are two main reasons why this happens:
- The current quantity in stock is negative and the user is trying to update a Purchase or an Adjustment Add with the same quantity but with a different value from the current average cost. Refer to the example below.
- The user is trying to process a Return to Supplier for an item with the same quantity as currently in stock but with a different value from the current average cost. Refer to the example below.
Example
Item ABC123: Current quantity in stock is -20; the average cost is € 10; and the valuation is -€ 200.
Purchase 20 at a cost of € 12 per item, which works out at a total value of € 240
The above will result in a cost different per item of € 2 -- a total of € 24.
|
Details |
Quantity |
Average Cost |
Valuation as per Inventory |
Valuation as per Balance Sheet |
|
ABC123 |
-20 |
10.00 |
-200 |
-200.00 |
|
Purchase ABC123 |
+20 |
12.00 |
+240 |
+240.00 |
|
Balance |
0 |
12.00 |
0 |
24.00 |
If the user prints a valuation report from SIMS, the value will be zero (Qty 0 * 12 = 0) while your accounting system will show a discrepancy of € 24 which is not accounted for.
e
The solution
The system provides the following option to account for these discrepancies as follows:
For users who have an interface with SFM, the first this to do is create an Account in the Profit & Loss part of the Chart of Accounts, under the Cost of Sale Sub Header accounts, which can be called Cost of Sales Valuation – SIMS. From SIMS, select the ADMIN option from the Menu > Company Maintenance and click the TAB Settings and amend the account code as created in SFM.
Note:
Full SFM Interface: For users who have the full interface with SFM, the system will post these values by debiting/crediting the account code as defined above and the stock control account.
Sales Only Interface with SFM: For users who do not interface the cost of sale, the system will not post any entries in SFM and it is up to the user to account for these values.
For both the above two settings, the system provides an audit trail of these adjustments which are available from the ADMIN Menu, SFM Interface, Average Cost Posting.
Related Articles
Error: 'Average cost below zero for stock code [code]' when returning an item
Problem When a user tries to return an item with a cost that is higher than the purchase price, the system gives a notification that the Average Cost below zero for Stock Code [code] Example: User has 465 * 4.0697 in stock = €1,892.41 Trying to ...SIMS and SFM Interface Posting
The following table identifies the accounting entries posted in the Shireburn Financial Manager from transaction in the Shireburn Management Inventory System. The link from the inventory to the accounting system is available from the stock group or ...Error: No accounting details for code when exporting from SIMS to SFM
Problem Error: No accounting details for code when exporting from SIMS to SFM Environment SIMS, SFM Solution The Accounting details on SIMS from Stock Groups or Location need to be updated. It is important to first: 1. Confirm which accounting ...Can I change or delete stock codes in SIMS?
SIMS provides the option to change or delete a stock code, as detailed below. Both options can be accessed from Admin > Change/Delete Stock Cards. Change a stock code When you access this function, click on the insert button to add the stock code ...How to Change a Stock Code in SIMS
To change a stock code: Open SIMS. Click on Admin > Change/Delete Stock Card > Change/Delete Stock Card. 3. Input the old stock code, leave the Delete box unchecked, and input the new stock code. 4. Click on the Save button (floppy disk icon) to ...