Floorplanning manual

Banqsoft ASA

Dealer User Manual

User Manual

Dealer web

www.banqsoft.no

Banqsoft ASA, Brynsengfaret 6b, N 0667 Oslo, Norway Phone +47 22 31 44 00


Introduction

Dealer

Introduction

Dealer Web is the Dealer portal to View21.

System requirements

· Internet Explorer 6.0 or later

· Excel reports; Excel2000 or later

· PDF; Adobe Acrobat Reader 5.0 or later

· Recommended screen resolution is minimum 1024x768

Start application

Start the Dealer Web application by opening your web browser and go to the location provided to you by your system administrator, typically ’http://webservername/Dealer’.


Login

Dealer

Login

Starting the application will bring up the login screen.

Enter your username and password in the login dialog and press login.

If login messages are enabled the login screen may look like this.

To login enter your username and password in the login dialog and press login as usual.

In addition there is a message below the login box with information, and optionally a link for more info... .

The more link may be reached from the 'i' icon on the toolbar. See pagelayout


Page layout

Dealer

Page layout

After login you will be redirected to the Dealer web main page. The application has the following layout.

Toolbar

home icon | Navigate back to main page
logout icon | Logout
login icon | Login
Info icon | Info, login message and other messages(if enabled)
help icon | popup documentation

Information Bar

User | The login user
Database | The connected database
Date | Current bank date

Title

Show the title of the current page.

Messages

Display system messages and warnings.

Menu

Menu details


Main menu

Dealer

Main menu

The Dealer web application has the following menu structure, note that some of the items are based on user privileges and may not be displayed for all users.

1. Customer

Customer name | The logged in user's customer name
User info | Display user information. Change password

2. Floorplanning releated functions

Consignment report | View consignment reports for specific dealer or all dealers.
Bought cars report | Reports for consignment cars bought by dealer. Specific dealer or all dealers
Invoice report. | Floorplanning fee invoice reports. Will list all fee invoices by dealer.
Wholesale report | Wholesale reports.
Nettacc spec | Netting account specification. Display netting account movements.
Netting statement future value | Netting account statement. Display future events (future value dates).
Invoices not paid | Invoices not paid report.

3. Account

Engagement

Dealer engagement


User info

Dealer

User info

The user info window will show info about the current user and lets the user change the login password.

Set new password

Click the "Set Password" button to display change password dialog.


Floorplanning

Dealer

Floorplanning

Floorplanning tasks:

Consignment report

Consignment note

Manage consignment cars

Bought consignment cars

Consignment car invoice

New wholesale car

Wholesale report

Wholesale repay loan

Netting account specification

Invoices not paid

Stock report

New stock

Netting statement future value


Consignment report

Dealer

Consignment report

The menu item ”Consignment Report” in the reports menu lets you search and view consignment cars.

Filters

The report can be filtered with the following parameters.

Dealer

View report for specific Dealer.

The dealer will be populated with releated dealers and bodybuilders.

Default is the logged in dealer and will display all consignment cars where the dealer is account owner or stock.

The stocks section lists all releated consignment stocks. Filter on a stock will display all consignment cars for the given stock.

The bodybuilder section lists all system and dealer related bodybuilders. Filter on bodybuilder will display all consigment cars for the given bodybuilder.

Type

Filter by consigment type

Blank will show all consignment types.

1) Consignment - show only new consignment

2) Consignment Used - show used only

Cars on consignment pr. date

Controls date, view cars consignment financed on given date

Cars in to consignment pr. date

Controls date, view cars in to consignment on given date. ( Based on Delivery Date )

Date

See above, default system bank date

Fetch

Fetch report

Result

The following result will be displayed.

The report header will display number of cars found and the total consignment financed amount.

Report details:

Invoice | Invoice number for the car
Order No | Order no for the car
Reg No | Car license
Car | Car description; make, model and type
Car Price | The consignment financed amount
Transport Date | Car delivery date
Days | Consignment financed days
Con Date | Consignment expiration date.
Stock | Customer name of current stock dealer
Car Mark | For used consignment cars a column will appear and the car will be marked with an "U" For reversed cars a column will appear and the car will be marked with an "R".

Selecting a row in the report table will enable the buttons; Release cert, Invert list, Options, Buy Car and Consign.Note. Select row will also set the car as current car. Note that only reports filtered on a specific stock will enable the "Invert List" button.

