Skip to Main Content
Sage 200 Evolution ZA Ideas Portal

Welcome to the Sage 200 Evolution ideas Portal

Created by Guest
Created on Jul 18, 2025

Update unit cost using Inventory Journal Batch when Qty on hand is zero

The client has requested the ability to update the unit cost price using the Inventory Journal Batch specifically when the quantity on hand is zero.

Currently, they are required to perform cost updates using inventory adjustments, which is both time-consuming and inefficient, as it must be done item by item.

Allowing the unit cost update through the inventory journal batch in scenarios where there is no quantity on hand would significantly streamline their operations and improve efficiency. the client will be able to update the unit cost of items in batches.

Steps to re-create:

  • Create a new Inventory Item and set it to latest cost.

  • Process a PO for the Item Qty 100 at cost R100

  • Process a Sales Order Invoice and Issue and Invoice the full Qty 100 so that you are left with zero qty Unit Cost remains 100.

  • Process Inventory Journal Batch for the same items, not change on Qty update the New Unit cost to 120.

  • Validate and process the Batch and print pre-update batch Notice that it says cost updated to R120.

  • Now edit the Inventory item and check the latest unit Cost has updated to R120.

  • Now process a new Purchase order and it still shows the old Unit cost of R100, regardless the fact that the system updated cost price to R120.

Your Designation/Role Other
Email.
  • Attach files