Forum Discussion

Jayshamone's avatar
Jayshamone
Helper I
5 years ago
Solved

Multiple Payment Methods in one Transaction

Hello,   we want to give our customers an overview of what they have purchased using their individual voucher code. The basic setup would be this: There is a transactions table connected to a tra...
Need Help
  • Jayshamone's avatar
    Jayshamone
    5 years ago

    I found a solution which gets the correct results, but might be rather inefficent when handling large amount of data.

    Basically, you can use another table including all combinations of payment ID and transaction ID which you can use for filtering. Relate that to the transactions table and leave the rest as it is. This should grant you the correct results.

     

     

    Thanks for your help

    If you have any idea how to manage this more efficiently, I'd be thankful

Devavella's avatar
Devavella
New Member
1 year ago

I had a similar case where I needed to handle split payments. What worked for me was treating each method as a separate line item with the same transaction ID, then grouping by that ID in Power BI. That way I could sum totals correctly without double-counting. For my custom payment flow with Naver Pay, I synced the logic with https://docs.antom.com/ac/antomop/naverpay to keep data consistent.