By selecting given row in the grid for some car "Release Cert." can be enabled or disabled. It is enabled if the following conditions are fulfilled:
- dealer can send certificate,
- dealer is allowed to send certificate before contract termination,
- the certificate exists for given car (was imported via CoreView),
- dealer has never sent certificate (it is not possible for dealer to resend certificates)
- certificate has not been sent (if so cancellation is needed)

Released certificate is always the newest certificate with given chassis and type adequate for object class.


Consignment note

Dealer

Consignment Note

The consignment note is available from the consignment report. Selecting a row in the report will enable the ”Consign.Note” button. This button will popup a new window display the ”Consign.Note” as a PDF using Adobe Acrobat Reader plug-in.

The Consignment note contains all details from the registration of the car and can be printed using the print button in Adobe Acrobat plug-in toolbar.


Manage consignment cars

Dealer

Manage consignment cars

The following actions can be performed on consignment financed cars.

Buy car | Buy car, i.e end consignment finance
Move car | Move car to another location.
Notes | Create and view car notes
Buy Car

Buy car from finance company i.e. terminate the consignment finance. The ”Buy Car” button is available in the ”Consignment Report”. Select a row in the table will enable the ”Buy Car” button.

A confirm dialog will appear and to activate car sale press the ”Ok” button. Car consignment buy transactions will be done in View21. The dialog will close and the ”Consignment Report” will be refreshed. The consignment finance is now terminated and the car can be found in ”Sold Car” reports ( See section ”Sold Car”)

Car options

The ”Options” button in the ”Consignment Report” will popup the car options dialog. Select a row in the table to enable the button. The dialog consists of a car information section and tabs for the following operations; move car and notes.

Read only information

Reg No | Car license
Model code | Car model code
Color Code | Car color code
Make | Car description; make, model and type
Stock | Customer name of current stock dealer
Current Program | The current price program for this car

Move car

To keep track of cars location, the system support move of consignment cars. Allowed locations are related customers and external bodybuilders (See manual View21 Floorplanning for setup and detail explanation).

Available Stocks | List of available stocks. The list contains related customers and bodybuilders.
Description | Move description, text field (optional)
Move | Press to activate move

All car movement will be logged in the Move Log.

Date | Move date
To | Move to customer number
From | Move from customer number
Description | Move description

If car is moved to an external bodybuilder, a notification email will be sent both to the bodybuilder and Finance Company.

Notes

It is possible to add notes to consignment cars.

Note text box | Type note here
New | Create new note
Save | Save current note
Cancel | Cancel edit
Notes table
Date | Note creation date
User | Created by user
Text | Note text

Close options dialog

Press “Ok” button to close options dialog. This will refresh the “Consignment Report”.


Bought consignment cars report

Dealer

Bought cars report

The menu item ”Bought Cars report” in the reports menu lets you search and view bought consignment cars .i.e terminated consingment cars.

Filters

The report can be filtered with the following parameters.

Dealer

View report for specific Dealer.

The dealer will be populated with releated dealers and bodybuilders.

Default is the logged in dealer and will display all consignment cars where the dealer is account owner or stock.

The stocks section lists all releated consignment stocks. Filter on a stock will display all consignment cars for the given stock.

The bodybuilder section lists all system and dealer related bodybuilders. Filter on bodybuilder will display all consigment cars for the given bodybuilder.

Type

Filter by consigment type

Blank will show all consignment types.

1) Consignment - show only new consignment

2) Consignment Used - show used only

Find

Search for dealer

Sold consingment cars pr. date

View report for given date

Fetch

Fetch report

Result

The following result will be displayed.

Invoice | Invoice number for the car.
Order No | Order no for the car
Reg No | Car license
Car | Car description; make, model and type
Car Price | The consignment financed amount
Transport Date | Car delivery date
Days | Consignment financed days
Sold Date | Sold date
Stock | Customer name of current stock dealer
Car Mark | For used consignment cars a column will appear and the car will be marked with an "U" For reversed cars a column will appear and the car will be marked with an "R".

The Options button will be enabled when a row is selected in the table. The options dialog will only be enabled for viewing and creating notes, all other options will be disabled


Consignment car invoice

Dealer

Consignment car invoice

Selecting a row in the ”Bought cars report” will enable the invoice button. This button will display the consignment invoice as a PDF

