Microsoft® Business Solutions–Navision® 4.

Financial Series I Extension for Poland

Corresponding Global Course:

Financial Series I, Course#: 8384A

Page 1
Microsoft Navision Financial Series I

Table of Contents
Module: VAT & Intrastat 3
Section 1: VAT Entries and Detailed VAT Entries ................................................. 5
Section 2: Sales Date / Purchase Document Receipt Date and VAT
Settlement Date Fields .......................................................................................... 7
Section 3: VAT Application Worksheet................................................................ 10
Section 4: Use VAT Application Worksheet to Realize, Hold and Post
Additional VAT Amounts ..................................................................................... 13
Section 5: Set up PKWiU Code and VAT Registration No. ................................. 16
Section 6: Use General Journal to Post VAT Invoices ........................................ 18
Section 7: Create and Post Internal Invoices ...................................................... 20
Section 8: VAT Register Report .......................................................................... 27
Section 9: VAT EU Statement ............................................................................. 32
Test Your Skills ................................................................................................... 35
Test Your Skills Solutions.................................................................................... 36
Module: General Ledger 39
Section 1: Bank Statements Posting and Reporting............................................ 39
Section 2: Bank Reports Closing and Printing..................................................... 43
Section 3: Open Closed Bank Reports................................................................ 45
Section 4: Petty Cash Operations Posting and Reporting................................... 46
Test Your Skills ................................................................................................... 49
Test Your Skills Solutions.................................................................................... 50
Module: Receivables Management 51
Section 1: Multiple Interests Rates Setup............................................................ 51
Section 2: Customer Confirmation Report........................................................... 56
Test Your Skills ................................................................................................... 61
Test Your Skills Solutions.................................................................................... 62
Module: Payables Management 63
Section 1: Vendor Confirmation Report............................................................... 63
Section 2: Vendor – Summary Aging Report....................................................... 64

Page 2
 Module: Vat & Intrastat

MODULE: VAT & INTRASTAT

The Polish VAT law allows the VAT settlement date to be different from the
sales or purchase invoice posting date. The VAT rate for sales and purchase
invoice can change in particular circumstances. If during the posting
procedure VAT can not be qualified as sales or purchase VAT, it should be
reported as On Hold VAT. As a result, you can report the VAT amount in
General Ledger on the accounts that are different from the standard VAT
accounts.

In some cases the VAT rate can change from for example 0 % rate to base
VAT rate for sales invoice. It concerns the situation when you have to post
VAT amount for sales invoice with non 0% VAT rate because you cannot
prove that you have delivered the sold goods to an EU vendor in time
required by tax authorities. When you can prove that the goods are delivered
to an EU vendor you can subtract sales VAT from the posted VAT amount.

VAT Setup

In order to post VAT in Navision Poland 4.0 you have to set up accounts and
VAT rates. Open FINANCIAL MANAGEMENT Æ SETUP Æ VAT POSTING
GROUP Æ POSTING SETUP and fill in the necessary fields.

Field Definition
VAT Bus. Posting Group Enter vendor or supplier VAT posting group.
VAT Prod. Posting Group Enter product VAT posting group.
PKWiU Mandatory If you mark this field for combination of the
VAT Business Posting Group and the VAT
Product Posting Group, the program will
check this combination if the PKWiU field
is filled in when posting purchase or sales
invoice. The PKWiU field is usually used
for the VAT rates that are different from the
base VAT rate.

Page 3
Microsoft Navision Financial Series I

VAT Registration No. If you mark this field for combination of the
Mandatory VAT Business Posting Group and the VAT
Product Posting Group, the program will
check this combination if the VAT
Registration No. field is filled in when
posting purchase or sales invoice.
Sales On Hold VAT Account Enter an account as On Hold VAT Account
for sale invoices. The sales VAT amount is
posted on this account instead of the
standard sales VAT account where the VAT
settlement is temporarily held.
Purch. On Hold VAT Account Enter an account as On Hold VAT Account
for purchase invoices. The purchase VAT
amount is posted on this account instead of
the standard purchase VAT account where
the VAT settlement is temporarily held.

Page 4
 Module: VAT & Intrastat

Section 1: VAT Entries and Detailed VAT Entries

In this section you will learn about the concepts VAT entries and detailed
VAT entries.

In order to understand the VAT entries and detailed VAT entries concepts
you have to analyze VAT entries fields.

Open FINANCIAL MANAGEMENTÆHISTORYÆREGISTERS. The G/L

Registers window appears. Click the Register button and then the VAT
Entries. The VAT Entries window appears.

Field Definition
Posting Date Shows the document posting date.
Purch.Doc.Receipt/Sale It is the document receipt date for purchase invoice
Date or sale date for sales invoice.
VAT Settlement Date Shows the VAT settlement date with tax
authorities. It can be different from the document
posting date.
Skip in VAT Register If you select this field the program will skip this
entry in the Sale/Purchase VAT Register report.
VAT Base Shows the VAT base amount, which is the account
for tax authorities.
VAT Amount Shows the VAT amount, which is the amount for
tax authorities.
On Hold VAT Base Shows the On Hold VAT base amount. That amount
is posted on the account which is different from the
standard General Ledger VAT account and is not
amount for tax authorities at the moment. This field
is only used for temporary situation.
On Hold VAT Amount Shows the On Hold VAT amount. That amount is
posted on the account which is different from the
standard General Ledger VAT account and is not
amount for tax authorities at the moment. This field
is only used for temporary situation.

Page 5
Microsoft Navision Financial Series I

The On Hold VAT Base and On Hold VAT Amount fields are specific in
Navision Poland 4.0. When VAT is held on during document posting, these
two additional fields show values. When you click them the Detailed VAT
Entries window appears.

The Detailed VAT Entries window shows changes of VAT amounts: On

Hold VAT Amount, VAT Amount, On Hold VAT Base and VAT Base for
one VAT entry.

Note: More about On Hold VAT Base, VAT Base you will learn in section 3
of this module: VAT Application Worksheet.

Page 6
 Module: VAT & Intrastat

Section 2: Sales Date / Purchase Document Receipt Date

and VAT Settlement Date Fields
In this section you will learn how Sales Date / Purchase Document Receipt
Date and VAT Settlement Date fields work.

The VAT tax is settled with tax authorities with the VAT settlement date. The
VAT Settlement Date is the same as the sales date in the sales case. In the
purchase case the VAT Settlement Date is the receipt purchase invoice date.

On the sales and purchase invoices the VAT Settlement Date field is hidden,
but by the default, the value of the VAT Settlement Date field in the Sales
Invoice document is the same as the Sales Date field. In the Purchase
Invoice document, the default value of the VAT Settlement Date is the same
as the Purchase Document Receipt Date field. Thus you have to fill in
manually the Sales Date and the Purchase Document Receipt Date fields.

In some cases the values in the Sales Date/Purchase Document Receipt

Date and the VAT Settlement Date are not the same. In this case you have
to use the VAT Application Worksheet.

Note: More about how to use the VAT Application Worksheet you will learn
in section 3 of this module: VAT Application Worksheet.

Sales Date and VAT Settlement Date Fields

The example shows how the Sales Date and the VAT Settlement Date fields
work. The example is prepared for sales invoice case. You can use the same
procedure for purchase invoice, but instead of the Sales Date field, there is
the Purchase Document Receipt Date field.

Click SALES&MARKETINGÆORDER PROCESSINGÆINVOICES.

