Sage 100

When going to the Reorder section of the MORE drop down menu and changing some of the data, SOMETIMES the new entries are not saved even though the "Accept" button has been clicked. Going back in and trying again does nothing. The only way I can get…

Has anyone set up the REORDER REPORT and noticed that the report is not showing any "QUANTITIES" on hand, on po, on so, on bo, and available? And it's only for some items not all. In my screen grab there are 2 items. Item 115123 which I know we…

What report is available by item that is similar to the above but also includes labor as defined in the Budget information from Work Ticket Templates? In other words a TRUE complete standard cost per unit?

After installing PU6 for Sage 100 2022 if the first line in a sales order invoice is a /C the customer receives a TAX ERROR. Rebuilding and/or changing the sales tax schedule doesn't fix the issue. If I change the sales tax schedule I receive "Tax Class…

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…

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

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…