Sage 100

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, however…

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 shown on…

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 cannot…

Sage 2021.2 Advanced

IRP 7.00.2.0 with PM and PO

Generate based on Plan by-Inventory / Procurement type Purchase and Selection of Warehouse Code to single warehouse

13K inventory items company wide across 7 warehouses taking 8 hours to generate before…

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

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…

We are running 2019 100c Advanced.  From time to time when entering a new SO the Order Total on the Totals tab is zero, while the total on the Lines tab is correct.  Oddly, the system allows the SO to be saved in this condition!  To correct the imbalance we…

Is there a way to calculate economic order quantity within Sage? If not would you all have any recommendations for systems to calculate EOQ that integrate well with Sage? Is it best just to calculate it manually and input it individually?

Thank you!…

Does Avg Cost have any implication for a Lot item?     

We have an item that was FIFO some time ago, but via Item Valuation change is now Lot.  That change was done some time ago.   The Avg Cost field is way off now.   But, does that matter?  

For this case, especially…

Most but not all Backorder lines are incorrectly calculated based on the Order Qty but should be Backorder Qty.  As a test, I copied the Live company into a test company at the end of our shipping day just before running Daily Sales Reports and Updates…