• A further automation of Lot Tracking and Bin Tracking

    Client tracks medical supplies with Lots and expiration dates, which are stocked in bins using Orchid Bin Tracking. They would like to add a few alerts and or processes; for example, when product has X days left before expiration, put it on Quarantine…
  • Why does Sage 300 not seem to convert the unit weight when clearly using a UOM that is different than the stocking UOM?

    Sage 300 OE module has 3 units of measure per line. A pricing UOM, invoice UOM and costing UOM. However it does not have a weight UOM, so it is taking the unit weight (which is for the default stocking unit of measure, and not using the conversion factor…
  • 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…
  • 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…
  • IC Shipment Quantity Issue

    An IC shipment was created where the operator accidently removed 51,138,686,093 units from stock. The Shipment appears to have posted but when trying to open the shipment we get a Code: 3.3550.0 Source: IC0630 error. Can I go into the ICSHED table end…
  • Aged Inventory Report Showing Negatives

    I am having trouble understanding the aged inventory report. See the output of one of the items below. If I just looked at the over 730 days column I would think that I had 602 quantity that was over 730 days old. But in fact I have to look at the other…
  • Changing Stocking Unit of Measure

    Is there anything we should look out for when we change the stocking unit of measure? We some items that have a couple of conversion factors and the items are used in BOMs. To be careful should I issue out all the inventory, change the stocking unit…
  • IC Transfer number missing

    IC Transfer number skipping a digit, for example after posting a transfer, TRF 0002, the next number generated is TRF 0004! (the image shows transfer no. TRF0005433 is missing the user says that when he posted the system did not give him the option…
  • Inventory Items/Price Lists and Web Services

    I am trying to add inventory items and price lists through the web services API. I can add the inventory item through the ICItems endpoint and I can add the price list code through the ICPriceListCodes endpoint. What I can't find is what endpoint to use…
  • Printing Item Labels When Received

    What is the best method to print item labels after it is received in receipt entry? I am using serialized inventory and I was expecting a prompt to appear after I clicked 'Post' to ask if I wanted to print labels, but I didn't see one. Are people just…
  • Inventory Items - Last Sales Date

    Where can I find the last date of sale for particular item or items?
  • Day end error

    Hi Support, One of our clients has an issue with day end processing in IC. The day end stops at a particular order. This has started happening after a power failure. I have performed DB verify and DB dump but it did not fix the issue. Sage 2012…
  • O/E Entry & Inventory

    Hi all, I hope you are all well. We have experienced in the following scenario on one stock item during Order Entry: Qty on hand = 0 Qty Committed = -3 Qty Available = 3 Negative inventory is never allowed. Could anyone shed some light on…
  • Average cost calculation

    Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good. Is there a way to fix the average cost? There was an adjustment done a few months back that was in error…
  • What's the most serial numbers you've ever seen on an OE shipment?

    I have a client who did a PO receipt two weeks ago of a serialized item, with 2,980,000 serial numbers on one line. This week, they're trying to ship that item with 600,000 of those serials. Day-end runs for 12 hours then crashes. Right now on SQL profiler…
  • Inventory physical count quantity only update

    We recently did a physical count in inventory and most of the items did a both update (quantity and cost), but two items did quantity only updates. How do we make sure that all items are doing a both update?
  • Trying to create a report in SQL that pulls all costs for an item.

    I am trying to create a report that pulls all OE sales by month and includes standard cost, average cost, most recent cost, last cost, alt cost 1 and alt cost 2. I can't seem to find which table or view has all of these costs. It looks like they are…
  • 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…
  • Ops inquiry IC item location tab

    Hi there, in Ops Inquiry IC Item Inquiry (in Location tab) the Most recent Costing Unit does not update with the Average Unit Cost. The Source App is P/O Issue occurred with one item only. Any idea there.
  • Stock take and data entry

    Hi Support, It is normal procedure to freeze all inventory transactions before generating the worksheet. Our month end inventory reconciliation last for up to two weeks. Is it possible to still post order entry invoices for the new month? What will…
  • How I/C Serial Number Inquiry transactions are sorted?

    Sage 300 ERP 2014 Advanced Edition Dear Support, The order of the serial transactions within the I/C Serial Number Inquiry looks sorted by DAYENDSEQ and ENTRYSEQ. However, the transactions initiated by I/C Module all are given the DAYENDSEQ = -1.…
  • Unbilled PO Receipts

    Where is a report that shows the Unbilled PO Receipts in Sage 300?Un
  • Inventory Costing

    We purchase used equipment and refurbish them and then process them by physically cleaning them (labour), testing for faults (labour), and package each item individually in boxes (materials and labour). I understand according to accounting principles…
  • Starting Inventory

    I am trying to write a Crystal Report on Internal usage. The client wants it a certain format (different from Stock transactions Inquiry) hence the effort. I am not able to get my starting inventory formula accurately. Does anyone have some ideas on…
  • unable to download HF21031340 Sage 300 ERP 2014

    I need to download the HF22031340 for version 2014 to fix the good 'ol "the sum of ICIVAL.STKQTY for item XXX doesn't match ICILOC.QTYONHAND". It is listed on the partner portal but not in Sage City's list of hot fixes. The problem is when I try to download…