User Manual 2.3/Financial Management

Contents 1 Receivables & Payables 1.1 Transactions 1.1.1 Bank Statement 1.1.1.1 Header 1.1.1.2 Lines 1.1.2 Cash Journal 1.1.2.1 Header 1.1.2.2 Lines 1.1.3 Funds Transfer 1.1.4 Remittance 1.1.4.1 Header 1.1.4.2 Lines 1.1.5 Payment Status Management 1.1.5.1 Header 1.1.5.2 Lines 1.1.6 Manual Settlement 1.1.6.1 Manual Settlement 1.1.6.2 Created Payment 1.1.6.3 Balance Payment 1.1.6.4 Balance Payment Replacement 1.1.7 Settlement 1.1.7.1 Cancelled Payments 1.1.7.2 Created Payments 1.1.7.3 Settlement 1.1.8 Remittance Cancellation/Return 1.1.9 Change Payment Status 1.2 Setup 1.2.1 Bank 1.2.1.1 Bank 1.2.1.2 Account 1.2.2 Cashbook 1.2.3 Remittance Type 1.2.3.1 Remittance Type 1.2.3.2 Parameter 1.2.4 Promissory Note Format 1.3 Analysis Tools 1.3.1 Bank Operations 1.3.2 Cash Operations 1.3.3 Cashflow Forecast 1.3.4 Payment Report 1.3.5 Invoice Tax Report 1.3.6 Payment Tracker 2 Accounting 2.1 Transactions 2.1.1 G/L Journal 2.1.1.1 Batch 2.1.1.2 Journal 2.1.1.3 Lines 2.1.2 GL Posting by DB Tables 2.1.3 Reset Accounting 2.1.4 Budget 2.1.4.1 Header 2.1.4.2 Lines 2.1.5 Create Budget Report in Excel 2.2 Setup 2.2.1 Fiscal Calendar 2.2.1.1 Calendar 2.2.1.2 Non Business Day 2.2.1.3 Period 2.2.1.4 Period Control 2.2.1.5 Year 2.2.2 Account Tree 2.2.2.1 Customized Elements 2.2.2.2 Element 2.2.2.3 Element Value 2.2.3 Accounting Dimension 2.2.3.1 Activity Dimension 2.2.3.2 Business Partner Dimension 2.2.3.3 Campaign Dimension 2.2.3.4 Organization Dimension 2.2.3.5 Product Dimension 2.2.3.6 Project Dimension 2.2.3.7 Sales Region Dimension 2.2.4 Accounting Schema 2.2.4.1 Account Schema Element 2.2.4.2 Account Schema Tables 2.2.4.3 Accounting Schema 2.2.4.4 Defaults 2.2.4.5 General Ledger 2.2.5 G/L Item 2.2.6 Account Combination 2.2.7 G/L Category 2.2.8 Document Type 2.2.9 Document Sequence 2.2.10 Tax Category 2.2.11 Tax Rate 2.2.11.1 Tax 2.2.11.2 Tax Zone 2.2.12 Bussines Partner Tax Category 2.2.13 ABC Activity 2.3 Analysis Tools 2.3.1 Non-Posted Documents Report 2.3.2 General Accounting Report 2.3.3 Balance Sheet 2.3.4 Accounting Dimensional Report 2.3.5 General Ledger Report 2.3.6 General Ledger Journal 2.3.7 Create 347 Model 2.3.8 Create Accounting Report 2.3.9 Accounting Report Setup 2.3.10 General Account Report Setup 2.3.10.1 Category 2.3.10.2 Node 2.3.10.3 Setup 2.3.11 Accounting Transaction Details 2.3.12 Create Tax Report 2.3.13 Tax Report Setup 2.3.14 Notice 3 Assets 3.1 Assets 3.1.1 Assets 3.1.2 Asset Amortization 3.2 Asset Category 3.3 Amortization 3.3.1 Header 3.3.2 Lines

Receivables & Payables

Transactions

Bank Statement

View your bank statements against transactions created and edited in the application.

View larger

Header

