• PO Day end on the Web Interface - (Customer do not have IC they only use PO)

    Hi Team Having a bit of a problem with the day end for customers that do not have IC module, on the normal desktop the day end then sit on Purchase orders how ever the web interface do not have the day end on PO. The admin must log on to the server…
  • Sage300 Item Pricing Query

    Is it possible to setup pricing with Sage where there would be a discount based on the quantity. We are looking for a way for this to be done in Sage: to setup pricing for the first item to be free and then the next item a price needs to be paid.
  • ICBOM01.rpt giving connector error when processing CSV_FILE

    ICBOM01.rpt gives connector error when processing CSV file made by ICCOMP.DLL V2020 I get no error if I suppress the sub-report so I know it is that sub-report showing BOM details Error happens on server with O365 and another server with no Office installed…
  • 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…
  • Item number does not exist when adding an item to a BOM using web screens

    When adding an item to a BOM using the web screens (Sage 300 2023.1) I get " Item number does not exist" error. Sometimes with the master item and always with the component item. I also notice that the UOM does not show in the UOM finder on the BOM either…
  • Updating Default BOM

    While looking over the recipe for an error in a large multilevel BOM I noticed a interesting issue. The Sub BOM's Default numbers have been changed but that doesn't seem to be reflected throughout the Master BOM recipe. Is there a way for the Build of…
  • IC report "Optimize Inventory"

    A client uses the inquiry screen called Optimize Inventory under IC Items & Price Lists. As more and more users at that company become familiar with that screen, they want to use it -- but they've found that only one person can be in at a time. Is this…
  • Item number change slow

    After upgrading to 2022 Sage 300 item number change is sunning extremely slow. Changing one item number was taking 2-3 hours in 2019 and now it would take close to 20 hours. Item valuation is taking forever, my guess is close to 18 hours. Hardware is…
  • IC Day End Processing could not be completed - cstp xIFO iloc mismatch error: missing ICCOST costing bucket

    We are running Sage 2018 (Build 30) (Product Update 3) - IC65A Inventory Control. A User posted a Stock Transfer transaction from Location AAA to Location YYY for stock item 123456. Then, before I/C Day end processing done, the User removed the Picking…
  • 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…
  • Internal Usage to supply production cells with parts?

    We're just going up on Sage 300 to control inventory, in a manufacturing environment. We have 1 central stocking location for bulk supply inventory parts, and a factory floor in close proximity. The plan is to periodically move 2 week's worth of inventory…
  • Chinese language item descriptions

    We have an opportunity to sell Sage 300 to a distributor that supplies Chinese restaurants. They want items to have English and Chinese descriptions. When I try to insert Chinese characters into the item description it shows up as ???? when I save. Any…
  • 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…
  • How do you fix a partial inventory transfer?

    My client did an inventory transfer and most items worked fine, but one item only transferred 1479 lbs of the 1488 requested to be transferred. 9 lbs remains outstanding. They have run day end processing, All the other lines show as complete, but that…
  • Location Details, Lead Time (SIA) are these business days or calendar days. Does Sage 300 use one over the other as default?

    I am looking at loading lead time days in the location detials screen onder the "Lead Time (SIA)" field. is this asking for calendar days or business days?
  • 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…
  • Sage 300 V2021 PU2>I/C>QTY on hand not updating correctly

    Hi We have a client who is running Sage 300 2021 Pu2. They recently upgraded and are experiencing issues with Inventory control and Lot Tracking. Posting here as advance warning to other BPs intending to upgrade. MAKE SURE YOU TEST TO SEE IF YOU ARE…
  • Inventory listing by Inventory Item Description

    How can I get a listing of the inventory Items in a specific location that contains a specific word in the description? For example a want a listing of all item with "Widget" in the Inventory Item Description. HELP???? Our OLD system could have…
  • 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…
  • Price List for Kits with non stock component

    Hi All, I have a kit with a non-stock item in it with an assigned cost (for labor). I'd like to assign a price list code to the kit that is a markup from cost. It's not including the cost I assigned in the kit for the non-stock item. Is there a possible…
  • How do I deal with scrap in an assembly?

    I am producing steel pipe (item 2) from a coil of steel (item 1). for example an 8000 kg steel coil produces 1200 - 6 foot pipes and 34 kgs of waste steel. How do I deal with the scrap steel?
  • day end error Generic Line Data. Attempt to modify a different record than was retrived.

    Could you please help us about Day End Processing could not process all transactions problem issue as below (urgent case) : error Generic Line Data. Attempt to modify a different record than was retrived. We have inquired preliminary problem …