{"id":18213,"date":"2026-01-30T12:47:41","date_gmt":"2026-01-30T12:47:41","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18213"},"modified":"2026-01-30T12:47:43","modified_gmt":"2026-01-30T12:47:43","slug":"how-import-gl-journal-respects-accounting-schema-rules","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-import-gl-journal-respects-accounting-schema-rules\/","title":{"rendered":"How Import GL Journal Respects Accounting Schema Rules"},"content":{"rendered":"\n

In iDempiere, the Import GL Journal<\/strong> process is tightly controlled by the Accounting Schema<\/strong>. Even though data is imported in bulk, it cannot bypass the fundamental accounting rules defined in the system. This ensures that every imported journal behaves exactly like a manually created journal from an accounting perspective.<\/p>\n\n\n\n


Accounting Schema as the Control Layer<\/strong><\/h2>\n\n\n\n

The Accounting Schema defines the structure and rules<\/strong> for all financial postings, including:<\/p>\n\n\n\n

    \n
  • Chart of Accounts<\/li>\n\n\n\n
  • Currency<\/li>\n\n\n\n
  • Accounting Calendar<\/li>\n\n\n\n
  • Posting precision<\/li>\n\n\n\n
  • Costing and balancing rules<\/li>\n<\/ul>\n\n\n\n

    When GL data is imported, iDempiere validates every record against the active Accounting Schema<\/strong> before allowing journal creation.<\/p>\n\n\n\n

    \"TenthPlanet-iDempiere-AccountingManagement-ImportGLJournal-1\"<\/figure>\n\n\n\n


    Account Validation During Import<\/strong><\/h2>\n\n\n\n

    Each imported journal line must reference:<\/p>\n\n\n\n

      \n
    • A valid Account<\/strong> from the schema\u2019s Chart of Accounts<\/li>\n\n\n\n
    • A compatible Organization<\/strong> and accounting combination<\/li>\n<\/ul>\n\n\n\n

      If an account does not exist or is not allowed by the schema, the record fails validation<\/strong> and is not imported as a journal. This prevents incorrect or orphaned accounting entries.<\/p>\n\n\n\n


      Currency Precision Enforcement<\/strong><\/h2>\n\n\n\n

      Accounting Schema<\/strong> defines base currency<\/strong>, conversion rules<\/strong>, and decimal precision<\/strong> for postings. During GL Journal import<\/strong>, amounts are validated against schema precision<\/strong>, currency mismatches flagged<\/strong>, and conversions applied<\/strong> only when properly configured. This prevents rounding and currency inconsistencies<\/strong> in the General Ledger.<\/p>\n\n\n\n

      \"TenthPlanet-iDempiere-AccountingManagement-ImportGLJournal-2\"<\/figure>\n\n\n\n


      Period and Calendar Control<\/strong><\/h2>\n\n\n\n

      The Accounting Schema is linked to an Accounting Calendar<\/strong>.
      When importing:<\/p>\n\n\n\n

        \n
      • The accounting date must fall within an open period<\/strong><\/li>\n\n\n\n
      • Closed or future-restricted periods are rejected<\/li>\n<\/ul>\n\n\n\n

        This ensures imported journals respect period control rules and cannot be posted into locked financial periods.<\/p>\n\n\n\n


        Standard Posting Engine Usage<\/strong><\/h2>\n\n\n\n

        After import<\/strong>, GL Journals<\/strong> use the same posting engine<\/strong> as manual journals to generate Accounting Facts<\/strong> per schema rules<\/strong>. Audit trails<\/strong>, reversals<\/strong>, and reporting<\/strong> function normally. Importing maintains full accounting logic<\/strong> without shortcuts.<\/p>\n\n\n\n

        \"TenthPlanet-iDempiere-AccountingManagement-ImportGLJournal-3\"<\/figure>\n\n\n\n





        The Import GL Journal<\/strong> feature fully respects Accounting Schema rules<\/strong> by enforcing account validity, currency control, period management, balancing logic, and standard posting behavior. Bulk import improves efficiency\u2014but never compromises accounting discipline<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

        In iDempiere, the Import GL Journal process is tightly controlled by the Accounting Schema. Even though data is imported in […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[58],"tags":[],"class_list":["post-18213","post","type-post","status-publish","format-standard","hentry","category-accounting"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18213","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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=18213"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18213\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}