The Consignment invoice contains all details from the registration of the car and can be printed using the print button in Adobe Acrobat plug-in toolbar.


New wholesale car

Dealer

New wholesale car

The menu item ”New wholesale car” menu item will open the register wholesale car window. The system can be configured to use an external source to retrieve car information and "Query" button will be enabled.

Manual Registration

Field description (bold=buttons, italic=readonly/caluclated, *=data fetched on lost focus)

Dealer | Logged in dealer
Car Acc. Bal. | Wholesale account current balance
Car Acc. Lim. | Wholesale account limit
Reg. No | Car License
Mileage | Car current mileage
Query | Disabled for manual registration, see Query registration for details.
Chassis No. | Car chassis no.
Engine No. | Car engine no
Model code | Car model code
Make | Car make / Disabled for query
Model | Car model / Disabled for query
Type | Car type / Disabled for query
Year | Car year / Disabled for query
Net Amount | Car net. value / Disabled for query
Fin. Degree | Finance Degree.
Fin. Amount | Financed amount.
Program | Selected programs. See section ”New Consignment Car – Program selection” for more details. Note will only fetch program of type wholesale
Get Programs | Retrieve programs.
New Loan | Register car as new loan
Clear All | Clear all fields
Query Registration

For query registration of wholesale cars the Query button is enabled. Required fields for query are Dealer, Reg.No and mileage. A query will be executed and if car is found in external source the fields will be populated and the read-only fields will be disabled for entries. If car not found in the external source, the registration window will be disabled.

Net Amount, Finance Degree and Financed Amount

In order to register a wholesale car you must selected a program using the ”Get Programs” and select a program in the list of available programs. Wholesale program contains a” Finance Degree” percent parameter, which is the maximum finance degree that can be applied to a car. This value will be display in the ”Fin. Degree” textbox. The value is editable but can not be higher than the value set on the selected program. This will calculate Finance Amount based on Net. Amount (fetched on query registration / entered in manual registration) and Finance degree.

The ”New Loan” button will be enabled and press this to register the car.


Wholesale report

Dealer

Wholesale report

The menu item ”Wholesale report” in the reports menu lets you search and view Wholesale cars.

Filters
Dealer | Logged in dealer
Cars on wholesale pr. date | Controls date, view cars wholesale financed on given date
Cars in to wholesale pr. date | Controls date, view cars in to wholesale on given date.
Cars out of wholesale pr. date | Controls date, view cars out of wholesale finance on given date.
Date | See above, default system bank date
Fetch | Fetch report
Result

The result header will display the type of report, date, number of cars, total marked value and total financed amount.

Report details:

License | Car license
Make | Car make
Model | Car model
Mileage | Car mileage
Marked Value | Car Marked value
Fin. Amount | Financed amount
Days | Wholesale financed days
Max Days | Max wholesale finance days, from Price Program. The loan will auto repaid at this date.
Customer | Customer number of wholesale account owner.
Tran. | Current tranche for this car


Repay wholesale loan

Dealer

Wholesale repay loan

To repay wholesale loan i.e. terminate the wholesale finance. selecta row in the wholesale table this will enable the ”Repay Loan” button. A confirmation dialog will appear.

Press the ”Ok” button to terminate the wholesale finance of the car. Termination transactions will be done in View21. The dialog will close and the wholesale report will refresh.

To view reports of terminated wholesale cars, use the” Cars out of wholesale pr. date” filter on the wholesale report.


Invoice report

Dealer

Invoice report

All Floorplanning tranche fees are invoiced according to the setup of consignment/wholesale accounts in View21. By default the accounts are setup to be invoiced monthly, and at month-end a trache fee invoice will be generated for each account.

The invoice reports lets you search and view Floorplanning tranche fee invoices.

Filters
Dealer | View report for specific Dealer. The dealer will be populated with releated dealers which has consignment/wholesale account
Find | Search for dealer
From Date | Invoices for period, From Date
To Date | Invoices for period, To Date
Fetch | Fetch report

Result

The report will show all consignment/wholesale fee invoices for the given period and dealer.

Invoice | View21 invoice number
Due Date | Invoice due date
Status | View21 invoice status
Total | Invoice total amount
Paid | Paid amount
Rest | Invoice rest amount