Page 7
Microsoft Navision Financial Series I

The Sales Invoice window appears.

When you fill in sales invoice fields you can post it. The Sales Date field will
be copied to the VAT Settlement Date field. You can change the VAT
Settlement Date in the VAT Application Worksheet.

Note: More about how to change the VAT Settlement Date you will learn in
section 3 of this module: Learn How to Use VAT Application Worksheet.

Purchase Document Receipt Date and VAT Settlement

Date Fields

The example shows how the Purchase Document Receipt and the VAT
Settlement Date fields work. The example is prepared for purchase invoice
case.

Click PURCHASEÆORDER PROCESSINGÆINVOICES.

Page 8
 Module: VAT & Intrastat

The Purchase Invoice window appears.

When you fill in purchase invoice fields you can post it. The Purch.
Document Receipt Date field value will be copied to the VAT Settlement
Date field. You can change the VAT Settlement Date value in the VAT
Application Worksheet.

Note: More about how to change the VAT Settlement Date you will learn in
section 3 of this module: VAT Application Worksheet.

Page 9
Microsoft Navision Financial Series I

Section 3: VAT Application Worksheet

In this section you will learn how to use the VAT Application Worksheet.

In the VAT Application Worksheet you can manage VAT and On Hold
VAT for purchase and sale invoices. You can also change the VAT
Settlement Date value for the VAT entry. There is a possibility to suspend
settlement VAT with tax authorities by using the On Hold VAT functionality.
In this case the VAT base and amount are posted on the accounts that are
different from the standard VAT accounts.

The VAT Application Worksheet window is placed in FINANCIAL

MANAGEMENT Æ GENERAL LEDGER Æ PERIODIC
ACTIVITIESÆVATÆVAT APPLICATION WORKSHEET. The VAT
Application Worksheet window appears.

You can choose entries by setting filters.

Field Definition
Type Filter Select invoice type filter. Available values:
Purchase and Sale. The program will use both to
filter the entries in the window.
Posting Date Filter Enter the invoice posting date or date range the
program will use to filter the entries in the
window.
Purchase Doc. Enter the sales date for sales invoices or
Receipt/Sale Date Filter purchase document receipt date for purchase
invoices the program will use to filter the entries
in the window.
VAT Settlement Date Enter the settlement date or range the program
Filter will use to filter the entries in the window.
Skip in VAT Register If you select this field the program will show

Page 10
 Module: VAT & Intrastat

Field Definition
Filter only entries with marked Skip in the VAT
Register field.
Document Type Filter Enter the document type the program will use to
filter the entries in the window.
VAT Bus. Posting Group Select the VAT Bus. Posting Group the
Filter program will use to filter the entries in the
window.
VAT Prod. Posting Group Select the VAT Prod. Posting Group the
Filter program will use to filter the entries in the
window.

The VAT Application Worksheet window shows VAT entries filtered and
grouped by document number. VAT entries contain:

Field Definition
Document No. Shows the document number of the VAT entry.
Posting Date Shows the VAT entry’s posting date.
Document Type Shows the document type that the VAT entry
belongs to.
Purch. Doc. Receipt/Sale It is the document receipt date for purchase
Date invoice or sale date for sales invoice.
VAT Settlement Date By default it is the same as Purch. Doc.
Receipt/Sale Date. In some cases Settlement
Date has to be different, so you can enter it
manually.
Hold VAT If this field is marked, VAT base amount and
VAT amount are placed in On Hold VAT Base
and On Hold VAT Amount fields instead of
VAT Base and VAT Amount. It means that
VAT amount and VAT base are posted on the
accounts which are different from standard
VAT accounts. The settlement with tax
authorities is suspended. In order to hold VAT
click FUNCTIONSÆHOLD VAT.
Skip in VAT Register If you mark this field the program will omit
entry in VAT register report. It is not
recommended to use it. Please use this field
carefully, because you can cause some problems
with settlement with tax authorities.
VAT Bus. Posting Group Shows the entry VAT Bus. Posting Group.
VAT Prod. Posting Group Shows the entry VAT Prod. Posting Group.
Type Shows the entry type: Purchase, Sale or
Settlement.
VAT Base Shows the entry VAT base amount.
VAT Amount Shows the entry VAT amount.
On Hold VAT Base Shows the entry amount of On Hold VAT base.
The value is greater than zero if you click

Page 11
Microsoft Navision Financial Series I

Field Definition
FUNCTIONSÆHOLD VAT. Then the Hold VAT
field is also marked.
On Hold VAT Amount Shows the entry amount of On Hold VAT. The
value is greater than zero if you click
FUNCTIONSÆHOLD VAT. Then the Hold VAT
field is also marked.

There are also aggregation fields on the bottom of the window.

Field Definition
VAT Base Shows the total VAT base amount of filtered
entries.
VAT Amount Shows the total VAT amount of filtered entries.
On Hold VAT Base Shows the total On Hold VAT base amount of
filtered entries.
On Hold VAT Amount Shows the total On Hold VAT amount of filtered
entries.

Page 12
 Module: VAT & Intrastat

Section 4: Use VAT Application Worksheet to Realize, Hold

and Post Additional VAT Amounts
Realize VAT Function

Select the entry with the Hold VAT field marked. It means that you hold on
VAT during sales or purchase invoice posting.

Note: More about holding VAT you will learn in section 2 of this module:
Sales Date/Purchase Document Receipt Date and VAT Settlement Date
Fields.

Now you can realize VAT by clicking the Functions button and then the
Realize VAT in the VAT Application Worksheet window. The Realize
VAT Posting window appears.

You have to enter a new posting date in the New VAT Settlement Date field.
If you click OK button VAT base and amount will be posted from the On
Hold VAT account to the standard VAT accounts.

Hold VAT Function

There are two possibilities to hold on VAT. The first one is described in the
section 2 of this module. The second one is available in the Application
Work Sheet window. Click the Functions and then the Hold VAT. The
Hold VAT Posting window appears.

Page 13
Microsoft Navision Financial Series I

The New VAT Settlement Date field is empty because the settlement with
tax authorities is suspended. The VAT amount will be posted from the
standard VAT account to the On Hold VAT account.

New VAT Entry Posting

You can add new VAT entry for existing document. In the Application
Work Sheet window click the Functions button and then the Post New
Entry VAT. The Full VAT Entry Post window appears.

Field Definition
Document No. The document number is filled in automatically.
External Document No. Enter the external document number.
Positing Date The invoice posting date if filled in
automatically.
Purch. Doc. Receipt/Sale Enter the document receipt date for purchase
Date invoice or sale date for sales invoice.
VAT Settlement Date The VAT settlement date is by default filled in
with posting date, but you can change it
manually.
VAT Bus. Posting Group Enter the business posting group for the vendor
or supplier.
VAT Prod. Posting Group Enter the VAT product posting group.
VAT % The VAT rate is filled in automatically from the
combination of the VAT Bus. Posting Group
and the VAT Prod. Posting Group fields.
VAT Amount Enter the VAT amount.
VAT Base Amount Enter the VAT base amount.
Bal. Account No. Enter the balancing account number.
VAT Registration No. Enter the VAT Registration number. It is
generally vendor or supplier NIP.

Page 14
 Module: VAT & Intrastat

The new entry VAT will be posted as full VAT. You can also define
dimensions. In the Full VAT Entry Post window click the Line button and
then the Dimensions.

Page 15
Microsoft Navision Financial Series I

