{"id":20651,"date":"2026-08-04T12:03:02","date_gmt":"2026-08-04T12:03:02","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20651"},"modified":"2026-08-20T10:34:36","modified_gmt":"2026-08-20T10:34:36","slug":"how-to-use-the-payment-transaction-window-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-use-the-payment-transaction-window-in-idempiere\/","title":{"rendered":"How to use the Payment Transaction Window in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Payment Transaction window stores a system-generated record of every online payment request iDempiere sends to a card gateway. It captures the gateway response, approval status, and processor used for the transaction.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It gives finance and store teams an audit trail linking each Payment to its gateway outcome, which improves reconciliation, refund tracking, and dispute handling.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"294\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Payment_Transactions.drawio-1024x294.png\" alt=\"\" class=\"wp-image-20654\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Payment_Transactions.drawio-1024x294.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Payment_Transactions.drawio-300x86.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Payment_Transactions.drawio-768x221.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Payment_Transactions.drawio-1536x441.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Payment_Transactions.drawio.png 1922w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Payment Transaction records are created automatically when Process Online runs.<\/li>\n\n\n\n<li>Each record links to exactly one Payment and one Business Partner.<\/li>\n\n\n\n<li>Processed and Approved flags reflect the live gateway response, not manual entry.<\/li>\n\n\n\n<li>Referenced Payment Transaction links a void or credit back to its original approval.<\/li>\n\n\n\n<li>Online Access marks that the record came from a real-time gateway call.<\/li>\n\n\n\n<li>Self-Service identifies transactions submitted from unattended checkout terminals.<\/li>\n\n\n\n<li>Records are historical; edits should be limited to descriptive corrections only.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisites<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Business Partner configured.<\/li>\n\n\n\n<li>Organization and Currency configured.<\/li>\n\n\n\n<li>Tender Type and POS Tender Type configured.<\/li>\n\n\n\n<li>Bank Account configured for the store or till.<\/li>\n\n\n\n<li>Bank Account Processor linked to a Payment Processor.<\/li>\n\n\n\n<li>Payment Processor configured with valid gateway host and merchant credentials.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigation<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"> Menu \u2192 Open Items (Financial Movements and Aging) \u2192 Payment Transaction<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Configuration Steps<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Confirm Processor Setup Before Any Transaction Exists<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open Bank Account Processor and confirm it links to an active Payment Processor with host address, port, and merchant credentials filled in.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Locate the Transaction Record<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Zoom from the related Payment, or search Payment Transaction by Business Partner and Transaction Date to locate the record.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Business Partner<\/td><td>Walk-in Customer<\/td><td>Party the payment was collected from.<\/td><\/tr><tr><td>Transaction Date<\/td><td>14-Jul-26<\/td><td>Date the gateway processed the request.<\/td><\/tr><tr><td>Payment<\/td><td>1000123<\/td><td>Payment record this transaction belongs to.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Review Core Amount and Currency Fields<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check Payment amount, Currency, and Currency Type against the original sale total and store currency setup.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Payment amount<\/td><td>89.99<\/td><td>Amount authorized with the gateway.<\/td><\/tr><tr><td>Currency<\/td><td>USD<\/td><td>Currency used for the gateway request.<\/td><\/tr><tr><td>Tender type<\/td><td>Credit Card<\/td><td>Method used to collect payment.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Verify Processor and Bank Routing Fields<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check Bank Account, Payment Processor, and Partner Bank Account to confirm the correct routing was used for this sale.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Bank Account<\/td><td>Main Store Account<\/td><td>Bank account credited by the gateway.<\/td><\/tr><tr><td>Payment Processor<\/td><td>PP Optimal<\/td><td>Gateway implementation that ran the request.<\/td><\/tr><tr><td>POS Tender Type<\/td><td>Credit Card &#8211; POS<\/td><td>POS-specific tender mapping used at checkout.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Confirm Processed and Approved Status<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check the Processed checkbox to confirm the gateway responded, and review Description for any decline or error detail.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 6: Use Referenced Payment Transaction for Voids and Credits<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When processing a return, set Referenced Payment Transaction to the original approved record before submitting the void or credit.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Transaction shows unapproved<\/td><td>Gateway declined the card or request.<\/td><td>Check Description for the decline reason and retry with a valid card.<\/td><\/tr><tr><td>No Payment Transaction created<\/td><td>Bank Account Processor not matched to the Payment.<\/td><td>Verify Tender Type, Currency, and amount match an active processor.<\/td><\/tr><tr><td>Missing Payment Processor<\/td><td>Bank Account Processor not linked to a processor class.<\/td><td>Assign a Payment Processor in the Bank Account Processor setup.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next Steps<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Configure Bank Account Processor for additional stores or tills.<\/li>\n\n\n\n<li>Review the Payment window for related payment records.<\/li>\n\n\n\n<li>Set up POS Tender Type mappings for new card types.<\/li>\n\n\n\n<li>Confirm Payment Processor credentials with the gateway provider.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Payment Transaction window stores a system-generated record of every online payment request iDempiere sends to a card gateway. It [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-20651","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20651"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20651\/revisions"}],"predecessor-version":[{"id":27995,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20651\/revisions\/27995"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}