{"id":486,"date":"2021-05-05T18:19:46","date_gmt":"2021-05-05T10:19:46","guid":{"rendered":"https:\/\/www.linyinghao.cn\/wordpress\/?p=486"},"modified":"2022-02-07T15:19:09","modified_gmt":"2022-02-07T07:19:09","slug":"oracle-financial-cloud-configuration-accounting-hub-fah","status":"publish","type":"post","link":"https:\/\/www.linyinghao.cn\/wordpress\/?p=486","title":{"rendered":"Oracle Financial Cloud Configuration \u2013 Accounting Hub (FAH)"},"content":{"rendered":"\n<p>Following configuration is based on the assumption that GL configuration has been completed.<\/p>\n\n\n\n<p>Following sequence is recommended by Oracle to setup accounting method and rules after source system is registered.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-7.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"286\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-7-1024x286.png\" alt=\"\" class=\"wp-image-497\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-7-1024x286.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-7-300x84.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-7-768x215.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-7.png 1112w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_74 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Register_Source_System\" >Register Source System<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Configure_Accounting_Rules\" >Configure Accounting Rules<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Create_Mapping_Set\" >Create Mapping Set<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Create_Account_Rule\" >Create Account Rule<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Create_User-Defined_Formula\" >Create User-Defined Formula<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Create_Description_Rule\" >Create Description Rule<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Create_Supporting_Reference\" >Create Supporting Reference<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Create_Journal_Line_Rule\" >Create Journal Line Rule<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Create_Subledger_Journal_Entry_Rule_Set\" >Create Subledger Journal Entry Rule Set<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Create_Subledger_Accounting_Method\" >Create Subledger Accounting Method<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Assign_Subledger_Accounting_Method_to_GL_Ledger\" >Assign Subledger Accounting Method to GL Ledger<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Upload_Transaction_Data_from_Spreadsheet\" >Upload Transaction Data from Spreadsheet<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Download_FAH_transaction_data_template\" >Download FAH transaction data template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Edit_transaction_date\" >Edit transaction date<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Upload_Transaction_Data\" >Upload Transaction Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=486\/#Submit_Import_Accounting_Transaction_Process\" >Submit Import Accounting Transaction Process<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"register-source-system\"><span class=\"ez-toc-section\" id=\"Register_Source_System\"><\/span>Register Source System<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Download rapid implementation spreadsheet<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"443\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-1024x443.png\" alt=\"\" class=\"wp-image-487\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-1024x443.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-300x130.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-768x332.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image.png 1413w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"501\" height=\"309\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-1.png\" alt=\"\" class=\"wp-image-488\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-1.png 501w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-1-300x185.png 300w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><\/a><\/figure>\n\n\n\n<p>Generate zip using spreadsheet<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"551\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-2.png\" alt=\"\" class=\"wp-image-489\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-2.png 735w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-2-300x225.png 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/a><\/figure>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-8ce52b54-3708-4bd1-b053-a88ded2a8170\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/XlaSourceSystemSetup06.zip\">XlaSourceSystemSetup06<\/a><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/XlaSourceSystemSetup06.zip\" class=\"wp-block-file__button\" download aria-describedby=\"wp-block-file--media-8ce52b54-3708-4bd1-b053-a88ded2a8170\">\u4e0b\u8f7d<\/a><\/div>\n\n\n\n<p>Upload the zip file<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"453\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-3.png\" alt=\"\" class=\"wp-image-492\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-3.png 512w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-3-300x265.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><\/figure>\n\n\n\n<p>Verify and confirm source system is created<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"431\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-4.png\" alt=\"\" class=\"wp-image-493\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-4.png 624w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-4-300x207.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"489\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-5-1024x489.png\" alt=\"\" class=\"wp-image-494\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-5-1024x489.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-5-300x143.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-5-768x367.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-5.png 1359w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-6.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"463\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-6-1024x463.png\" alt=\"\" class=\"wp-image-495\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-6-1024x463.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-6-300x136.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-6-768x347.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-6-1536x695.png 1536w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-6.png 1895w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"configure-accounting-rules\"><span class=\"ez-toc-section\" id=\"Configure_Accounting_Rules\"><\/span>Configure Accounting Rules<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Accounting rules are attached to accounting method, which is in turn attached to primary or secondary ledger.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-10.png\"><img loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"302\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-10.png\" alt=\"\" class=\"wp-image-504\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-10.png 470w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-10-300x193.png 300w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/a><\/figure>\n\n\n\n<p>To access accounting rules, use following navigation:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"489\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-8-1024x489.png\" alt=\"\" class=\"wp-image-498\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-8-1024x489.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-8-300x143.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-8-768x367.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-8.png 1330w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-mapping-set\"><span class=\"ez-toc-section\" id=\"Create_Mapping_Set\"><\/span>Create Mapping Set<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Mapping set is used to derive single segment value, or even account combination values from source transaction or reference attribute values. Up to <strong>10<\/strong> transaction or reference attributes can be used as input to a mapping.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-11.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-11.png\" alt=\"\" class=\"wp-image-506\" width=\"580\" height=\"401\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-11.png 764w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-11-300x208.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-9.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"317\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-9-1024x317.png\" alt=\"\" class=\"wp-image-500\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-9-1024x317.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-9-300x93.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-9-768x238.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-9.png 1266w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-13.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"497\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-13-1024x497.png\" alt=\"\" class=\"wp-image-509\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-13-1024x497.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-13-300x146.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-13-768x373.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-13-1536x745.png 1536w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-13.png 1888w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-account-rule\"><span class=\"ez-toc-section\" id=\"Create_Account_Rule\"><\/span>Create Account Rule<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Account rules derive the accounts for the journal lines. At least one account for debit and one account for credit is required. Account run can either use or not use mapping set.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-14.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-14-1024x332.png\" alt=\"\" class=\"wp-image-512\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-14-1024x332.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-14-300x97.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-14-768x249.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-14.png 1290w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Create one rule to derive account segment value from mapping set created in previous step, in case Refinance Type is None.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-15.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"478\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-15-1024x478.png\" alt=\"\" class=\"wp-image-513\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-15-1024x478.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-15-300x140.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-15-768x359.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-15-1536x717.png 1536w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-15.png 1868w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Create another rule to derive account combination value for receivable account.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-16.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"462\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-16-1024x462.png\" alt=\"\" class=\"wp-image-514\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-16-1024x462.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-16-300x135.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-16-768x346.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-16-1536x693.png 1536w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-16.png 1883w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Create one more rule to derive account combination value for cash account.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-17.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"454\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-17-1024x454.png\" alt=\"\" class=\"wp-image-515\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-17-1024x454.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-17-300x133.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-17-768x341.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-17-1536x682.png 1536w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/04\/image-17.png 1661w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-user-defined-formula\"><span class=\"ez-toc-section\" id=\"Create_User-Defined_Formula\"><\/span>Create User-Defined Formula<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"446\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-1-1024x446.png\" alt=\"\" class=\"wp-image-520\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-1-1024x446.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-1-300x131.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-1-768x334.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-1.png 1435w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-description-rule\"><span class=\"ez-toc-section\" id=\"Create_Description_Rule\"><\/span>Create Description Rule<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"362\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-2-1024x362.png\" alt=\"\" class=\"wp-image-521\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-2-1024x362.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-2-300x106.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-2-768x272.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-2.png 1434w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"549\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-3-1024x549.png\" alt=\"\" class=\"wp-image-522\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-3-1024x549.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-3-300x161.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-3-768x411.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-3.png 1411w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"333\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-4-1024x333.png\" alt=\"\" class=\"wp-image-523\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-4-1024x333.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-4-300x98.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-4-768x250.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-4.png 1406w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-supporting-reference\"><span class=\"ez-toc-section\" id=\"Create_Supporting_Reference\"><\/span>Create Supporting Reference<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"374\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-5-1024x374.png\" alt=\"\" class=\"wp-image-524\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-5-1024x374.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-5-300x109.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-5-768x280.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-5.png 1414w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"136\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-7-1024x136.png\" alt=\"\" class=\"wp-image-526\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-7-1024x136.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-7-300x40.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-7-768x102.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-7.png 1388w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>There is another <a href=\"https:\/\/www.linyinghao.cn\/wordpress\/?p=561\">article <\/a>describes how to get supporting reference values in SQL query for BIP report.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-journal-line-rule\"><span class=\"ez-toc-section\" id=\"Create_Journal_Line_Rule\"><\/span>Create Journal Line Rule<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"329\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-8-1024x329.png\" alt=\"\" class=\"wp-image-527\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-8-1024x329.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-8-300x96.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-8-768x247.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-8.png 1431w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-9.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"442\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-9-1024x442.png\" alt=\"\" class=\"wp-image-528\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-9-1024x442.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-9-300x129.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-9-768x332.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-9.png 1434w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-10.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"448\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-10-1024x448.png\" alt=\"\" class=\"wp-image-529\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-10-1024x448.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-10-300x131.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-10-768x336.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-10.png 1429w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-subledger-journal-entry-rule-set\"><span class=\"ez-toc-section\" id=\"Create_Subledger_Journal_Entry_Rule_Set\"><\/span>Create Subledger Journal Entry Rule Set<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This step combines 4 configurations setup by previous steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Journal line rules &#8211; this derives DR\/CR lines <\/li><li>Account rules &#8211; this derives accounting segments<\/li><li>Description rules &#8211; this derives line and header description<\/li><li>Supporting reference &#8211; this derives supporting references<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-11.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"305\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-11-1024x305.png\" alt=\"\" class=\"wp-image-531\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-11-1024x305.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-11-300x89.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-11-768x229.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-11.png 1434w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-13.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"537\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-13-1024x537.png\" alt=\"\" class=\"wp-image-533\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-13-1024x537.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-13-300x157.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-13-768x403.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-13.png 1416w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Line 1 Setup<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-14.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"294\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-14-1024x294.png\" alt=\"\" class=\"wp-image-534\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-14-1024x294.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-14-300x86.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-14-768x221.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-14.png 1407w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Line 2 setup with description and supporting reference<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-subledger-accounting-method\"><span class=\"ez-toc-section\" id=\"Create_Subledger_Accounting_Method\"><\/span>Create Subledger Accounting Method<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-15.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"337\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-15-1024x337.png\" alt=\"\" class=\"wp-image-535\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-15-1024x337.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-15-300x99.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-15-768x253.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-15.png 1414w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-16.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"492\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-16-1024x492.png\" alt=\"\" class=\"wp-image-536\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-16-1024x492.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-16-300x144.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-16-768x369.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-16.png 1431w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"assign-subledger-accounting-method-to-gl-ledger\"><span class=\"ez-toc-section\" id=\"Assign_Subledger_Accounting_Method_to_GL_Ledger\"><\/span>Assign Subledger Accounting Method to GL Ledger<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-17.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"289\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-17-1024x289.png\" alt=\"\" class=\"wp-image-539\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-17-1024x289.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-17-300x85.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-17-768x217.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-17.png 1426w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-18.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"393\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-18-1024x393.png\" alt=\"\" class=\"wp-image-540\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-18-1024x393.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-18-300x115.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-18-768x295.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-18.png 1416w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"upload-transaction-data-from-spreadsheet\"><span class=\"ez-toc-section\" id=\"Upload_Transaction_Data_from_Spreadsheet\"><\/span>Upload Transaction Data from Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"download-fah-transaction-data-template\"><span class=\"ez-toc-section\" id=\"Download_FAH_transaction_data_template\"><\/span>Download FAH transaction data template<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>FAH transaction data template can be obtained from following navigation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-19.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"446\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-19-1024x446.png\" alt=\"\" class=\"wp-image-542\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-19-1024x446.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-19-300x131.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-19-768x335.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-19.png 1434w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-20.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"340\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-20-1024x340.png\" alt=\"\" class=\"wp-image-543\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-20-1024x340.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-20-300x100.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-20-768x255.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-20.png 1429w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"edit-transaction-date\"><span class=\"ez-toc-section\" id=\"Edit_transaction_date\"><\/span>Edit transaction date<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>FAH transaction data is a zip file containing 3 sub files<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Metadata_08PER_LOAN_MORG.txt<\/li><li>XlaTrxH.csv<\/li><li>XlaTrxL.csv<\/li><\/ol>\n\n\n\n<p>Metadata file inclusing the metadata information of specified subledger application. Normally it doesn&#8217;t need modification.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Metadata version number : 1\nZIP Version number : 1\nCreation date : 2021-04-28 03:21:47.0\nApplication Short Name : 08PER_LOAN_MORG\nDate format : yyyy-MM-dd\nTransaction Headers file : XlaTrxH.csv\nTransaction Lines file : XlaTrxL.csv<\/code><\/pre>\n\n\n\n<p>XlaTrxH.csv contains subledger journal header data<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-21.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"68\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-21-1024x68.png\" alt=\"\" class=\"wp-image-544\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-21-1024x68.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-21-300x20.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-21-768x51.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-21.png 1412w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>TRANSACTION_TYPE,LEDGER_NAME,TRANSACTION_DATE,TRANSACTION_NUMBER,LOAN_SCHEDULED_PAYMENT_DATE,LOAN_MATURITY_DATE,LOAN_TYPE,LOAN_AMOUNT,LOAN_ORIGINATION_DATE,MORTGATE_OWNER,CUSTOMER_NUMBER,LOAN_NUMBER,LOAN_OFFICER,REFINANCE_TYPE\nLOAN_ORIGINATION,08Ledger US,2021-04-30,CL-001,2021-05-31,2021-04-30,Fixed Rate,100000,2021-01-01,Kimberly,1002,101,John Nile,None\nLOAN_ORIGINATION,08Ledger US,2021-04-30,CL-002,2021-05-31,2021-04-30,Adjustable Rate,300000,2021-01-01,Douglas,1003,106,John Nile,None\nLOAN_ORIGINATION,08Ledger US,2021-04-30,CL-003,2021-05-31,2021-04-30,Fixed Rate,150000,2021-01-01,Nancy,1008,109,Patric Lee,None\n<\/code><\/pre>\n\n\n\n<p>XlaTrxL.csv contains subledger journal line data<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-22.png\"><img loading=\"lazy\" decoding=\"async\" width=\"636\" height=\"106\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-22.png\" alt=\"\" class=\"wp-image-545\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-22.png 636w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-22-300x50.png 300w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><\/a><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>TRANSACTION_NUMBER,DEFAULT_AMOUNT,DEFAULT_CURRENCY,LOAN_RATE08\nCL-001,100000,USD,3.5\nCL-002,300000,USD,3.25\nCL-003,150000,USD,3.875\n<\/code><\/pre>\n\n\n\n<p>Package these 3 files into zip.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-a5e926e6-5304-4aaa-88d1-dc34022a9cf7\" href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/XlaTransactionUploadTemplate08-2.zip\">XlaTransactionUploadTemplate08-2<\/a><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/XlaTransactionUploadTemplate08-2.zip\" class=\"wp-block-file__button\" download aria-describedby=\"wp-block-file--media-a5e926e6-5304-4aaa-88d1-dc34022a9cf7\">\u4e0b\u8f7d<\/a><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"upload-transaction-data\"><span class=\"ez-toc-section\" id=\"Upload_Transaction_Data\"><\/span>Upload Transaction Data<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-23.png\"><img loading=\"lazy\" decoding=\"async\" width=\"778\" height=\"656\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-23.png\" alt=\"\" class=\"wp-image-547\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-23.png 778w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-23-300x253.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-23-768x648.png 768w\" sizes=\"auto, (max-width: 778px) 100vw, 778px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-25.png\"><img loading=\"lazy\" decoding=\"async\" width=\"959\" height=\"618\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-25.png\" alt=\"\" class=\"wp-image-549\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-25.png 959w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-25-300x193.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-25-768x495.png 768w\" sizes=\"auto, (max-width: 959px) 100vw, 959px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-26.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"165\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-26-1024x165.png\" alt=\"\" class=\"wp-image-550\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-26-1024x165.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-26-300x48.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-26-768x124.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-26.png 1088w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"submit-import-accounting-transaction-process\"><span class=\"ez-toc-section\" id=\"Submit_Import_Accounting_Transaction_Process\"><\/span>Submit Import Accounting Transaction Process<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-27.png\"><img loading=\"lazy\" decoding=\"async\" width=\"757\" height=\"685\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-27.png\" alt=\"\" class=\"wp-image-552\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-27.png 757w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-27-300x271.png 300w\" sizes=\"auto, (max-width: 757px) 100vw, 757px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-28.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"503\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-28-1024x503.png\" alt=\"\" class=\"wp-image-553\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-28-1024x503.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-28-300x147.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-28-768x377.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-28.png 1124w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-29.png\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"354\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-29.png\" alt=\"\" class=\"wp-image-554\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-29.png 720w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-29-300x148.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/a><\/figure>\n\n\n\n<p>Wait for import completion<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-30.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"365\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-30-1024x365.png\" alt=\"\" class=\"wp-image-555\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-30-1024x365.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-30-300x107.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-30-768x274.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-30.png 1423w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Verify import result from subledger<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-31.png\"><img loading=\"lazy\" decoding=\"async\" width=\"860\" height=\"488\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-31.png\" alt=\"\" class=\"wp-image-556\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-31.png 860w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-31-300x170.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-31-768x436.png 768w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-32.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"527\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-32-1024x527.png\" alt=\"\" class=\"wp-image-557\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-32-1024x527.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-32-300x155.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-32-768x396.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-32.png 1431w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-33.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"328\" src=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-33-1024x328.png\" alt=\"\" class=\"wp-image-558\" srcset=\"https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-33-1024x328.png 1024w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-33-300x96.png 300w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-33-768x246.png 768w, https:\/\/www.linyinghao.cn\/wordpress\/wp-content\/uploads\/2021\/05\/image-33.png 1419w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article describes general steps to configure FAH and import data from external system using spreadsheet.<\/p>\n","protected":false},"author":1,"featured_media":842,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[12],"class_list":["post-486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-saas","tag-oracle-financial-cloud"],"_links":{"self":[{"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=486"}],"version-history":[{"count":17,"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/486\/revisions"}],"predecessor-version":[{"id":902,"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/486\/revisions\/902"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/842"}],"wp:attachment":[{"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linyinghao.cn\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}