Getting from Payment to Invoice

petevans

We are restoring data for a customer after a crash, and would like to make a dataport to import info into the Cash Receipt Journal. So starting from Detailed Customer Ledger, most of the info is there.

The problem is the "Applies-to Doc. No." field in the journal.

For many posts in the Detailed Customer Ledger I can find the Invoice number in the Document No. field. However, for posts of type Payment, this field does not contain an invoice number.

So my question is this: How can I find out which invoice a payment applies to?

KYDutchie

Hi,

Look at the code in the trigger "FindApplnEntriesDtldtLedgEntry" in form 61 Applied Customer Entries.
This form will show you how payments were applied to invoices.

hopes this helps,

Regards,

Willy

petevans

That code seemed a bit weird to me, but it got me started and attracted my attention to the field Initial Document Type. Detailed CLE posts with "Invoice" here have a corresponding (non-detailed) CLE with the invoice document no.

Thanks Willy! :thumbsup: