Sage 100

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.

Sage 100 Standard 2021, PU 2. This was working (and still works) in 2018. Advanced Logic says to include only a Range of Customers PLUS 1 specific Customer. Here is what it looks like in 2018: And, like I say, it works. Here it is in 2021: Of course…

Hi. I am trying to pull MRP from the prior year.

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

Does anyone have a creative suggestion on how to display the sage 100 user who is running a custom crystal report on the report so I can link to the AR salesperson? I’m trying to find a way to suppress information on a custom crystal report where the…

Message is “You cannot run this report as the data is in use by another task.” Other messages include: "view cannot be used - one or more tables are missing" to the table VIEW_ to the "you do not have sufficient rights" depending on if you try to select…

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

Hello, I was making final edits on a Crystal Report, Inventory Reorder Report in Inventory Management, and I have not moved the file in any way or changed the name. I am just now getting this error after running the report successfully mere minutes…

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

Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…

I have a UDF(checkbox) on SO_Header called 'Additional Handling'. When I open Picking Sheet Printing, and use the filters to say UDF_ADDITIONAL_HANDLING equal to "Y"....the correct orders print, but each pick sheet only has 1 line on it...even if the…

Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…

Sage 100 ERP 2013 I've been struggling to create a panel I need for my small business and create a form in Crystal Reports for it - I've hardly had time to attempt this and I'm not having an easy time with the advice that's been offered. I don't have…

Does anyone that knows how to control and allow salesperson to be able user lock the by the salesperson to be able to see only see their only their customer statement and sales order invoice but no other sales representative. Currently, the lookup is…

I've created a UDT with 2 fields, ItemNumber (The key) and Description (A multiline text field). I want to link the ItemNumber to the ItemBillNumber of a work order and display the Description on the Work Order Traveler. I've added the UDT table in…

Hi... Seen many posts about this issue, but no solution or answer. I have edited the windows registry and running the crystal outside of sage or from the report manager function, the parameter shows all the records for that database, even if over 1000…

Hello, We went live with a new project yesterday and are having some issues. I spoke with support, but because we have so many modifications they said they were unable to help. I found the two below entries in the activity log that I believe may be…

Cannot utilize AR_CustomerSalesHistory. Need $0 Customer sales report for specific time frame. Parameter = i.e. Nov 1 2018 thru Nov 31 2019. Thanks for your assistance.

Hello, Normally when sending out a purchase order, everyone uses the Quick Print button to Print and Electronically Deliver just that PO. Occasionally someone will hit the Purchase Order Printing Button to Deliver the PO and will accidentally send…

When running the standard Monthly Sales Report in the Accounts Receivable module, under Options, the screen only shows the oldest accounting period in our database. Shouldn't users be able to pull down a menu and choose any individual month or range of…

I've created a report that generates a label. My report asks for the Sales order no and the line on the sales order. The report table sources are so_salesorderheader, so_salesorderdetail and line item reference on the sales order. Sometimes the…

I'm sure this is similar to the issues others are having when trying to get PII data from Sage to another application, but I'll ask anyway. Our client has an Access database. They need First Name, Last Name and Status. Anyone figured out how to do this…

Does Sage 100 have a SOC 1 (old SSAE 16) report for our auditors?

Is there a way with Crystal Reports to string together 3 different sales order form codes to print at once? either for a single order of for multiple orders?