Sage 100

We have set reorder points on all our products we inventory, these items are flagged by a udf in CI_Item. The reorder point report in Sage looks kind of clunky to me and I was trying to get a notification to order items below the reorder point. I've read…

I have a client using Sage 100 in a cloud platform (SWK). When I login under the client's name into SAGE (but my name on the network), I can see a report in Report Viewer. When the client logs in under their name in the network and into Sage, they do…

Hi Folks, I am trying to add payment information to my A/R invoices. My test company has a formula field called "Payment" with the following formula "formula = {@NetInvoice} + {AR_InvoiceWrk.FreightAmt} + {AR_InvoiceWrk.SalesTaxAmt}" that does not seem…

Hi Guys, New member here and new to Sage 100. I am trying to custom build a GL Details postings report for beg of the year to present to present to management and want to include my own parameters like: (period, account, account description, p&l category…

I'm trying to find out how many invoices are being entered by month/period. The generic report JAccounts Payable Analysis Report shows this information, but it is showing me data from year 2022, May through October. How do I change the date range? Or…

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…

How do I add a "Description of work" to a T&M invoice?

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…

When you use the Auto Generate Purchase Orders from Sales Orders you select the criteria you want to generate PO's for, then once you click proceed you can view a report before actually generating PO's. Not sure what that report would be called but, is…

I have created a custom Work Ticket report setting with a subreport. The subreport uses the JT_WorkTicketAttachments file. The main report links to the sub report by SalesOrderNo and WTNumber. I have placed an image placeholder on the sub report detail…

I've been working on some changes to our Open Orders by Item report in Sage 100. I would like to print this report, and have it indicate the quantity on hand in addition to the items on open orders to better help show when product is available to fill…

Looking into a way to have Sage automatically calculate the Total material cost by taking beginning inventory plus purchases, less ending inventory and incorporating this into the financials cost of sales. Is there a way to have this done? Also, if…

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

I am trying to run a custom crystal report that pulls customer invoices based on Invoice Date and Sale Type of "GSA". For the life of me I can't seem to find the table that holds this information. Thanks in advance.

I'd like to include an active hyperlink in a custom report form using Sage report writer. Is there any way that the report writer can recognize a hyperlink or HTML?

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…

How can I add a column to my customer statement for the due date? Thank you for your help!