Add received bank statements to compare the completed financial transaction with application transactions.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Bank Account:	A monetary account of funds held in a recognized banking institution.
Bank Statement:	Bank Statement of account
Beginning Balance:	Balance prior to any transactions
Client:	Client for this installation.
Create Lines from:	An addition of statements from pre-existing documents.
Description:	A space to write additional related information.
Ending balance:	Ending or closing balance
Manual:	A task or process completed directly by the user, not automatically by the application.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Posted:	An accounting status noting if a specified transaction was added to the general ledger.
Process Statement:
Process Statement:
Statement difference:	Difference between statement ending balance and actual ending balance
Transaction Date:	The date the transaction is carried out and registered in the cash journal.

Lines

Add bank statement lines. Each line represents a particular transaction included in the received bank statement.

Fields:

Accounting Date:	The date this transaction is recorded in the general ledger.
Active:	A flag indicating whether this record is available for use or de-activated.
Bank Statement:	Bank Statement of account
Bank statement line:	A statement displaying one transaction in the bank statement.
Charge:	A cost or expense incurred during business activity.
Charge amount:	The amount of a cost or expense incurred during business activity.
Client:	Client for this installation.
Convert Charge amount:	Convert Charge amount
Create Payment:
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
DP Management:	Debt Payment Management
Effective date:	Date when money is available
Line No.:	A line stating the position of this request in the document.
Memo:	Memo Text
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.
Reference No.:	The number for a specific reference.
Reversal:	This is a reversing transaction
Statement amount:	Statement Amount
Transaction Amount:	Amount of a transaction

Cash Journal

Add individual cash transactions to be managed and viewed in the cashbook. What are the types of cash operations? Charge Debt/Payment Difference General Expense General Receipt

View larger

Header

Add cash transactions performed by the company.

Fields:

Accounting Date:	The date this transaction is recorded in the general ledger.
Active:	A flag indicating whether this record is available for use or de-activated.
Activity:	A distinct activity defined and used in activity based management.
Beginning Balance:	Balance prior to any transactions
Cash Book:	A document used to manage all cash transactions.
Cash Journal:	Cash Journal
Client:	Client for this installation.
Description:	A space to write additional related information.
Ending balance:	Ending or closing balance
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Posted:	An accounting status noting if a specified transaction was added to the general ledger.
Process Cash:
Process Now:	A request to process the respective document or task.
Project:	A defined task or undertaking
Sales Campaign:	An advertising effort aimed at increasing sales.
Statement difference:	Difference between statement ending balance and actual ending balance
Transaction Date:	The date the transaction is carried out and registered in the cash journal.
Trx Organization:	The organization which performs or initiates the transaction.
1st Dimensinon:	A display of optional elements that are previously defined for this account combination.
2nd Dimension:	A display of optional elements that are previously defined for this account combination.

Lines

Add cash journal lines. Each line represents one particular cash transaction.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Amount:	A monetary total.
Cash Journal:	Cash Journal
Cash Journal Line:	A statement displaying one transaction in the cash journal.
Cash Type:	Source of Cash
Charge:	A cost or expense incurred during business activity.
Client:	Client for this installation.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Discount Amount:	Calculated amount of discount
Generated:	This Line is generated
Line No.:	A line stating the position of this request in the document.
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.
Sales Order:	A unique and often automatically generated identifier for a sales order.
Write-off Amount:	A monetary sum that can be deducted from tax obligations.

Funds Transfer

Add funds transfers to move money between your Bank Accounts and/or your Cash Journal.

View larger

Remittance

Edit payments by using remittances to cancel or return them. What is a Remittance? A set of payment obligations to be sent to the bank. In this way the bank manages the selected debt/payment obligations. A payment obligation can be invoices, expenses, and any type of manual settlement. Keep in Mind: If the created remittance is marked as consolidated the settlement is automatically created whenever the user processes this type of remittance.

View larger

Header

Create remittances by including specified payments.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Bank Account:	A monetary account of funds held in a recognized banking institution.
Client:	Client for this installation.
Create File:
Create Lines from:	An addition of statements from pre-existing documents.
C_Remittance_ID:	Remittance
Document No.:	An often automatically generated identifier for all documents.
DP Management:	Debt Payment Management
Due Date:	The date when a specified request must be carried out by.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Process:
Remittance Type:	Remittance Type
Settlement:	The process of exchanging or carrying out a payment once a transaction is made.
Transaction Date:	The date that a specified transaction is entered into the application.

Lines

