Sage 100

Hello, I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…

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…

I entered AP Payment Processing in Company "A," created a new Form Code, and used Designer to create a new custom Check. I have 10 other companies and would like to copy the custom Check to all of those companies. I think I'm supposed to use Report Manager…

I need to print an Accounts Receivable Invoice History Report sorted by Customer type. I have created the UDF for Customer Type and added to all the work and history files. When I run the report just selecting invoice dates I get my report showing the…

Is there an AR report to show/compare the Customer Sales History by Fiscal Period and Fiscal Year for more than 2 years?

We have 3 company codes in our system. The operational efficiency ratio data on the general ledger analysis report populates for one of our companies but not the other. Has anyone experienced this issue before?

The Visual Integrator "Job Log Report" is cutting off the information on the errors that occur. For example, a recent report looked like this: You can see that the error description is being cut off and so I can't see which batch or invoice I need…

We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…

Hi, In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…

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

Hello, I have taken over at a small non-profit association and was given zero information by the previous accountant. I have never used this software. I am trying to simply look at all of the journal entries from the previous month so I can see what…

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…

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…