Page History

...

See the end-user documentation space for details on how to set these things up and what they mean. Also see this for more advanced options for Products, Categories, and so on.

Accounting data organization and Setup

Anchor
accountingSetup accountingSetup

(field/entitynames in brackets\[\])

General principles

1. Wiki Markup
   The general ledger of ofbiz consists out of a list of 'ledger buckets = glAccounts' with a non meaningfull ID: \[glAccountId\] and a meaningfull code \[accountCode\] and a meaningfull name \[accountName\] Initially, in the demo data, the account id and code are the same. When reorganizations are required these codes can be easily renamed without changing the glAccountId.

2. Wiki Markup
   The buckets are in a hierarchy where totals of the lower levels are added together and be shown at the higher levels, therefore every ledger bucket has a parent \[parentGlAccountId\]; with one exeption if the glaccount is a toplevel glAccount/bucket.

3. Wiki Markup
   Every glAccount has a account type id \[glAccountTypeId\] with a organization dependent second default glAccountId \[GlAccountTypeDefault.glAccountId\] to be able for the system to create the double booking. (Currently the system will do that always to "ACCOUNTS_RECEIVABLE" default glAccountTypeId for sales invoices).

4. Transactions are created for several reasons like posting of invoices or payments, inventory movements and workeffort costs.
5. GlAccount class is used for categorization and reporting.

General Setup (accounting -> global GlSettings)

1. Company data and internal organizations
   demo file at: /applications/accounting/data/DemoOrganizationData.xml

2. Wiki Markup
   All glAccounts are predefined \[GlAccount\] and can be viewed on the globalGlSettings->chartOfAccounts screen. demo file at /applications/accounting/data/DemoGeneralChartOfAccounts.xml

3. Load the Sales/purchase InvoiceItemType table and default glAccountId general setup for all organizations.
   demo file at /applications/accounting/data/DemoGlSetupData.xml

Organizational Setup (accounting -> organizational settings -> setup).

1. Wiki Markup
   The predefined glAccounts are assigned to an organization \[GlAccountOrganization\] on screen chartOfAccounts (this file can only be loaded and not changed) demo file at /applications/accounting/data/DemoGlSetupData.xml

2. if required override the invoiceItem type type assignement for a particular organization at the glAccountDefaults->SalesInvoice/PurchaseInvoice

3. Wiki Markup
   Enter/load the payment TYPE GlType Mapping file \[PaymentGlAccountTypeMap\] at glAccountDefaults->PaymentTypeGlMapping

4. Wiki Markup
   Enter/load the payment METHOD GlType Mapping file \[PaymentMethodTypeGlAccount\] at glAccountDefaults->PaymentMethodTypeGlMapping

Creating ledger transactions.(to be completed)

1. Sales invoice
2. Purchase invoice
3. Incoming payment
4. Outgoing payment
5. Inventary adjustment
6. Workeffort costs