Edit remittance lines. Each line corresponds to one payment.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
C_Remittance_ID:	Remittance
C_Remittanceline_ID:	Remittance line.
Debt Payment Cancelled:	Debt Payment Cancelled
Line No.:	A line stating the position of this request in the document.
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.
Returned:

Payment Status Management

Edit the status of payments for the accounting purposes.

View larger

Header

Create and edit payments.

Fields:

Accounting Date:	The date this transaction is recorded in the general ledger.
Active:	A flag indicating whether this record is available for use or de-activated.
Activity:	A distinct activity defined and used in activity based management.
Client:	Client for this installation.
Create Lines from:	An addition of statements from pre-existing documents.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Document No.:	An often automatically generated identifier for all documents.
Document Type:	A value defining what sequence and process setup are used to handle this document.
DP Management:	Debt Payment Management
Organization:	Organizational entity within client
Post Payment Management:
Posted:	An accounting status noting if a specified transaction was added to the general ledger.
Process Now:	A request to process the respective document or task.
Project:	A defined task or undertaking
Sales Campaign:	An advertising effort aimed at increasing sales.
Transaction Date:	The date that a specified transaction is entered into the application.
1st Dimensinon:	A display of optional elements that are previously defined for this account combination.
2nd Dimension:	A display of optional elements that are previously defined for this account combination.

Lines

Create and edit payment lines by changing payments status.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
C_Dp_Managementline_ID:	Debt/payment management line.
Client:	Client for this installation.
DP Management:	Debt Payment Management
Line No.:	A line stating the position of this request in the document.
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.
Status From:	Status From
Status To:	Status to

Manual Settlement

Create and edit payments with no corresponding document/transaction in the application.

View larger

Manual Settlement

Create and edit manual settlements for payments with no corresponding document/transaction in the application.

What is a Manual Settlement?

Manual Settlement enables the user to create settlements that have not been previously generated based on any customer or vendor invoices. In its simplest terms, a manual settlement is used when there no previously created invoice exists.

Fields:

Accounting Date:	The date this transaction is recorded in the general ledger.
Active:	A flag indicating whether this record is available for use or de-activated.
Activity:	A distinct activity defined and used in activity based management.
Canceled not charge:	Canceled not charge amount
Charged amount:	Charged amount
Client:	Client for this installation.
Copy from Settlement:	Generates a manual settlement
Create File:
Create Lines from:	An addition of statements from pre-existing documents.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Document No.:	An often automatically generated identifier for all documents.
Document Type:	A value defining what sequence and process setup are used to handle this document.
Organization:	Organizational entity within client
Post Settlement:
Posted:	An accounting status noting if a specified transaction was added to the general ledger.
Process Now:	A request to process the respective document or task.
Project:	A defined task or undertaking
Sales Campaign:	An advertising effort aimed at increasing sales.
Settlement:	The process of exchanging or carrying out a payment once a transaction is made.
Settlement amount:
Settlement Open:
Settlement Type:	Settlement Type
Template:	Is Template
Transaction Date:	The date that a specified transaction is entered into the application.
1st Dimensinon:	A display of optional elements that are previously defined for this account combination.
2nd Dimension:	A display of optional elements that are previously defined for this account combination.

Created Payment

Create manual settlement lines. Each line represents one payment.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Amount:	A monetary total.
Ballancing amount:
Bank Account:	A monetary account of funds held in a recognized banking institution.
Bank statement line:	A statement displaying one transaction in the bank statement.
Business Partner :	Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Cancelled Settlement No.:	The settlement used to cancel the corresponding payment.
Cash Book:	A document used to manage all cash transactions.
Cash Journal Line:	A statement displaying one transaction in the cash journal.
Client:	Client for this installation.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Direct Posting:	Direct Posting
Due Date:	The date when a specified request must be carried out by.
Form of Payment:	The method used to pay the request.
Generate_Processed:	Generate Processed
G/L Item:	An alias for the Account Combination which can be commonly used in daily operations.
Invoice:	A document listing products, quantities and prices, payment terms, etc.
Manual:	A task or process completed directly by the user, not automatically by the application.
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.
Payment Complete:	A confirmation stating whether the request has been closed through a monetary transaction.
Project:	A defined task or undertaking
Receipt:	A confirmation stating whether the request has been closed through receipt of a monetary transaction.
Settlement:	The process of exchanging or carrying out a payment once a transaction is made.
Status:	A defined state or position of a payment.
Valid:	A confirmation that something is correct.
Write-off Amount:	A monetary sum that can be deducted from tax obligations.

