{"id":20812,"date":"2026-08-04T12:03:04","date_gmt":"2026-08-04T12:03:04","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20812"},"modified":"2026-08-20T08:45:01","modified_gmt":"2026-08-20T08:45:01","slug":"how-to-use-online-transaction-history-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-use-online-transaction-history-in-idempiere\/","title":{"rendered":"How to use Online Transaction History in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Online Transaction History is the audit log window in iDempiere that records every response returned by a card payment gateway after a Process Online action on a Payment.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each record links back to the originating Payment Transaction, giving finance and support teams a reliable trail for reconciliation, dispute handling, and gateway troubleshooting.<\/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=\"383\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Online_Transaction_History-1024x383.png\" alt=\"\" class=\"wp-image-20813\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Online_Transaction_History-1024x383.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Online_Transaction_History-300x112.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Online_Transaction_History-768x287.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Online_Transaction_History.png 1503w\" 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>Active records reflect valid, retained gateway response entries for a transaction.<\/li>\n\n\n\n<li>Each history record is linked to one Table and Record ID, typically Payment Transaction.<\/li>\n\n\n\n<li>Text Message stores the raw gateway response, success or failure detail.<\/li>\n\n\n\n<li>Error is checked automatically when the gateway declines or fails a transaction.<\/li>\n\n\n\n<li>Processed is set once iDempiere finishes writing the transaction outcome.<\/li>\n\n\n\n<li>History records are created automatically; users do not enter them manually.<\/li>\n\n\n\n<li>Every Process Online attempt generates a corresponding transaction history entry.<\/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>Bank Account Processor configured and linked to the store&#8217;s bank account.<\/li>\n\n\n\n<li>Payment Processor configured with a valid gateway class and host address.<\/li>\n\n\n\n<li>Business Partner and Payment record created for the sale, refund, or void.<\/li>\n\n\n\n<li>Credit card or tender details captured on the Payment window.<\/li>\n\n\n\n<li>Organization and Tenant (Client) set up for the retail store location.<\/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\"><strong>Menu \u2192 Payment Processor \u2192 Online Transaction History<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Opening the window shows a list of history records. Each row displays the Tenant, Organization, linked Table, Record ID, and Processed\/Error flags, with Text Message holding the gateway detail.<\/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 Payment Processor Setup Is Complete<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open Payment Processor, verify Pay Processor Class and host details are filled in, then confirm the Bank Account Processor links this processor to the store&#8217;s bank account.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Process a Payment Online<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open the Payment window, enter card details, and click Process Online. iDempiere sends the request to the gateway and generates the history record automatically.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Open the Online Transaction History Window<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Navigate to Payment Processor \u2192 Online Transaction History, then locate the newest record using Created date or the Record ID from the Payment Transaction.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Field Reference Table<\/strong><\/h3>\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>Tenant<\/td><td>GardenWorld Retail<\/td><td>Client that owns the transaction record.<\/td><\/tr><tr><td>Organization<\/td><td>Downtown Store<\/td><td>Store or branch where the payment occurred.<\/td><\/tr><tr><td>Created<\/td><td>14\/07\/2026 10:42<\/td><td>Date and time the history record was generated.<\/td><\/tr><tr><td>Table<\/td><td>C_PaymentTransaction<\/td><td>Reference table the record is linked to.<\/td><\/tr><tr><td>Record ID<\/td><td>1000123<\/td><td>ID of the linked Payment Transaction record.<\/td><\/tr><tr><td>Active<\/td><td>Checked<\/td><td>Marks the history record as valid and retained.<\/td><\/tr><tr><td>Text Message<\/td><td>Approved \u2013 Auth Code 445extra<\/td><td>Raw gateway response returned for the transaction.<\/td><\/tr><tr><td>Error<\/td><td>Unchecked<\/td><td>Indicates the gateway declined or failed the request.<\/td><\/tr><tr><td>Processed<\/td><td>Checked<\/td><td>Confirms iDempiere finished recording the outcome.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Review Error and Processed Flags<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If Error is checked, read the Text Message for the decline reason. If Processed is unchecked, treat the payment as incomplete and re-verify with the gateway before retrying.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Cross-check with Payment Transaction and Payment<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Use the Record ID to open the matching Payment Transaction, then trace it to the originating Payment for amount, business partner, and tender details.<\/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>No history record after Process Online<\/td><td>Bank Account Processor or Payment Processor not found for the tender type<\/td><td>Verify processor configuration matches currency, tender type, and amount used<\/td><\/tr><tr><td>Error checked but Text Message is blank<\/td><td>Gateway response fields were not mapped by the processor implementation<\/td><td>Check the payment processor class handling and gateway integration logs<\/td><\/tr><tr><td>Duplicate history records for one payment<\/td><td>Process Online was triggered more than once for the same transaction<\/td><td>Confirm Payment isApproved or isVoided status before reprocessing<\/td><\/tr><tr><td>Record ID does not match expected Payment Transaction<\/td><td>Table reference points to a different AD_Table_ID than expected<\/td><td>Confirm the processor is writing to C_PaymentTransaction consistently<\/td><\/tr><tr><td>Processed stays unchecked after a successful sale<\/td><td>Gateway response evaluation did not complete before saving<\/td><td>Re-run Process Online and check gateway connectivity and timeout settings<\/td><\/tr><tr><td>Text Message shows generic error only<\/td><td>Processor did not capture Authorization Code or Reference fields<\/td><td>Review processor mapping of R_AuthCode, R_PnRef, and R_RespMsg fields<\/td><\/tr><tr><td>Users cannot find related payment quickly<\/td><td>Record ID requires manual lookup with no direct zoom<\/td><td>Train staff to search Payment Transaction by ID from this window<\/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 or review Bank Account Processor settings.<\/li>\n\n\n\n<li>Configure or review Payment Processor gateway class and credentials.<\/li>\n\n\n\n<li>Review Payment Transaction records for full transaction snapshots.<\/li>\n\n\n\n<li>Check Payment window for the originating sale, refund, or void.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Online Transaction History is the audit log window in iDempiere that records every response returned by a card payment gateway [&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-20812","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\/20812","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=20812"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20812\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}