Section 5: Set up PKWiU Code and VAT Registration No.

In this section you will learn how to use the mandatory PKWiU Code and
VAT Registration No. for specific VAT rates.

Open SALES&MARKETING Æ ORDER PROCESSING Æ INVOICES.

The Sales Invoice window appears. If you want to post an item with specific
VAT different from the basic VAT rate you have to fill in the PKWiU field.

If you want the PKWiU field to be filled in automatically open

SALES&MARKETINGÆINVENTORY&PRICINGÆITEMS. The Item Card
appears. On the Invoicing tab you have to fill in the PKWiU field.

In order to activate the program to check whether the PKWiU and the VAT
Registration No. fields are filled in, you have to open FINANCIAL
MANAGEMENTÆSETUPÆVAT POSTING GROUPÆPOSTING SETUP.
The VAT Posting Setup window appears. Check the PKWiU Mandatory
and the VAT Registration No. Mandatory fields.

Page 16
 Module: VAT & Intrastat

Then if PKWiU and VAT Registration No. fields are not filled in during
posting the Sales Invoice, the program will show an error message and stop
the posting process.

Page 17
Microsoft Navision Financial Series I

Section 6: Use General Journal to Post VAT Invoices

In this section you will learn how to use general journal in order to post VAT
invoices.

In cases of posting invoices from incidental vendors or customers or lack of

appropriate modules, you can use general journal. You have to create VAT
register report, which has detailed information for every VAT transaction
such as: vendor name, address, postal code, city and VAT registration no.
During posting in general journal you can add the detailed VAT transaction
information to the VAT Additional Info window.

VAT Invoices Posting

In order to post invoice using general journal open FINANCIAL

MANAGEMENT Æ GENERAL JOURNALS. The General Journal window
appears. You have to click the VAT Amount assist edit button. The VAT
Additional Info window appears.

You have to fill in the Purch. Doc. Receipt/ Sale Date field, the VAT
Settlement Date field, the External Document No. field and the VAT
Registration No. field. There are some vendors for whom you do not keep
cards; you can add their data in the VAT Contracting Parties window. Click
the VAT Registration No., the VAT Contracting Parties window appears.

Page 18
 Module: VAT & Intrastat

You have to fill in the fields:

Field Definition
VAT Registration No. Enter the vendor VAT registration no.
Name Enter the vendor name.
Address Enter the vendor address.
Post Code Enter the vendor postal code.
City Enter the vendor city.

You can post VAT invoice using Bank Report Journals and Cash Report
Journals in the similar way.

Page 19
Microsoft Navision Financial Series I

Section 7: Create and Post Internal Invoices

In this section you will learn how to create and post internal invoices.

When you buy products from one of the European Union countries you have
to create internal invoice. It is similar to purchase invoice and can concern
one or more purchase invoices. Internal invoice is prepared in companies in
order to calculate VAT for Intra-European trade specifically purchasing.

Internal invoice is a document required by tax authority in Poland. Internal

invoice is usually posted as follows: purchase VAT is posted on credit, sales
VAT is posted on debit in general ledger accounts.

In some cases, if you do not accomplish all required conditions, you have
post sales VAT on one of your cost accounts.

You can only create internal invoices for the vendors with the EU Country
Code filled in.

On the basis of internal invoices you can create VAT Register report.

Note: More about creating VAT Register report you will learn in section 8 of
this module: VAT Register Report.

Set up Internal Invoices

Open PURCHASE Æ SETUP Æ PURCHASE & PAYABLES SETUP. The

Purchase & Payables Setup window appears.

On the Numbering tab you have to fill in fields:

• Internal Invoice Nos. - not posted invoice number,

Page 20
 Module: VAT & Intrastat

• Posted Internal Invoice Nos. - posted invoice number,

• Int. Credit Memo Nos. - not posted credit memo number,
• Posted Int. Credit Memo Nos. - posted credit memo number.

On the VAT EU tab fill in the VAT Bus. Posting Group EU field with the
business VAT posting group. For combination of the VAT business posting
group and the VAT product posting group you have to set VAT Calculation
Type to Full VAT value in the VAT Posting Setup window. The VAT Bus.
Posting Group EU field value will be used as the default VAT business
posting group during internal invoice posting. During the internal invoice
entry creation the VAT Bus. Posting Group EU field value and VAT
product posting group will show VAT purchase and VAT sales account
numbers.

Open ADMINISTRATION Æ GENERAL Æ COUNTRIES/REGIONS. The

Countries window appears.

Fill in the EU Country Code field with country code. If the EU Country
Code field is invisible you have to show it.

Open ADMINISTRATION Æ APPLICATION SETUP Æ PURCHASE Æ REPORT

SELECTIONS. The Report Selection - Purchase window appears.

In order to print internal invoices reports you have to:

Page 21
Microsoft Navision Financial Series I

• Fill in the Report Name field with Internal Invoice for Int. Invoice
Usage field value,
• Fill in the Report Name field with Test Internal Invoice for Int. Test
Usage field value,
• Fill in the Report Name field with Internal Credit Memo for Int. Cr.
Memo Usage field value.

Create and Post Internal Invoices

In order to create and post internal invoice open PURCHASE Æ ORDER

PROCESSING Æ INTERNAL INVOICE. The Internal Invoice window
appears.

The most important of the Internal Invoice header fields are:

Field Definition
No. The Internal Invoice document number.
Vendor No. Shows the number of the vendor. You have to
choose the number of the vendor from the
Vendor List windows. The Vendor List
window is available if you click the Vendor No.
field.
Vendor Name Shows vendor name. It is filled in automatically
when the Vendor No. is chosen.
Vendor address Shows vendor address. It is filled in
automatically when the Vendor No. is chosen.
Buy-from Post Code/City Shows vendor post code and city. It is filled in
automatically when the Vendor No. is chosen.
Vendor Country Code Shows vendor country code. It is filled in
automatically when the Vendor No. is chosen.

Page 22
 Module: VAT & Intrastat

Field Definition
Vendor VAT Registration Shows vendor VAT registration no. It is filled in
No. automatically when the Vendor No. is chosen.
Document Date Shows the Internal Invoice document creation
date.
Posting Date Shows the Internal Invoice document posting
date.
Purch. VAT Settlement Shows the Internal Invoice document VAT
Date settlement date.
VAT Bus. Posting Group Shows vendor VAT business posting group. It is
filled in automatically when the Vendor No. is
chosen.
Currency Code Shows vendor currency code. It is filled in
automatically when the Vendor No. is chosen.

The most important of the Internal Invoice entries fields are:

Field Definition
VAT Settlement Date Shows the entry’s VAT settlement date.
Factor Date Shows the date of exchange rate used in Internal
Invoice line to calculate the VAT Base Amount
and the VAT Amount fields. By default the
factor date is the same as the VAT Settlement
Date. The exchange rate will be taken from rate
of exchange table for the Factor Date field
value.
No. Shows the number of item or fixed asset.
Description Shows item or fixed asset description.
Currency Code Shows vendor’s currency code. Click the
Currency Code if you want to change the
currency exchange rate manually.
Original Doc. Type Shows the type of the original entry document.
Available values: Invoice, Credit Memo.
Original Doc. No. Shows the number of the original entry
document.
Unit Cost Shows the unit cost of the goods in vendor
currency.
Amount Shows the total amount of the goods in vendor
currency.
Empty VAT Purch. Group Shows the empty VAT purchase group.
VAT Base Amount (LCY) Shows the total VAT base amount of the goods
in Polish currency.
VAT Amount (LCY) Shows the total VAT amount of the goods in
Polish currency.
Sales VAT Account Shows the account number for sales VAT.
Purchase VAT Account Shows the account number for purchase VAT.

