Search results for query: *

I need to find the matching SSN/TINS (that appear on two different worksheets) and then compare the 1099 amounts for that SSN/TIN. If the amounts match, do nothing. If the amounts are different, highlight the amounts or put the SSN/TIN and the two different amounts in new columns. Is this...

Using CR v2012 and Sage 50 2015. We used to be able to run reports through a crystal reports viewer within Peachtree (Sage 50). Now, with Sage 50, we must run reports outside of Sage 50 and just connect to the database. We use the OLE DB connection. After we updated the Database Location, we...

Hi: I'm using Crystal Reports 2008 for Peachtree. Sage 50 Premium 2013 and database engine is Pervasive SQL. I created an annual sales report in Crystal Reports. The customer created a new company in Sage 50 Premium 2013 and they want to combine the transactions for both the old and new...

I am using Quantum 2014 and Crystal Reports 2008. Pervasive SQL is the database engine. I created a report to display Available Inventory as of today's date. The user is required to enter the inventory item id's in a parameter and the year in another parameter. My record selection is: If...

I am using Quantum 2013 and Crystal Reports 2008. The database engine is Pervasive SQL. I created a report to display the sales for customers for a specific date range. I need my selection criteria to include all customers whose ID startswith "GC", but doesn't end with "EX" or "EXEMPT". For...

I am using Quantum 2013 by Sage. Pervasive SQL is the database engine and using Crystal 2008. I need to group items on the report by the Item Description. The Item Description has text then a slash "/" and then more text. I want to group on the Item Description for all the text before the...

I am using Sage 50 (Peachmtree) Quantum 2013 with pervasive sql as the database engine with Crystal 2008. I need help with creating a formula to group item id's. If the item id contains a dash "-" then the formula should extract the first 6 characters and create a group when the first 6...

I am using Sage 50 (formerly Peachtree) Quantum 2013, Crystal Reports 2008 and a pervasive database. I created a report to convert the number of units sold to ounces. One field in the inventory item record stores the number of ounces and another field stores the number of units in a case. My...

I am using Sage 50 (formerly Peachtree) Quantum 2013 with Crystal Reports 2008. Sage 50 uses Pervasive SQL as the database. I am creating a report to print shipping labels with the following information: Customer Name Sales Order # Part # I need to print a shipping label for the number of...

Peachtree Quantum 2012 Pervasive SQL Database Crystal Reports 2008 I have a report that lists total quantity of Sales Orders and Purchase Orders by Item ID by month: Item OnHand JAN FEB MAR APR JUN A 3 0 0 98 0 0 Sales Order...

Using Peachtree Premium 2010 with Crystal Reports 2008. Peachtree has a PSQL database. When we open the custom crystal report in Peachtree (using the Crystal Reports viewer) we can display the report but it won't print. We can print the report in Crystal Reports Designer, but not inside...

I am using Crystal Reports 2008 (SP 2) with Peachtree 2010, pervasive SQL database. I created a report to list sales orders. Every time I try to run the report (either from the Crystal Reports Viewer in Peachtree or from Crystal Reports Designer) I get an error: unspecified error. And then...

I'm using Crystal Reports 2008 with Peachtree 2011, a pervasive sql database engine. I created a report to list sales orders and invoices with inventory item information. I want the report to pull open sales orders, closed sales orders or both depending on what the user enters in the sales...

CR 2008, Pervasive SQL on Windows 7 I have an inventory report that displays the inventory items by vendor. I created two groups: Group#1 – Vendor, Group#2-Item I need to get the Inventory Contribution % per Item and per Vendor. Inventory Contribution % per Item = ({@OnHand$$per Item}/{@Total...

I am using Peachtree Quantum 2011 and Crystal Reports v2008. Peachtree uses Pervasive SQL as its database engine. I designed a report to show the items sold. The report is grouped by vendors that supply the item(s). The report also displays the current quantity on hand for the item. If the...

How can I create a formula to show sales amounts for the last 4 quarters? If the fiscal year is Sept. 1 to Aug. 31 and the date is May 25, 2011, I need the report to display: Sales Rep Customer Qtr 1(mar-apr-may 2010) Qtr 2(jun-jul-aug 2010) Qtr 3(Sept Oct Nov 2010) Qtr 4(Dec-jan-feb...

I'm using Peachtree 2011 which uses Pervasive SQL as the database engine and Crystal Reports 2008. I created a report to show the commission for each sales person. I created a formula to calculate the commission: {@Commission} = IF {Employee.Type} = "STR" THEN {@COMMISSIONSTR} ELSE IF...

I'm using Crystal Reports 2008 and Peachtree 2011(Pervasive SQL is the database engine). I am creating a sales commission report. The sales rep has a field for storing the commission category. The categories are STR, SAE and SAP. If the sales rep's commission category is "STR" then there are...

Using Windows 7 Professional on an Aspire laptop. It's a 64 bit machine. Every time I create a crystal report in Crystal v9 or Crystal 2008, the save buttons do not work. I click on the save icon or the File menu and then SAVE or SAVE AS and nothing happens. There are no error messages. The...

Using Peachtree Premium 2010, Crystal Reports 2008 on pervasive SQL database engine. I am trying to create a group based on account numbers. I created the formula: If (InStr({Chart.AccountID} in ["5000" to "5900"])>0) then 1 else if (InStr({Chart.AccountID} in ["6000" to "6399"])>0) THEN 2...