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. If I link OE invoices to OE detail, OEdetail to OEcreditheaders, OE creditheaders to OEcredit detail what happens is for each detail in an invoice that has a credit note attached gets linked to each detail on the credit note attached. Can anybody help me with the proper links or another solution to get the total quantity? Thank in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
total quantity in OE
- Thread starter ianus
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question