Sage 100

We are trying to find an easier way to show what is on hand for a costed bill of material inquiry. The report obviously shows what the components are but we want to show the quanitityy of those components on hand. I tried checking all the reports that…

Hello, I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…

Re-posting here since I think I was in the wrong section before. Haven't had any luck finding an answer to this so hoping you all can help. Currently when you search using the "Description" option on a web search, it only searches Item Name (short…

We have products that we purchase from multiple vendors. We have the Vendor codes and descriptions set up as Vendor Alias' in Item maintenance. When we make a PO for a vendor and enter an item that has multiple Alias codes, it will actually print out…

Is there really no other way to transfer inventory from one warehouse to the other than by using the transaction entry utility? Our issue is that we need a "picking sheet" or some form that has the bin locations to help workers pick the necessary items…

Hi Everyone, I am wondering if there is a way that I can have excel look up a part number when entered in sage and pull the standard price from the Item Inquiry under the Bill of Materials menu automatically. So my excel sheet is for scrapped items…

We stock all kinds of hardware for some of our installation work like bolts, washers, and nuts. While our company standard is to utilize manufacturer specific part numbers, this doesn't make as much sense for truly generic hardware. I might order hardware…

Hi, Is it possible to copy whatever data in AR customer table field "Customer Type" into a UDF in sales order header of that customer's sales order? We want to be able to pull the sales order of that customer and see the "customer type"

Good Afternoon, I am creating a part number in Sage 100 and it is a finished good that's procurement type is a make. From what I have been taught, if it is this kind of finished good, I fill in the Retail price and the Standard price but do not touch…

Hi Forum, We need to delete BOMs with a BOI script. when i use nDelete() the return value is "1" and yet the BOM is still in Sage. I can find the BOM by doing a SetKey with BillNo+Rev. Any inout will be appreciated. Regards, Manuel …

Ultimate goal is to be able to run a report that shows percentage of sales orders completed withing 1 day of the order date. There are two reasons an order will not ship within 1 day. 1. item is not in stock 2. staff was just too busy and didn't…

Hi all, We're interested in seeing if anyone has added the package number to the line items on an invoice? We have customers who regularly receive multi-box shipments and have asked for this to help stage deliveries. I've taken a quick look in Crystal…

I'm looking to generate an on time shipment reports that need the Ship Date aka ShipExpireDate from the SalesOrderHeader table to be saved for reporting. I have seen in previous posts that others are using the Promise Date for this information. This however…

I need the Cancel Reason Description to appear on Open S/O report. I added using Database Expert I added SO_CancelReasonCode database. Put the field into the repport. Not the report ONLY displays S/O that are = HOLD and shows the Cancel Reason. If I remove…

We are trying to figure out a way to make and print packing lists per box, as opposed to printing one packing list for the full order and placing it one of the boxes. How is this done with Sage100 Standard? We want our customers to know the contents…

We are interested in disabling the "pay balance" feature in sage 100ERP (version 5.20.2.0 ) with regard to credit card transactions. We have a glitch that occurs at our invoicing step that is sending a signal to SAGE PAYMENTS to charge the card a 2nd…

We are a company that sells plumbing tees, elbows, valves, etc. When customers are finished with a project, they just bring back a large box with a mixture of parts. The warehouse writes up the part numbers and quantities. These parts could have been…

Hello, I'm trying to create a new report and I see that one of the work table has most of the fields that I wanted on my report, So is it possible to use existing work table with many other tables and create a joints in crystal report. If so how do…

I created a UDF to show total qty on purchase order. Works fine for new orders, but it's showing 0 for existing orders. Any way to update the existing purchase orders to show the total qty on the purchase order?

On every module or input field where Auto Complete feature should work, if the item is relatively new, the Auto Complete does not function. I am unsure when, if ever, Auto Complete will work on these items. Is there any way to force Sage to recognize…

v2018.2 (Standard). VI job to create WO from csv (set up by someone else, prior to upgrading to v2018). The current problem we are dealing with is that the Req for WO value in IM_ItemWarehouse is not being populated properly (for component items) and…

I was wondering if any one has done this type report I did a custom crystal report that i'm able to see specific item code, but for some reason when i'm running the report those item codes that doesn't have any transaction history is not showing and…

I run an open PO report each week. My problem is that it shows PO's that items have been received but just not invoiced. For example, the part shows ordered and received but because it hasn't been invoiced yet, the PO is still open. I am okay with that…

Sage 100 2018. Is it possible when using paperless office to email or even if we export to pdf from preview that a fillable form is sent or exported? Also, does anyone know of a way to take signatures on sales orders through the desktop, not the scanco…

When you enter a Quote you begin by changing the Order Type from Standard Order to Quote. Before you do this the Print Pick Sheets box is checked for the Std Order. After you choose Order Type Quote it disappears. Perfect but...when you convert the Quote…