Need help to extract data from A/P

[mlbechard]

I have to extract data for tax review. Here are the information requested:

Accounts Payable Detail File
(1) Supplier or Vendor Name
(2) Supplier or Vendor Number
(3) Batch, Voucher, Document, Posting or Transaction Number (all where applicable)
(4) Invoice Number
(5) Invoice Date
(6) Invoice Amount
(7) G/L Distribution of Invoice Amount by G/L Account, specifically identifying the amounts being allocated to GST/HST and QST, if applicable.

So far, I have found the following:
(1) Vendor number:
cicmpy.crdcode --> link between gbkmut and cicmpy on gbk.crdnr = cmp.crdnr AND cmp.crdnr IS NOT NULL AND gbk.debnr IS NULL
(2) Vendor name:
cicmpy.cmp_name --> same as Vendor Number
(3) Transaction Number:
gbkmut.TransactionNumber
(4) Invoice Number:
gbkmut.faktuurnr or gbkmut.docnumber --> I am not 100% sure which one is the good one
(5) Invoice Date:
gbkmut.docdate
(6) Invoice Amount:
gbkmut.bdr_val

I am missing the following:
(3) Batch, Voucher Document and Posting Number
(7) all of it

Can someone help me on this please?

Your help is appreciated.

Thanks

 

[jbelk11]

Hi mlbechard....

Have a look at the BankTransactions table.

Everything associated with invoices and payments (vendors and customers) is located in that table.

Jen