Hi All,
I hope someone can help here. I am wanting to find all unposted transactions linked to PO receipts within a given date range. I work through TR_HIST using the date range for all tr_type = "RCT-PO" and from there I get the PO details and all of the voucher details (if any).
The problem that I am having is that if there is any voucher details, and the voucher has been paid but the transaction hasn't yet been posted to the GL, how do I get to the glt_det record?
The path that I think I need involves finding a trgl_det record using tr_trnbr and tr_type but I can't seem to find this information uniquely (possibly because of trgl_sequence and me not being able to find what the info in this field means). From there I will have the gl_ref number.
Can anyone shed any light on this problem for me? I have a feeling there might be something QAD's Solution Publisher but I can't check that as the PC I am on at work is behind a firewall that denies access
TIA,
James.
I hope someone can help here. I am wanting to find all unposted transactions linked to PO receipts within a given date range. I work through TR_HIST using the date range for all tr_type = "RCT-PO" and from there I get the PO details and all of the voucher details (if any).
The problem that I am having is that if there is any voucher details, and the voucher has been paid but the transaction hasn't yet been posted to the GL, how do I get to the glt_det record?
The path that I think I need involves finding a trgl_det record using tr_trnbr and tr_type but I can't seem to find this information uniquely (possibly because of trgl_sequence and me not being able to find what the info in this field means). From there I will have the gl_ref number.
Can anyone shed any light on this problem for me? I have a feeling there might be something QAD's Solution Publisher but I can't check that as the PC I am on at work is behind a firewall that denies access
TIA,
James.