Balance Payment

Define the G/L items that are going to be used.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Amount credit:	Credit amount
Amount debit:	Debit amount
C_Debt_Payment_Balancing_ID:	Debt/Payment Balancing
Client:	Client for this installation.
G/L Item:	An alias for the Account Combination which can be commonly used in daily operations.
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.

Balance Payment Replacement

Define a G/L items which can be used to replace G/L items defined in the header tab.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Amount credit:	Credit amount
Amount debit:	Debit amount
Client:	Client for this installation.
G/L Item:	An alias for the Account Combination which can be commonly used in daily operations.
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.
Replace Balances:

Settlement

Edit payments by summing one or many into one or by dividing one into many. Here you manage payments that come from invoices generated in the application. What is a Settlement? Documents formed based on payment obligations from customers or vendors invoices. When an invoice is created, a need to pay/receive money is created. A settlement allows the user to break up a debt/payment obligation into smaller installations or sum up more than one obligation into few bigger ones.

View larger

Cancelled Payments

View cancelled payments.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Amount:	Amount in a defined currency
Bank Account:	A monetary account of funds held in a recognized banking institution.
Bank statement line:	A statement displaying one transaction in the bank statement.
Business Partner :	Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Cancel processed:	Cancel processed
Cash Book:	A document used to manage all cash transactions.
Cash Journal Line:	A statement displaying one transaction in the cash journal.
Change Debt Payment:	Take this Debt/Payment out of the settlement
Client:	Client for this installation.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Due Date:	The date when a specified request must be carried out by.
Form of Payment:	The method used to pay the request.
Invoice:	A document listing products, quantities and prices, payment terms, etc.
Manual:	A task or process completed directly by the user, not automatically by the application.
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.
Payment Complete:	A confirmation stating whether the request has been closed through a monetary transaction.
Receipt:	A confirmation stating whether the request has been closed through receipt of a monetary transaction.
Settlement:	The process of exchanging or carrying out a payment once a transaction is made.
Status:	A defined state or position of a payment.
Valid:	A confirmation that something is correct.
Write-off Amount:	A monetary sum that can be deducted from tax obligations.

Created Payments

Create payments. The amount of all the payments created must be equal to the amount of all the payments cancelled.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Amount:	A monetary total.
Ballancing amount:
Bank Account:	A monetary account of funds held in a recognized banking institution.
Bank statement line:	A statement displaying one transaction in the bank statement.
Business Partner :	Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Cancelled Settlement No.:	The settlement used to cancel the corresponding payment.
Cash Book:	A document used to manage all cash transactions.
Cash Journal Line:	A statement displaying one transaction in the cash journal.
Client:	Client for this installation.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Direct Posting:	Direct Posting
Due Date:	The date when a specified request must be carried out by.
Form of Payment:	The method used to pay the request.
Generate_Processed:	Generate Processed
G/L Item:	An alias for the Account Combination which can be commonly used in daily operations.
Invoice:	A document listing products, quantities and prices, payment terms, etc.
Manual:	A task or process completed directly by the user, not automatically by the application.
Organization:	Organizational entity within client
Payment:	A obligation to pay or a right to collect for a specified item or service.
Payment Complete:	A confirmation stating whether the request has been closed through a monetary transaction.
Project:	A defined task or undertaking
Receipt:	A confirmation stating whether the request has been closed through receipt of a monetary transaction.
Settlement:	The process of exchanging or carrying out a payment once a transaction is made.
Status:	A defined state or position of a payment.
Valid:	A confirmation that something is correct.
Write-off Amount:	A monetary sum that can be deducted from tax obligations.

Settlement

Create settlements for selected payments.

Fields:

