Sage 100

I have a user who accidentally created duplicate favorites in the toolbar. I asked them to log out of SAGE, deleted the duplicate entries, saved favorites.JSON, and asked them to log back in. SAGE synced the duplicate entries back into the JSON file.…

I am trying to modify the AP_ExtendedStub report in Crystal Reports. This is the ACH Remittance form. There is a data field ACHDistributionAmount which is the total ACH amount. I want this amount in the page header, however I cannot get this field to…

Does anyone know of a 3rd party addon that can be installed for Sage 100 to allow multi electronic delivery forms i.e. Invoices for one company?

Is there a path to get UDF's from SO to Customer Last Purchase History? or a script? Sage 100 ver 2024

Looking for a way to add UDF fields to the search window below

When we print our invoices that have serial numbers, the serial numbers print one after another on a separate line - see screenshot below. Is there a way to make the serial numbers print next to each other with a comma or something? Otherwise, the invoice…

Working on Sage 100 Advanced v2022.1 I created a CI_Item UDF with a list of 20 codes for "Packaging Types" about a month ago and all 20 were showing up from the drop down on the Item Inquiry/Maintenance screen. I update the UDT with 9 additional codes…

Is there a way to update this report to include the Invoice due date? Thanks!

According to the Sage 100 brochure for Payroll and Time Track: "With the use of Microsoft® Power Automate, your Azure access and Sage 100 web APIs including an available template, time track can quickly be deployed as a mobile time collection application…

I needed to have a version of AR Statements with a column that shows days past due for each invoice. Did not sound that hard. Pulled up Statement Printing from AR Period End. clicked on Designer to start Crystal Reports. Saveas first thing to new name…

Bonjour la communauté, J'ai créé une information libre pour mes articles de type Table. Pour certains de mes articles, dans leurs fiches, j'ai sélectionné le choix souhaité dans l'information libre. Maintenant, je souhaite dans mon édition de facture…

We have a required UDF in Sales Order. I noticed that the UDF doesn't seem to showing up consistently. Is there a way to fix this?

Been reading up on ways to utilize the "Image File" associated with itemcodes. Since the actual file is just saved in the Image folder would it be possible to save an image in the folder (not through an actual item) and add a script on the SO_Detail to…

We have a required UDF in Sales Order. When we try to generate the RMA, it's requiring the UDF, except the UDF is not in the RMA panel. How do I go about getting the UDF added to the RMA panel? Thanks.

Open a panel in Customizer and click to edit the panel's Tab order. The middle buttons are mirror versions of what they should be. The "Insert" button should show as an arrow from right to left. The "Remove" buttons should show an arrow / arrows…

I've been battling with this for a while now with a couple clients. The error appears to be completely sporadic. The error appears immediately after clicking the link button (as if its not even able to run the script). If the user then clicks the button…

Does anyone know whether it is possible to trigger a Sage Alerts event by running a Windows batch file? We're on Sage 100 Premium (SQL) and I'd like to create a batch file that runs a job in SQL, waits x seconds for that job to complete, and then runs…

We are looking to add a line to our invoices similar to the one below and I am struggling getting the right Discount Amount to calculate on the invoice. The Discount Amount we are wanting is the Terms Code Discount (1% 10 days, net 30) but I am not able…

We have instances where we change the salesperson assigned to our customers and I am able to use visual integrator to import those changes. However, this does not change the salesperson assigned under the primary ship to address on the customer. Is there…

Where is the company's name flowing from in Crystal Reports, @CompanyAddressBlock? I've changed it in Library Master > Company Maintenance but it did not impact anything. Trying to avoid having to re-write the address block on all of our reports. Thanks…

Hi, I'm currently working in an AP Invoice Data Entry import. Currently running v7.00.2.10. In my source file column 3 is the invoice number. In Column 8 if there is data in the cell then we need to use this number as the invoice number. If the field…

Hello, I'm trying to import multiple Receipts of Goods Entry against open POs, but keep running into this issue - the quantity received is imported but the quantity ordered column for the PO is coming up as 0. It should pull the open ordered quantity…

How do I find what a button does on a form. In my case I know that it opens a crystal report but I don't know the name of the crystal file.

I'd like to filter a view by comparing to columns in the view. I'm specifically trying to create custom 'Customer History Invoices' view in AR, and would like to identify invoices that didn't have an invoice date and a transaction date in the same month…

Hi Sage Community, Our company has an old note pop-up that only occurs when an old Product Line that has recently been activated again is added to the Line Items of a Sales Order: I thought it might be a memo, but can't find an associated memo and…