Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
We have Sage 100 Enterprise at the company I support. Performance directly on the host server is lightning fast, but on client PCs over the network it is painfully slow, especially when printing to paperless and opening Adobe Reader. I have followed every…
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 are attempting to delete a SO. we have successfully done so to other SO but this one item gives us an error #47 Substring reference out of string and we are unable to do anything.
When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…
All,
I'll try and be concise. I am working with Sage100 2019 and Visual Integrator Jobs. We just moved up from Mas90 4.3. Whoa, I know. Here's my dilemma:
In Mas90, we had a VI job that would bring in website orders in a csv formatted file and import…
We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…
Hi
I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank .
Later when there is an update on the Date…
Does the Connector support UNION Queries for Sage 100 Data?
Have a simple UNION that just doesn't seem to work. See sample below:
Select
JT_Transaction.SalesOrderNo as 'SalesOrderNo' ,
JT_Transaction.TotalCost+JT_Transaction.TotalLaborCost…
Questions: 1. How to check status completion of VI Job? (see picture 1) 1. What Sage MAS 100 table and field should we use to determine VI Job status using ODBC? 2. Is there other way to run VI Job without using PVXWIN32.EXE?
The problem description…
Questions: 1. Is there any option (bypass) for access to Job Cost tables via ODBC driver? 2. Is there any option (bypass) to decrypt employee encrypted data from external app? 3. Which of tools are recommended for reading data from Sage Mas 100 in replace…
I have gone through the set up wizard for the General Ledger Exchange to import a journal entry from a CSV vile and got all of the way through to the GL Exchange window to import the file. When I click on the Proceed file I get an error that says, "Source…
I am trying to use BOI tp print PO to paperless office and I am having hard time finding any good examples of printing to paperless.
Does anyone have code for printing of any forms or reports to paperless?
My goal is to email PDF copy of purchase…
I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total.
The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount.
I don…
Thank you very much. It works.
However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table.
Also, what are all abbreviation of different type of tables, such as header table, wrk…
