In QAD General Ledgers, How do I find the corresponding Debit Transaction from the Credit Transactions?
I have been looking in the "CInvoice" table and we have a PO number (populated in CInvoicePONbr) for a credit record but not for any debit records.
I have also been checking cInvoiceCIText field and again, it populates the invoice number for credits, but for debits, it appears to show a different description.
I hope this makes sense,
If you check the supplier invoice view, you would see SI posting and
Matching Posting for any supplier invoice, Both these postings would
have different daybooks and invoice number.
These postings will have both DEBIT and CREDIT transactions.
Technicially speaking supplier invoice transactons are stored in this
sequence. CInvoice -> CInvoicePosting -> Posting -> PostingLine.