Sage 100

In most accounting software programs, when you create a document, you are able to click on any line to drill down. I do not see such an ability with Sage 100. What am I missing?

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…

Hi, My client wants to filter the transaction date range within a specific statement date on AR Statement Printing Report. I tried to filter the date range using 'select expert' which set the between from to transaction parameter. If I press F5…

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…

Please forgive me if already answered somewhere, but I could not find it. Sage 100C - I need to print a list of all jobs from 2015 - present. Just need the Job Number, Job Name, Job Address. This should be so simple, but I was not able to find…

Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…

Hello, We went live with a new project yesterday and are having some issues. I spoke with support, but because we have so many modifications they said they were unable to help. I found the two below entries in the activity log that I believe may be…

When running the standard Monthly Sales Report in the Accounts Receivable module, under Options, the screen only shows the oldest accounting period in our database. Shouldn't users be able to pull down a menu and choose any individual month or range of…

Is there a way with Crystal Reports to string together 3 different sales order form codes to print at once? either for a single order of for multiple orders?

What are the differences between 'Time Created' and 'Time Updated' fields in the invoice history? Assuming they are my local times and that it is based on a 24 hour clock with decimals as fractions of the hour (e.g. 15.5 = 3:30 PM)?

I want to pull the raw data behind Inventory Valuation by Period report into excel so that i can run a pivot table off of it. I want to be able to format according to my needs but also refresh it as we close each month to see the trends. I was trying…

We have one user for whom every time they go to print any form, the Template Selection dialog pops up so she has to select 'Preprinted,' 'Plain,' 'Marbled,' &c., before proceeding to the main form printing screen. This has only been happening since our…

Hello New to Sage. Creating a Job Cost report. I want to key the listing on JC_JobBillingHistory to pull all the open and closed records. Using JC_Job for Open and JC_JobBilling for Closed. I can't get both of the tables to link to key table. It will…

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've printed paperless office financial Reports. Now when I go to the Report Viewer, I only see the documents with "All documents" selected. I was expecting to filter on "GL Financial Report" to see them. However, when I filter on "GL Financial Reports…

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…

I want to create a calculated field (say Gross Margin) in the Item View Explorer. Calculation would be (Standard Price- Last cost)/Last Cost. However there are several items that do not have a last cost yet because there has not been any inventory produced…

Hello I am new to SAGE and I am trying to find a report that will show me individual credit card transactions that were entered during a specific period. I can't seem to find anything, help is appreciated.