Page 23
Microsoft Navision Financial Series I

You can create the Internal Invoices in two ways. Firstly, you can use batch
job, which will create internal invoice from invoice or credit memo.
Secondly, you have to create internal invoice header manually first and then
you can use batch job to create lines from invoice or credit memo. There are
two batch jobs to create internal invoices from invoice or credit memo and
two batch jobs to create lines from invoice or credit memo.

You can use the batch jobs as follows:

1. Click FUNCTIONSÆCREATE INT. INV. FROM PURCH.

INVOICES button. The Create Int. Inv. from Invoice window
appears.

On the Vendor tab in the Create Int. Inv. from Invoice window
you can fill in vendor number in order to filter vendor.

On the Purch. Inv. Header you can filter posted invoices

numbers, invoice posting date and VAT settlement date.

On the Options tab in the Create Int. Inv. from Invoice

window you have to fill in the following fields:

Field Definition
Document Date Enter the new internal invoice
document creation date.
Posting Date Enter the new internal invoice
document posting date.
VAT Settlement Date Enter the new internal invoice VAT
settlement date.
New Int. Invoice for If you check this field, you will get
Purch. In. one internal invoice for one purchase
invoice.
Compress Lines If you check this field it will
compress lines.

If you click OK button you will create the Internal Invoice from
purchase invoices.

Page 24
 Module: VAT & Intrastat

2. Click FUNCTIONSÆCREATE INT. INV. FROM PURCH CR.

NOTES button. The Create Int. Inv. from Cr. Note window
appears.

The Create Int. Inv. from Cr. Note window is similar to the
Create Int. Inv. from Invoice window.

If you click OK button you will create the Internal Invoice from
purchase credit memo.

3. If you create internal invoice document header manually, you can

add new posted purchases entries.

You can also add new entries to the existing internal invoice
document.

Click FUNCTIONSÆCREATE LINES FROM PURCH INVOICES

button. The Create Int. Inv. Lines window appears.

On the Purch. Inv. Header tab in the Create Int. Inv. Lines
window you can filter posted purchase invoice number, purchase
invoice posting date and purchase invoice VAT settlement date.
If you click OK button you will add new entries to the existing
the Internal Invoice.

4. If you create internal invoice document header manually, you can

add new posted purchases credit memos.

You can add posted purchase credit memo entries to existing

internal invoice. The procedure is similar to adding new posted
purchases entries.

In order to post internal invoice you have to click POSTINGÆPOST button.

Page 25
Microsoft Navision Financial Series I

Create and Post Internal Credit Memos

In some cases you have to correct internal invoice document. In order to

correct internal invoice document you have to create and post internal credit
memo.

Open PURCHASE Æ ORDER PROCESSING Æ INTERNAL CREDIT MEMO.

The Internal Credit Memo window appears.

To create the new Internal Credit Memo press F3 and then you have to
choose the Vendor No. from the Vendor List window. Click the Vendor
No. field and the Vendor List window appears. The appropriate fields for
vendor will be automatically filled in. You have to fill in the Corr. Int.
Invoice No. field manually with posted internal invoice number. You can
choose posted internal invoice number from the Posted Internal Invoices
window. The Posted Internal Invoices window is available by clicking on
the Corr. Int. Invoice No. field. The entries in the Internal Credit Memo
are copied from appropriate posted internal invoice automatically.
If you post the internal credit memo document it will remove internal invoice.
You can also make changes on the Internal Credit Memo document.

In order to post changes in the Internal Credit Memo document click

POSTINGÆPOST button.

Page 26
 Module: VAT & Intrastat

Section 8: VAT Register Report

In this section you will learn about the VAT Register Report.

The VAT Register Report is the basic report to calculate purchase and sales
VAT amount periodically. The VAT Register Report shows the VAT base
amount, VAT amount and detailed information about customer and vendor
for every document. The VAT base amount and VAT amount are divided and
shown for particular VAT rates. It also shows the total VAT amount and
summed VAT amounts for every combination for VAT business posting
group and VAT product posting group.

The VAT Register Report can present VAT entries calculated by VAT
posting group or VAT identifier.

VAT Register Report

Open FINANCIAL MANAGEMENTÆGENERAL LEDGER Æ REPORTS Æ

POLAND Æ SALE/PURCHASE VAT REG. The Sale/Purchase VAT Reg.
window appears.

On the Vat Entry tab in the Sale/Purchase VAT Reg. window you can filter
entries by:

• VAT Settlement Date – you have to enter the date range you want to
filter entries,
• Purch. Doc. Receipt/Sale Date – you have to enter purchase
document receipt date for purchase document, sale date for sales
document,
• VAT Bus. Posting Group – select VAT Business Posting Group,
• VAT Prod. Posting Group – select VAT Product Posting Group,
• Document Type – select document type if you want to get report
only for one document type: invoices, payments, credit memo,
finance credit charge memo, reminder or refund,

Page 27
Microsoft Navision Financial Series I

• Document Signed – for credit memo document type the report will
have a sign field.

On the Options tab in the Sale/Purchase VAT Reg. window you can choose
the VAT Register Type from three available options:

• Sale – the Sale/Purchase VAT Reg. report will show only sales
documents,
• Purchase - the Sale/Purchase VAT Reg. report will show only
purchase documents,
• Sale and Purchase - the Sale/Purchase VAT Reg. report will show
sales and purchase documents.

On the Options tab in the Sale/Purchase VAT Reg. window you can also
choose how totals field values on the Sale/Purchase VAT Reg. report will be
created:

• Show Only Totals - if you mark it the Sale/Purchase VAT Reg.

report will show only calculations for each document,
• Show Related Documents - if you mark this field the Sale/Purchase
VAT Reg. report will show also related documents for each entry.

If you click the Print button, you will print the Sale/Purchase VAT Reg.
report. You preview the Sale/Purchase VAT Reg. report clicking on the
Preview button. The example report is shown below.

Page 28
 Module: VAT & Intrastat

The first page of the report is shown below:

The Sale/Purchase VAT Reg. report fields description:

Field Definition
Sales Date Shows the sales date, which is on the document.
VAT Settlement Date Shows the settlement date, which is on the
document.
Document Type Shows the document type e.g. invoice, credit
memo, etc.
VAT Registration No. Shows the VAT registration number of the
entry.
VAT Bus. Posting Shows the business posting group of the entry.
Group.
VAT Prod. Posting Shows the product posting group of the entry.
Group
VAT Identifier Shows the VAT Identifier of the entry e.g.
VAT22, VAT7.
VAT Base Shows the base VAT amount of the entry.
VAT Amount Shows the VAT amount of the entry.
Amount Incl. VAT Shows the amount including VAT of the entry.

Page 29
Microsoft Navision Financial Series I

The last page of the report:

The last page of the Sale/Purchase VAT Reg. report presents summed up
values for all entries and for combinations of VAT posting group and VAT
product posting group for the fields:

• VAT Base,
• VAT Amount,
• Amount Incl. Vat.

Create Related Documents

In order to define relations between documents open FINANCIAL

