Product Update 405: Changes to Cartea mare report (Romanian legislation)
Cartea mare is a legal report used in Romania that is printed on a monthly basis, and all the financial transactions recorded in the ledger accounts are available in this report. In this product update, several changes have been made to the Cartea mare report (at Finance à Romanian reports à Big book) for the Romanian legislation, such as the following:
- All the entries will be displayed in the report.
- The financial transaction will be identified by the same our reference information.
- Storno entries will be supported. The display of amounts will be dependent on the general ledger balance definition, such as debit, credit, and none. For example, a negative sign will be used to depict the debit balance of the general ledger with a credit balance definition such as revenue general ledger and other general ledgers.
- The amounts in the report will be grouped by period and quarter.
- The Financial year field has been added under the Date section in the Finance / Romanian reports / Big book screen.
Example 1: Sales invoice
Sales invoice entry:
|
GL |
Debit |
Credit |
|
Debtor GL 1300 |
1,200.00 |
|
|
Revenue GL 8000 |
|
1,000.00 |
|
VAT to pay GL 1503 |
|
200.00 |
The Cartea mare report will display the following results in the general ledger accounts.
Debtor GL 1300:
|
Offset GL
Period |
1503 |
8000 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
200.00
0.00 |
1,000.00
0.00 |
1,200.00
|
0.00 |
1,200.00 |
|
|
Total pe trim. |
200.00
0.00 |
1,000.00
0.00 |
1,200.00
|
0.00 |
1,200.00 |
|
Total rulaj. |
200.00
0.00 |
1,000.00
0.00 |
1,200.00
|
0.00 |
1,200.00 |
Revenue GL 8000:
|
|
Offset GL
Period |
1300 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
1,000.00 |
0.00
|
1,000.00 |
-1,000.00 |
|
|
Total pe trim. |
0.00
1,000.00 |
0.00
|
1,000.00 |
-1,000.00 |
|
Total rulaj. |
0.00
1,000.00 |
0.00
|
1,000.00 |
-1,000.00 |
VAT to pay GL 1503:
|
Offset GL
Period |
1300 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
200.00 |
0.00
|
200.00 |
-200.00 |
|
|
Total pe trim. |
0.00
200.00 |
0.00
|
200.00 |
-200.00 |
|
Total rulaj. |
0.00
200.00 |
0.00
|
200.00 |
-200.00 |
Example 2: Sales invoice with return
Sales invoice entry with returns:
|
GL |
Debit |
Credit |
|
Debtor GL 1300 |
1,200.00 |
|
|
Revenue GL 8000 |
|
1,200.92 |
|
VAT to pay GL 1503 |
|
108.08 |
|
Rev. Returns GL 8010 |
|
-100.00 |
|
VAT to pay GL 1503 |
|
-9.00 |
The Cartea mare report will display the following results in the general ledger accounts.
Debtor GL 1300:
|
Offset GL
Period |
1503 |
8000 |
8010 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
99.08
0.00 |
1,200.92
0.00 |
-100.00
0.00 |
1,200.00
|
0.00 |
1,200.00 |
|
|
Total pe trim. |
99.08
0.00 |
1,200.92
0.00 |
-100.00
0.00 |
1,200.00
|
0.00 |
1,200.00 |
|
Total rulaj. |
99.08
0.00 |
1,200.92
0.00 |
-100.00
0.00 |
1,200.00
|
0.00 |
1,200.00 |
Revenue GL 8000:
|
Offset GL
Period |
1300 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
1,200.92 |
0.00
|
1,200.92 |
-1,200.92 |
|
|
Total pe trim. |
0.00
1,200.92 |
0.00
|
1,200.92 |
-1,200.92 |
|
Total rulaj. |
0.00
1,200.92 |
0.00
|
1,200.92 |
-1,200.92 |
Revenue GL 8010:
|
Offset GL
Period |
1300 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
-100.00 |
0.00
|
-100.00 |
100.00 |
|
|
Total pe trim. |
0.00
-100.00 |
0.00
|
-100.00 |
100.00 |
|
Total rulaj. |
0.00
-100.00 |
0.00
|
-100.00 |
100.00 |
VAT to pay GL 1503:
|
Offset GL
Period |
1300 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
99.08 |
0.00
|
99.08 |
-99.08 |
|
|
Total pe trim. |
0.00
99.08 |
0.00
|
99.08 |
-99.08 |
|
Total rulaj. |
0.00
99.08 |
0.00
|
99.08 |
-99.08 |
Example 3: Fulfillment
Fulfillment entry:
|
GL |
Debit |
Credit |
|
COGS GL 5203 |
396.00 |
|
|
Stock GL 2002 |
|
396.00 |
|
COGS GL 2006 |
222.00 |
|
|
Stock GL 0500 |
|
222.00 |
|
COGS GL 2006 |
35.00 |
|
|
Stock GL 0410 |
|
35.00 |
The Cartea mare report will display the following results in the general ledger accounts.
COGS GL 5203:
|
|
Offset GL
Period |
2002 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
396.00
0.00 |
396.00
|
0.00 |
396.00 |
|
|
Total pe trim. |
396.00
0.00 |
396.00
|
0.00 |
396.00 |
|
Total rulaj. |
396.00
0.00 |
396.00
|
0.00 |
396.00 |
Stock GL 2002:
|
Offset GL
Period |
5203 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
396.00 |
0.00
|
396.00 |
-396.00 |
|
|
Total pe trim. |
0.00
396.00 |
0.00
|
396.00 |
-396.00 |
|
Total rulaj. |
0.00
396.00 |
0.00
|
396.00 |
-396.00 |
COGS GL 2006:
|
|
Offset GL
Period |
0500 |
0410 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
222.00
0.00 |
35.00
|
257.00
|
0.00 |
257.00 |
|
|
Total pe trim. |
222.00
0.00 |
35.00
|
257.00
|
0.00 |
257.00 |
|
Total rulaj. |
222.00
0.00 |
35.00
|
257.00
|
0.00 |
257.00 |
Stock GL 0500:
|
|
Offset GL
Period |
2006 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
222.00 |
0.00
|
222.00 |
-222.00 |
|
|
Total pe trim. |
0.00
222.00 |
0.00
|
222.00 |
-222.00 |
|
Total rulaj. |
0.00
222.00 |
0.00
|
222.00 |
-222.00 |
Stock GL 0410:
|
|
Offset GL
Period |
2006 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
35.00 |
0.00
|
35.00 |
-35.00 |
|
|
Total pe trim. |
0.00
35.00 |
0.00
|
35.00 |
-35.00 |
|
Total rulaj. |
0.00
35.00 |
0.00
|
35.00 |
-35.00 |
Example 4: Reversal
Reversal entry:
|
GL |
Debit |
Credit |
|
Creditor GL 1600 |
|
-1,000.00 |
|
Expense GL 4000 |
-1,000.00 |
|
The Cartea mare report will display the following results in the general ledger accounts.
Creditor GL 1600:
|
Offset GL
Period |
4000 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
-1,000.00 |
0.00
|
-1,000.00 |
1,000.00 |
|
|
Total pe trim. |
0.00
-1,000.00 |
0.00
|
-1,000.00 |
1,000.00 |
|
Total rulaj. |
0.00
-1,000.00 |
0.00
|
-1,000.00 |
1,000.00 |
Expense GL 4000:
|
|
Offset GL
Period |
1600 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
-1,000.00
0.00 |
-1,000.00
|
0.00 |
-1,000.00 |
|
|
Total pe trim. |
-1,000.00
0.00 |
-1,000.00
|
0.00 |
-1,000.00 |
|
Total rulaj. |
-1,000.00
0.00 |
-1,000.00
|
0.00 |
-1,000.00 |
Example 5: Closing entries
Sales invoice entry created in Period 4:
|
GL |
Debit |
Credit |
|
Debtor GL 1300 |
1,200.00 |
|
|
Revenue GL 8000 |
|
1,000.00 |
|
VAT to pay GL 1503 |
|
200.00 |
Sales credit note entry created in Period 5:
|
GL |
Debit |
Credit |
|
Debtor GL 1300 |
-2,400.00 |
|
|
Revenue GL 8000 |
|
-2,000.00 |
|
VAT to pay GL 1503 |
|
-400.00 |
The following closing entries will be generated per period:
|
Period |
GL |
Debit |
Credit |
|
4 |
Revenue GL 8000 |
1,000.00 |
|
|
4 |
Closing entries GL 121001 |
|
1,000.00 |
|
5 |
Revenue GL 8000 |
-2,000.00 |
|
|
5 |
Closing entries GL 121001 |
|
-2,000.00 |
In the Cartea mare report, the balance definition for the closing entries in the general ledger will be taken into account when displaying the results in the report. The default general ledger closing entries can be defined at General ledger settings à Year-end closing process à Result. If the general ledger is defined, the first 3 digits will be used to identify the closing general ledger. Otherwise, the system will check the general ledger starting with the number “121”.
The Cartea mare report will display the following results in the general ledger accounts.
Debtor GL 1300:
|
|
Offset GL
Period |
1503 |
8000 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
200.00
0.00 |
1,000.00
0.00 |
1,200.00
|
0.00 |
1,200.00 |
|
|
5 |
-400.00
0.00 |
-2,000.00
0.00 |
-2,400.00
|
0.00 |
-2,400.00 |
|
|
Total pe trim. |
-200.00
0.00 |
-1,000.00
0.00 |
-1,200.00
|
0.00 |
-1,200.00 |
|
Total rulaj. |
-200.00
0.00 |
-1,000.00
0.00 |
-1,200.00
|
0.00 |
-1,200.00 |
VAT to pay GL 1503:
|
Offset GL
Period |
1300 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
200.00 |
0.00
|
200.00 |
-200.00 |
|
|
5 |
0.00
-400.00 |
0.00
|
-400.00 |
400.00 |
|
|
Total pe trim. |
0.00
-200.00 |
0.00
|
-200.00 |
200.00 |
|
Total rulaj. |
0.00
-200.00 |
0.00
|
-200.00 |
200.00 |
Revenue GL 8000:
|
Offset GL
Period |
1300 |
121001 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
1,000.00 |
0.00
-1,000.00 |
0.00
|
0.00 |
0.00 |
|
|
5 |
0.00
-2,000.00 |
0.00
2,000.00 |
0.00
|
0.00 |
0.00 |
|
|
Total pe trim. |
0.00
-1,000.00 |
0.00
1,000.00 |
0.00
|
0.00 |
0.00 |
|
Total rulaj. |
0.00
-1,000.00 |
0.00
1,000.00 |
0.00
|
0.00 |
0.00 |
Closing GL 121001:
|
Offset GL
Period |
8000 |
Total
Debit |
Total
Credit |
Total balance |
|
Trim. 2 |
4 |
0.00
1,000.00 |
0.00
|
1,000.00 |
1,000.00 |
|
|
5 |
0.00
-2,000.00 |
0.00 |
-2,000.00 |
-2,000.00 |
|
|
Total pe trim. |
0.00
-1,000.00 |
0.00
|
-1,000.00 |
-1,000.00 |
|
Total rulaj. |
0.00
-1,000.00 |
0.00
|
-1,000.00 |
-1,000.00 |
| Main Category: |
Support Product Know How |
Document Type: |
Release notes detail |
| Category: |
Release Notes |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
23.670.980 |
| Assortment: |
Exact Globe
|
Date: |
10-05-2017 |
| Release: |
405 |
Attachment: |
|
| Disclaimer |
|
|