john_i
09-15-2003, 04:27 PM
I'm trying to do an analysis of how many days after invoicing each customer pays on average.
I can go to the Jrnl, and find the cash receipts (JrnlRow.Journal=1), and the date the cash was received; or the sale and how much was paid against it (JrnlRow.Journal=3) -- JrnlRow.AmountPaid... but for the life of me I can't figure out if there's a link between the receipt and the sale, other than the amount, because the cash receipt row doesn't include the invoice number. I've tried linking the cash receipts to the InvHeader, but am still not seeing the Invoice #
Has anyone else addressed this question?
I can go to the Jrnl, and find the cash receipts (JrnlRow.Journal=1), and the date the cash was received; or the sale and how much was paid against it (JrnlRow.Journal=3) -- JrnlRow.AmountPaid... but for the life of me I can't figure out if there's a link between the receipt and the sale, other than the amount, because the cash receipt row doesn't include the invoice number. I've tried linking the cash receipts to the InvHeader, but am still not seeing the Invoice #
Has anyone else addressed this question?