• Credit Memos going to wrong GL account

    When using the 'new' feature that asks if you want to recall info from original invoice when creating a credit memo, I've noticed that it even recalls the GL account that the original invoice lines were driven to (Sales). Credit memos should be going…
  • PO was received in full but still shows backordered status

    PO was received in full but status shows it as backordered. We double checked and qtys ordered are exactly the qtys received. What causes this? How can I troubleshoot this? Things we have tried already: Increased each line item, save it and then…
  • Rework - Labeled Product

    Need to reprocess labeled product into a new FG item. How can this be completed? Currently we take bright product and turn it into FG labeled product. Pallet tags with quantities and lot codes are generated. We are taking two FG labeled product and…
  • Program Freeze

    A client has a few workstations (but not all) that freeze when doing this: PO Receipt of Goods batch, then updating, the program would freeze with a message screen of "MAS is not responding" with choices to close the program or wait for it to respond…
  • 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…
  • How to remove invoice items for deleted batch

    Dear concern, I am using sage erp 100. I accidentally deleted batch . Now can not post invoices. But these invoices hold items which are not available for sale. I want to cancel or delete these invoices. Please help me to solve this problem
  • Component Exception Manager, Order To Stock, Not By W/T

    Hi - I am trying to use CEM to make stock orders based on my CEM report data. CEM shows me the demand but when I cut the PO it still links all the w/t's. This is causing issues between order and use quantities and generally a mess. Instead, I want CEM…
  • Inventory economic reorder method doesn't recommend ordering enough to meet quantity available..

    I'm struggling with how Sage 100 calculates the suggested reorder quantity when using the ECONOMIC reorder method on an item. It determines reorder is necessary based on quantity available but then only recommends ordering the amount in the Economic Qty…
  • Receipt of goods # in batch is currently referencing this purchase order.

    I am trying to edit a purchase order to remove an item that the vendor no longer sells. However, when I go back into the PO I am receiving the following error message "Receipt of goods 007807 in batch is currently referencing this purchase order". I…
  • Quantities Grid; Available field (Required for Work Ticket)

    Is there a way for the Available field to automatically take into account the "Req for W/T" quantity? It seems completely illogical that the On Hand Quantity is the same as the Available when parts are needed for an open Work Ticket. I mean it takes…
  • 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?
  • Data Validation Error 115 SO Detail

    Hello Does anyone know what the root cause of this break between the SO and PO Lines. Since we upgraded to 2022 version (Sage 100 Advanced 2022 7.10.2.03 64 bit) This scenario has occurred on a frequent basis. I know how to correct it; however, we would…
  • Purchase Order Error Message

    While entering an order, my system went down. Restarted the computer and began entering the order. When I go to save it, I get a dialog box that states The Creation Date is required/The Creation Time is required. I restarted the computer again, and…
  • 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?
  • Work Ticket Transaction "Reversal"

    We are stumbling our way through Work Ticket implementation in the Production Management module with very little "specific step by step" instructions. Thus I didn't realize if I entered a quantity into the "Close" ticket screen it would process the quantity…
  • Disappearing some SO backordered lines

    Hi there, I really hope you can help me with something unusual that has been happening here for the past month. We've been experiencing some issues with SO backorders. Normally, when we print the Pick Ticket and there isn't a sufficient quantity,…
  • IZ TYPE CODE

    How does an IZ TYPE CODE IN INVENTORY TRANSACTION ENTRY populate?
  • Po qty not being able to be added to work ticket already billed

    Information pop up: You cannot change quantity ordered on a purchase order line attached to a work ticket chargeable line which has already been billed.
  • SO Shipping Batch No. missing on Invoice

    Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry. We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…
  • 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…
  • Sub Assembly

    We make a part off a machine (sub assembly part) send it out to process and complete at the final part number. We want to record inventory receipt at the sub assembly level before it goes out to process. Can we use one work ticket or do we need two…
  • 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…