Sage 100

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 that…

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…

Hello All,

The current bestsofware shipping tracking will not work for us since we need a custom hyperlink with the tracking to each of the shipping carriers. We have the tracking number in Electronic Delivery Message Document email message body. We would…

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 from…

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?

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…

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

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…

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 I have…

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 on…

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…

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…

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…