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…

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 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…

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…

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…

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…

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…

Is there any easy way to remove Custom Reports from the Custom Reports Menu? I found this on the Knowledgebase, however, it is not for Version 2013. https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Sage%20MAS%2090%20and%20200/Gated%20Customers…