The result example show invoices generated for a whole year for a specific dealer, note that it is two invoices pr. month; one consignment invoice and one wholesale invoice.

Selecting a row in the table will enable the "Details button", this will popup a new window and show the invoice details.


Invoice details

Dealer

Invoice details

To view invoice details select a row in the invoice report table; this will enable the ”Details” button. Click this button to popup the invoice as PDF.

The invoice is build up by the following sections

Finance Company header

Display Finance company name

Customer

Dealer name and address details

Invoice Info

1) Invoice date

2) Invoice due date

3) Invoice number ( View21)

4) Customer number

Invoice Details

The invoice details are divided in the following columns:

1) License

2) Chassis no.

3) Description

4) Amount

Example of a row in the invoice details

Car Dealer1

lic-79426

VW CADDY KOMBI 1,4LB 55KW/75HK 136 338,00

Base Importer Consignment

Invoice Fee 31Days

50,00

Consignment Fee 31 Days

575,77

Sum

625,77

...

Sum stock

625,77

The grouping of the invoice details rows are as follows.

1) Stock

2) Car

3) Tranche Program

Customers can be related to mirror organization structures (See manual: View21 Floorplanning). The invoice is generated based on consignment/wholesale account owner and grouped on stock. The invoice detail will be divided in one section pr. stock.

Each stock section will again be grouped on car; further each car is grouped by program, to reflect price program changes. For each price program pr. car all debited fees will be listed.

The invoice detail footer will list other amount on the invoice that is not related to tranche fees. Ex. Limit fee on the account.

Finance company footer

Detailed Finance company info and address details.

The invoice can be printed using the print button in the Adobe Acrobat plug-in toolbar. The invoice layout can be customized, see Manual View21 Floorplanning for details.


Netting account specfication

Dealer

Netting account specification

To reduce the number of transactions between the Dealer and Finance company, Floorplanning can be configured to use the Netting functionality in View21. The”Netting Account spec” report in the reports menu will show all movements on the dealers netting account for a given period.

Filters
From Date | Period from date
To Date | Period to date
Fetch | Fetch report

Result

The result is presented as a PDF.

The report output has the following columns:

Verification Date |
Verification/Invoice |
Due date | Invoice due date
Stock | Invoice total amount
Identity | Transaction identity, for car transaction, car license
Account |
Amount | Transaction amount

The report details are grouped in the following sections:

Payment, consignment assets | Dealer payment of consignment cars can be done using netting. This section will list all payment of consignment cars for given period.
Price Program invoices | Price Program fee invoice payments can be done using netting. This section will list all payment of such invoice for given period
Wholesale loans | Both payout and payment of wholesale loans can be done using netting. Will be specified in this section.
Payments from bank | Payments from bank will be specified in this section
Miscellaneous debit | Other debits on netting account not specified in above sections.
Sum netting movements | Sum netting movements for given period
Incoming balance | Incoming balance
Netting period | Sum netting movements for given period
Outgoing balance | Outgoing balance


Netting account fututure value

Floorplanning

Netting account future value

The report will show future amounts of what will be debited on this netting account.

Filters
Customer | Customer
From Date | Period from date
To Date | Period to date
Fetch | Fetch report

Result

The result is presented as a PDF.

The report output is like a statement and has the following columns:

Value Date | Value date of the amount
Identity | Type of transaction. For car transactions also car license
Details | Transaction details
Amount | Transaction amount
Expected Balance | Expected balance


Invoices not paid report

Dealer

Invoices not paid report

The invoices not paid report will list all netting invoices due and not paid.

The result will be displayed as a PDF.

Result will display on line pr. not paid invoice, with the following columns

Verification Date |
Verification/Invoice |
Due date | Invoice due date
Stock | Invoice total amount
Identity | Transaction identity, for car transaction, car license
Total |
MVS |
Amount |


Stock report

Dealer

Stock report

The menu item ”Stock Report” in the reports menu lets you search and view cars in stock.

Filters

The report can be filtered with the following parameters.

Dealer

View report for specific Dealer.

The dealer will be populated with related dealers and bodybuilders.

Default is the logged in dealer and will display all consignment cars where the dealer is account owner or stock.

The stocks section lists all related consignment stocks. Filter on a stock will display all cars for the given stock.

The bodybuilder section lists all system and dealer related bodybuilders. Filter on bodybuilder will display all cars for the given bodybuilder.