Accounting Date:	The date this transaction is recorded in the general ledger.
Active:	A flag indicating whether this record is available for use or de-activated.
Activity:	A distinct activity defined and used in activity based management.
Canceled not charge:	Canceled not charge amount
Charged amount:	Charged amount
Client:	Client for this installation.
Create File:
Create lines from:	Process which will generate a new document lines based on an existing document
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Document No.:	An often automatically generated identifier for all documents.
Document Type:	A value defining what sequence and process setup are used to handle this document.
Generated amount:	Generated amount
Organization:	Organizational entity within client
Post Settlement:
Posted:	An accounting status noting if a specified transaction was added to the general ledger.
Process Now:	A request to process the respective document or task.
Project:	A defined task or undertaking
Sales Campaign:	An advertising effort aimed at increasing sales.
Settlement:	The process of exchanging or carrying out a payment once a transaction is made.
Settlement Open:
Settlement Type:	Settlement Type
Transaction Date:	The date that a specified transaction is entered into the application.
1st Dimensinon:	A display of optional elements that are previously defined for this account combination.
2nd Dimension:	A display of optional elements that are previously defined for this account combination.

Remittance Cancellation/Return

Edit pending remittances by cancelling or returning them.

View larger

Change Payment Status

Edit a previously completed payment changing the status from paid to unpaid.

Setup

Bank

Define banks and the related accounts.

View larger

Bank

Create your banks to be used in application transactions.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Bank:	Bank
Business Partner :	Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Client:	Client for this installation.
Code bank:	Code of the bank
Code branch:	Code of the branch
Digit control:	Digit control
INE Number:	INE Number.
Location / Address:	A specific place or residence.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Own Bank:	Bank for this Organization
Routing No:	Bank Routing Number
Swift code:	Swift Code (Society of Worldwide Interbank Financial Telecommunications)

Account

Create and edit bank accounts for a selected bank.

Fields:

Account No:	Account Number
Active:	A flag indicating whether this record is available for use or de-activated.
Bank:	Bank
Bank Account:	A monetary account of funds held in a recognized banking institution.
Bank Account Type:	Bank Account Type
Client:	Client for this installation.
Code account:	Code of the account
Credit limit:	Amount of Credit allowed
Currency:	An accepted medium of monetary exchange that may vary across countries.
Current balance:	Current Balance
Default:	A value that is shown whenever a record is created.
Digit control:	Digit control
Organization:	Organizational entity within client
Statement processor class:	Statement Processor Java Class

Cashbook

Define cashbooks to be used for the company's cash transactions.

View larger

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Cash Book:	A document used to manage all cash transactions.
Client:	Client for this installation.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Default:	A value that is shown whenever a record is created.
Description:	A space to write additional related information.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client

Remittance Type

Create and edit remittance types with corresponding parameters according to your business needs.

View larger

Remittance Type

Create and edit remittance types.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Consolidate:	Consolidate
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Payment Rule Consolidated:	Payment Rule Consolidated
Remittance Type:	Remittance Type
Returned Status:	Returned Status
Status To:	Status to

Parameter

Add parameters for a selected remittance type according to your business needs.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Content:	Content
C_Remittance_Parameter_ID:	Parameter
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Remittance Type:	Remittance Type

Promissory Note Format

Using this window is possible to create and edit the structure of how to print a promissory note or cheque. Understanding promissory note or cheque like:

Although all the banks use the same promissory note structure, they are not exactly the same. There are millimeter differences. That is why this window was created. So the user can adjust the promissory printing in its own.

The promissory note is structured with four lines. And each line has different blanks. All together, there are nine blanks. Setting up the relative spaces between lines, we will be able to set up a promissory template for each bank. This way, a proper promissory note will be printed.

So, what are the parameters for?

Line 1 Left: Left margin for line 1

Line 2 Left: Left margin for line 2

Line 3 Left: Left margin for line 3

Line 4 Left: Left margin for line 4

Line 1 Top: First line's top margin.

Line 2 Top: The space between the first and the second line.

Line 3 Top: The space between the second and the third line.

Line 4 Top: The space between the third and the fourth line.

Param11: The space between the first blank and the second one, in line 1.

Param12: The space between the second blank and the third one, in line 1.

Param13: The space between the third blank and the fourth one, in line 1.

Param31: The space between the first blank and the second one, in line 3.

Param32: The space between the second blank and the third one, in line 3.

Param41: The space between the first blank and the second one, in line 4.

Param42: The space between the second blank and the third one, in line 4.

Param43: The space between the third blank and the forth one, in line 4.

All the source fields are just to set up the font size for each filled blank.

"Print bank location" flag is to configure whether we want to write the bank location or not, depending if the bank location is already defined on the promissory note.

So, using all this configuration, it is possible to have different banks and print different promissory notes for each bank.

Analysis Tools

Bank Operations

