Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I am trying to run an MRP generation to generate a report. I am doing so in the legacy MRP for Sage 100 ERP version 2018. This will be the first time that the generation would be run for this particular company. The files for this company are not gigantic…
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…
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…
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…
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…
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?
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…
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!
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…
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…
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,…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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