• 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…
  • Stock date of existing Lot number not updating at the time of Receipt !

    Hi, If we receive an item to an existing Lot, Why the stock date and Expiry dates are not updating automatically to the date of PO Receipt. ? This will make an issue of Auto-allocation in OE, system will take this Lot ,even it contains the latest…
  • Item Valuation Doesn't match with General Ledger

    Hello, Which is the correct procedure of comparing current Inventory value with General ledger? Item valuation by ''Transaction cost'' is matching with GL. But, ''Location details cost'' not matching with GL.
  • Vendor Details

    My SAGE 300 is setup the way every time we enter receipt it will update vendor cost in Vendor Details. In general this is fine but lately we experiencing problem where PO’s are delivered after 3-4 moths and price is changing frequently, so old PO will…
  • 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…
  • Moving away from segmented item numbers

    Our company started using item structures and segment codes around 3 years ago and it is simply not working for the type of business we do. Currently we use the hyphen as a segment separator. We would like to go back to using the vendors item number as…
  • Errors on Posting

    Client receiving errors in posting status on worksheet. stocktake does get posted and adjustment batch posted. But on post reconciliation, status is Errors in Posting
  • qty on s/o with decimal?

    FormerMember
    FormerMember
    The product has an odd number of quantity on S/O. There shouldn’t be any decimals in this field because all quantities listed in S/O should be for each.
  • What the criteria for an item to be reflected on the IC reorder report

    FormerMember
    FormerMember
    Good Day Please explain what criteria is used for determining which items get reflected on the re-order report. I am experiencing instances of item QOH below the minimum Qty but not showing on the report. What other factor is being evaluated ? Please…
  • IC Day End Error

    Hi All, There is a day end error of our client which displaying - Day end processing could not process all transactions. Their Installation is Sage 300 ERP 2017 - PU 5. We had done DB Dump, Load, Integrity Check with Fix minor errors, but it did not…
  • Qty committed to sale

    Hi Support, We have a client who used to use VM Service manager. which was linked to inventory and order entry. they have identified some items that have Qty committed to sale because of VM service manager. the items are old and need to be written…
  • Returning items to inventory

    Hello, I have a few items that were capitalized some time ago that need to be returned to inventory. I am unsure how to do this. How can I move them back to inventory and have the original cost associated with each item? And how can I adjust the accumulated…
  • 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…
  • ALTERNATE ITEM

    Hi All, Does anyone know or can tell from which screen in sage the alternate item is usable? can it be use in order entry where you can easily substitute the alternate item when the original item has no stock? Thanks
  • BOM question - exchange parts/components

    hi guys, need to pick your brains on this one: M(aster item) = A + B + C + D In one single transaction, we would like to swap (exchange) D with X, in other words: M = A + B + C - D + X How do we achieve this without first "disassemble" then…
  • easiest way to update item pricing after changing discount percentages on a Price List Code?

    Sorry if this is a dumb question -- I'm just starting to learn I/C and O/E. I don't see an obvious way to update prices on items if I make changes to the discount percentages for A-E on the Price List Code which those items are assigned to. Update Item…
  • How do you lock item categories using Sage 300 ERP for Inventory Management?

    This topic came up during Sage Summit 2013: How do you lock item categories using Sage 300 ERP for Inventory Management? What advice would you give?
  • Does Sage 300 ERP need a cycle count before locking down inventory?

    Another question that people wanted to have an answer to Does Sage 300 ERP need a cycle count before locking down inventory? Let's see what people have to say.
  • How do you update inventory pricing in Sage 300 ERP when over 5,000 items exist with different product lines?

    This was question was on a lot of people's minds during Sage Summit 2013: How do you update inventory pricing in Sage 300 ERP when over 5,000 items exist with different product lines? How would you answer this question?
  • Assign serial number error

    When trying to receive inventory for a serialized item I receive the following message: Description: Incorrect procedure. The next serial number cannot be generated: the serial mask structure does not contain an incrementable segment. I have no incremental…
  • The Order of Things: Day End Processing

    As we continue to explore the Inventory Control module in Sage 300 ERP, this week’s blog is going to outline the order that Day End Processing takes once you run it. The main purpose of Day End Processing (DEP) is to move a lot of processing away from…
  • Understanding Inventory Control Account Sets

    In the second of our series on outlining the various Inventory Control Costing Methods in Sage 300 ERP, this week’s blog focuses on helping you understand the different Inventory Control Account Sets. Account sets are groups of general ledger accounts…
  • Defining Inventory Control Costing Methods

    In the first of our series of blogs outlining the various Inventory Control Costing Methods in Sage 300 ERP, we want to start things off by introducing you to the different Costing Methods you will find in the Inventory Control module. Weighted…