Sage 100

Hi, I am attempting to export the JT_Template table to turn around and import the file in another company. The only field not coming through the export is the Text field from tab 6 of WT Template Maintenance. The field in the Data tab of the export says…

A SAGE100 Premium VS. 2020 has occasional missing S/O order header records. The order lines are still there. The order is completely there in order history. The order has NOT been invoiced. Anyone seen this?

Hi I do have a concern with sage 100 V 6.10.2, My inventory item shows 0 item no transactions in there, but when I run the Inventory Stock status report it show a quantity on hand of 384 any idea how to clear that or if there is any program to run…

I need to add several hundred product from our website into sage. I can export product codes from our website, and I'd prefer to format descriptions on one master excel sheet. Can you "mass add" products using VI? I'm a bit new to VI, so I wanted to ask…

(I think I figured this out as I typed out the question... answer below... posting in case it helps someone else). I have a custom report (for the purpose of detecting imported invoices with over-shipments by 3rd parties) which links invoice OrderLineKey…

I am working on importing into Work Ticket Header in Sage 100 version 2020 Premium working with Production Management. I am trying to create the same action that occurs in the user interface of Work Ticket Entry in Production Management. In the UI of…

I have a business partner account. And, I have setup sage SData and Sage ERP 100 on window server machine. I can access some resources in the browser like: sage.lvh.me/.../ MyGreatLakes /AR_Customer It returns a huge file of XML. My problem is…

So we have around 1800 Items in inventory that are labeled KIT, when they should be Finished Goods. We are unable to move the majority of these records to their proper status because most have a Bill of Materials attached. What we are trying to determine…

I am trying to run a VI job that contains a record count at the end of the file being exported. However, I don't know if there is a way to do this within Visual Integrator (using Sage 100 v2018).

I am tasked with exporting certain fields from our Sage 100 v2018 AP_Vendor table to a third party. However the data needs to encompass all of our company codes. Is there a way to do that within VI?

We need an MRP report that is just a small subset of the entire 154 p. report and in a format more readily readable by our purchasing buyers. Using a silent connection string, I created a MSQuery table in Excel that brings in the filtered results of MRP…

I'm working on a test system and forgot to install the hot fix to prevent the IM_LotSerialTransactionHistory from taking a long time. How long does it take to convert this table? I've been waiting for over 4 hours! Will the table eventually convert…

link SO to WT .docx I'm trying to find a file that contains the quantity on WorkTicket shown on the Sales Order line if exploded. see attached word doc for screen shot. The SO detail file contains the work ticket number and the item number but not…

We have recently upgraded to Sage 100 2020 and one of our companies is noticing a weird issue in Work Order Inquiry. When attempting to open certain work orders, the Work Order Inquiry window closes. However, if we open a different work order and go to…

I am using VI to Import an SO Invoice batch. The batch is automatically being created as an Invoice batch (batch type I). I need it to be a Shipping Batch (batch type S). I don't see anywhere where that can be assigned in the import job. Other than DFDM…

Hello all. I am attempting to use Visual Integrator to update my company's projected demands on the fly. I am attempting to import into the MP.SCHED table. The problem I'm running into is that the import fails on the CUST_NUMBER field if this is left…

Hi guys We seem to be having an issue with auto reorder. We have ran a rebuild on the modules PO, SO and IM and it didn't seem to solve the issue. See picture below. Any ideas on what my have caused this? Thanks Guys

I am assuming I have a client experiencing this, since they have large negative numbers showing up on certain items which should have On PO qtys of 2,3, etc. The client did have a PO blow up during entry and the items appear to be related, but I can…

I'm importing inventory issues. I want to default the "Enter exceeds on hand qty" to Yes. I think this is possible - just can't remember how to do it. Thanks

After Job Cost was updated to the Business Objects Interface Sage confirms but has not corrected two major problems (for us). When Sales Order is integrated with Job Cost there is the ability to create a new job from Sales Order Entry. When entering the…

Which Sage 100 IM table contains the Standard Cost field? I need it for a Crystal report, but can't seem to locate it.

I would like to delete the 'Customer Price Schedule' for just 1 customer. Is there an easy way to do this without having to delete each item individually? I noticed another reply that mentioned something about script - which is foreign to me and another…

Hello All, Running: Sage 100 2017 V5.40 Here is the problem. Need to import inventory transactions however, getting this message on the import. (Already checked inventory is there and good) Please help, I have tired everything even SAGE without…

I would like to update all our customers to receive invoice via email pdf, what table should I use for import? Also is there a way for us to set all new customers to have the Paperless office PDF to have the email checked? Thanks.

Is there any way to populate the BM_ComponentReportSelection.M4T without manually keying it in the Gross Requirements Report? It is not an available table to import into for Bill of Materials. Thanks Russ