Create a report showing all the operations performed using selected bank accounts during a specified time period.

Cash Operations

Create a report showing all the operations performed using selected cashbooks during a specified time period.

Cashflow Forecast

Create cash flow forecasts for your bank accounts.

Payment Report

Create a report showing your receivables and payables.

Invoice Tax Report

Create a report showing the tax amounts applied to completed invoices.

Payment Tracker

Create a report showing the payments lifecycle.

Accounting

Transactions

G/L Journal

Create and edit manual G/L journal entries.

View larger

Batch

Create G/L Journal batches in order to group journals of similar characteristics. Each batch may have many journals.

Fields:

Accounting Date:	The date this transaction is recorded in the general ledger.
Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Control Amount:	If not zero, the Debit amount of the document must be equal this amount.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Document Date:	The time listed on the document.
Document No.:	An often automatically generated identifier for all documents.
G/L Category:	A classification used to group lines in the general ledger.
Journal Batch:	General Ledger Journal Batch.
Organization:	Organizational entity within client.
Period:	A specified time period.
Posting Type:	A distinct posting amount characteristic used for processes and sometimes grouped within a category.
Processed:	A confirmation that the associated documents or requests are processed.
Template:	Is Template
Total Credit:	Total Credit in document currency.
Total Debit:	Total debit in document currency.

Process Buttons:

Copy Details:	Copy Journal/Lines from other Journal Batch
Process Batch:

Journal

Create G/L Journals for specified fiscal periods.

Fields:

Accounting Date:	he structure used in accounting including costing methods, currencies, and the calendar.
Accounting Schema:	A flag indicating whether this record is available for use or de-activated.
Active:	A flag indicating whether this record is available for use or de-activated.
Approved:	Indicates if this document requires approval Budget A group of planned expenses for a task.||
Client:	Client for this installation.
Control Amount:	If not zero, the Debit amount of the document must be equal this amount.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Currency Rate Type:	A distinct currency rate characteristic used for processes.
Description:	A space to write additional related information.
Document Date:	The time listed on the document.
Document No.:	An often automatically generated identifier for all documents.
Document Status:	A specified position resulting from processes which have/have not been executed.
Document Type:	A value defining what sequence and process setup are used to handle this document.
G/L Category:	A classification used to group lines in the general ledger.
Journal Batch:	x
Journal Entry:	One transaction with a debit and credit and entered into the general ledger.
Organization:	Organizational entity within client.
Period:	A specified time period.
Posted:	An accounting status noting if a specified transaction was added to the general ledger.
Posting Type:	A distinct posting amount characteristic used for processes and sometimes grouped within a category.
Print:	A reference stating whether or not the document has been printed at any time in the past.
Processed:	A confirmation that the associated documents or requests are processed.
Rate:	The percentage to be multiplied by the source to arrive at the tax or exchange amount.
Total Credit:	Total Credit in document currency.
Total Debit:	Total debit in document currency.

Process Buttons:

Process Journal:

Lines

Add G/L Journal lines. Each line corresponds to one G/L Journal entry.

Fields:

Accounting Combination:	An identification code comprised of an individual account number and additional dimensions such organization, product, and business partner.
Accounting Date:	The date this transaction is recorded in the general ledger.
Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Credit:	The amount credited to an account, converted to the organization default currency.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Currency Rate Type:	A distinct currency rate characteristic used for processes.
Debit:	The amount debited to an account, converted to the organization default currency.
Description:	A space to write additional related information.
Foriegn Currency Credit:	The amount credited from the account, given in provider currency.
Foriegn Currency Debit:	The amount debited from the account, given in provider currency.
Generated:	This Line is generated.
Journal Entry:	One transaction with a debit and credit and entered into the general ledger.
Journal Line:	General Ledger Journal Line.
Line No.:	A line stating the position of this request in the document.
Organization:	Organizational entity within client.
Quantity:	The number of a certain item.
Rate:	The percentage to be multiplied by the source to arrive at the tax or exchange amount.
UOM:	A non monetary unit of measure.

GL Posting by DB Tables

Recreate accounting information and add transactions for the General Ledger, grouped by defined database tables.

View larger

Reset Accounting

Delete all accounting records/information and set the status of all documents to "not-processed." They can then be re-created by running the accounting processes again.

View larger

Budget

Create budgets for a selected year to be used for informative purposes.

