• Replies 4 replies
  • Subscribers 415 subscribers
  • Views 56 views
  • Users 0 members are here
Related

Partial Payments; which GL?

Former Member
Former Member $organization

Hello,

If I have an order with two line items, each assigned to it's own GL#, is there a way to determine/decide which GL the money will be assigned to if a partial payment is made?

Thanks!

Parents
  • $organization

    Hi Michael,

    Good day.

    SELECT     T_ORDER.customer_no, T_SUB_LINEITEM.order_no, T_SUB_LINEITEM.sli_status,T_SLI_DETAIL.due_amt, T_SLI_DETAIL.paid_amt, T_PMAP.gl_hold_no
    FROM       T_ORDER INNER JOIN
    T_SUB_LINEITEM ON T_ORDER.order_no = T_SUB_LINEITEM.order_no INNER JOIN
    T_SLI_DETAIL ON T_SUB_LINEITEM.sli_no = T_SLI_DETAIL.sli_no INNER JOIN
    T_PMAP ON T_SLI_DETAIL.pmap_no = T_PMAP.pmap_no
    WHERE     (T_ORDER.order_no = @yourOrderNumber)

     

    SELECT     T_TRANSACTION.sequence_no, T_TRANSACTION.transaction_no, T_TRANSACTION.ref_no, T_TRANSACTION.trn_dt, T_TRANSACTION.trn_type,
    T_TRANSACTION.trn_amt, T_TRANSACTION.posted_status, T_TRANSACTION.batch_no, T_TRANSACTION.campaign_no, T_TRANSACTION.appeal_no,
    T_TRANSACTION.source_no, T_TRANSACTION.fund_no, T_TRANSACTION.fee_no, T_TRANSACTION.pmap_no, T_TRANSACTION.order_no,
    T_PAYMENT.payment_no, T_PAYMENT.pmt_amt, T_FEE.fee_gl_no, T_FUND.restricted_income_gl_no, T_FUND.nonrestricted_income_gl_no,
    T_FUND.future_rec_gl_no, T_FUND.current_rec_gl_no, T_FUND.written_off_gl_no, T_FUND.constituency, T_PMAP.gl_hold_no
    FROM         T_TRANSACTION INNER JOIN
    T_PAYMENT ON T_TRANSACTION.sequence_no = T_PAYMENT.sequence_no AND
    T_TRANSACTION.transaction_no = T_PAYMENT.transaction_no LEFT OUTER JOIN
    T_FUND ON T_TRANSACTION.fund_no = T_FUND.fund_no LEFT OUTER JOIN
    T_PMAP ON T_TRANSACTION.pmap_no = T_PMAP.pmap_no LEFT OUTER JOIN
    T_FEE ON T_TRANSACTION.fee_no = T_FEE.fee_no
    WHERE     (T_TRANSACTION.order_no = @yourOrderNumber)

    put your order number into @yourOrderNumber, then you will have GL.

     

    have fun

    Ben

Reply
  • $organization

    Hi Michael,

    Good day.

    SELECT     T_ORDER.customer_no, T_SUB_LINEITEM.order_no, T_SUB_LINEITEM.sli_status,T_SLI_DETAIL.due_amt, T_SLI_DETAIL.paid_amt, T_PMAP.gl_hold_no
    FROM       T_ORDER INNER JOIN
    T_SUB_LINEITEM ON T_ORDER.order_no = T_SUB_LINEITEM.order_no INNER JOIN
    T_SLI_DETAIL ON T_SUB_LINEITEM.sli_no = T_SLI_DETAIL.sli_no INNER JOIN
    T_PMAP ON T_SLI_DETAIL.pmap_no = T_PMAP.pmap_no
    WHERE     (T_ORDER.order_no = @yourOrderNumber)

     

    SELECT     T_TRANSACTION.sequence_no, T_TRANSACTION.transaction_no, T_TRANSACTION.ref_no, T_TRANSACTION.trn_dt, T_TRANSACTION.trn_type,
    T_TRANSACTION.trn_amt, T_TRANSACTION.posted_status, T_TRANSACTION.batch_no, T_TRANSACTION.campaign_no, T_TRANSACTION.appeal_no,
    T_TRANSACTION.source_no, T_TRANSACTION.fund_no, T_TRANSACTION.fee_no, T_TRANSACTION.pmap_no, T_TRANSACTION.order_no,
    T_PAYMENT.payment_no, T_PAYMENT.pmt_amt, T_FEE.fee_gl_no, T_FUND.restricted_income_gl_no, T_FUND.nonrestricted_income_gl_no,
    T_FUND.future_rec_gl_no, T_FUND.current_rec_gl_no, T_FUND.written_off_gl_no, T_FUND.constituency, T_PMAP.gl_hold_no
    FROM         T_TRANSACTION INNER JOIN
    T_PAYMENT ON T_TRANSACTION.sequence_no = T_PAYMENT.sequence_no AND
    T_TRANSACTION.transaction_no = T_PAYMENT.transaction_no LEFT OUTER JOIN
    T_FUND ON T_TRANSACTION.fund_no = T_FUND.fund_no LEFT OUTER JOIN
    T_PMAP ON T_TRANSACTION.pmap_no = T_PMAP.pmap_no LEFT OUTER JOIN
    T_FEE ON T_TRANSACTION.fee_no = T_FEE.fee_no
    WHERE     (T_TRANSACTION.order_no = @yourOrderNumber)

    put your order number into @yourOrderNumber, then you will have GL.

     

    have fun

    Ben

Children
No Data