Sage 100

I would like to hide a line item on a tax invoice. We work much like the car repair industry. I invoice out the total service charge in one line item however I have inventory items related to the total charge and if not invoiced individually out it…

We have recently found that the on order quantity shown in item maintenance does not agree with the quantity of open purchase orders. See screenshots below. On PO qty shows 12 pcs However, we only have an open PO for 6 pcs We cannot figure out…

A user accidentally completed a total of 700 parts against a work ticket that was planned and originally processed for 600. I thought if we just increased the Quantity Ordered to 700, it would set things up for the extra 100 as far as the Materials go…

In work order module is there a way to transfer materials from one work order to another and maintain the original cost?

Does IP Type Code show up in transaction tab for all items during inventory count or does it only show up in the transaction tab if a count was made towards the item?

How does an IZ TYPE CODE IN INVENTORY TRANSACTION ENTRY populate?

We have 2 items in our inventory, that show an SO for a negative amount. I cannot find an orders that have negative amounts and no orders that match the quantities. For example, we on hand 110 units of product A with SO of -15 and an available inventory…

I have a PO with returned item still showing as received. 15 ordered, 20 originally received, 5 returned, 15 invoiced The PO shows the goods receipts for the 20 and (5), GLs are debited and credited as expected and inventory is correct. However, the…

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…

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…

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…

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…

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

Is there any way to delete an active warehouse?

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.

I could really use some help for a best practice here. A vendor overcharged us for an inventory item. To correct this, they issued a Credit Memo for the original (incorrect) invoice amount, and then sent a second invoice for the correct amount. What is…

I could use some assistance on making an adjustment in inventory management. There was an invoice entered incorrectly last month. The unit of measure was incorrect as entered which is causing issues in our unit price for the item. The previous month is…

Where can I find a detailed explanation of how Item Maintenance works and what each valuation does and setting up Units of Measure? We have a terrible habit of just copying what is done for other items that have been set up in the past. I want everyone…

I am getting this error message when I am going to rename these items. Has anyone every encountered this? I've never seen it before.

I just want to bounce some thoughts around. We're a manufacturing and distribution company. We are trying to take into account how many boxes we use for packing our finished goods. These finished goods are sold to our intercompany via p.o and receipt…

How does one correct an item received at the wrong price and billed at a cheaper price? The item cannot be returned as it has been used from inventory. Example: Item 1234 received at 1.80 ea, but billed at 1.65 ea.

In Sage 100c Advanced 2016, Updated a completion step of Work Order. Some items posted to scrap with all the cost and some items posted to inventory with no cost. Somehow the cost was all posted to scrap. Now if we complete other steps in the Work Order…