MANAGEMENT ÆGENERAL LEDGER Æ PERIODIC ACTIVITIES Æ VAT Æ
VAT ENTRIES FOR APPLICATION. The VAT Entries for Application
window appears.

Page 30
 Module: VAT & Intrastat

You have to select the Entry No. field on the header of the VAT Entries for
Application and then you can add related documents to the selected entry.
Then you have to add document number to the VAT Entries for Application
lines by filling in the Related VAT Entry No. field.

Note: For the internal invoices related documents are created automatically.

Page 31
Microsoft Navision Financial Series I

Section 9: VAT EU Statement

In this section you will learn how to use VAT EU statement.

You have to prepare VAT EU declaration if you sell or buy goods from EU
vendors or customers. The VAT EU declaration should be created every
quarter. It contains information about deliveries and purchases. Deliveries
data are based on purchase invoices. Purchases information is prepared from
internal invoices.

VAT EU Statement Setup

VAT EU Statement Series No. Setup

You have to set up series no. for VAT EU declaration. Open FINANCIAL
MANAGEMENT ÆSETUP ÆGENERAL LEDGER SETUP. The General Ledger
Setup window appears, on the Numbering tab you have to enter series no. in the
Quarter VAT Statement Nos.

VAT EU Statement Company Information Setup

You have fill in the company information, which is required by tax

authorities. Open ADMINISTRATION ÆAPPLICATION SETUP ÆGENERAL
ÆCOMPANY INFORMATION.

Page 32
 Module: VAT & Intrastat

The Company Information window appears. On the VAT EU tab fill in

each field.

In the VAT BPG filter for EU Delivery enter general business posting group
for deliveries and in the VAT BPG filter for EU Purchase enter general
business posting group for purchases for which you want to create VAT EU
declaration.

VAT EU Statement

Open GENERAL LEDGER ÆPERIODIC ACTIVITIES ÆVAT ÆVAT – EU

DECLARATION. The VAT EU Declaration window appears. You have to
select series no., and then the company information will be shown.

You have to fill in the Quarter and the Year fields manually, according to
the period for which you want to prepare the VAT EU Declaration. You can
create only one statement for each quarter in particular year.

Page 33
Microsoft Navision Financial Series I

Now you can enter lines in the VAT EU Declaration manually or you click
the Functions and then the Calculate declaration lines.

The VAT EU Declaration entries fields’ description:

Field Definition
Country Code Shows customer or vendor country code.
Client VAT Registration No. Shows customer or vendor VAT registration
no.
Amount (LCY) Shows customer or vendor summed purchase
or delivery amount for given period of time.
EU 3-Party Trade It is checked when the entry is a transaction 3-
Party Trade.

If there will be more than 12 entries for deliveries the program will create
additional attachment A and will show its number in the VAT –EU/A field in
the VAT EU Declaration header.

If there will be more than 9 entries for purchases the program will create
additional attachment B and will show its number in the VAT –EU/B field on
the VAT EU Declaration header.

Page 34
 Module: VAT & Intrastat

Test Your Skills

Scenario: VAT Application Worksheet.

You will perform VAT Application Worksheet in compliance with the above
stated examples.

In FINANCIAL MANAGEMENT Æ GENERAL LEDGER Æ PERIODIC

ACTIVITIES Æ VAT Æ VAT APPLICATION WORKSHEET, add all required
filters and fill in fields. For example fill in the fields with the following data:

• Type Filter – Purchase,

• Posting Date Filter – p1,
• Purchase Doc. Receipt – p1,
• VAT Settlement Date Filter – p1,
• Document Type Filter – Invoice,
• VAT Bus. Posting Group Filter – KRAJ,
• VAT Prod. Posting Group Filter – VAT22.

Scenario: VAT Register Report to Reconcile VAT.

In FINANCIAL MANAGEMENTÆGENERAL LEDGER Æ REPORTS Æ

POLAND Æ SALE/PURCHASE VAT REG., on the VAT Entry tab fill in the
VAT Settlement Date with value p2. On the Options tab set the VAT
Register Type field as Sale, the VAT Entries by as VAT Posting Group
value and check the Show Related Documents field.
Preview the report.

Scenario: VAT EU Statement.

In FINANCIAL MANAGEMENT Æ SETUP Æ GENERAL LEDGER SETUP

on the Numbering tab enter appropriate Quarter VAT Statement nos.

Set up the VAT Statement Company Information field in

ADMINISTRATION Æ APPLICATION SETUP Æ GENERAL Æ COMPANY
INFORMATION. Enter the information:

• VAT BPG Filter for EU Delivery – ECO,

• VAT BPG Filter for EU Purchase – PLN,
• Tax Office – I Wielkopolski Urząd Skarbowy,
• Taxpayer Type – Legal,
• County – Wielkopolskie,
• District – Poznań,
• Commune – Poznań,
• Street – Poznańska,
• Post – 60-432 Poznań,
• First Name – Jan,
• Last Name – Kowalski.

In GENERAL LEDGER Æ PERIODIC ACTIVITIES Æ VAT Æ VAT – EU

DECLARATION enter: the No., the Quarter, and the Year fields. Use the
VAT EU Declaration.

Page 35
Microsoft Navision Financial Series I

Test Your Skills Solutions

VAT Application Worksheet

Step-by-Step

1. Open FINANCIAL MANAGEMENT Æ GENERAL LEDGER Æ

PERIODIC ACTIVITIES Æ VAT Æ VAT APPLICATION
WORKSHEET.

2. Fill in the Type Filter field with required value, for example
Purchase.
3. Enter the Posting Date Filter, the Purchase Doc. Receipt/Sale
Date Filter, the VAT Settlement Date Filter fields (for
example: p1 as the first period of the year) and the Document
Type Filter field (for example: Invoice) with the data you want
to filter your VAT Application Worksheet. You have to fill in
at least the Type Filter field.
4. You can also select the VAT Bus. Posting Group Filter field
(EXPORT) and the VAT Prod. Posting Group Filter field
(VAT22) in order to filter the VAT entries.

VAT Register Report to Reconcile VAT

Step-by-Step

1. Open FINANCIAL MANAGEMENTÆGENERAL LEDGER Æ

REPORTS Æ POLAND Æ SALE/PURCHASE VAT REG. The
Sale/Purchase VAT Reg. window appears.

2. On the Vat Entry tab filter entries by setting VAT Settlement

Date – you have to enter the date range you want to filter entries.

3. On the Options tab select the VAT Register Type as Sale – the
Sale/Purchase VAT Reg. report will show only sales
documents.

4. On the Options tab select Show Related Documents.

5. Click the Preview button to show the report.

VAT EU Statement

Step-by-Step

1. To set up series no. for VAT EU Declaration, open FINANCIAL

MANAGEMENT Æ SETUP Æ GENERAL LEDGER SETUP.

Page 36
 Module: VAT & Intrastat

When the General Ledger Setup window appears, on the

Numbering tab enter series no. (for example EUDEC0001) in
the Quarter VAT Statement Nos.
2. To set up the VAT EU Statement Company Information open
ADMINISTRATION Æ APPLICATION SETUP Æ GENERAL Æ
COMPANY INFORMATION and fill in appropriate fields.

3. Open GENERAL LEDGER Æ PERIODIC ACTIVITIES Æ

VAT Æ VAT – EU DECLARATION. On General tab of the
VAT-EU Declaration window enter series no. the company
information will appear. Then enter quarter and year of the
declaration.
4. Click FUNCTIONS Æ CALCULATE DECLARATION LINES in
order to create declarations lines automatically or fill in lines
manually.

