Recent content by ianus

You could set up a User/System DSN in the Windows' ODBC Data Source Administrator (Add a new data source, select the Microsoft Paradox Driver (*.db) for it and specify the default directory). After that you can open the database with DAO and manipulate it as you would manipulate any other...

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

can't post large messages, i'll try a short one

I have a main report that has two parameters a and b. In the report I have inserted two subreports. The first subreport narows down data through two parameters (which are the same as for the main report), the second subreport uses one parameter. I am trying to link the subreports to main report...

I have the following scenario in ACCPAC OE 3.0 . I have to find out the total quantity sold in OE over a period of time and also take into account the credit notes issued against the invoices issued in that period of time. The credit notes detail are in a different table than the invoice detail...