Wikiadmin: Created page with "{{BackTo|Screens_Reference}} == Accounting Schema == An accounting schema is set of accounting rules to be used while posting transactions in an organization. Accounting rule..."

2021-11-18T15:18:54Z

Created page with "{{BackTo|Screens_Reference}} == Accounting Schema == An accounting schema is set of accounting rules to be used while posting transactions in an organization. Accounting rule..."

New page

{{BackTo|Screens_Reference}}

== Accounting Schema ==
An accounting schema is set of accounting rules to be used while posting transactions in an organization. Accounting rules such as the currency and the account tree to use while posting transactions to the ledger.
=== Accounting Schema ===
[[File:WS199.png|thumb|Accounting Schema]]
The accounting schema window allows you to review and maintain imported accounting schemas and to create new ones if needed.
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''Name''' : A non-unique identifier for a record/document often used as a search tool.
* '''Description''' : A space to write additional related information.
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''Accounting Standard''' : Accounting Standard
* '''[[Screenshot:Currency#Currency | Currency]]''' : An accepted medium of monetary exchange that may vary across countries.
* '''Element separator''' : Element Separator
* '''Allow negative''' : Allow negative entries in credit and debit
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''Accounting Schema''' : The structure used in accounting including costing methods, currencies, and the calendar.
=== Account Schema Element ===
[[File:WS217.png|thumb|Account Schema Element]]
The account schema element tab list the accounting dimensions selected while running either the Initial Client Setup process or the Initial Organization Setup process. It is always possible to add additional accounting dimensions to the list.
* '''Sequence Number''' : The order of records in a specified document.
* '''Name''' : A non-unique identifier for a record/document often used as a search tool.
* '''Type''' : A distinct item characteristic used for processes and sometimes grouped within a category.
* '''[[Screenshot:Organization#Organization | Trx Organization]]''' : Organizational entity within client
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''[[Screenshot:Account Tree#Element | Account Tree]]''' : A unique identifier of the Account Tree.
* '''Balanced''' : Balanced
* '''Mandatory''' : An indication noting that completing in a field is required to proceed.
* '''[[Screenshot:Account Tree#Element Value | Account Element]]''' : A identification code for an account type.
* '''[[Screenshot:Product#Product | Product]]''' : An item produced by a process.
* '''[[Screenshot:Business Partner#Business Partner | Business Partner]]''' : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
* '''[[Screenshot:Location#Location | Location / Address]]''' : A specific place or residence.
* '''[[Screenshot:Sales Region#Sales Region | Sales Region]]''' : A defined section of the world where sales efforts will be focused.
* '''[[Screenshot:Service Project#Service Project | Project]]''' : Identifier of a project defined within the Project & Service Management module.
* '''[[Screenshot:Sales Campaign#Sales Campaign | Sales Campaign]]''' : An advertising effort aimed at increasing sales.
* '''[[Screenshot:ABC Activity#Activity | Activity]]''' : A distinct activity defined and used in activity based management.
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''Acct.Schema Element''' : Acct.Schema Element
* '''[[Screenshot:Accounting Schema#Accounting Schema | Accounting Schema]]''' : The structure used in accounting including costing methods, currencies, and the calendar.
=== Account Schema Tables ===
[[File:WS800041.png|thumb|Account Schema Tables]]
Account schema tables allows to define which tables and therefore transactions generate accounting and which ones not.
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that points to the database table.
* '''[[Screenshot:Accounting templates#Templates | Accounting Template]]''' : Accounting Template
* '''Disable for Background''' : Disables the selected table for accounting in background process
* '''SQL Description''' : Acct description
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''Acctschema table''' : Acctschema table
* '''[[Screenshot:Accounting Schema#Accounting Schema | Accounting Schema]]''' : The structure used in accounting including costing methods, currencies, and the calendar.
=== Documents ===
[[File:WS1007400000.png|thumb|Documents]]
Documents tab allows to define which document types within a table type allow negative posting at document level and whether they use a different accounting process than the default one based on a given accounting template.
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''Document Category''' : A classification of document types that are shown and processed in the same window.
* '''Allow negative''' : Allow negative entries in credit and debit
* '''[[Screenshot:Accounting templates#Templates | Accounting Template]]''' : Accounting Template
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''C_AcctSchema_Table_DocType_ID'''
* '''[[Screenshot:Accounting Schema#Account Schema Tables | Acctschema table]]''' : Acctschema table
=== Process ===
[[File:WS4F9E1C27F7F040C58C5CA2E6FD5B26CB.png|thumb|Process]]
It is possible to assign additional accounting process to be run after the standar one for a given accounting schema.
* '''Sequence Number''' : The order of records in a specified document.
* '''[[Screenshot:Accounting Process#Accounting process | Accounting Post_Process]]''' : Accounting process to be executed at posting time
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''Isdataset'''
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''Accounting Schema Post_Process''' : Process to be executed at posting time
* '''[[Screenshot:Accounting Schema#Accounting Schema | Accounting Schema]]''' : The structure used in accounting including costing methods, currencies, and the calendar.
=== General Ledger ===
[[File:WS200.png|thumb|General Ledger]]
General ledger tab allows to define defult accounts to be used while posting certain type of transactions if applicable.
* '''Suspense Balancing Use''' : Use Suspense Balancing
* '''[[Screenshot:Account Combination#Combination | Suspense Balancing]]''' : Suspense Balancing Account
* '''[[Screenshot:Account Combination#Combination | Retained Earning]]''' : Retained Earning Account
* '''Suspense Error Use''' : Use Suspense Error
* '''[[Screenshot:Account Combination#Combination | Suspense Error]]''' : Suspense Error Account
* '''[[Screenshot:Account Combination#Combination | Income Summary]]''' : Income Summary Account
* '''Currency Balancing Use''' : Use Currency Balancing
* '''[[Screenshot:Account Combination#Combination | Currency Balancing Acct.]]''' : Account used when a currency is out of balance
* '''[[Screenshot:Account Combination#Combination | CFS Order Account]]''' : Cash Flow Statement Order Account
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''Reverse Permanent Account Balances''' : Reverse Permanent Account Balances
* '''[[Screenshot:Account Combination#Combination | PPV Offset]]''' : Purchase Price Variance Offset Account
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Account Combination#Combination | Due from Intercompany]]''' : Intercompany Due From / Receivables Account
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''Accounting schema GL''' : The General Ledger defines error and balance handling to use as well as the necessary accounts for posting to General Ledger.
* '''[[Screenshot:Accounting Schema#Accounting Schema | Accounting Schema]]''' : The structure used in accounting including costing methods, currencies, and the calendar.
=== Defaults ===
[[File:WS252.png|thumb|Defaults]]
Default tab allows to maintain or to add a complete set of default accounts to be used while posting certain transactions types.
* '''[[Screenshot:Account Combination#Combination | Customer Receivables No.]]''' : An account number in the general ledger to mark transactions with a business partner.
* '''[[Screenshot:Account Combination#Combination | Customer Prepayment]]''' : The Customer Prepayment account indicates the account to be used for recording prepayments from a customer.
* '''[[Screenshot:Account Combination#Combination | Write-off]]''' : Account for Receivables write-off
* '''[[Screenshot:Account Combination#Combination | Write-off Revenue]]''' : Account for Payables write-off
* '''[[Screenshot:Account Combination#Combination | Vendor Liability]]''' : An account number in the general ledger used to mark transactions with this business partner.
* '''[[Screenshot:Account Combination#Combination | Vendor Prepayment]]''' : An account number in the general ledger used to mark transactions with this business partner.
* '''[[Screenshot:Account Combination#Combination | Non-Invoiced Receipts]]''' : Account for not-invoiced Material Receipts
* '''[[Screenshot:Account Combination#Combination | Non-Invoiced Services]]'''
* '''[[Screenshot:Account Combination#Combination | Product Asset]]''' : A tangible asset used for business without expectation of sale in the coming fiscal year.
* '''[[Screenshot:Account Combination#Combination | Product Expense]]''' : An account number in the general ledger to mark transactions with this item.
* '''[[Screenshot:Account Combination#Combination | Product Revenue]]''' : An account number in the general ledger to mark transactions with this product.
* '''[[Screenshot:Account Combination#Combination | Product COGS]]''' : The cost of goods sold for a specified product.
* '''[[Screenshot:Account Combination#Combination | Invoice Price Variance]]''' : The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price.
* '''[[Screenshot:Account Combination#Combination | Product Revenue Return]]''' : An account number in the general ledger to mark returns of this product.
* '''[[Screenshot:Account Combination#Combination | Product COGS Return]]''' : The cost of goods returned for a specified product.
* '''[[Screenshot:Account Combination#Combination | Pending Services Revenue]]'''
* '''[[Screenshot:Account Combination#Combination | Warehouse Differences]]''' : Warehouse Differences Account
* '''[[Screenshot:Account Combination#Combination | Inventory Revaluation]]''' : Account for Inventory Revaluation
* '''[[Screenshot:Account Combination#Combination | Work In Progress]]''' : An account used in production projects until it becomes defined as a finished good.
* '''[[Screenshot:Account Combination#Combination | Withholding Account]]''' : not part of task
* '''[[Screenshot:Account Combination#Combination | Bank Asset]]''' : Bank Asset Account
* '''[[Screenshot:Account Combination#Combination | Bank In Transit]]''' : Bank In Transit Account
* '''[[Screenshot:Account Combination#Combination | Bank Expense]]''' : Bank Expense Account
* '''[[Screenshot:Account Combination#Combination | Bank Revaluation Gain]]''' : Bank Revaluation Gain Account
* '''[[Screenshot:Account Combination#Combination | Bank Revaluation Loss]]''' : Bank Revaluation Loss Account
* '''[[Screenshot:Account Combination#Combination | Tax Due]]''' : Account for Tax you have to pay
* '''[[Screenshot:Account Combination#Combination | Tax Credit]]''' : Account for Tax you can reclaim
* '''[[Screenshot:Account Combination#Combination | Cash Book Asset]]''' : Cash Book Asset Account
* '''[[Screenshot:Account Combination#Combination | Cash Book Differences]]''' : Cash Book Differences Account
* '''[[Screenshot:Account Combination#Combination | Cash Transfer]]''' : Cash Transfer Clearing Account
* '''[[Screenshot:Account Combination#Combination | Depreciation]]''' : Depreciation account
* '''[[Screenshot:Account Combination#Combination | Accumulated Depreciation]]''' : Accumulated Depreciation
* '''Copy Accounts''' : Copy and overwrite all accounts to system defaults (DANGEROUS!!!)
* '''[[Screenshot:Account Combination#Combination | Payment Selection]]''' : AP Payment Selection Clearing Account
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Account Combination#Combination | Disposal Loss]]''' : Disposal Loss
* '''[[Screenshot:Account Combination#Combination | Disposal Gain]]''' : Disposal Gain
* '''Creation Date''' : The date that this record is completed.
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''Accounting Schema''' : Acctschema default
* '''[[Screenshot:Accounting Schema#Accounting Schema | Accounting Schema]]''' : The structure used in accounting including costing methods, currencies, and the calendar.
=== Financial Account Defaults ===

Default accounts for the financial accounts in this accounting schema
* '''[[Screenshot:Financial Account#Account | Financial Account]]''' : Financial account used to deposit / withdrawal money such as bank accounts or petty cash
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''[[Screenshot:Account Combination#Combination | Bank Fee Account]]''' : Account used for posting Bank Fees
* '''[[Screenshot:Account Combination#Combination | Bank Revaluation Gain Account]]''' : Account used for posting currency revaluation gains
* '''[[Screenshot:Account Combination#Combination | Bank Revaluation Loss Account]]''' : Account used for posting currency revaluation losses
* '''[[Screenshot:Account Combination#Combination | Receive Payment Account]]''' : Receive Payment Account used by financial account
* '''[[Screenshot:Account Combination#Combination | Make Payment Account]]''' : Make Payment Account used by financial account
* '''[[Screenshot:Account Combination#Combination | Deposit Account]]''' : Deposit Account used by the financial account
* '''[[Screenshot:Account Combination#Combination | Withdrawal Account]]''' : Withdrawal Account used by the financial account
* '''[[Screenshot:Account Combination#Combination | Debit Account]]''' : Debit Account used by the financial account
* '''[[Screenshot:Account Combination#Combination | Credit Account]]''' : Credit Account used by the financial account
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''Financial Account Accounts''' : Financial Account Accounts
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''[[Screenshot:Accounting Schema#Accounting Schema | Accounting Schema]]''' : The structure used in accounting including costing methods, currencies, and the calendar.

{{BackTo|Screens_Reference}}

[[Category:User_Guide]]

[[Category:Generated_Doc]]

Screenshot:Accounting Schema - Revision history

Wikiadmin: Created page with "{{BackTo|Screens_Reference}} == Accounting Schema == An accounting schema is set of accounting rules to be used while posting transactions in an organization. Accounting rule..."