Page 37
Microsoft Navision Financial Series I

Page 38
 Module: General Ledger

MODULE: GENERAL LEDGER

Bank systems are meant to report all banking operations on your company
bank account in order to check and control bank account balance
continuously. Bank reports are useful for control bank statements, which are
delivered by bank. Every statement includes beginning balance, ending
balance and transactions.

Section 1: Bank Statements Posting and Reporting

Set up Bank Reports

In this section you will learn how to set up bank reports.

1. Create a new bank account.

Note: More about Bank Account Card Setup see Microsoft Navision
Financial Series I, Chapter 5, page 120.

2. In order to report bank account you have to set a check mark in the
field Cash/Bank Report Mandatory to indicate that this is an active
bank account, which you want to report.

You can also activate bank account reports functionality for the
existing bank accounts. In this case bank account reports include all
the historical account statements. Bank account reports can also
include the statements of the new bank accounts.

3. Click the Posting tab and select the Cash/Bank Report Nos. in the
corresponding field.

Page 39
Microsoft Navision Financial Series I

Numeration series will be used for bank account reports numeration

for one particular bank account.

Note: More about No. Series see Microsoft Navision Financial Series I,
Chapter 5, page 107.

Set up Bank Report Journals

In this section you will learn how to set up bank reports journals.

1. Click FINANCIAL MANAGEMENTÆCASH MANAGEMENTÆBANK

REPORTS JOURNAL. The Bank Report Journal window appears.

2. Select the Batch Name in the corresponding field. The Cash/Bank

Journal Batches window appears.

Page 40
 Module: General Ledger

3. Enter Name, Description and Cash/Bank Account No. The Bank

Account List window appears.

4. Enter No. and Name of the bank into list and confirm OK.

5. Select the No. Series field. The No. Series window appears.

6. Enter or select appropriate Code and confirm OK.

Use Bank Reports

In this section you will learn about posting bank report journals.

You have to open new bank report when you want to start reporting bank
account. This activity is always necessary when you want to start reporting
bank account statements.

1. Open New Report.

In order to open new bank account report click BANK ACCOUNT

LIST ÆCASH/BANK REPORTSÆCASH/BANK REPORTS. The
Cash/Bank Reports window appears. Click the Functions button
and Open new report. The new report is opened.

2. In the Bank Report Journal window enter data: Posting Date,

Document Type, Document No., Account Type, Account No.,
Description, Amount.

3. Click the Functions button and then the Apply Entries. On Apply
Customer Entries window click the Application button and Set
Applies-to ID.

Page 41
Microsoft Navision Financial Series I

4. In the Bank Report Journal window click the Posting button, then
Post and confirm posting.

In order to report bank reports we use the Bank Report Journals

window. It is a standard report with all the General Bank Report
functionalities. Additionally it has some new features.

In the Batch Name field we have bank account series no. and for this
account program fills in automatically balancing account.

The additional fields are described below.

Field Definition
Bal. Account Name Shows balancing account name
which bank report refers.
Current Cash Bank Report Shows the number of actual bank
No report.
Currently Cash/Bank Report Shows balance of currently posted
Balance bank reports.
Journal Line Balance Shows current journal line balance.
Total Balance Shows journal total balance. It is sum
of all journal lines balance.

If you use two currencies then Currently Cash/Bank Report

Balance, Journal Line Balance and Total Balance will be in two
columns, one for each currency.

In order to report you have to fill in fields: Posting Date, Document

No., Account Type (Customer or Vendor), Amount, Account No.
and then click Functions Æ Apply Entries.

Note: More about Bank Report Journal see Microsoft Navision Financial
Series I, Chapter 4, page 82.

Page 42
 Module: General Ledger

Section 2: Bank Reports Closing and Printing

In this section you will learn how to close bank reports and print them.

Bank Reports Closing

In order to close bank reports you use the Bank Account Card.

1. Click FINANCIAL MANAGEMENTÆCASH MANAGEMENTÆBANK

ACCOUNTS. The Bank Account Card appears.

2. Click CASH Æ CASH/BANK REPORTS. The Cash/Bank Reports

window appears.

The Open Balance field shows balance before posting and the Close
Balance field shows balance after posting. In order to compare open
balance and close balance with bank account statements you have to
click the Cash/Bank Report button and then the Ledger Entries.

3. Click the Functions button and then the Close Current Report to
close report.

Note: You can close bank report if there are no not posted transactions for
this report.

Page 43
Microsoft Navision Financial Series I

Bank Reports Printing

You can print bank reports using Bank Account Card.

1. Click FINANCIAL MANAGEMENTÆCASH MANAGEMENTÆBANK

ACCOUNTS. The Bank Account Card appears.

2. In the Bank Account Card window click CASHÆCASH/BANK

REPORTS.

3. The Cash/Bank Reports window appears. Click CASH/BANK REPORT

Æ PRINT. The Cash/Bank Report window appears.

4. Click the Preview button. Now you can preview Cash/Bank Report.

Note: You must remember that only one Cash/Bank Report can be open at the
moment.

Page 44
 Module: General Ledger

Section 3: Open Closed Bank Reports

In this section you will learn how to open bank reports.

Sometimes we have to open already closed bank report, because we need to

correct transactions in closed bank report. We can correct for example date,
amount, etc.

If we reopen closed bank report and change transaction amount, it will also
change opening and closing balance in further bank reports.

In order to open bank reports use the Bank Account Card.

1. Click FINANCIAL MANAGEMENTÆCASH MANAGEMENTÆBANK

ACCOUNTS.

2. In the Bank Account Card window click the Cash button and then the
Cash/Bank Reports.

3. The Cash/Bank Reports window appears. Click the Functions button

and then the Open New Report.

4. Confirm that you want to open the new report.

Page 45
Microsoft Navision Financial Series I

Section 4: Petty Cash Operations Posting and Reporting

In some cases we need to record all cash operations. Cash records use the
bank accounts functionality. Hence, you have to create new bank account for
cash.

Set up Cash Report

In this section you will learn how to set up cash reports.

1. Create a new cash account. Creating a cash account is identical to

creating a bank account.

Note: More about Bank Account Card Setup see Microsoft Navision
Financial Series I, Chapter 5, page 120.

2. On the Posting tab on the Bank Account Card you have to fill in the
Bank Acc. Posting Group field with G/L account.

3. You can set controlling minimum balance of cash account by

checking the Control Minimum Balance field and filling in the
Min. Balance field on the General tab on the Bank Account card.
This functionality protects balance of cash account from entering any
operation, which can make cash account balance lower than
minimum balance given in the Min. Balance field.

Set up Cash Report Journals

Cash Reports Journal is similar to Bank Reports Journal.

1. FINANCIAL MANAGEMENTÆ CASH MANAGEMENTÆ BANK

REPORTS JOURNALS.

2. The basic functionality you have to set up is similar to the set up in

Bank Reports Journal.

Page 46
 Module: General Ledger

3. For an additional functionality you have to change the Batch Name

field from Default to for example KP (means cash income) or KW
(cash outcome). In order to change the Batch Name field value click
the Batch Name field. The Cash/Bank Journal Batches window
appears.

