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…

Hi Folks, I am trying to add payment information to my A/R invoices. My test company has a formula field called "Payment" with the following formula "formula = {@NetInvoice} + {AR_InvoiceWrk.FreightAmt} + {AR_InvoiceWrk.SalesTaxAmt}" that does not seem…

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 looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

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…

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…