Sage 100

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…

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…

When processing an RMA for a customer where the item needs to be repaired, we typically need to send it back to the vendor for repair. I was just curious how other folks handle this scenario? Right now we choose the following actions for the item in this…

I don't work in shipping but I had a shipping question brought up to me. We have a customer that placed a rather large order. They notified us that they made a mistake and ordered too much of one item. To avoid a ton of work, I did a return of just the…

Hello, regrettably we are still using the legacy work order module. Is there a way we can prevent work order entry for items that do not have a bill of materials and/or a procurement type of make? Right now work order entry allows any item to be entered…

I found out an Inventory Item was set up as standard cost. The inventory item should have been assigned FIFO. How do I correct this in SAGE 100.

Hi, When I do an inventory inquiry, it shows 104 of an item on hand, but we only have 40. I couldn't do an inventory adjustment of -64, because there are less than 64 to distribute. How do I get the inventory that shows on hand in inventory inquiry to…

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…

We have a client using Standard Cost for all their items. When they run the Inventory Valuation report some of these items have zero quantity on hand but will show an Inventory Value. We have checked the IM_Itemwarehouse file and the value shows zero…

Hey there I have an issue with an item showing that it is on sales order and its committed but we have no open sales orders with the item nor back orders. I'm also going to mention that we use multi bin and I can see that 7 are set in a warehouse but…

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?

Perhaps a dumb question, but we just received a price increase for an item. I need to adjust the Standard Cost using 'Standard Cost Adjustment Entry', but does this affect the items that are currently in inventory? Attaching a sample of a previous cost…

Does anyone know exactly when a PM license is consumed? The knowledgebase says when someone is in PM or if a user does not have Production Management open but they are in a different module and the task has a work ticket tied to it, a Production Management…

What are the best options for getting automatic entries for new Sales Orders? Looking to integrate orders placed through online sales and have them directly entered into Sage. Currently on 2020, but looking to update.

I entered an invoice in A/P, but assigned it to the wrong GL account. Do I have to void and reenter or is there a way to adjust the invoice?

When we enter an order, the line item is not pointing to the correct GL, example: For this particular customer the above should be pointing to 30000-07 for sales and 40200-09 for cost. See list below: Currently, all items are pointing to 30000…

Hello. Hoping someone can help with an issue we have been working around for some time concerning component boxes and kits. We are currently using Sage 100 Advanced 2022.1 (7.10.1.0) with Production Management Background: We sell kits but do not…

There is a PO in my system where everything is completed, but it shows as a backorder and says ***over invoiced*** on the open po report. Any ideas on how to get this to a completed status? Thanks, Dan

Can work orders be automated in the field?

Do we have ability to charge restocking fees based on price net of prorated discount? thanks

Is there any way to delete an active warehouse?

v2022.2-PO receipt register qty * unit cost not giving the correct extension. Has anyone experienced this? It posted like this in the GL and if you look at the receipt history in PO it is this incorrect extension as well but on the po clearing report…

Looking for best practice recommendations on how users handle the PV source journals where ROG unit cost differs from ROI. Do you go inventory adjustment to correct the unit cost if so how often monthly, annually etc. Thanks.

Have a client using the new option to recall an invoice when creating a CM and they are getting errors on kit component lines re "missing COGS account". In my testing, it appears that 4 fields are not being populated when pulled from history the same…