Then define two types of operations cash income (KP) and cash
outcome KW. You have to fill in the fields: Name, Cash/Bank
Account No., and No. Series and Amount Sign – there are two
options: Only Positive or Only Negative. The Amount Sign field
works like a filter, for example if you set the Amount Sign field as
Only Positive it will allow entering only positive amount on the Cash
Report Journal Amount field. If you set the Amount Sign field as
Only Negative it will allow entering only negative amount in the
Cash Report Journal Amount field.

This additional functionality simplifies cash account reporting.

4. If you want to print cash income or outcome during reporting cash

account, you have to set up new journal template.

Open FINANCIAL MANAGEMENT ÆSETUP Æ GENERAL Æ

JOURNAL TEMPLATES and for journal Cash entry fill in the Test
Report Id field with value 12301. This template is specially prepared
for presenting cash income and cash outcome operations.

By default, the Test Report Id field is hidden, so you have to show

this column.

Page 47
Microsoft Navision Financial Series I

Posting, Reporting and Printing

These functionalities are similar to Bank reports.

There is an additional functionality, you can assign invoice to cash reports.

Open SALES & MARKETING Æ ORDER PROCESSING Æ INVOICES Æ

SALES INVOICE.

You have to fill in balance account by entering cash account in the Payment
Method Code field on the Invoicing tab in the Sales Invoice window. The
Cash/Bank Report Cons. No. field will be automatically filled in with
opened cash report.

Then posting invoice is allowed only when given cash report is opened,
otherwise program does not allow to post invoice. Then you have to open
new cash report, or reopen the closed one, and then choose active cash report
from the Cash/Bank Report Cons. No. field list.

Posting and Reporting Cash Reports

The only difference between Bank Reports and Cash Reports is that you have
to fill in the Bal. Account Type field and Bal. Account No. field manually.

Printing Cash Reports

If you set the Test Report Id field in FINANCIAL MANAGEMENT Æ SETUP

Æ GENERAL Æ JOURNAL TEMPLATES to template 12301 you will get two
copies of operation, original for customer or vendor and copy for cash.

Page 48
 Module: General Ledger

Test Your Skills

Scenario: Set Bank Report and Post Bank Statement Including Payables
Application.

1. Create the new bank account.

2. On the General tab of the Bank Account Card window check the
Cash/Bank Report Mandatory.

3. Set the Cash/Bank Report Nos.

4. In FINANCIAL MANAGEMENT Æ CASH MANAGEMENT Æ BANK

REPORTS JOURNAL fill in all required fields.

5. Open BANK ACCOUNT LIST Æ CASH/BANK REPORTS Æ

CASH/BANK REPORTS. Fill in all required fields and post the bank
report.

Page 49
Microsoft Navision Financial Series I

Test Your Skills Solutions

Set Bank Report and Post Bank Statement Including

Payables Application

Step-by-Step

1. Open FINANCIAL MANAGEMENT→CASH MANAGEMENT→BANK

ACCOUNTS.

2. Create new bank account.

3. Check the Cash/Bank Report Mandatory in active bank account, which

you want to report.

4. Click the Posting tab and select the Cash/Bank Report Nos. in the
corresponding field.

5. Click FINANCIAL MANAGEMENTÆCASH

MANAGEMENTÆBANK REPORTS JOURNAL.

6. Select the Batch Name in the corresponding field. The Cash/Bank

Journal Batches window appears.

7. Enter Name, Description, join journal batch with the Cash/Bank

Account No. Bank Account List window appears.

8. Enter No. and Name of the bank into list and confirm OK.

9. Select the No. Series field. The No. Series window appears.

10. Enter or select appropriate Code and confirm OK.

11. Open New Report. Click BANK ACCOUNT LIST ÆCASH/BANK

REPORTSÆCASH/BANK REPORTS. The Cash/Bank Reports window
appears. Click the Functions button and Open new report.

12. In the Bank Report Journal window enter data: Posting Date, Document
Type, Document No., Account Type, Account No., Description, and
Amount.

13. Click the Functions button and then the Apply Entries. On Apply
Customer Entries window click the Application button and Set
Applies-to ID.

14. In the Bank Report Journal window click the Posting button, then Post
and confirm posting.

Page 50
 Module: Receivables Management

MODULE: RECEIVABLES MANAGEMENT

Section 1: Multiple Interests Rates Setup
In this section you will learn how to set up multiple interests rates.

In some cases you need reminder system since you can not expect that all
customers will pay their invoices on time.

There are two types of interest rates used in Poland: Statutory interest rates
(which are also used to calculate interest on tax liabilities so sometimes are
called tax interests rates) and free-hand interest rates.

Statutory interest rates are published by National Bank of Poland, free-hand

interests are agreed on basis of negotiations between seller and customer.
The screenshot shows the example how the free-hand interest rates and tax
rates work. The due time was 60 days from posting date and the customer
paid his invoice after 80 days. Then you can add additional fees: free-hand
interests rates for 20 days of delay and tax rates for the period between 30 and
60 days. In Poland you can always add tax rates when the 30 days period
after posting date passes. In Navision you can set up the duration of this
period of time.

Page 51
Microsoft Navision Financial Series I

Multiple Interests Rates Setup

Open SALES&MARKETING Æ SETUP Æ SALES Æ SALES &

RECEIVABLES SETUP. The Sales & Receivables window appears.

In the Int. Period Split Date Formula field on the General tab enter the
required period of time. In order to activate multiple interest rates check the
Multiple Interest Rates field. If you check the Int. Rates for Payment field
the report only calculates interests for payments. In this case if you settle
invoice by credit memo the report will not calculate it.

In order to set up multiple interest rates open FINANCIAL MANAGEMENT Æ

RECEIVABLES Æ SETUP Æ FINANCE CHARGE TERMS. The Finance
Charge Terms window appears.

In Poland you have to fill in the Interest Period (Days) field with 365 as the
value. You have to set the Interest Calculation Method field as the Average
Daily Balance option.

Note: More about Finance Charge Terms setup see Microsoft Navision
Financial Series I, Chapter 6, page 191.

Page 52
 Module: Receivables Management

To set up multiple interest rates click the Multiple Interest Rates button.
The Multiple Interest Rates window appears.

You have to fill in the lines with different interest and tax rates for
appropriate period of time.

Generate and Print Reminders

In order to generate and print reminders open FINANCIAL MAMAGEMENT Æ

RECEIVABLES Æ PERIODIC ACTIVITIES Æ REMINDERS. The Reminders
window appears.

Page 53
Microsoft Navision Financial Series I

You have to fill in a number of appropriate fields: Posting Date, Document

Date and the Customer No. fields for whom you want to create reminders. In
order to create reminder lines you have to click the Functions button and
then Suggested Reminder Lines. When the Suggest Reminder Lines
window appears click OK.

If you click in the Interest Amount field you will get multiple interest rates
line details in the Detailed Reminder Lines window. The example shows
rates changes for different periods of time.

Page 54
 Module: Receivables Management

The description of the Detailed Reminder Lines fields:

Field Definition
Days Shows the number of days for which the program
will calculate interests.
Interest Rate Shows the interests rate value in %.
Interest Base Amount Shows the amount from which the interest’s
amount is calculated.
Interest Amount Shows the calculated interests amount.

Note: More about reminders see Microsoft Navision Financial Series I,

Chapter 6, page 186.

Page 55
Microsoft Navision Financial Series I

Section 2: Customer Confirmation Report

In this section you will learn how to use customer confirmation report.

At least once per financial year you have to confirm balance with customers.

In this case you can use the Customer Balance Confirmation report. The
report consists of two sections: A and B. You have to send both parts of the
report to customer. Customer has to sign the report and send you back only
section B as the confirmation.

