• Recalculate Cost Inventory Control Item

    When we are using costing item on Inventory Control module, Day End Process or During Posting. Then we have Audit result and doing Adjustment backdate, ex. current period Nov 2023 (many issued/internal usages Item from Jan to Oct), we input IC Adjustment…
  • Adjustment Inventory after Audit

    We use Sage 300 2022 PU2, and Costing setup Inventory Control is During Posting (not Day End Process). We have done Adjustment Cost (IC Adjustment --> Cost Increase) for date 31 Dec 2022, after that we do issue (internal usage) for 24 Aug 2023. But the…
  • How do I get the inventory counts for items to update when they are received in the Purchase Order module?

    I recently joined a company using Sage 300, and I've been trying to get their system working. In the past, they used generic item numbers on purchase orders (i.e. BATHHARDWARE1), so their inventory counts were useless because many items shared the same…
  • Adjust a BOM during a transaction

    Is there a way to adjust a BOM during a transaction. My client has a BOM that can use substitute materials. We are creating versions of the BOM for normal customizations, like using 50% of one material and 50% of the other, but they can make many versions…
  • How to updating Physical Inventory in Sage 300

    I'm a new user of Sage 300 I wanna Update my physical inventory because he's different with what I have on hand, so when is connect to the POS (Orion POS) I'm using the data are different to what I have on hand sometimes I can't even sell some Items.…
  • Cost decrease adjustment is not reflecting in Location details.

    We adjusted one of the item cost (cost decrease), but it is not affecting in location details. Inventory movement and Stock transaction report is showing correct figures. How an i solve this issue. In ICILOC table i saw Qtyonhand is 11 and Qtyshnocst…
  • How do I return a serialized item back to inventory that has been shipped but not invoiced?

    Hi Everyone, I have an order that has been "shipped" but not invoiced and I want to reduce the shipment by one, putting the serialized item back into stock. How do I do this? Thanks David
  • Quantity on S/O but no Sales Order in system for specific item

    Our client is working on Sage 300 2014 PU3. When doing the Physical Inventory Reconciliation it gave an error that states "There is insufficient quantity available to adjust item XXX at location XXX". When checking the specific item via Item Location…
  • po receipt entry

    Dear all I have a customer who has received 16 goods intstead of 32 and inserted the invoice number.. after running the day and processing, he realizes that he was supposed to receive all 32 quantities... what do i do please help
  • Batch description and Process bottom are not accessible for users

    When trying to process the Create Revalation batch in General Ledger, the Batch Description and the Process Botton are not accessible. We are using Sage 300 ERP 2014 , PU3, Microsoft SQL. Any ideas?
  • Inventory Costing

    Sorry if this is a duplicate posting - I may have hit the wrong button when previously entering. I have a client who recently converted to Sage 300. They implemented Inventory Control with FIFO for all items, even those that are serialized. Is there any…
  • Cost adjustment causing user to lose all entered data

    Have a client that tries to enter adjustments in Inventory. Sometimes when there's insufficient quantity for the adjustment it gives this error message, they fix their error and continue on: Other times, they get this error and it causes them to…
  • Items average cost showing negative

    Some of the costs(average cost) are showing negative on Adjustement...I will like to know what I am doing wrong to show this and what can be done to correct it,also what to avoid to avoid next occurrence...Thanks
  • Receiving Slip Entry Error

    Hello, While posting a receiving slip, the wrong item quantity was entered (2 instead of 1) and posted. I can re-post the receiving slip, but the inventory quantity for this item remains overstated. How can I correct this? Thank you!
  • Sage 300 5.5 inventory with negative average cost

    I have a couple of items with negative average cost. What's the best way to fix this in Sage 300 5.5? TIA, Peter Heinicke
  • IC Lot Quantity For Costing (not to be mistaken for "quantity shippable") - how to adjust/edit?

    Hello All, Does anyone know how (without going through SQL) to modify the columns "Quantity for Costing" under the lot tracking module? IC Lot Reconciliation and IC Adjustments merely affect the "quantity shippable". We're trying to modify the "quantity…