Sage 100

is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…

First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…

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…

Our customer wants to see the GL Account(s) and the respective dollar(s) for the invoices that appear on the Payment History Report and also to have the report sort by GL account. I haven't had great success using the AP_TransactionPaymentHistory and…

I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…

I am trying to make an excel sheet (ideally a custom report), which shows the amount we invoiced every day, and the amount that was promoted from quote to sales order every day. Grouped bar graphs is what I'm trying to achieve. I figure the easiest…

I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…

Apologies if this is not the correct category. From time to time we receive the following error when attempting to do custom report printing. The temp file is there. The only fix seems to be rebooting the server and deleting the file. Sage 100 will then…

We recently started using the DSD SQL Mirror to speed up reporting and are very pleased so for with the results but I have run into a problem. I am attempting to move the slower reports in SAGE custom report menus over to the mirror and when I attempt…

We have 10 active Company Codes. Each one has a set of core sales reports that are exactly the same except they pull the sales reps, customers & products from the specific company code. Due do performance issues I can't use dynamic parameters in the CR…

I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…

I have pretty limited knowledge/experience with Sage or report writing but I'm currently working on recreating non-modifiable System Report 4-1-3-21 so I can add "account" as a selection criteria. I was able to recreate the calculated fields and I am…

I would like to add some fields to the selections for the SO Customer Sales History report. It has been a while since I've done this and don't remember where to do this. I am looking to add Division, Country, State. Thanks for any help.

Hi, I was trying to write a crystal report, where it would show all PO's open or closed, and allow the user to enter a PO date range and item number and then get detail list of all PO's open or closed for that item that included qty and dollars. it…

I have a custom crystal report to print labels out of MAS. I want to set a different printer as default just for this report. I believe that any custom report should save the printing information from the last time it was printed. But in this case it…

We have a custom Crystal Reports sales order form which prints the bill of materials option category descriptions for each line item - which is pulled from the BM_BillOptionCategory table. In order to grab this information, I need to link the SO_SalesOrderWrk…

We have a large number of custom reports for some of the modules. Is there a way to organize the order in which they show up? They are currently in the order in which they were added. Short of removing the reports and then re-adding them in the order…

I created a custom report and have been trying to add it to the Sales/Custom Reports. I done this on many other reports in our system and have had no problems. In this case I have added the report to the menu, but every time i launch the report it will…

When I have a custom report run, (I am running a report to print labels), I like to have a spot on the selection criteria to tell the report number of pages to print. Can I do this, if so how? Thank you

We have a number of customers who require their item# to print on the invoice and packing slip and I'm running into performance issues when trying to get a customized SO Invoice Print form to work. I've added those customer specific item #s to the IM_AliasItem…

I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files. I want to have it subtotal the quantities of each of the products and then print all items with a negative number on one page and all…

Hello, We are looking for a company that can develop Invoice and Packing slip forms for us using the Crystal Reports 2011 that comes with the Sage ERP 100 Does anyone know of a good company to help with this? Thank you

I am using MAS 90 under Windows 7. I have made copies of several custom reports using the Custom Report Maintenance screen, typing in a new report number, and then using the Copy From button to copy the old report number to the new report number. The…

I am trying to create a profit & loss trend report that compares three or more years. I am using the "Custom Report Maintenance" option in MAS90. Is this possible? Any solutions would be appreciated. Thank you.

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…