The formula for average cost calculation with negative quantities in SIMS

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 transaction. This is the standard formula to account for the cost of sales.

When the next purchase is updated in the system, and the two costs (average cost and new purchase price) do not match, the system will post a journal to the general ledger in the cost allocation account to provide for this discrepancy. At the same time, the system will update the Average Cost Posting Audit within SIMS (Admin > SFM Interface > Average Cost Posting). This does not affect the quantity in stock or the last purchase price.

From negative to positive quantity in stock

When the current quantity in stock is negative and you purchase enough stock to cover the negative amount and more, the system will replace the current average cost with the last purchase price or landed cost of the product.

In this event, the system will post an SFM journal in the cost allocation account for the amount of the negative quantity * [the difference between the current average cost and the new purchase price]. Please refer to Example 1 in the attached sheet.

From negative quantity to still negative quantity in stock

When the current quantity in stock is negative and you do not purchase enough stock to turn the quantity in stock to positive, the system will maintain the current average cost (not the last purchase price or landed costs).

In this event, the system will post an SFM journal in the cost allocation account for the total quantity of the purchase * [the difference between the current average cost and the last purchase price for this consignment]. Please refer to Example 2 in the attached Excel sheet.  


Notes:  
- The above formula was optimised and updated from Version 2.3.31 of SIMS.
- The posting of the journal entry is only applicable to installations with the SFM Interface which includes the posting of the cost of sales.
- The entries in the Average Cost Posting Audit are applicable to all installations.







    • Recent Articles

    • How to Reverse a Sales/Purchases Transaction in SFM

      Reversing Entries in SFM Once users confirm an entry in SFM, they cannot modify any of its elements. The only available option is to reverse the entire transaction and re-post it with the correct values. The system supports both simple reversals and ...
    • Setting Up BOV SEPA v9

      Before proceeding, please ensure you are using the latest version of SFM. Starting October 5th, 2025, Bank of Valletta (BOV) will begin processing live transactions using the new SEPA file format (version 9). The older version 3 format will no longer ...
    • How do I process a Nominal Reconciliation?

      Procedure for Reconciling a Nominal Account (Current Year > Nominal > Nominal Reconciliation) Account Field: Select the relevant Nominal Account from the drop-down menu that you wish to reconcile. Details Field: Enter any necessary free text in the ...
    • How to Update SFS

      For optimal results, update SFS directly from the server. Important notes before updating: - All Users: Log out of SFS, SIMS and SFM (if applicable). - Remote Desktop Users: Log out of SFS, SIMS and SFM before disconnecting from the remote session. ...
    • How to Add Custom Footers per Client basis

      If you want to apply the same footer across all your invoices or the same footer across all your statements, please refer to this article: How to insert document footers in SFM If you need to use different footers for specific clients, SFM also ...
    • Popular Articles

    • How do I process an End Of Year in SFM?

      Overview SFM allows posting into two financial years simultaneously. This means that users do not need to finalise 2024 before starting to post entries into 2025. The end of year procedure will move the “Current Year” data into the "Previous Year". ...
    • Do I need to Process an End-of-Year in SIMS?

      SIMS does not require an end of year procedures to be run. However, SIMS controls users to only allow posting of transactions, such as sales invoices, cash sales, adjustments and purchases, within a range of dates referred to as the Posting Period. ...
    • How to setup a System Control Account in SFM? (Bank Account, Cash Account, Stock Control, etc...)

      Create the Account in your Chart of Accounts as seen below. Please make sure you use the code depending on your Heading and Sub-Heading digits. After creating the account, you need to specify the account as a System Control Account. Go to Support > ...
    • How to reset your Shireburn remote desktop service (RDS) account password

      The password for the Shireburn RDS Account used to connect to RDS server is set to expire after 90 days. A notification is provided to the user daily starting 5 days prior to the expiry date. In order to change password, the following steps need to ...
    • SIMS - User Manual

      The attached PDF includes the necessary functions and features of SIMS to get you started. SIMS User Manual.pdf