Sage 100

Hi, We have a lot of master PO's that suppliers ship partials in multiple shipments. Hence we assign a letter to a standard PO for each shipments using the same master PO #. The standard PO draws balance from the master PO (Master/Repeat PO). We are…

I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker. Essentially, instead of the user typing the invoice # they would type the sales order…

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…

We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view. I tested it on a few other lookup windows…

is there a way to get a sum total of all the pieces ordered to calculate and print on the SO, Packing list or bill of lading. I am looking for the grand total of all the items. Having a grand total of the items shipped would also be helpful. Than…

I created a Date UDF in PO Receipt of Invoice. it populates correctly. I'm trying to get this data into the AP_InvoiceHistoryHeader & AP_TransactionPaymentHistory. I've tried several links and can't seem to get the correct combination. Can someone…

Sage 100 2018 Customizer question All Inventory items are FIFO Valuation Client wants a Date UDF added to the PO Receipt of Good Lines I added the Date UDF to the PO Receipt of Good grid I need to know the steps on how to get this Date UDF to post thru…

There are several orders in our system, of which both the Sales Order Entry UI and table field of PickingSheetPrinted indicates that the picking sheet has not been printed. However, I do find the paper version of picking sheets of those orders in the…

Is is possible to change the description of the Early pay discount? This would be the description that prints on customer statements and located within the customer's "Invoices" tab. It shows under "Payment Ref" within the details section within the invoices…

From Main Item Maint Panel I added a button link to run a vbscript, which runs a shell command. How can I pass the ItemCode to the vbscript. ' init vars Dim itemcode Dim oShell itemcode = "S-209220" 'hardcoded here works, but needs to change…

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…

I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…

We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…

I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…

Hi, We Needed help to integrate Sage 100 2020 with Amazon Seller Central for Amazon Payment and inventory reconciliation. Following is my requirement : - 1) Sync Amazon sales with sage 2) Sync Amazon returns with Sage 3) Sync Amazon Payments…

Hi, I found a thread about a somewhat related customization, but it wasn't quite similar enough and I wasn't able to learn enough to be able to use the information there. I'm trying to setup my sales orders to print to different trays based on criteria…

OK. This has me flustered. I have figured out how to use Temp fields in Vi for Sage 100 2019 to create a single SO that has multiple items on it. The data source I'm using has a separate row for each item purchased, and my current VI job creates one…

I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order. The only indicator they get is SO_SalesOrder_UI in a message box. Here is the…

Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…

I've encountered problems while trying to use SAGE 100's Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table? I need to export all of the JobHistoryTransDetail table records for a desired date…

I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report. I need to create a summary report that includes data from both tables. I'm hoping that someone has…

We sell valves for oil and gas pipelines and installations. We use one short description for sales orders and then very long detailed descriptions for purchase orders on how the valves are to be built. As Sage 100 only has one item description field we…

Hi, Needed Sage 100 2020 integration with Amazon Seller Central for Amazon Payment and inventory reconciliation. Following is my requirement : - 1) Sync Amazon sales with sage 2) Sync Amazon returns with Sage 3) Sync Amazon Payments with sage…

I have just setup an existing Sage100c customer on the Sage Provisional Portal and I am trying to migrate their Sage 100c 2019 version to the cloud version 2020. Now I did not install the Sage 100cloud so I do not have the Administrator password however…

Hi, My company is currently importing journal entries to the General Journal Entry module by uploading a csv file through the General Ledger Exchange. I was wondering if there's a way to customize the settings so that Sage is the one assigning the journal…