Sage 100

Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing . I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket…

I am on Sage 100, 2020, Premium (SQL) version 6.20.0.1 I have customized the Purchase Order report and it works fine from purchase order printing until in crysal reports I link the inventory memo table to the purchase order wrks table. As soon as I…

Hello. I have created a custom Crystal report showing sales by Salesperson code. I realize there is a "standard" report in Sage already, but our director is wanting one that exports to a clean Excel format. A couple of issues... 1. The custom report…

Instructions on how to create a label (4x6) The two modules we could start to use this feature is in: Sales Order\Main\Shipping Label Printing Purchase Order\Main\Receipt of Goods Entry

I am attempting to move some of our label printing to crystal reports. I can successfully print labels but, is there a way in Crystal Reports to have a group section repeat X amount of times based on an equation? For example, lets say I have 1 line item…

We are planning on beginning to email invoices and I have been testing this in a test company code. I have an invoice form that I have modified that we have been using without issue, when I print the form it looks perfectly fine. Some of the sections…

Is there a way to print the user ID of the person who printed a report on a report? We have a customer service team who prints all of the picking sheets for our different warehouses, occasionally mistakes are made and it would be very helpful if we could…

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!