User Manual 2.40/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 Tax Payment 1.1.2.1 Header 1.1.2.2 Tax Register Header 1.1.2.3 Lines 1.1.3 Cash Journal 1.1.3.1 Header 1.1.3.2 Lines 1.1.4 Funds Transfer 1.1.5 Remittance 1.1.5.1 Header 1.1.5.2 Lines 1.1.6 Payment Status Management 1.1.6.1 Header 1.1.6.2 Lines 1.1.7 Manual Settlement 1.1.7.1 Manual Settlement 1.1.7.2 Created Payment 1.1.7.3 Balance Payment 1.1.7.4 Balance Payment Replacement 1.1.8 Settlement 1.1.8.1 Cancelled Payments 1.1.8.2 Created Payments 1.1.8.3 Settlement 1.1.9 Remittance Cancellation/Return 1.1.10 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 Tax Register Type 1.2.4.1 Tax Register Type 1.2.4.2 Lines 1.2.5 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

Tax Payment

Tax Payment where put the payment of tax and in where tax register is recorded.

View larger

Header

Add cash transactions performed by the company.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Accounting schema:	An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar.
Business Partner:	Refers to whom tax register is paid, normally government
Client:	Client for this installation.
Create Vat Registers:	Process that creates registers and register lines from invoices.
Ending Date:	The Date To indicates the end date of a range
Generate Payment:	The Generate Payment flag indicates whether a payment for this registers will be generated or not.
Journal Entry:	The General Ledger Journal identifies a group of journal lines which represent invoice tax entries cancellation.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Starting Date:	The Date From indicates the starting date of a range.
Settlement:	Document containing the payment for this tax payment
TaxPayment Post:	Post the TaxPayment.

Tax Register Header

Each line represents one particular register type.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Last Register Amount:	Amount of last register.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Page No.:	Starting page number for the report.
Tax Payment:	Tax payment.
Tax Register Type:	Tax Register Type.
Tax Total Amount:	Total amount of the lines.

Lines

Each line represents one invoice tax line contained in this register type.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Document No.:	Invoice document No.
Exempt Amount.:	No taxable amount.
Invoice Tax:	Origin invoice tax.
Invoice Date:	Origin invoice date
Name:	A more descriptive identifier.
No VAT Amount:	No VAT Amount.
Name:	A more descriptive identifier.
Name:	A more descriptive identifier.
Organization:	Organizational entity within client
Tax:	The Tax indicates the type of tax for this line.
Taxable Amount:	The Tax Base Amount indicates the base amount used for calculating the tax amount.
Tax Amount:	The Tax Amount displays the total tax amount for a document.
Tax Payment:	Tax payment.
Tax Register:	Tax Register.
Total Amount:	The Total Amount indicates the total document amount.
Undeductable Amount:	Tax Undeductable Amount.

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 Code:	Code of the bank (Mandatory only for previous bank account encoding).
BIC code:	Bank International Code. Also known as Swift Code (Society of Worldwide Interbank Financial Telecommunications)
Branch Code:	Code of the branch (Mandatory only for previous bank account encoding).
Business Partner :	Each bank can have a business partner in the system, with more information about the bank.
Client:	Client for this installation.
Control Digit:	Digit control (Mandatory only for previous bank account encoding).
Country:	If the bank specifies an international bank account number (IBAN), the country of the bank must be specified.
INE Number:	INE Number.
Location / Address:	Address where bank is located.
Name:	Name of the Bank
Organization:	Organizational entity within client

Account

Create and edit bank accounts for a selected bank.

Fields:

Account Type:	Whether the bank account is a checkings or a savings account.
Active:	A flag indicating whether this record is available for use or de-activated.
Bank:	Bank to which this bank account belongs to.
Client:	Client for this installation.
Control Digit:	Control Digit (Mandatory only for previous bank account encoding). If filled in, bank code, branch code and control digit must be indicated in the Bank tab.
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.
Displayed Account:	Aspect that this bank account will have when showed anywhere in the application.
Generic Account:	Account code in a free format.
IBAN:	International Bank Account Number. If filled in, bank country must be indicated in the Bank tab.
Organization:	Organizational entity within client
Partial Account No:	Partial Account Number (Mandatory only for previous bank account encoding). If filled in, bank code, branch code and control digit must be indicated in the Bank tab.
Show Generic:	A flag indicating that this bank account will be shown in an Generic format, using the bank account code contained in the Generic Account textbox.
Show IBAN:	A flag indicating that this bank account will be shown in an IBAN format, using the bank account code contained in the IBAN textbox, and checking that honors the IBAN control check.
Show Spanish:	A flag indicating that this bank account will be shown in an Spanish format, using the bank account code contained in the Partial Account No. textbox, and checking that Control Digits are ok.

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

Tax Register Type

Create and edit tax register types with corresponding lines according to your business needs.

View larger

Tax Register Type

Create and edit tax register types.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Name:	A identifier for a document which can be used as a search tool.
Organization:	Organizational entity within client
Description:	A description is limited to 255 characters.
Sales Transaction:	The Sales Transaction checkbox indicates if this item refers to Sales Transactions.
Help / Comment:	The Help field contains a hint, comment or help about the use of this item.
G/L Item:	General ledger item relate to this register type.

Lines

Add lines to this tax register type to indicate tax rates and document types included.

Fields:

Active:	A flag indicating whether this record is available for use or de-activated.
Client:	Client for this installation.
Organization:	Organizational entity within client
Tax Register Type:	Type of Tax Register
Tax:	The Tax indicates the tax rate for this register type.
Document Type:	Invoice document type in which system will look for taxes.

Promissory Note Format

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

View larger

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 way 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 setup 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.
Foreign Currency Credit:	The amount credited from the account, given in provider currency.
Foreign 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.
Export Actual Data:	A flag indicating whether the actual data should be also exported.

Process Buttons:

Copy Budget:'Create a new budget, copying data of the selected one.'
Export Budget to Excel:'Export Budget data to a spreadsheet.'

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.	</