Cars in stock pr. date

Controls date, view cars financed on given date

Cars in to stock pr. date

Controls date, view cars in stock on given date. ( Based on Delivery Date )

Date

See above, default system bank date

Fetch

Fetch report

Result

The following result will be displayed.

The report header will display number of cars found and the total financed amount.

Report details:

Color field | Depending on configuration of number of days car has been in stock, the color green, yellow or red is displayed. No configuration = white field
Reg No | Car license
Chassi | Car chassis no
Car | Car description; make, model and type
Stock | Customer name of current stock dealer
Type | Consignment, Whole Sale or Non-financed
Stock Status | Stock status selected from dialog window displayed by clicking 'Options'
Market value | Market value
Value | Value = market value for status 'Non-Financed' and 'Wholesale'

Selecting a row in the report table will enable the button 'Options'. By clicking the button, a dialog window with configured stock status can be set on selected car.


New Stock

Dealer

New Stock

New Stock let you register a non-financed stock object

Reg No | Car license
Order No | Order no for the car
Chassi No | Car chassis no
Make | Car make
Model | Car model
Type | Car type
Year | Car year
Market Value | Car market value
In Stock from date | Car will be in stock from date


Account

Dealer

Account

The account menu contains miscellaneous dealer account reports.

Engagement


Consignment report

Dealer

Account Adminstration

The account Adminstration module of the Dealer web allows Dealers to see account termination calculation and account invoices. The module require sufficient application privileges.


Consignment report

Dealer

Account termination

Accounts can be configured in View21 to allow dealers to see account termination calculation.

Account Search

Enter Object License or account number and press the "Find" button" to search for a specific account. Accounts must be configured in View21 to be accessible for the Dealer or a child dealer in a organization.

Lease Termination

Loan Termination


Consignment report

Dealer

Loan Termination

Account (contract) | Account (contract) number
Reg. no’s | Vehicle’s registration number. If there are several vehicles registered they are all displayed here.
Regress |
Vendor | Vendor number and name
Balance | Balance of the loan, in relation to payments on the loan
Unpaid Principal | Invoiced, unpaid instalment
Unpaid Interest | Invoiced, unpaid interest
Unpaid Reminder Fee + Penalty | Invoiced, unpaid reminder fee and penalty interest
Unpaid Other Items | Other unpaid items
Mature Date | The loan’s normal maturity date
Invoiced Until | The loan is invoiced until this date
Sum Pay Plan Subsidy | The total of payment plan subsidies
Rest Subsidy/ Commission | Remaining, non-periodic, commissions/subsidies.
Interest Reference Date | The given date is used for interest calculation on the termination invoice.
Reference Balance, Adjusted | Balance on the contract per the foregoing interest reference date.
Calculated Interest | Total interest on capital up to and including the redemption date, both invoiced and non-invoiced interest, from and including the interest reference date.
Next Rate Change | Next interest change date on the loan.
Termination Date | Enter the termination date for the loan
Due Date | If nothing is entered in this field, the due date is the same as the redemption date. This allows the user to give the customer “reasonable” time to pay the redemption sum.
Rest Balance | Balance on the contract as far as it is invoiced
Interest Adjustment | Accumulated, non-invoiced interest adjustment (displayed in Invoice Status)
Accrued Penalty | Accumulated, non-invoiced penalty interest (displayed in Invoice Status)
Miscellaneous Fees | Accumulated, non-invoiced fees (displayed in Invoice Status)
Delayed Invoice Fee | N/A
Reminder Fee | Accumulated, non-invoiced reminder fees (displayed in Invoice Status)
Expenses | Accumulated, non-invoiced expenses
Periodic expenses | If blank, any expenses defined on the contract will be included in the termination invoice.
Periodic fees | If blank, any fees defined on the contract will be included in the termination invoice.
Interest | Interest on the end balance up to and including the redemption date. If the box is checked interest calculation follows the payment plan.
Follow Plan | See explanation in Interest amount
Insurance | Accumulated, unpaid insurance
New Penalty Accrual | New accumulated penalty interest. Can occur if late payments form part of a future redemption
Termination Fee | Any termination fees (charge for early pay-off)
Termination Interest | If a figure has been entered in the “Calc Rate” field, an interest amount is displayed here. The redemption rate must be defined on the product. Present value calculation of the remaining amount from the original maturity date to the redemption date is used to cover any additional costs that may arise from early redemption of a fixed rate loan.
VAT | VAT
Prepayment Balance | Prepayment amount (customer credit balance) (displayed in Invoice status)
Rounding | Rounding amount
Subtotal | Capital, calculated interest and fees from last due date up to and including the redemption date.
Overdue Invoice | Total sum of overdue, unpaid invoices
Invoiced, Not Due | Total sum of invoiced, not due invoices
Total | Total to be paid
Loan Rate | Information field: Displays the contract’s current interest rate
Calc Rate | Enter an interest rate for calculating a prospective redemption rate.
Invoice | Information field: Displays the redemption invoice number. Generated when the Execute button is pressed.


