Dynamics Community Forum Thread Details

SQL querry

Hi everyone,

*Expert advise please*

Whenever I am putting SQL query. It is picking up only Invoice data only which is AP. However, I need the data from GL (Manual jornals) and AR (negative data) as well.

Following is the query I am using.

SELECT aualtran.trn_num, aualtran.des_acc, aualtran.pst_per, aualtran.trn_cde, aualtran.src_acc, av_ap_creditor_details.CreditorName, aualtran.trn_ref, aualtran.act_val, aualtdes.trn_dsc, aupcacct.acc_lv1, aupcacct.acc_lv2, aupcacct.acc_lv3, aupcacct.acc_lv4, aupcbals.bgt_p12
FROM authlive.dbo.aualtdes aualtdes, authlive.dbo.aualtran aualtran, authlive.dbo.aupcacct aupcacct, authlive.dbo.aupcbals aupcbals, authlive.dbo.av_ap_creditor_details av_ap_creditor_details
WHERE aualtran.src_acc = av_ap_creditor_details.CreditorFormattedAccount AND aualtran.trn_num = aualtdes.trn_num AND aualtran.des_acc = aupcacct.lgr_acc AND aupcacct.lgr_acc = aupcbals.lgr_acc AND ((aualtdes.trn_lin=0) AND (aualtdes.seq_num=0) AND (aualtran.pst_yer=2023) AND (aupcbals.pst_yer=2023) AND (aualtran.src_mdu='AP') AND (aualtran.des_acc Like '%.4384.0568'))
ORDER BY aualtran.trn_ref

Just wondering if anybody can help.

Thanks.

Quick Links