• Material Costs in reference to routings

    I am stumped and need to find some answers, hopefully someone here can help? On the routings, each material item has an associated "Material Cost", I am trying to determine where is cost is coming from. It doesn't matter to me if the material part if…
  • Landed Cost not posted in IM Purchase Return

    Feature or a Bug? I have an inventory item that has an existing Cost Tier with a Landed Cost Component (let's say, $5.00 Freight) and a $25 Material Cost component. I do an IM Purchase Return transaction to push out 1 piece. The Inventory Transaction…
  • During MRP, received error "Cannot create steps for Planned order. Error in Routing xxxxx, step

    Received this error on several of the items. We have reviewed the routings/steps and do not see any issues. The are set to Standard/Active. Some are Phantoms, some are stand alone. What could cause these type of errors?
  • Calculated Trade Discount and Sales Tax Amount

    How does Sage 500 ERP calculate the trade discount and sales tax amounts? I keep getting the warning " Calculated Trade Discount Amt not the same as value passed in." after running the stored procedure, "spsoAPISalesOrdIns", and it keeps defaulting the…
  • Can you adjust the time period used by Average cost?

    We are using Average Cost, but I"m finding that during the first couple of years using Sage MAS 500 there were a lot of issues with incorrect settings, bad data, user errors, etc.. and this has caused an inflated value with our average cost. Can I somehow…
  • Bill of Material fields

    Where can I find more info on the fields in the BOM's? I'm looking to find what certain fields mean and how they get populated. Specifically the Set Fix & Set Var fields. I can see them in the Explore view, but is this data coming from the Data Import…
  • Lead Time Formula vs Projected Lead Time

    If you specify both a Lead Time formula & Projected lead time in the Maintain Inventory, which does MRP consider? I did a average lead time calculation based on the last 15 months using the PO date vs the Receipt date and was going to update the Projected…
  • Sage Intelligence Sage500 Statistical data

    Can SI for Sage500 pull Statistical GL data, i.e. Qty? If so any hints on how?
  • Unit of measure conversion

    Ok, I'm running Sage MRP against our system and I have found a issue with unit of measure. We have a base unit of measure of EA . We sell in units of "72 cel" which are set up properly to the best of my knowledge as 72 each's. However, when the MRP is…
  • PO freight charges and GL accounts

    v7.20.14 We have a problem with the way MAS500 handles purchase order freight charges. The following communication describes the situation. ******************************************* From end-user: There is a problem with the way the MAS500 Purchase…
  • Inventory Transaction History Analyzer, Stock Out and Lost Sales Quantity field calculation

    In the Inventory Transaction History Analyzer, does anyone know how are the Stock Out field and Lost Sales Quantity field calculated?
  • Cost Tier Adjustments

    Zennon or anyone, We are about to roll out a new costing program. To begin our project we must post a cost tier adjustment for all tiers of our inventory. The only problem is that we have 290+ inventory items and some have more then one tier. Is their…
  • O2 Process Manufacturing Users - Strange Material Variances

    When I close a production batch, sometime I get a strange material variance which caused my unit cost to increase dramatically. This happens once in a while. Has anyone had this issue? Thanks Allan. [email protected]
  • SDK for Sage 500 ERP 2016 has been released

    The SDK for Sage 500 ERP 2016 has been released and is now available for Sage 500 ERP business partners with the developer's license as a download on the Partner Portal. After accessing the portal, navigate to the Knowledgebase page and search for SDK…
  • Forecast and MRP

    Ok, we have work orders, sales orders and forecast all going into MRP. For sales orders and work orders I see the inventory as UOM Each. However, I think that the forecast is coming in UOM 72 or 30 (our flat size ). As you can see below the forecast only…
  • Undocumented secret ?

    Version 2014. I just recently found this by shear accident . MRP planned orders tab, in the date cells for Req Date or Ord Date. Double click a date in the cell to activate, then double click it again and a calendar pops up to pick a new date. Now I don…
  • Unit cost of WIP inventory

    I need a report that shows the unit cost in WIP by L-M-OH. Or what have others provided to their auditors that breaks this out per unit in WIP? Thanks