Consignment report

Dealer

Lease Termination

Lease Start Date | The start date of the contract
Mature date | The normal end date of the contract.
Invoiced Until | The date displayed in “Invoiced until” is the due date for the period that is invoiced, for instance a monthly contract in advance with due date 2003-05-01 includes the entire month of May.
Termination Date | Termination Date i.e. the date when the termination are to be executed. The next due date are automatically suggested whether the contract is invoiced or not. You may choose another date if so wanted. (Important! Must be a due date, in the picture above, the 20th of a month)
Loan rate | The current rate on the contract.
Margin Calc. Rate | As default you will find zero. The contract is discounted at the current interest rate, and the net present value = booked value. If you enter an interest rate > zero a profit will occur.
Repurchasor (Cust.no) | The repurchasor that is registered in the asset window on the contract appears as a suggestion, but may be changed.
Object Net Amount Column |
Future Residual Value | Displays calc residual value by the end of the loan term.
Net Sale | Sum net profit/loss on the object. Some small currency differences are caused by the fact that all discounted leases are summarized. The reason why you summarize leases is that the system allows different period lengths (For instance a mixture of quarterly and monthly).
Sale Value ex VAT | Sale Value ex VAT
Net VAT Refund (F90) | Applies for Norway
Fee/Discount | Here you may enter a fee or a discount. Note! Since the box “Object fee / Discount on Contract” is checked as default, this amount will be summarized to the total customer claims. If the check mark is removed a capital gain/loss on the asset is generated. (Important that an account for capital gain/loss is defined on the product)
Vendor Already Invoiced | If automatic rest value invoice is being sent to the vendor, the invoice amount is displayed here.
Value Date Interest | Sum interest (based on contract interest rate), the difference between term date and pay date. The interest are calculated on asset price incl Vat.
Contract Net Amount Column |
Unpaid Invoices | Unpaid invoices that are invoiced (total sums)
Invoice Method | Here a letter is displayed that identifies the payment method of the customer. Nothing = Normal invoice, A = autogiro, B = collection invoice, C = common invoice, G = avtalegiro not sent, H = avtalegiro sent BBS with note, I = avtalegiro sent BBS without note, J = avtalegiro sent BBS-deleted, K =original avtalegiro sent customer as OCR, P = piceno, replaced on next invoicing, S = salary deductions, X =OCR (Autogiro and Avtalegiro is Norwegian invoice format).
Credits (-) | Invoices that are credited (total sums)
New Charges | New accrued charges that are not previously invoiced
Termination Fee | Term fee that the customer shall pay. They are booked as handling revenue, not capital gain!
Rest Prepaid Lease (-) | Rest, not periodized prepaid lease
Prepayment Balance (-) | Any possible ”on account” on the contract
Adjustment Net Amount Column |
Mileage | Mileage
Reconditioning | Here you may register any possible reconditioning charge.
Other Charges | Here you may register other charges in connection with the return/term of the asset.
Vendor Net Amount Column |
Subsidy/Commission Rest | Rest not periodized subsidy/commission
Vendor Expenses | Other charges depending on termination actions in the expense class
Expenses | Add vendor expenses
VAT Column | Displayed on each item, and also included in the subtotal for each heading, i.e. object, contract, adjustment and vendor.
Total Column | Subtotal for each heading, i.e. object, contract, adjustment and vendor.


Consignment report

Dealer

Account invoices

Accounts can be configured in View21 to allow dealers to see account invoices

Account Search

Enter Object License or account number and press the "Find" button" to search for a specific account. Accounts must be configured in View21 to be accessible for the Dealer or a child dealer in a organization.

