|
If you sum on date & check # you get a virtually fool proof system (its what we do on statements). Mark Curtis IT Director Hafele U.K. Limited > -----Original Message----- > From: owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com]On > Behalf Of Rindi Wheeler > Sent: Tuesday, March 23, 1999 1:51 PM > To: BPCS-L@midrange.com > Subject: Re: ACR - Payment details > > > Unfortunately you cannot get the original payment amount. If > they're putting the check # in the reference field you could > sum each RAR with the same reference, but it's dependant upon > them following the process. > > Rindi Wheeler > Director of Enterprise Systems > (214) 589-8315 > Rindi.Wheeler@trin.net > > >>> dharmara <dharmara@bom5.vsnl.net.in> 03/22 9:04 PM >>> > Hi > > My client wishes to create a Customer statement of accounts, > which would contain all the invoices, credit notes , debit notes > & payments received from customer. This statement should reflect > the original payments made by customer & not the allocated > amounts. I was able to get the details of invoice, debit & > credit memos from RAR file, but the payments, in case they are > auto allocated to invoices or adjusted against invoices or Cr. > Memos are displayed with record ID RP and are written against > every original document number of invoice, but I could not locate > the original payment amount (unallocated one) > > Are there any other files other than RAR from where I could pick > the payment amounts (unallocated one) > > Nari > > +--- > | This is the BPCS Users Mailing List! > | To submit a new message, send your mail to BPCS-L@midrange.com. > | To subscribe to this list send email to BPCS-L-SUB@midrange.com. > | To unsubscribe from this list send email to > BPCS-L-UNSUB@midrange.com. > | Questions should be directed to the list owner: dasmussen@aol.com > +--- > > +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.