Sage 100

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…

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 …

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

My customer wants to alter the Accounts Receivable Aged Invoice Report to sort on the Salesperson number listed in the AR_CUSTOMER (name sp?) table rather than the salesperson number in the AR_AgedInvoiceRportWrk table which is the same number that is…

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…

First, let me say, we are a long time Sage user. Started with Mas90 back in the mid 90's. I'm really tired of the way Sage has handled their accounts. This newest issue is so annoying. Each year end we run vendor labels for files. I just find the custom…

Is there a specific Sage 100 table to use for a custom Crystal Report, that will show a list of all users currently logged in to the Sage 100 ERP system at any given moment?

Has anyone had any luck connecting these two tables together? I am trying to create a daily sales report that has profit based on the lot number. The problem I am running into is the OrderTierDist clears when the sales order is being invoiced and pushes…

Just started with this error in December 2015. Users of both DC Reader and Acrobat Standard XI, Windows 7 ,Mas 4.2. Not sure if MS or Adobe update caused the issue. Any help is appreciated!

I need to be able to review invoice line history for specific customers for a period in time(AR INIVOICEC HISTORY) Detail and Header). From that data I want to exclude specific items sold during specific date ranges(Sale items). Once I have gotten the…

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…

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 have created a report that pulls from AR_InvoiceHistoryHeader, AR_InvoiceHistoryDetail, and AR_Customer. It has a parameter to pick an item and then it has a cross-tab of the quantity shipped for that item by month by customer. I know that I can put…

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!