Sage 100

We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…

Hi there, I searched and couldn't quite find what I was looking for. I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue…

As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…

What version of Sage 100 will interface with LCP Tracker for certified payroll reporting?

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…

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

Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?

I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…

I've recently created some custom versions of reports (AR Aged Invoice Report, for example) and set them as default for all users, but for some users it still defaults to the STANDARD report every time. It is set to the default report via the checkbox…

I am trying to add the "JobDesc" field to our AR Aged Invoice Report so that we can see what job name corresponds with the invoice on the report. I'm a beginner in Crystal Reports, but here is what I've tried: In Crystal Reports designer, I created…

I have a client who has a fairly heavily modified SO form (although we cut back from what we had previously done by quite a bit). The client will have an issue with the Freight amount not saving on the Total tab. I will go in and recreate the customized…

I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

Hello, I'm trying to modify my picking sheet so it shows which Sage user created the sales order. I'm using Sage 100 ERP 2013 and Crystal Reports 2011. I have "SO_SalesOrderDefaults" added in Crystal Reports under Database Fields, but when I add …

This might be a simple question, but I couldn't find a solution. I have an Excel Spreadsheet with a PostDate column whose value is: VLOOKUP(E2,upload!A:H,2,FALSE) and it shows as a Date. I'm using this spreadsheet as a data source, but my application…

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…

Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table? I've tried creating an UDF via CM under SO Additional Picking List Work, but I…

We're editing our picking form, but now when there is a comment on an item it will add a line of space before the next line item. Is there a way to get rid of this space? Is there a way to get rid of the extra space created when an item doesn't have a…

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…

In Business Insights Explore, is there a way for me to have the Data Field information and the Preview Field information on the same report? I've got all my fields the way I want them, but I don't want to just see the Invoice History, I want to see the…

I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…

Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…

Hello, We are having an issue with our invoices not closing out because the actual kit is marked as 'backordered' as opposed to 'shipped'. However, all components of the kit have shipped. For example, the KIT named ABC-KIT has 3 components: ABC…

Hi everyone, I'm using Sage 2013 I've added a new tab to the Sales Order module in Main > Invoice Data Entry I've added fields/UDFs (some are already ones that existed), but I'm unable to add to anything in this tab or figure out how to get some of…