Sage 100

Hello, In our current table " AR_AgedInvoiceReportWrk" has a field called balance however, it is not calculating the customer balance properly. If I create a formula the properly calculate the balance would it be: if {AR_AgedInvoiceReportWrk.Balance…

Hello, I am hoping someone could assist me with a formula I'm trying to create. The UDF field I created for our users displays in numbers but I want to create a form that if the number displayed is x then it should display y. For example, "If {SO_OpenOrdersWrk…

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…

I need a formula that will print the customer alias item description ONLY when an alias item exists but NOT print the item description. And when an alias item description does NOT exist, print the item description. I know there is probably some time of…

We can have several vendors for just one item code and I need my report to show the Primary Vendor Alias Item No only, but it show the first vendor instead of the fourth one. Where do I find PV * ? Ive looked in IM_ItemVendor and IM_AliasItem and dont…

I have a crystal report utilizing the shadow text feature to print our pick tickets along with a packing slip. I am running into a road block on everything thing I've tried, we want to suppress some miscellaneous items on the packing slip, any charge…

Hello, Has anyone found a way to link IM_Item Table to the JC Job Transaction Detail Report Work Table? We are looking to get an item description included along with a part number on the report when we view for material pricing purpose. I am sure…

We have a client that has a page footer that is around 3" wide. They oftentimes have invoices that are more than 1 page and don't like all the empty space at the bottom of the page on the pages before the last page. Has anyone else has this complaint…

DELETE

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…