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.
Hello everyone,
I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…
Why would a Sage 100 2022 Customizer Utility import fail if it is used to copy from a ".M4X" file a P/R UDT, VI jobs, and event script to the same level (Both are Sage 100 Standard 7.10.2.0 and P/R 2.23.0.0) from which it was created?
Hi,
We have a lot of master PO's that suppliers ship partials in multiple shipments. Hence we assign a letter to a standard PO for each shipments using the same master PO #. The standard PO draws balance from the master PO (Master/Repeat PO). We are…
is there a way to get a sum total of all the pieces ordered to calculate and print on the SO, Packing list or bill of lading.
I am looking for the grand total of all the items. Having a grand total of the items shipped would also be helpful.
Than…
Is is possible to change the description of the Early pay discount? This would be the description that prints on customer statements and located within the customer's "Invoices" tab. It shows under "Payment Ref" within the details section within the invoices…
I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report.
I need to create a summary report that includes data from both tables. I'm hoping that someone has…
Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table?
I've tried creating an UDF via CM under SO Additional Picking List Work, but I…
In Business Insights Explore, is there a way for me to have the Data Field information and the Preview Field information on the same report? I've got all my fields the way I want them, but I don't want to just see the Invoice History, I want to see the…
Been awhile since I've worked with Crystal and have what should be a simple formula.
The Qty BO Column on the SO Picking Sheet just prints an Underscore.
I'm trying to get it to print the Qty BO if not equal zero and a blank if equal zero.
Keep…
Hello, folks:
In our payroll module, the Employee Masterfile Audit Report doesn't capture changes to employee deductions, direct deposit bank accounts, or paystub emails or passwords. For years, our workaround has been to save screenshots of the change…
I would like to add the $ to the beginning of sales numbers in a custom Crystal Report, however I can't seem to locate a place to add it when in Cyrstal Reports.
I'm creating a Crystal report and wanting only Job Billing History for a specific year. Currently using the selection
{JC_Job.LastBillDate} in Date (2020, 01, 01) to Date (2020, 12, 31),
but it is still including 2019 and earlier invoices?
Apologies if this is not the correct category. From time to time we receive the following error when attempting to do custom report printing. The temp file is there. The only fix seems to be rebooting the server and deleting the file. Sage 100 will then…
Sage 2019
I created a Data Container. I added a table and would like to add an alias of the same table with a left join.
When I attempt to add the table, a message informs me the table has already been added. In Crystal or Access, I am allowed…
I have 20 report in the Payroll Custom Menu, and when I add a new report via the Library Master Report Manager, all the reports disappear except the one I just added.
Can anyone tell me where I can find step by step directions on creating a custom check history payroll report? We have 3 departments and within the departments employee work within department numbers. I can print the payroll check history report and break…
Is it possible to insert HTML code in the ‘Electronic Delivery Message Maintenance’ window? We would like a nicer landing page for the employee pay stubs.
I am trying to make a custom report in Business Insights Explorer that shows:
Item Code
Item Description
Product Line
Quantity on Sales Order
Total Quantity on Hand
But I cannot link a "Qty. on Sales Order" column to the rest of the report…
I really like the presentation of "Days Delinquent" on the AR Aged Invoice Report and would like to do the same on the AR Statements.
My problem is trying to find a good field that equals the "Statement Date" (with cut-off ability). What I've done so…
How do I customize my subcontracts to include all of our legal verbiage we require? I can find how to format the form and add small areas of text and fields, but I have 3 pages to our subcontracts.
running Sage 2018 sp3.
I have this script running on quantity shipped in SO Invoice Data Entry.
tmpQtyShip=0 tmpGrWt=0
retVal = oBusObj.GetValue("QuantityShiped", tmpQtyShip)
retVal = oBusObj.GetValue("UDF_GROSS_WEIGHT", tmpGrWt)
retVal = oBusObj…
Sage 100 Advanced 2018 - Crystal 2016 - New payroll check alignment using Stub, Check Stub format - The "file", "page setup" allows the increase of the top margin without causing it to go to a second page (at least from my testing so far). I've been able…