Search results for query: *

CR 8.5 My report looks like this: CustomerID Period1 period2 period3 Group IDCUST Details: IDCUST netsales1 netsales2 netsales 3 netsales is a formula containing the sum of running totals for invoices and credit notes that meet conditons. The detail section...

Thanks lbass. That works. dgillz, the report was more complex than that. But thanks for the input.

Hi all, I am using Crystal 11. This report uses an ODBC connection to Pervasive sql tables. In detail section A: I have running totals summing invoices for each month that meet a certain condition. In detail section B: I have running totals summing credit notes for each month that meet a...

In column A you could make the account range references like this: 4000:4000. Under the different divisions use =FRAMTA("BALP",""," ( ACCTFMTTD LIKE ""%-%-division"" ) ") substitute division for the segment code. You might have to hard code account descriptions.

What happens when you print to the screen or printer? Do you get multiple copies of the same invoice also? Which of the invoice specs are you using? Is it customized or did you convert it from a previous version?

I know that you can run an Accpac report through crystal that is based on a sql stored procedure. You could probably test your objective by creating such a report in crystal then record a macro from the Accpac desktop that calls it.

Virtual Server is also an option.

Check that at the time of invoice entry a different term code was not applied, like COD.

There is always the possibility that a few issues may arise that you will have to troubleshoot. Best approach is to do a test upgrade first on a non production PC. Then research any issues that arise.

Put the System Manager CD in and follow the process of installing, but choose to install only the sample data. Leave all other check boxes blank.

There is no such option. Apart from creating vendors you can only use misc. payments. If you are on ver. 5.3 you can use optional fields to track the refund payments.

You shouldn't have to do a dummy check. Use the PO number when doing the prepayment. When purchasing dept. posts the invoice in PO, and it then gets gets posted in AP, it will automatically be applied to the invoice as well.

Yep. Thanks Bro that approach worked. Will have to work on understanding why it had to be done like that though, I was simply doing #RT1 + #RT2. Thanks.

Hi guys: The detail section of invoices in my Accpac database looks like this: Inv#001 Detail Type Item# Amt Item Prod1 100 Miscellaneous Freight 20 Miscellaneous Other 10 Miscellaneous Deposit -50 Values in the Amt. field are stored in the field...