This will show a invoice report for given account

Invoice | Invoice number
DueDate | Invoice due date
Last Paydate | Invoice last paydate
Total Amount | Invoice total amount
Paid | Invoice paid amount
Rest | Invoice rest amount
Status | Invoice status
Installment | Invoice installment
Interest | Invoice interest amount
Expenses | Invoice expenses amount
Vat | Invoice Vat amount


Engagement

Dealer

Engagement


Factoring

Factoring

Factoring is basically a finance form where one party (factor) settles account receivables for a second party (creditor) versus a third party (debtor).

This is done by the creditor transferring open invoices to the factor that collects payment from debtor.

Factoring types:

  • Administrative Factoring - the factor performs the process of reminding and collection (dunning), often also the issuing of the original invoice. Factor pays creditor when the debtor pays and subtracts his fees and commissions. Disputable and non-collectable claims are rejected by the factor versus the creditor.
  • Financial Factoring – As Administrative factoring with the addition that the factor grants creditor a loan (either as payout of a new tranche or as increasing limit on a credit line) as a function of the receivable amount. When debtor pays, the credited amount is subtracted (together with fees and commission) before final amount (reserve) is credited creditor. Disputable and non-collectable claims are rejected by the factor versus the creditor and any credited amount reversed (Recourse).
  • Portfolio Factoring – The factor purchases the total (or segments of) creditors receivables at an agreed price at own risk. Some variants of constructions exist, but often factor takes most risks, sometimes with exemption of disputes.
The setup-window of factoring agreements is done in the CoreView application.


Factoring Invoice Overview

Factoring

Factoring Invoice Overview

The Invoice Overview page is a master -detail where the invoice-files is shown in the upper part. The list of files may be filtered by File Id and factoring agreement.

When a row is selected in the upper file table, the lowermost shows its invoices with key figures.

When a row is selected in the lower invoice table, dispute messages may be attached to the invoice. The dispute messages may be inspected in the Dispute Overview page.

Creditor (Customer number & name) | Logged in user (agreement creditor)
File Id | Id of the invoice file (used as fetch-filter)
Agreement | List of creditors factoring agreements
Fetch | Fetch a list of the factoring invoice files
New Dispute | Add a dispute message to the invoice

Factoring Invoice-File Table
Factoring Agreement | Factoring agreement where the invoice belongs to
File Id | File identification string
Invoices | Total invoices in the file
Total Amount | Total invoiced amount in the file
Time | File read time, set automatically

Factoring Invoice Table
Invoice Number | Invoice number (external).
Financed Amount | Depending on finance degree
Paid Fees | Paid fees
Mortgaged | If checked, the invoice is included in the Hypothec balance
Factoring Status | Preliminary, OK, Erroneous, Rejected, Reversed, Disputed
FactoringFile | Factoring XML-file identification string
Invoice / Out | View21 invoice number.
Customer | Customer number.
Customer Name | Customer's surname or name of company.
Due Date | Due date.
Currency | Invoice currency
Rest | Amount not yet paid.
Type
  • Factoring - standard factoring invoices.
  • Factoring Reminder - factoring reminder invoice.
Invoice Status | Current status of invoice.
Method | See 'Invoice Overview' for a method overview
Last Pay Date | Date for latest payment.
Total | Total invoiced amount.
Paid | Paid amount so far.
This Total | Amount from current period.
This Paid | Amount paid on current period so far.
Reminder Fee | Fee for sending out reminders.
Principal Penalty | Penalty interest for late payments in previous periods.
Expenses | Expenses – payments to the customer.
Vat | VAT amount
Receivable Ref. | Invoice’s transaction reference number.
Pay Ref. | The last payment’s transaction reference number.
Cid | The invoice’s Customer Identification number
Date | Date for invoice generation.
Delay Date | Delay date.
Error Text | Error text in case of status=erroneous


Invoice Disputes

Factoring

Invoice Disputes

The Invoice Dispute shows invoices with dispute messages, possibly filtered by factoring agreement and reversed invoices.

When a row is selected in the upper invoice table, the lower leftmost table shows its dispute list. This list is selectable and each message contents is shown in the lower rightmost text-area.

Disputed invoices may be reset to normal state or reversed. Reversed invoices can not be reset to normal state

