Sage 100

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…

Hello, I am looking at sending an automated monthly report to a customer with a list of the items they supply us. If possible, I also wanted to provide a breakdown of any work orders, inventory adjustments, etc against each item. Is this report possible…

How do you handle purchase orders for non-inventory items. Two examples - 1) the office heater is broken, we call repair shop to fix it - PO needs to be created to match up with billing invoice,do you just use a comment field? But do you still have to…

Any suggestions on a label printer for inventory receipt of goods? I'd like the label to be about 2 x 3 - most printers are either 1 x 2 1/8 or 4 x 6 - to small or too large. I need a printer and of course the labels, compatible with Sage 100. Thanks…

Trying to figure out why " *item" line items show at time shipping is picking the order in one Company, but not in a different company. I feel like something is not turned on in the company.

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

Is it possible to set up a Sage Alert to run a system report on a schedule? I want to get the Inventory report Multi-Bin QOH and Valuation Report to email on a schedule, but I can't get the report to generate values unless I run it through Sage. I've…

We have a ton of components that are set to INACTIVE, that still show up on the WHERE-USED Inquiry lookup and the WHERE-USED Report. How can we get them to not show up? We tested an item and set it to Discontinued and set it to Inactive but it still shows…

We created a work order for a part number and accidentally put the unit cost in as $1,486.4667 instead of $14.8429. The work order is closed and inventory is overstated. Help!

My company manufactures products that we categorize by Lot #. As an example, I have an item with Lot # ABCD that we delivered into Sage 4,143 bottles. Of that Lot #, I can confirm that 3,628 have been invoiced and sold, leaving 515 left, which is exactly…

We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog: When I click More…

My question is what's the correct way to bad debt an inventory item? We have an item that we want to take out of inventory and put to bad debt. I have played different scenarios in my head but not sure which way is the proper way and which GL's it's going…

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…

We are showing a serialized item on hand and available, but it was sold in November 2021. History shows the item was received and sold, with no further movement on this serial number It's still showing on the Inventory Valuation Report - item in…

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

Hi all, When we start to create a new item record the UOM fields all default to "EACH" automatically. I notice also that "EACH" doesn't even exist in our Unit Of Measure Conversion Maintenance. Customizer says the initial value for this field is…

For example, we have " EA " setup in our Units Of Measure Conversion Maintenance and the users should be selecting it from the UOM lookup but that doesn't always happen. Over the years, inventory managers at different locations have entered items items…

My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ? Thank you,

I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…

Hello, I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me. My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN. We utilize the WO module to purchasing, including…

Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…

A customer wants to get a report of new inventory to publish on a web site and wants to know if he can get an inventory list by dates created?

Hi, We were reviewing the physical count and posted it on accident. Is there a way to reverse that? Regards, Becki

Hi, I know that I cannot delete Inventory if their is history. What constitutes the meaning of history? Thanks, Tim

What is the recommended length of time to retain inventory history in Sage 100?