how to get the invoice number of marked transaction in the settlement of payment journal

hi everyone, i’m currently doing a Manager’s Check Form[Report], and i need to get the invoice number of ever mark transaction under settlement in the the payment journal of Account Payable module…i used to get the invoice number when the settled amount have withholding tax because it is the same invoice number with the vendtrans table. however when the settled amount has no withholding tax i need to get the invoice number from the vendtrans table…

i dont know to join the spectrans and vendtransopen to vendtrans and ledgerjournaltrans table.

i tried joining ledgerjournaltrans and vendtrans but i think it’s not enough to the the two table only.

I hope anyone could help me…thank you in advance…^.^

Hi,

I have a same query…

Please help me for the same

Thanks

Darshana

Please do post your problem as a separate query…

Hi ,

did you get the right query?
i have same problem here…

please share it…

tnx

dynamicsuser.net/…/89886