Sage 100

We have the option under sales order options to print the pick tickets by line number. We also have the group header suppress check box checked off on the crystal report. When one line has a different warehouse the pick ticket is out of order compared…

Hey all, I was wondering if there is a utility or report in Sage 100 that could list which users switch quotes to Sales Orders? We are wanting to track who is taking quotes in the system and turning them into Sales Orders without prior authorization…

I have a suppression formula on the details line in crystal however it is filtering out the items when the order type switches to backorder. How can I include the backorder order type, is it as simple as removing the last statement in the formula? …

In Sage 100, I am attempting to select the earliest and latest dates from the completed date column on the work order scheduling tab. I need to do this via an SQL table. Currently, I am using the following calculation: [SELECT srvsch.findte FROM srvsch…

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?

Good afternoon, I am new to Sage and Crystal Reports so sorry for all of the questions. I am looking to update a column header and have no clue how to go about this or how Crystal Reports works. I am in Designer, and looking to edit the screenshot shown…

Hello, I have a custom crystal report for Sage 100 v2021 Advanced that has a group that uses the PO Required Date and groups it by week. Sage Alerts will only send this report successfully if I remove this group. The alerts error I receive when generating…

Can't seem to figure out how to get my text strings to continue on one line and not start a new line. Here is a screen shot of how its printing out and a screen shot of the crystal report of how its set up.

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} >=…

Within our sales orders we have miscellaneous items randomly, they all start with "/INST...". I am wondering if there is a way to script or use a formula to add a solid line above the line item "/INST..." each time it shows up? This would be on the crystal…

I am trying to create a Crystal Report to show AP Invoices based on Invoice Date that went to a certain GL Account. The GL Accounts I am trying to grab are in the range of 540000-000 to 540000-999. This is what I have current Linking which I feel…

In SO entry a bill type of kit always explodes on the sales order and we have "include kit items on picking sheets" checked in SO options. Have a request for the picking sheet to print and group all kit component items first followed by any other items…

What is the main reason for this error when creating a formula in crystal? I am getting this error on all of my formulas, they contain UDF's that I am sourcing from the SO_Header, the UDF's are on the SO_PickingSheetWrk table and that is where the formulas…

Trying to find some direction on editing our Picking Sheet form. In the "details a" section we have the item code, etc., when we have more than one line on the picking sheet I would like to have more spacing between the two different lines on the picking…

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…

I'm editing an existing check report that currently has the "Company Name", "CompanyAddress1", etc. formula fields that are being populated via witchcraft. I need to add the company city, state, and ZIP to the report. The solution from 14 years ago…

I don't think there is any out of the box functionality to handle this right? If not, anyone think its possible to rig up somehow (for quick printing only)? Assuming you had a UDF setup in Customer Maintenance - I see you could technically attach a UI…

Hello, What is the process of copy forms such as S/O's, P/O's, pick sheets...etc from one company to another.. Regards

I made a report using AR_Customer/AR_InvoiceHistory/AR_InvoiceHistoryHeader to find out the sales from a certain vendor and a UDF commission sales rep. It takes 30min to generate a months of data. If the report has already been generated I can add a Group…

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…

We print our daily sales reports/updates with Paperless Office. Is there any way to get rid of those prompts before each report? Do you want to print Gross Profit Journal? Do you want to print Daily Recap Reports? Do you want to update SO Journal…

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.

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…

Have a sales order crystal form using operations management and I'm hiding chargeable components on the form so it only prints the parent item. Due to the hiddent items, Crystal always thinks that there's more records to print so that "onlastrecord" in…