Sage 100

I have two udf’s that are populated on the SO_SoDetail table, they are also printing on our pick ticket.  How can I capture a date time stamp value for when that udf is edited (it’s a numerical value) and display it on the crystal report for the…

Hi...

When running custom Crystal Reports from the Sage menu or even in Crystal Reports, the run time parameter is not letting you edit the field or add new data to the field.  Even the calendar widget for date parameters will not access.  Is this something…

I have this in Select Expert and I need to also include a value that has no VendorNo

{AR_InvoiceHistoryHeader.InvoiceDate} = {?Date Range} and
{AR_InvoiceHistoryDetail.VendorNo} like ["0000833", "001????", "002????", "003????"] and
{@Total Sale} >= 0.01…

Trying not to duplicate a question that has already been asked.

I have a crystal report that can be run from Sage and interactively that does not use any work tables, but when attempting to run it from a KnowledeSync report in 10.5 version I get a Database…

Hey All,

I am customizing our Bill of Lading (Picking Ticket) so that it will calculate and print the Net and Gross weight of each item on the ticket. I have just about everything worked out. Where I'm stuck is when there is an item that is repeated on…

I am adding the Creator (2 or 3 initials of our team) of a Sales Order/Work Ticket on the WIP Report.  It only comes up on part of the Work Tickets listed.  I have tried to compare of what has hours applied, what has parts, etc.  Is there utility I should…

We'd like our quotes to display the product codes hyperlinked to their associated webpage on our website.

Is there a way to do this with sage 100 and crystal reports? Seems like a very basic thing that should be doable. 

I created a sales history report in Business Insights Report Wizard using Invoice History.  Objective is a total invoice amount including invoice number, customer number, customer name, invoice date, transaction date.  However, the report repeats invoice…

When I started with Sage, I took several classes online - Data File Structures, Crystal Reports, etc.  I can't find any resellers that offer these programs anymore and Sage seems to only offer X3 classes.  Yes, I see the YouTube offerings but I am looking…

What formula would be used in QuantityDecimal to set the number of decimals to 2?  We need 4 decimals for qty for BOMS only, so would like all forms to only display 2 decimals.

Thanks.

Getting database connection error on all custom payroll rpts after upgrade to 2021.  Other custom rpts fine.

We had our system put in about a month ago(Sage 100 2021). When I go to make a customer credit in the Sales Order module, I can apply it to a specific invoice. But once I go to send the customer the credit, nowhere on the form is there a 'applies to invoice…

Scheduled regular sage 100 rpts work well in task scheduler.

Is there a documented way to schedule a custom crystal report.  Posts I see are many years old so hoping there's an easier solution now.  Have a involved rpt that takes a while to run while…

I've been tweaking our AR Aged Invoice Report in Crystal Reports and have ended up with a few versions that I now need to delete. They are showing up as options in the Report Setting List. I've deleted them in the Reports Manager, but that had no affect…

I am trying to add the "JobDesc" field to our AR Aged Invoice Report so that we can see what job name corresponds with the invoice on the report. I'm a beginner in Crystal Reports, but here is what I've tried:

In Crystal Reports designer…

I need to create a sales order form for KnowledgeSync. I can't get the lines to print in the correct order.

The standard sales order form created from the sales order work table has a "Group" that I'm assuming is what gets order lines to print as…

We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…

I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name.  I added the Sales Report…

I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…

I figured out how to add images to our picking sheets, but not all items have images and those that don't leave a huge blank space where the image is supposed to be. Is there a way to "collapse" this space if there is no image associated with the product…

Hi all,

I need to add the Sum of 3% Parts ( which seems to be a sum at the Group 2 level) and 3% Freight but I cant seem to get them to add correctly.

Any help is greatly appreciated.

---

Parts Extension
IF {AR_InvoiceHistoryDetail.ItemType}="1" THEN …

I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…

Hello!

I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer.

It would be nice if i could filter a whole list of orders…

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…

I'd like to edit the Picking Sheet printing Crystal report to only print orders containing a specific item.  So if it contains that item, it prints a picking sheet with that item and any additional items ordered. 

Does anyone have a formula for that…