• On order quantity does not match open purchase orders

    We have recently found that the on order quantity shown in item maintenance does not agree with the quantity of open purchase orders. See screenshots below. On PO qty shows 12 pcs However, we only have an open PO for 6 pcs We cannot figure out…
  • Completed more against a work ticket than the planned quantity

    A user accidentally completed a total of 700 parts against a work ticket that was planned and originally processed for 600. I thought if we just increased the Quantity Ordered to 700, it would set things up for the extra 100 as far as the Materials go…
  • Work order

    In work order module is there a way to transfer materials from one work order to another and maintain the original cost?
  • IP TYPE CODE

    Does IP Type Code show up in transaction tab for all items during inventory count or does it only show up in the transaction tab if a count was made towards the item?
  • IZ TYPE CODE

    How does an IZ TYPE CODE IN INVENTORY TRANSACTION ENTRY populate?
  • Negative quantities for Sale Order.

    We have 2 items in our inventory, that show an SO for a negative amount. I cannot find an orders that have negative amounts and no orders that match the quantities. For example, we on hand 110 units of product A with SO of -15 and an available inventory…
  • returned item shows as received on PO

    I have a PO with returned item still showing as received. 15 ordered, 20 originally received, 5 returned, 15 invoiced The PO shows the goods receipts for the 20 and (5), GLs are debited and credited as expected and inventory is correct. However, the…
  • RECEIPT OF GOODS VS P.O. VS COST DETAIL

    What would be the best way to get around the issue of receiving items at the incorrect cost? The issue we're having is that the receivers are just receiving in the items with no knowledge of cost differences on the p.o. vs the invoice we receive from…
  • FIFO items, zero qty on hand with negative average cost

    We have a client that has several items with a negative average cost. The valuation method is FIFO and the current qty on hand is zero. Should we run the IM_CommitCheckClear_utl, the IM_ClarCommitDataEntry_utl and the Balance Quantity and Cost utilities…
  • How to correct Inventory Item set up as Standard Cost should have been FIFO

    I found out an Inventory Item was set up as standard cost. The inventory item should have been assigned FIFO. How do I correct this in SAGE 100.
  • INVENTORY

    Hi, When I do an inventory inquiry, it shows 104 of an item on hand, but we only have 40. I couldn't do an inventory adjustment of -64, because there are less than 64 to distribute. How do I get the inventory that shows on hand in inventory inquiry to…
  • Standard Cost items zero qty on hand, showing Value on Valuation report

    We have a client using Standard Cost for all their items. When they run the Inventory Valuation report some of these items have zero quantity on hand but will show an Inventory Value. We have checked the IM_Itemwarehouse file and the value shows zero…
  • COMMITTED ITEMS NOT ACTUALLY SHOWING ON ORDER

    Hey there I have an issue with an item showing that it is on sales order and its committed but we have no open sales orders with the item nor back orders. I'm also going to mention that we use multi bin and I can see that 7 are set in a warehouse but…
  • Standard Cost adjustment-Inventory Mangemement

    Perhaps a dumb question, but we just received a price increase for an item. I need to adjust the Standard Cost using 'Standard Cost Adjustment Entry', but does this affect the items that are currently in inventory? Attaching a sample of a previous cost…
  • Over Invoiced PO

    There is a PO in my system where everything is completed, but it shows as a backorder and says ***over invoiced*** on the open po report. Any ideas on how to get this to a completed status? Thanks, Dan
  • deleting warehouses

    Is there any way to delete an active warehouse?
  • PV source journals

    Looking for best practice recommendations on how users handle the PV source journals where ROG unit cost differs from ROI. Do you go inventory adjustment to correct the unit cost if so how often monthly, annually etc. Thanks.
  • Inventory Item Invoiced for Incorrect Amount

    I could really use some help for a best practice here. A vendor overcharged us for an inventory item. To correct this, they issued a Credit Memo for the original (incorrect) invoice amount, and then sent a second invoice for the correct amount. What is…
  • How to correct unit cost. Invoice entered incorrectly.

    I could use some assistance on making an adjustment in inventory management. There was an invoice entered incorrectly last month. The unit of measure was incorrect as entered which is causing issues in our unit price for the item. The previous month is…
  • Item Maintenance

    Where can I find a detailed explanation of how Item Maintenance works and what each valuation does and setting up Units of Measure? We have a terrible habit of just copying what is done for other items that have been set up in the past. I want everyone…
  • Error Message when using Delete/Change Items

    I am getting this error message when I am going to rename these items. Has anyone every encountered this? I've never seen it before.
  • Bill of Materials and Transfers

    I just want to bounce some thoughts around. We're a manufacturing and distribution company. We are trying to take into account how many boxes we use for packing our finished goods. These finished goods are sold to our intercompany via p.o and receipt…
  • Error 36 In Physical Count

    I am trying to take a physical count of a few new items I recently imported through VI, not sure why I am getting this error, items seem pretty basic. Don't see any other instances of the same error in the forums.
  • Updating BOM Cost Amounts

    I am new to Sage and in over my head as our former controller left without any transition. I would like to update the Labor and Overhead rates in our BOM module. We have about 400 products that have varying cost components, but all have labor and overhead…
  • PM Work Ticket (Estimate/Quote) Material tab line cost update post creation without deleting and readding of lines

    PM Work Ticket (Estimate/Quote) created with steps and materials. New item pricing for IM module input due to increase from vendor a few days later. Go to WT post creation and old pricing remains in Estimate. How can we trigger an update to Materials…