Message Boards

How do I find the related Debit Transaction from a Credit Transaction?

thumbnail
Joseph Betts, modified 3 Years ago.

How do I find the related Debit Transaction from a Credit Transaction?

Post Date: 10/1/19 (Bronze, 20 Posts) Recent Posts

Hello,

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,

Kindest Regards,
Joseph 

credit gl finance debit
thumbnail
Shivakumar Patil, modified 6 Years ago.

Re: How do I find the related Debit Transaction from a Credit Transaction?

Post Date: 10/2/19 (Bronze, 24 Posts) Recent Posts

Hi Joseph,

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.

Regards,

Shiva

 

 

Message place holder