Recent content by Anoli

You did not answer if you ship multiple orders together; I would check if this orders is part of a multiple order shipment to try to explain the discrepancy If you confirm the discrepancy is caused by the order being a secondary order (part of a shipment that covers multiple orders and the...

Do you create shipments from multiple orders? I believe when multiple orders are shipped together using the "From Multiple Orders" checkmark and the resulting shipment is invoiced the OEINVH table will not contain all the order numbers that were shipped together, it will contain only the first...

Hi there: Thank you for your help, I managed to make the macro open its own session and close it at the end. Still have to revise some small issues but you provided me with very useful info. Thanks again.

I have a macro containing a form showing an Accpac UI and when I am logged onto one database works OK, if I am logged in two databases at the same time it shows the Accpac Log-on screen before showing the form/UI and I must create a new session before it continues, otherwise it cannot open the...

I have a question regarding how to add headings to a csv file that I am using through an ODBC link (I built a report on it , to manipulate the data format) Is it possible using only Crystal? If not, what would be the VBA code necessary to add the headings to the file? Thank you very much

I am new at working with variables and I have a question. I have inserted a subreport in a report, in the subreport I declared a shared variable, that picks up the value of a filed (report to sub links are one on one). I bring the value of the variable in the main report in a formula. The...

You can use a subreport.

it seems when you created the database you put the oldest fiscal year only 1999, that is why it is failing on converting older documents. Try to crete 1998, 1997 etc in the fiscal year calendar.

Hi there: Thank you for your replies. I was using Crystal 6.0 but uponmoving to ver 7 I was able to use the running totals formulas adding only the first record in the group, the way kenhamady suggested. Thanks for your help.

Also I tried a different approach: I created a field that is 1 if the record detail is the first one (or the only one)in an invoice and zero otherwise. I multiply this field with the receipts amount and I get a new formula field that is equal to the receipt amount for every first detail in the...

I have done a report in which I linked OE history detail (I need to report payments by item category) to AR receipt. There are invoices that do not have a payment attached and also because an invoice has more than one detail line I want the payment amount to be added into an accumulator only...

I have a variable in the subreport and I would like to pass the value to a formula in the subreport. Is it possible? I am new to Crystal and I would appreciate any suggestions.

I am new to Crystal and I have a question re: grouping. Say I have a report based on one table and in the detail area I have customer number, invoice number, invoice amount, Salesperson1, Salesperson2. Sometimes a specific salesperson in in Salesperson1 or Salesperson2 filed. I would like for...