Sage 100

I am trying to find a way to return the description of a UDF using SQL. I am currently using the following: Select * FROM JT_Employee But I need to bring forward the descriptions of the UDF's. So for example, "UDF_F_Name" would return "Employee…

We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…

We are having an issue where control labels are missing after panels have been modified. This is occurring for labels/controls that were not part of the modification. As a result, we have to keep continuous backups of our panels and roll these back in…

Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?

MN has enacted Safe and Sick pay that must show on an employees paystub. I have added this field and label to the DD stub but do not want it to print for employees that are not in MN. The hours are helfd in time off 2. How can I suppress this field from…

Why on one pc suddenly the credit card number is masked? Just the last digits show on that pc no matter who logs onto it. All the other pcs show the full number so we can verify it. (The person entering the card is not the same as the person running…

I've created a UDT in AP. Populated the data and then created a UDF in AP Invoice Detail. The Code field appears from the table but i cannot select it. what needs to be changed? UDT AP Invoice Detail UDF in AP Thanks for your assistance…

I need to make a single, one tine purchase from a vendor we will not be using again. I searched in Sage City, Sage University, YouTube, and Google and found nothing. The lack of info is extremely frustrating...I've yet to find any source that can help…

How would I go about adding a description field that displays the corresponding description record for a UDF? Does this require scripting or can these be linked in Custom office? I dont want someone to be able to select available descriptions from the…

I'm exporting column names in my Visual Integrator export. I need to rename one of the column headings, but I can't seem to find a way to do that. Anyone have any suggestions? Thanks!

Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…

We are trying to get our receivables under control and our IT department has helped so that our customers now go on automatic credit hold when they have invoices in 120 days. In our system, when a salesman attempts to open a sales order and the customer…

We have 2 companies to convert to production management... V2019 to V2023. I have been working with my sage partner with this test upgrade, however this is our 2nd test installation and the one company is still taking way to long to convert when it…

Morning, I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)? {SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…

Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

Hey All, I am customizing our Bill of Lading (Picking Ticket) so that it will calculate and print the Net and Gross weight of each item on the ticket. I have just about everything worked out. Where I'm stuck is when there is an item that is repeated…

Is it possible to change the order of the columns or delete a column not used in customer maintenance under the invoice tab We never use the Disc Date or the Discount amount is it possible to move them to the last columns or remove them from the view…

Has anyone else noticed the themes in Sage 100 2022 Premium are misaligned? We use different frame colors by company. The cutouts for the minimize, maximize, and exit buttons on the top right of every screen are misaligned.

Hi All, I was searching for the object reference for Sales Order Line Items. Can anyone please guide me on this.

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…

I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…

Can't determine what the problem is for the script message not displaying in SO Entry. Here is my script. Client is Premium version 2021 ' -------------------------SCRIPT START ------------------------------------ If oSession.CompanyCode <> "ZZZ" and…

What formula would be used in QuantityDecimal to set the number of decimals to 2? We need 4 decimals for qty for BOMS only, so would like all forms to only display 2 decimals. Thanks.

We had our system put in about a month ago(Sage 100 2021). When I go to make a customer credit in the Sales Order module, I can apply it to a specific invoice. But once I go to send the customer the credit, nowhere on the form is there a 'applies to invoice…

On a 2021.0 and 2021.2 system, exporting to Excel from a list box results in the cell formatting applied being off by one column whereas on a 2020.1 system, the cells have the correct formatting applied. On the 2021 systems, this was observed when exporting…