Creditor (Customer number & name) | Logged in user (agreement creditor)
File Id | Id of the invoice file (used as fetch-filter)
Agreement | List of creditors factoring agreements
Include Reversed | Also show disputed reversed invoices
Fetch | Fetch a list of the factoring invoice files
Reverse | Reverse the invoice
Reset | Reset the invoice to normal status

Disputed Invoices Table
Agreement | Factoring agreement where the invoice belongs
Invoice No | External invoice identification
Reversed | Reversed invoice mark
File-ID | Invoice file identification
Invoice# | Internal View21 invoice number
Customer | View21 Debtor Number
Customer Name | Debtor name
Due Date | Invoice due date
Cid | Invoice CID

Dispute List
Dispute# | Internal dispute sequence number.
Date | Date when the dispute was entered


New Debtor

Factoring

New Debtor

New debtors may be created with this page, the invoice-address information is entered in lowermost part. The customer information of existing debtors may be altered.

Agreement | Creditors factoring agreements
Last Name | Debtors last name
First Name | Debtors first name
Org/Pers. Nr. | Debtors organization or person number
Acc. Group | Debtors accounting group
Browse | Browse and fetch an existing debtor (for modification)
Clear | Clear all fields and make them writeable
Modify | Modify mode, keep field contents but make them writeable
Save | Save the debtor information, new or updates
Cancel | Cancel a modification

Address Name | Name of the customer address.
Customer | Customer number.
Last Name | Last name.
First Name | First name.
Address 1 | Address line 1.
Address 2 | Address line 2.
Address 3 | Address line 3.
City | City.
ZIP | ZIP.
Country | Country.
Invoice Email | E-mail address for invoices.
Email | E-mail address.
Phone | Phone number.
Mobile | Mobile phone number.
Fax | Fax number.


New Factoring Invoice

Factoring

New Factoring Invoice

With this page the user may create new individual factoring invoices with multiple amount/description lines. Functionally this page corresponds to the independent invoice menu in the CoreView application.

Creditor (Customer number & name) | Logged in user (agreement creditor)
Agreement | Creditors factoring agreements
Due Date | Invoice due date
Invoice Date | Invoice date
Debitor | Debtors Vew21 customer number and name (read-only)
Cid | Invoice CID
Invoice No. | External invoice number
Amount | Detail Amount
Description | Detail description
Specification | Extra invoice Specification
Ref. No | Returned transaction reference after a successful creation
Save | Save the detail line into the detail table (amount/description, Vat is automatically calculated)
Cancel | Clears amount/description
Execute | Creates the factoring invoice


Factoring Transfer Funds

Factoring

Factoring Transfer Funds

With this page the agreement-creditor user may transfer funds from his credit-line account to his netting-account.
These accounts are specified in the agreement setup.

Be sure the users profile is defined with sufficient transaction limits.

Creditor (Customer number & name) | Logged in user (agreement creditor)
Agreement | Creditors factoring agreements
Description | Transfer description
Amount | Amount for transfer
Value Date | Transaction value date
Ref. No | Returned transaction reference after a successful transfer
Execute | Executes the transfer operation


Appendixes

Dealer

Appendixes

Appendix A, Export of report tables to Excel

Appendix B, Date fields and the calendar


Appendix A, Export of report tables to Excel

Dealer

Appendix A, Export of tables to Excel

Most Floorplanning reports can be exported to excel. Reports that are available for export has the excel icon in the report header.

Currently Excel version 97 or higher is supported.

After the report has fetched and displayed, click the excel button to export. This will popup a new browser window and prompts the following message:

1) Open will open the Excel document in popup browser window.

2) Save will allow you to save Excel documents to disk.

Output of Consignment Report exported to Excel:


Appendix B, Date fields and the calendar

Dealer

Appendix B, Date fields and the calendar

All date fields in the Floorplanning web application have calendar function. In a date field press “F2” will popup the calendar.

Calendar buttons

OK | Select current date
> | Next month
< | Previous month
>> | Next year
<< | Previous year

Calendar navigation keys

Arrow up | Move up week in current month
Arrow down | Move down week in current month
Arrow left | Move back one day in current month
Arrow right | Move forward one day in current month
Page up | Next month
Page down | Previous month
Home | Next year
End | Previous year
Enter | Select current date
Esc | Cancel