The report presents open settlements with customers and current settlement
balance. Settlement balance is the sum of open settlements with customers.

Use Customer Balance Confirmation

In order to open the Customer Balance Conformation report click FINANCIAL

MANAGEMENTÆ RECEIVABLES Æ REPORTS Æ CUSTOMER BALANCE
CONFIRMATION.

The Customer Balance Confirmation window appears.

On the Customer tab of the Customer Balance Confirmation window you

can filter customer by No., Search Name, and Date Filter etc. If you want to
filter entries by particular date you have to fill in the Date Filter field with
the value for example: “..31-05-05”.

Page 56
 Module: Receivables Management

On the Options tab in the Customer Balance Confirmation window you

can change report settings.

Field Definition
Confirmation Period (Days) Enter the period of time (in days) during
which customer has to send you back the
signed section B of the Customer Balance
Confirmation report.
Register Interaction Check this field if contact card for customer
exists.
Only non zero balances If you check this field the Customer
Balance Confirmation report will show
only customers with non 0 balance.
Only zero balances If you check this field the Customer
Balance Confirmation report will show
only customers with 0 balance.

Page 57
Microsoft Navision Financial Series I

If you click the Print button, you will print the Customer Balance
Confirmation report. You can preview the Customer Balance
Confirmation report by clicking the Preview button. The example report is
shown below.

For each currency used in the transaction there is separated balance

calculation on the report.

Use Customer/Vendor Balance

When the contractor is at the same time vendor and the customer you do not
have to prepare and print the Vendor and Customer Balance Confirmation
report separately. You can use the Customer/Vendor Balance report.

Customer/Vendor Balance Report Setup

You have to create relations between customer and vendor who is the same
contractor, because their data are stored in different tables.

Page 58
 Module: Receivables Management

Open FINANCIAL MANAGEMENTÆ RECEIVABLES Æ CUSTOMERS.

The Customer Card window appears.

In order to create relation between customer and vendor choose appropriate

customer and then on the Payments tab fill in the Related Vendor field with
the vendor’s number.

Create and Print Customer/Vendor Balance Report

Open FINANCIAL MANAGEMENTÆ RECEIVABLES Æ REPORTS Æ

CUSTOMER/VENDOR BALANCE.

The Customer/Vendor Balance window appears.

The Customer tab and the Options tab in the Customer/Vendor Balance
window are similar to the Customer Balance Confirmation window.

Page 59
Microsoft Navision Financial Series I

On the Options tab there are two additional fields:

• Only Customer – if you set a check mark in this field the report will
only show customer’s balance,
• Show External Doc. No. – if you set a check mark in this field it will
also show the external’s document number.

If you click the Print button, you will print the Customer/Vendor Balance
report. You can preview the Customer/Vendor Balance report by clicking
the Preview button.

Page 60
 Module: Receivables Management

Test Your Skills

Scenario: Multiple Interests Rates Setup and Reminder Creation.

You will perform multiple interest rates setup.

In SALES&MARKETING Æ SETUP Æ SALES Æ SALES & RECEIVABLES

SETUP on the General tab fill in the Int. Period Split Date Formula.

In FINANCIAL MANAGEMENT Æ RECEIVABLES Æ SETUP Æ FINANCE

CHARGE TERMS to set up multiple interest rates.

Create reminder in the FINANCIAL MAMAGEMENT Æ RECEIVABLES Æ

PERIODIC ACTIVITIES Æ REMINDERS. You have to fill in the appropriate
fields.

Scenario: Customer Balance Confirmation in Different Scenarios

(Multiple Currency Receivables, Historical Balance Confirmation).

In FINANCIAL MANAGEMENTÆ RECEIVABLES Æ REPORTS Æ

CUSTOMER BALANCE CONFIRMATION fill in appropriate fields: on the
Customer tab the No. field (10000), the Date Filter (..31-05-05) and on the
Options tab: the Confirmation Periods (Days) field: 7. Print the
document.

Page 61
Microsoft Navision Financial Series I

Test Your Skills Solutions

Multiple Interests Rates Setup and Reminder Creation

Step-by-Step

1. Open SALES&MARKETING Æ SETUP Æ SALES Æ SALES &

RECEIVABLES SETUP on the General tab fill in the Int. Period
Split Date Formula with 30D and check the Multiple Interests
Rates field.

2. Open FINANCIAL MANAGEMENT Æ RECEIVABLES Æ SETUP Æ

FINANCE CHARGE TERMS. Add new line, enter the value 365 in
the Interests Period (Days) field, set the Interest Calculation

3. Method field to Average Daily Balance and the Interests Rate. In

order to create multiple interests rates click the Multiple Interests
Rates button and then fill in the Valid Date, the Interest Rate and
the Tax Rate fields for each new added multiple interest rates.

4. Open FINANCIAL MAMAGEMENT Æ RECEIVABLES Æ PERIODIC

ACTIVITIES Æ REMINDERS. You have to fill in the fields:
Customer No., Posting Date and Document Date. In order to create
reminder click the FUNCTIONS Æ SUGGESTED REMINDERS
LINES.

Customer Balance Confirmation in Different Scenarios

(Multiple Currency Receivables, Historical Balance
Confirmation)

Step-by-Step

1. Open FINANCIAL MANAGEMENTÆ RECEIVABLES Æ REPORTS

Æ CUSTOMER BALANCE CONFIRMATION on the Customer tab
fill in the fields which will filter customer documents: No. –
customer number - 10000, Search Name, Date Filter – period of time
- ..31-05-05.

2. On the Options tab you can change report settings: Confirmation

Period (Days) – 7.

3. There will be one total balance for each currency in which the
customer buys goods. Click the Print button.

Page 62
 Module: Payables Management

MODULE: PAYABLES MANAGEMENT

Section 1: Vendor Confirmation Report
In this section you will learn how to use vendor confirmation report.

At least once per financial year you have to confirm balance with vendors.

In this case you can use the Vendor Balance Confirmation report. The
report consists of two sections: A and B. You have to send both parts of the
report to vendor. Vendor has to sign the report and send you back only
section B as the confirmation.

The report presents open settlements with vendors and current settlement
balance. Settlement balance is the sum of open settlements with vendors.

Use Vendor Balance Confirmation

In order to open the Vendor Balance Conformation report click FINANCIAL

MANAGEMENTÆ PAYABLES Æ REPORTS Æ VENDOR BALANCE
CONFIRMATION.

The Vendor Balance Confirmation window appears. In order to prepare and

print the Vendor Balance Confirmation report you have to follow the same
instructions as during the Customer Balance Confirmation report.

Page 63
Microsoft Navision Financial Series I

Section 2: Vendor – Summary Aging Report

In this section you will learn how to create Vendor – Summary Aging
Report.

This report shows a list of vendors with payables amounts divided into
four periods: 0-30, 31-60, 61-90 and over 90 days from the invoice
posting date.

Open FINANCIAL MANAGEMENT Æ PAYABLES Æ REPORTS Æ

VENDOR – SUMMARY AGING SIMP. The Vendor – Summary Aging
Simp. window appears.

On the Vendor tab you can filter vendor who you want to prepare the report.
On the Options tab you have to fill in the Starting Date field, which is the
starting date of report. You can preview and print the report clicking on the
appropriate buttons. The example of the Vendor – Summary Aging Simp.
report is shown below.

Page 64