Sage 100

I need to be able to review invoice line history for specific customers for a period in time(AR INIVOICEC HISTORY) Detail and Header). From that data I want to exclude specific items sold during specific date ranges(Sale items). Once I have gotten the…

We have a custom Crystal report that we run every morning that shows sales based on divisions. We can input a custom date / division / etc. I have recently discovered that the report shows sales that have not been invoiced yet. For instance, I can run…

I have written a report in Crystal utilizing dynamic parameters. When I run the report outside of Sage, it works fine and all of the parameters work as they should. If I add the report to Sage 100, the parameters no longer function properly. There is…

I have a Crystal Report that is linking CI_Item, to IM_ItemWarehouse and also linking to IM_TransactionHistory all with Inner Joins. The criteria are the following: {IM_ItemWarehouse.WarehouseCode} = "003" and {IM_ItemTransactionHistory.TransactionDate…

Recently we have been running into an issue with our 64-bit Windows users where they receive the below error when running any report in Sage 100 2014. Does any one have an idea of why this happens?

I am wanting to make small changes to the Trial Balance Report and run it outside of Sage 100. I went into trial balance designer and "Save as" to make a copy of the crystal report however when I refresh the data it never prompts me for parameters and…

I have a parameter field link to the CI_Item for Value Field, I would like to have only the Type 1 item show up in the drom down, what is the best way to manage the parameter field in crystal reports? or can I do something like this?

I have created a Bar code for Inventory Labels, We have MAS200 4.4.08 version, azalea fonts. I have create a label that has a barcode of the Item number and Quantity. The label looks great, however I am having a problem and I not sure what is causing…

Does anyone have suggestions how to launch a crystal report from a stored procedure?

I have a new install of sage 100 ERP that is slow to print any crystal report. All default reports take 20-60 seconds to run. This is a new install of OS, Citrix, Sage. Testing from servers console with no other users in ERP. AV has exclusions for…

I have created a Custom General Ledger Detail By Source Report under the General Ledger Reports. I would like to print the parameters that have been selected on the Report but I do not see under special fields or under the database work table any fields…

Everything works on the script except for the line that calls for the print oRpt.Printout (I tried oRpt.Printout(FALSE) but then nothing happens at all) The line actually technically works, but instead of just printing the the default printer, the…

I am trying to create a report either in crystal or explore that will give back the number of units sold per sku within a specific date range. Anything I create in explore will give details and a summary line but this is too much detail (and rows). I…

Hi. Does SAGE 100 ERP Support Crystal Reports 2008. If it does, how do I upgrade? I want to take advantage of the additional functionality, "Calculated Members" in cross-tab reporting Thanks. -Sol

We just upgraded to Sage 100 ERP from Mas 200 and I got this error this morning. I'm not familiar with it. I've looked through a few areas for help, but haven't found any solution thus far. I'm hopeful that someone has run across this issue before.

Ok, you MAS crystal experts, need a bit of help with this one. Customer has a report that connects to a new System DSN called MAS_KSYNCV45. This DSN uses the MAS 4.0 ODBC as the driver. 1. If I do a test connect in the DSN. I do not get prompted for…

I need to print a two page document with each Sales Order I print. Crystal shortens my document to the size of the page less the size of the page footer. I need the page footer. I have tried to use sup reports, I get the same page footer problem. I have…

I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total. The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount. I don…

When I create a CR that includes customer numbers, how do I only show the one customer number line itself without showing a separate line for that same customer that has a different item code that was ordered? Example:

We recently upgraded a client from 4.4 to 2013. My client can no longer print their Work Order Travelers unless we remove the fields that are using a bar code font. I ran the Code128Tools setup program, but that did not resolve the issue. The report will…