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.
In most accounting software programs, when you create a document, you are able to click on any line to drill down. I do not see such an ability with Sage 100. What am I missing?
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…
I am using the above-mentioned version of Sage 100. I am also told it is called Sage 100 Construction although I do not see that information on the application. I have four different companies on Sage, and I want to create consolidated financials without…
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…
First time in 12 years that the report I maintain is getting an error.
Failed to retrieve data from the database.
Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…
Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit.
We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…
Hi,
My client wants to filter the transaction date range within a specific statement date on AR Statement Printing Report.
I tried to filter the date range using 'select expert' which set the between from to transaction parameter.
If I press F5…
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 am trying to attach a crystal report to a Sage Alert. I have crystal reports installed on the Sage Alerts server and Sage 100 workstation installed as well. I have the SAP Crystal runtime engine for .NET framework 64 bit installed as well. The alert…
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.
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…
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…
Is it possible to change the company code during a VI Chain to event?
We have a process of importing data into the SO tables in one company code and then updating a field in the PO Header of another company code. I'd like to use the VI Chain To field…
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…
I have a request to add an "options" button that will open a custom dialog box with various button scripts performing different functions.
One in particular is hiding some elements on-screen for what I suppose is to sanitize some information for screen…
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…
Hi all,
Is there a way to have the work order notes prefill with each new work order without using a template? Would like to setup a series of questions that CSR can see in the work order notes and type in answers after for example:
Problem: (CSR…
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?
Is it possible to have a locked UDF field display its contents in red, possibly via a DFDM property change?
I've attempted (without success thus far) to update the color via the DFDM Nomads_Color property to 01FF which appears to be the hex code for…
How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error.
For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…
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…
if an employee has a customized panel (which overrides the all user panel ) how can we return the customized panel back to the all user version?
we had an employee accidently create a customized panel and it is not correct how can I get her back to…
From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card.
First I actually…
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.