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.
I thought I read a post about this, but now I cannot locate one.
When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not:
Of course we get this message, which…
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…
Hello fellow Sagers!
Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …
Our customer wants to see the GL Account(s) and the respective dollar(s) for the invoices that appear on the Payment History Report and also to have the report sort by GL account. I haven't had great success using the AP_TransactionPaymentHistory and…
I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…
When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order?
Thanks
Hello everyone,
I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…
Hi All,
I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…
I have pretty limited knowledge/experience with Sage or report writing but I'm currently working on recreating non-modifiable System Report 4-1-3-21 so I can add "account" as a selection criteria.
I was able to recreate the calculated fields and I am…
We have been looking for a report that will show the total job cost including labor cost at the marked up rate and contractor's fee for bid and time & materials jobs. Is there a report that will show those numbers? The only ones I have been able to find…
We have a large number of custom reports for some of the modules. Is there a way to organize the order in which they show up? They are currently in the order in which they were added. Short of removing the reports and then re-adding them in the order…
Deductions are automatically calculated but at times when an employee is on vacation, deductions are not calculated for that week for that employee. They are entered manually next pay period in addition to the automatically calculated deductions. What…
I created a custom report and have been trying to add it to the Sales/Custom Reports. I done this on many other reports in our system and have had no problems. In this case I have added the report to the menu, but every time i launch the report it will…
I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…
Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled.
Thanks for your help!
