• 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…
  • 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…
  • Item cost difference

    Why do I have a difference in the extension value of the cost when I invoice the customer? The item entered to the inventory at 3.333 got out the same day at 3.333 but the extension is showing a difference of 0.42 and I have to adjust this differences…
  • Purchase return in Weighted Average & FIFO Inventory Methods

    Hello to all, Have a question regarding Weighted Average Cost and FIFO when returning purchases to vendor 1- Weighted Average Cost we have following purchase: 10 unit @ $20 & 5 unit @ $15 so average cost per unit is $ 18.33 = (10*20)+(5*15)/15 after that…
  • Last Cost with Average Valuation Method

    All items have a valuation method of average cost. When enter purchase orders, we want to use last cost. We do not want to enter vendor price levels. Is there a way to use last cost in Purchase Order Entry, maybe using a script?
  • PM - Selecting "Explode" check box when copying in a template does not bring in sub-bill LABOR

    I have a client whose finished good items are made up of several manufactured components, as well as purchased items. They had been creating WT for all of the mfd components, but in reality, they VERY RARELY stock these items, but may occasionally have…
  • Sales order entry - unit price goes down to 0$ after changing quantity

    Unit price drops down to 0 when changing the quantity of "ordered" on the same line item. Is this normal behavior, or was this intentionally implemented at some point? Can anyone point me in the direction of an article to reverse this? Thanks!
  • Unit Cost is messed up over time, how?

    Hi, I need some help on this unit cost. PO cost was around $32.00 for this product. We buy one at $32, and then sell it. For some reason, the cost changed over time, and became unrealistically big. I'm wondering what might have changed it. I don't see…
  • What criteria is used for Sage to classify an item as "sold" vs an "issue" when viewing the history tab in item inquiry.

    I am trying to determine what criteria Sage uses when classifying transactions as either "sold" or "Issued". Any guidance would be appreciated.
  • Negative amounts on PO.

    Does anyone have any idea why an inventory item would show a negative amount on PO. The inventory trial balance report does not show any of the negative PO amounts, and I don't see them on the Detail Transaction Report, either. I am having trouble locating…
  • Work Order WIP discrepancy issue

    Hi All, Came across an issue in Work Order I was hoping someone might be able to shed some light on - for a given work order, we are simply issuing the necessary raw materials out of inventory for the work order, then completing the finished goods,…
  • Sales Kits

    We currently have sales kits set up in Sage 100, but I notice that when an order is entered, it does not reflect in the Sales Kit, but only in the components. Is there a way to correct this? Quantities showing on Sales Kit Item Quantities as…
  • FIFO Items and Credit Memos

    We are using FIFO for items which results in different tiers existing for PO receipts and this is working as expected. And actually we have been using FIFO for quite a few years. Sales Orders are created and later invoiced. Due to the nature of our business…
  • Paya Virtual Terminal Settlement Report totals incorrect

    I have been having an issue with the totals on the Settlement reports in Virtual Terminal not being correct since May. Some days they are okay, but most days they just do not sum properly. I've had 2 support cases open with Paya and not only are they…
  • Operation Codes setup in Production Management 2022

    new install of sage standard 2022 v 7.10...trying to setup fixed overhead costs in PM and just not working out for me... In W/O we used operation codes, parts per hour, to determine machine rates and labor costs. I find labor, working just fine, but…
  • How to best account for promotion cost so that they don't throw off profit calculations?

    I'm not sure if this is an elementary question, but I was wondering how to best handle inventory costs in the following situation. We keep inventory as average cost valuation. Periodically, we get promotions activities from vendors where we're "selling…
  • Recalculate Costs on Purchase Orders

    Is there a way to Recalc Cost on a PO similar to the Recalc Price function on SO? We have many open POs in our system where we need to update line item cost to new vendor cost based on price increases. Those new vendor costs are uploaded to the SKU, so…
  • Sales Order Line Item Discounts by Dollar Volume

    We have a client on 4.5 that uses Item Pricing by Total Quantity, based on Item Category. They are taking on a new product line, however, that they want to implement discounts by line item based on the total PRICE of the items on the order within that…
  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
  • Why Is It My Company Can't Invoice or Update Inventory for a Week to Ten Days after The Start of a New Month?

    Someone really needs to explain to me why with Sage invoices, inventory and, payables can't be updated until accounting does what ever is they do. Leaving the GM, Sales and inventory blind for half the month unable to finalize anything. This is not how…
  • How to distribute landed costs to items from a shipping invoice

    In receiving goods, occasionally there is one invoice for the items themselves, (paid to the vendor), and another invoice for the cost of shipping, (paid to the shipper). For the former invoice, all the items are invoiced, and in invoicing the PO, none…
  • Sales UOM Pricing - SO using the Standard UOM

    We have some items where the Sales UOM is EACH and standard is KG. When adding these items to a sales order, the sales quantity shows as EACH however the price is coming over as the standard price x the KGs per EACH. This only occurs for a handful of…
  • Can an Inventory Depletion be Linked to the Receipt???

    First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…
  • SAGE 2020 Warehouse Negative Inventory

    Hello everyone, Does SAGE have an option to not allow inventory for warehouses to go negative regardless of the transaction type? We are running into issues with multiple warehouses. Thank you
  • Incorrect Qty on SO

    So rebuilding sort files typically cleans this up, but we have an item code showing a warehouse having a qty of 8000 on Sales Order, but as far as we are aware (and as stated on the 'Orders' tab in item maintenance, the item is on 2 sales orders for a…