Sage 100

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…

Hello folks, We are starting the process of upgrading from an older version of MAS 90 which ran on Providex to 2023 Premium. There are a number of custom apps that we've developed over the years to run with our MAS data and they all used the MAS ODBC…

is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…

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?

Hi, I am new to Sage 100 Advanced (2021) as of Oct. 2023. I'm beginning to grasp the structure of Sage and how to customize it for business needs as they arise. However, one need I haven't been able to figure out is if the "Packing List" and "Picking…

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 would like to add the Company name on all employees pay stubs. Is there an easy way to do this?

I was unable to find anything online, how can I print item's extended descriptions so they will show up on printed Sales Orders? Or alternatively how can I increase the 30 character maximum that the SOs will currently print? Thank you for the help.

I am working on an issue after a new a install of Sage 100. The font on the Sales Order Entry Module is tiny. ( See attached Pic ) . I have adjusted the resolution and scaling in Windows. But this has not made any difference. All other Sage modules and…

Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…

Sage has built-in support for storing dates in a UDF by simply changing the "Data Type" to "Date". Then under default value, "<SystemDate>" to allow the date to be immediately filled upon new record creation. Did they forget that dates are usually paired…

Trying to color the SO header customer# field if the customer type fall = specific value. I appreciate if you can help. Ctype = "" retVal = oBusObj.GetValue("CustomerType$", Ctype) If Ctype = "SDIS" then Set myUIObj = oSession.AsObject(oScript…

Is there a way to make hidden columns by Transaction Entry type show in transaction types they don't typically? And be editable? For example, the Unit Cost / Price definition in the Sage Help has this note: " The transaction type selected in the Transaction…

Does anyone know if you can display the billto customer # in the main screen in customer maintenance on the sold to?

Why would a Sage 100 2022 Customizer Utility import fail if it is used to copy from a ".M4X" file a P/R UDT, VI jobs, and event script to the same level (Both are Sage 100 Standard 7.10.2.0 and P/R 2.23.0.0) from which it was created?

Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?

I am trying to hide tabs 3, 4, and 5 for Customer Maintenance for a specific user. I know I could set the fields on the tabs to hidden, but the user wants the entire tab to be unseen when looking at Customer Maintenance/Inquiry. I cannot delete the tabs…

I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…

In GL_CompanyActiveBatch it appears the batch status field is always blank. Trying to write a Sage Alert that filters out any batch "in use". Is it even possible? Sage 100 v2021. Thanks.

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…

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…

I have created a UDF in A/P Invoice Header to hold a document number (separate from the invoice number) on our A/P invoices being imported from a 3rd party solution. That will work for invoices being created now. What would be the best way to update existing…

I am trying to add a UDF with a one to many relationship with an inventory item. I created a UDT to store the values of the UDF that will be associated with the items. Then I created a second UDT to store the relationship between the items and the UDF…

With 4k monitors and a lot more screen room we would like to move some information from the "additional" tab to the "main" tab in inventory and accounts receivable so we don't have to flip back and forth between tabs to see everything we need. I was working…