View larger

Header

Create budgets for a selected year to be used for informative purposes.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Budget:	A group of planned expenses for a task.
Budget Type:	x
Client:	Client for this installation.
Description:	A space to write additional related information.
Name:	An identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client.
Year:	Calendar Year.

Process Buttons:

Copy Budget:
Export Budget to Excel:

Lines

Add budget lines. Each line may refer to a specified period, business partner, product, etc.

Fields:

Accounting Combination:	An identification code comprised of an individual account number and additional dimensions such organization, product, and business partner.
Active:	A flag indicating whether this record is available for use or de-activated.
Activity:	A distinct activity defined and used in activity based management.
Amount:	A monetary total.
Budget:	A group of planned expenses for a task.
Budget line:
Business Partner :	Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Business Partner Category:	A classification of business partners based on defined similarities.
Client:	Client for this installation.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Organization:	Organizational entity within client
Period:	A specified time period.
Price:	The cost or value of a good or service.
Product:	An item produced by a process.
Product Category:	A classification of items based on similar characteristics or attributes.
Project:	A defined task or undertaking
Quantity:	The number of a certain item.
Sales Campaign:	An advertising effort aimed at increasing sales.
Sales Region:	A defined section of the world where sales efforts will be focused.
Sequence:	The order of records in a specified document.
Trx Organization:	The organization which performs or initiates the transaction.
UOM:	A non monetary unit of measure.
1st Dimensinon:	A display of optional elements that are previously defined for this account combination.
2nd Dimension:	A display of optional elements that are previously defined for this account combination.

Create Budget Report in Excel

Create a structured excel file to import your budgets to the application.

Setup

Fiscal Calendar

Create multiple fiscal calendars and periods for accounting purposes.

View larger

Calendar

Create multiple fiscal calendars to be used by one or all your organizations.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Calendar:	A table showing the days of the week for each month of the year.
Client:	Client for this installation.
Description:	A space to write additional related information.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client

Non Business Day

Define non business days for a selected fiscal calendar.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Calendar:	A table showing the days of the week for each month of the year.
Client:	Client for this installation.
Date:	Date when business is not conducted
Name:	A identifier for a document which can be used as a search tool.
Non Business Day:	Day on which business is not transacted
Organization:	Organizational entity within client

Period

Create and edit fiscal periods according to your needs, as well as open/close selected periods.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Ending Date:	A parameter stating when a specified request will end.
Name:	A identifier for a document which can be used as a search tool.
Open/Close All:	Open/Close all Base Document Types for this Period
Organization:	Organizational entity within client
Period:	A specified time period.
Period No:	Unique Period Number
Period Type:	Period Type
Start Date:	A parameter stating when a specified request will begin.
Year:	Calendar Year

Period Control

Add and edit document types to be included in the accounting process during the selected fiscal period.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Document Category:	A classification of document types that are shown and processed in the same window.
Open/Close:
Organization:	Organizational entity within client
Period:	A specified time period.
Period Action:	Action taken for this period
Period Control:	Period Control
Period Status:	Current state of this period

Year

Create fiscal years with the possibility of automatically adding fiscal periods.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Calendar:	A table showing the days of the week for each month of the year.
Client:	Client for this installation.
Create Periods :	Create 12 standard calendar periods (Jan-Dec)
Create Reg Fact Acct:
Description:	A space to write additional related information.
Drop Reg Fact Acct:
Fiscal Year:	Calendar Year
Organization:	Organizational entity within client
Year:	Calendar Year

Account Tree

Create and edit account elements and add them to your defined chart of accounts or account trees.

View larger

Customized Elements

Edit elements and add or subtract them according to your needs.

Fields:

Account:	The identification code used for accounting.
Account Element:	A identification code for an account type.
Active:	A flag indicating whether this record is available for use or de-activated.
C_Elementvalue_Operand_ID:	Element value operand
Client:	Client for this installation.
Organization:	Organizational entity within client
Sequence:	The order of records in a specified document.
Sign:	Sign

Element

Create account elements structures to be used in the accounting schema.

Fields:

Accounting Element:	A unique identifier for an account type.
Active:	A flag indicating whether this record is available for use or de-activated.
Additional Tree (1):	For parallel Reporting
Additional Tree (2):	For parallel Reporting
Balancing:	All transactions within an element value must balance (e.g. cost centers)
Client:	Client for this installation.
Description:	A space to write additional related information.
Name:	A identifier for a document which can be used as a search tool.
Natural Account:	The primary natural account
Organization:	Organizational entity within client
Tree:	Identifies a Tree
Type:	A distinct item characteristic used for processes and sometimes grouped within a category.
Value Format:	Value Format

Element Value

Add and edit elements and edit elements tree structures.

Fields:

Account Element:	A identification code for an account type.
Account Sign:	Indicates the Natural Sign of the Account as a Debit or Credit
Account Type:	Indicates the type of account
Accounting Element:	A unique identifier for an account type.
Active:	A flag indicating whether this record is available for use or de-activated.
Bank Account:	A monetary account of funds held in a recognized banking institution.
Bank Account:	A monetary account of funds held in a recognized banking institution.
Client:	Client for this installation.
Currency:	An accepted medium of monetary exchange that may vary across countries.
Description:	A space to write additional related information.
Document Controlled:	Control account - If an account is controlled by a document, you cannot post manually to it
Element Level:	Element Level
Foreign Currency Account:	Balances in foreign currency accounts are held in the nominated currency
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Post Actual:	Actual Values can be posted
Post Budget:	Budget values can be posted
Post Encumbrance:	Post commitments to this account
Post Statistical:	Post statistical quantities to this account?
Search Key:	A fast method for finding a particular record.
Show element:	Show element
Show Value Condition:	Show Value Condition
Summary Level:	A means of grouping fields in order to view or hide additional information.
Valid from Date:	A parameter stating the starting time of a specified request.
Valid until Date:	A parameter stating the ending time of a specified request.

Accounting Dimension

Create and edit accounting dimensions to be used in dimensional reports.

View larger

Activity Dimension

Maintain Acitivity Accounting Dimension Tree

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Activity:	A distinct activity defined and used in activity based management.
Client:	Client for this installation.
Description:	A space to write additional related information.
Help/Comment:	A comment that adds additional information to help users work with fields.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Search Key:	A fast method for finding a particular record.
Summary Level:	A means of grouping fields in order to view or hide additional information.

Business Partner Dimension

Create and edit business partner dimensions to be used in the dimensional reports.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Business Partner :	Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Client:	Client for this installation.
Description:	A space to write additional related information.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Search Key:	A fast method for finding a particular record.
Summary Level:	A means of grouping fields in order to view or hide additional information.

Campaign Dimension

Maintain Marketing Campaign Accounting Dimension Tree

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Channel:	Sales Channel
Client:	Client for this installation.
Costs:	Costs in accounting currency
Description:	A space to write additional related information.
Ending Date:	A parameter stating when a specified request will end.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Sales Campaign:	An advertising effort aimed at increasing sales.
Search Key:	A fast method for finding a particular record.
Start Date:	A parameter stating when a specified request will begin.

Organization Dimension

Create and edit organizational dimensions to be used in the dimensional reports.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Description:	A space to write additional related information.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Search Key:	A fast method for finding a particular record.
Summary Level:	A means of grouping fields in order to view or hide additional information.

Product Dimension

Create and edit products dimensions to be used in the dimensional reports.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Attribute Set:	A group of attributes which are assigned to a selected product.
Attribute Set Value:	An attribute associated with a product as part of an attribute set.
Bill of Materials:	Bill of Materials
Classification:	Classification for grouping
Client:	Client for this installation.
Comments:	A space to write additional related information.
Description:	A space to write additional related information.
Description URL:	An address for the product description which can be accessed via internet.
Discontinued:	A statement mentioning that this product will no longer be available on the market.
Discontinued by:	The name of the person who discontinues an item.
Download URL:	URL of the Download files
Expense Type:	Expense report type
Freight Category:	A classification used to help calculate shipping company freight amounts.
Guarantee Days:	Number of days the product is guaranteed or available
Help/Comment:	A comment that adds additional information to help users work with fields.
Image URL:	An address for the product image which can be accessed via internet.
Mail Template:	A template used to organize and send mail using a standard format.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Print detail records on invoice :	Print detail BOM elements on the invoice
Print detail records on pick list:	Print detail BOM elements on the pick list
Product:	An item produced by a process.
Product Category:	A classification of items based on similar characteristics or attributes.
Product Type:	An important classification used to determine the acc