Sage 100

I created a task in the Sage 100 task scheduler to update PO batches. If I hit 'Run Now' button in the Task Scheduler module, it all works perfectly. However, I can't get it to execute at a certain time each day. Windows task history shows it's executing…

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…

I am new to designing reports in Sage 100. Is there a good YouTube video or documents on this? I just need something simple for an audit (employee name, job title, gross wages, and overtime wages).

The Sage 100 Open Sales Order Report has a list of stock criteria fields, and some fields we added using custom office..see attached. Are we able to add additional standard Sage fields to this list eg; CustomerPO?

Hi... I'm trying to find a way to add a value from the bill of materials bill number field in bill of materials maintenance to autopopulate the bill number when you run the Single Level Report from the screen. As it works now, the report will appear…

I am looking to print the customer type on the picking sheet. I added the AR_Customer table to the database, used a left outer join. Added the Customer Type to the crystal form (browsed the data-I could see the customer types) BUT when printing it does…

We print large batches of picking sheets a couple times a day, when this process is run the printing prints all of the picking sheets form 1 first, then goes back and prints the second form for the picking sheet. The process is run on 20-100 sales orders…

MN has enacted Safe and Sick pay that must show on an employees paystub. I have added this field and label to the DD stub but do not want it to print for employees that are not in MN. The hours are helfd in time off 2. How can I suppress this field from…

We have 170+ rows and they are separated into 4 different groups of rows. First group of rows is 1-54 and behind that one is 108-55 and then 109-138 & 162-139. We could have a order that has an item that's on row 1, row 54 & 108 for example. If they pull…

I need my team to be able to see certain information on Sales Orders for a few product lines - is there a way to auto-generate comments on those products? Or would it be easier to implement extended descriptions to SOs instead?

There are additional efforts to use Crystal Reports 2020 (@Sage 100 2023) with MS Office or text files. I have Custom Reports that include links to Excel and MS access. Without the native connectors we will have to use downloaded add-ins. Does anyone…

I am trying to import multiple POs into the same Receipt of Goods. I chose Next for the Receipt Number and pointed it to the field I want to use to determine the change, but apparently it ignores that and changes whenever any header field changes, i.e…

I would like to add the Company name on all employees pay stubs. Is there an easy way to do this?

I have created numerous custom SQL views in sage company databases and used them in custom reports, added to custom reports, and module forms. I just did the same for a customer and cannot print/preview the report from the custom report's menu. The error…

I made a custom report with Business Insights. Pretty simple report, shouldn't be a big deal. But every time I try to make a custom report, it will run very fast on the server. As soon as I try to run it on a workstation, it takes forever and ends up…

Hi, I built a report in Crystal that they can input several item codes and it returns who has bought those items. It was added to the MAS menu AR custom reports. I had to build Access databases and custom ODBC to run the report. Its worked for a long…

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