Error: 'Average cost below zero for stock code [code]' when returning an item

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 return 462 * 5.75 = €2,656.50

€1,892.41 - €2,656.50 = - €764.09

Even though the user is returning a smaller quantity, the cost is much larger, resulting in a negative value.

Environment

  1. SIMS: Return to Supplier module

Solution

1. Change the Average Cost:

The user needs to change the average cost of the product to return the item at that cost.
The average cost can be changed by pressing the Avg button located in the stock cards details:


Solution

2. Make an Adjustment Deduct:

This can also be done by making an Adjustment Deduct of the current item and then an Adjustment Add of the same item with the correct average cost.

Cause

 The user attempts to return an item with a higher cost than the purchase price.


Related articles: 

    • Related Articles

    • 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 ...

    • 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 ...

    • What is the formula for average cost calculation with negative quantity?

      Negative quantity and average cost calculation When a product(s) sells more than the quantity in stock, the system will use the current average cost as the cost of sale of the product, both for the inventory reports and also for the 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 ...

    • 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 ...