Sage 100

Hi I am trying to access this database on crystal reports so i can add another table to the PO_AutomaticReorderSelect report. I have full Admin Privileges. I have never seen this company before but the Report i want to change is in there. Any help…

Would anyone have a label template for a shelf tag that can be used in a Zebra label printer, continuous? I would like to be able to modify a label that would print Item code, description, bin location and sell price. I am also willing to pay for any…

Currently A/P info on the Job Transaction Detail Report is showing Vendor number and invoice number. We would like it to show the Vendor name. In previous versions we had an extended solution that we purchased to accomplish this but they told us that…

When I build a crystal report using the database PO_VendorPriceLevel only, its showing some vendors that don't show up in MAS under item inquire/Vendor at all. How is this possible. I'm not sure if this is related to our price change problems.

Hello, I am having some issues with making a script to change the output setting for paperless office inside of sales order printing. I have some code below that I found searching the forum. The way it is now I do not get an error message and nothing…

Hi... Using multi-part printing in invoicing. There is a criteria if there is a certain salesperson, then print the commission page in multi part printing. I was able to create a formula in crystal that will only print the copy if the condition is met…

** Support advised that we should post here too We have about 30 machines (only 5-10 use Sage 2019 concurrently) on our network and upgraded from MAS 200 v4.3 >> Sage 2017 >> Sage 2019. Select users are having an issue where launching PREVIEW of reports…

I really like the presentation of "Days Delinquent" on the AR Aged Invoice Report and would like to do the same on the AR Statements. My problem is trying to find a good field that equals the "Statement Date" (with cut-off ability). What I've done so…

I have been using the Sage100ERP.Reporting.dll to automate Crystal Reports and export data at a number of clients without issue. I am in the middle of an upgrade to version 2018, and my script is coming back with an error on this line: Set report =…

I have been trying to figure out the best way to get a report that would describe something like Item “Usage” by Customer. The trick with the report is that not only do we have to recognize items that are SOLD to specific customers, but we must contemplate…

I am starting with a base report that uses a "work file" database - let's say Packing List. Can I link to another work file database and expect to get any data from the second work file? I'm thinking NO, since work file style databases are only populated…

We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…

I have been using MAS90 and Sage 100 for many years. Now I am needing more custom reports, but I do not know that much about creating or modifying crystal reports. I am using Sage 100c Standard 2017 V5.40.1.0 and Cryatal v14.0.3.613 RTM. Where can I…

I've been working with creating new income statement reports. I have 100+ departments and when I print out the income statement, each department is printing individually. I would like to have all 100+ departments print in one PDF?? is that possible?

Using Sage 100 Premium 2017 Using Crystal Reports 2011 I have six production SQL databases, all structured identically (for regional purposes). I have created a Crystal Report using a Connection based on OLEDB using one of the 6 databases. It uses…

Trying to install Crystal Reports 2011 on a Server 2016 with terminal services enabled. I have A: UAC disabled B: Changed user status to "install" and C: Disabled the antivirus. It appears to install and gets to the point of clicking on "Finish" at…

I need to be able to consolidate inventory items on the printed purchase order after generating multiple Purchase Orders from multiple Sales Orders. The system can consolidate the vendor POs automatically by selecting it in the PO setup options but it…

Hello, I am trying to make a custom quote form for the Sales Order module. In particular, I have created three miscellaneous comment codes that I would like to use in the form to act as a type of specialized input for our business' needs. However, when…

I need to be able to print Inventory Labels by the Qty on Hand amount. How can I do this?

I have a customer that has a very large number of items with lot numbers. Their products are lumber of various dimensions. 2 x 4 x 10 or 1 x 10 x 12 etc. We want to add a UDF or possibly an alias that will allow a lookup of a all "2 x 4"'s or all…

Is there a way we can add an "on-the-fly" text field that will show up on printed labels through Inventory Label Printing ? Our previous ERP system had a textbox on the print screen that allowed the user to type in a custom remark that then printed out…

Hi on sage 100 standard 2017 I am trying to pull 2 years with of data from our AR_InvoiceHistoryHeader/Detail records. The report i am trying to write will compare 2 years worth of data. so if I put in a date like May 31, 2018 it will compare may…

I'm trying to modify the PO's to include the Vendor's item #, which I put on there as a formula field under a new Details section: if {PO_PurchaseOrderWrk.VendorNo} = {IM_ItemVendor.VendorNo} then {IM_ItemVendor.VendorAliasItemNo} As soon as I added…

Error when I try to export a ODBC (SOTAMAS90) from Crystal. On one computer I can select Export ODBC, ODBC Formats (SOTAMAS90), LOG ON, Table Name, Failed to export the report [ProvideX][ODBC Driver][FILEIO] Not Supported. On my other computer I can…

I'm needing Beginning Qty from the Item Inquire History window. I'm wanting to find the Average quantity sold for each month when we had stock was available. I'm using IM_ItemWhseHistoryByPeriod in my report to get quantity sold in each period for the…