E10.1.500.10
We are trying to find the database field where the Ref Invoice value is stored for a credit memo. This value is the original invoice to which the credit memo relates. For example, assume we have invoice 123 and issue credit memo 456 against it. 456 is also an invoice number but the “invoice” has a CM suffix so we know it’s actually a credit memo. The 123 value is entered in the Ref Invoice field. We want to be able to return 123 in the credit memo record on the customer statement (and in a BAQ).
In the Field Help, there is no actual DB Field. There is an EpiBinding of InvcHead.DspInvoiceRef. I assume there is a linking table somewhere that relates invoices and credit memos, but I can’t find it based on a quick scan of the Product (erp) tables and their descriptions.
Any thoughts on how to locate this value?
Thanks.