NP Retail Support

Search






Table of Content


68.7 Conversion from Audit Roll to POS Entry List.
68.7.1 Conversion Script to Upgrade to POS Entry List.
68.7.1.1 POS Payment Method List.
68.7.1.2 POS Payment Bin.
68.7.1.3 POS Posting Setup.
68.7.2 Conversion of closing balance from V1 into Opening balance in V3.


Conversion from Audit Roll to POS Entry List.

Conversion Script to Upgrade to POS Entry List.

The conversion script is accessible from the NP Retail Setup as follows



From the Navigate Ribbon choose Upgrade/Upgrade to Balancing V3 Setups.
The following tables will be created

  1. POS Payment Method List
  2. POS Payment Bins
  3. POS Posting Setup.


POS Payment Method List.


The input will be the Payment Type table
For each Payment Type a corresponding POS Payment Method List will be created.



Field mapping will be done as follows


POS Payment Method List



Payment Type


Field No.

Field Name

Field Name


1

Code

No.


10

Processing Type

Processing Type
See below for detailed mapping


15

Currency Code



20

Vouched By



25

Is Finance Agreement



30

Include In Counting

To be Balanced


35

Bin for Virtual-Count



40

Post Condensed

Posting


41

Condensed Posting Description



50

Rounding Precision

Rounding Precision


51

Rounding Type

"Nearest"


52

Rounding Gains Account



53

Rounding Losses Account




Mapping of Processing Type Field

"Payment Type"."Processing Type"

"Payment Method List"."Processing Type"

Cash

CASH

EFT

EFT

Foreign Credit Voucher

VOUCHER

Foreign Gift Voucher

VOUCHER

Finance Agreement

VOUCHER

Payout

PAYOUT

Foreign Currency

CASH

Gift Voucher

VOUCHER

Credit Voucher

VOUCHER

Terminal Card

EFT

Manual Card

EFT

Other Credit Cards

EFT

Debit Sale

CUSTOMER

Invoice

CUSTOMER

DIBS

EFT

Point Card

EFT


POS Payment Bin.


The Input table is POS Units.
For each record in POS Units a corresponding POS Payment Bins will be created.
Field Mapping will be done as follows


POS Payment Bins



POS Units

Field No.

Field Name

Field Name


1

No.

No.


5

POS Store Code

POS Store Code


6

Attached to POS Unit No.

No.


10

Description



20

Status



30

Invocation Method

"Printer"


40

Bin Type

"CASH_DRAWER"




POS Posting Setup.

For each combination of Cash Register and Payment Type Method List,
A record will be created.
The fields mapping are as follows

POS Posting Setup




Field No.

Field Name

Field Name


1

POS Store Code

Register."Register No."


2

POS Payment Method Code

PaymentTypePOS."No."


3

POS Payment Bin Code

Register."Register No."


8

Account Type

PaymentTypePOS."Account Type"


9

Account No.

PaymentTypePOS."G/L Account No."


10

Difference Account Type

"G/L Account"


11

Close to POS Bin No.



12

Difference Acc. No.

Register."Difference Account"


13

Difference Acc. No. (Neg)

Register."Difference Account - Neg."



Conversion of closing balance from V1 into Opening balance in V3.

The function enabling "Advanced POS Entries Activated" in NP Retail will convert the Audit Roll Entries into POS Entry and will as well convert the closing balance from Balance V1 into opening balance in Balance V3.



The following conditions prevails for it to calculate the opening balance:

  1. All Setups (as per setup section above) must be done beforehand.
  2. The Cash Register must be balanced before data migration; hence the Cash Register will have a Status = 'Balanced'.


The function creates a "dummy entry" to set the opening balance. There is no accounting entries associated with it as, the accounting entries has already been taking care in the closing of Balance V1.
Note:
In case, the process of enabling the "Advanced POS Entries Activated" and the opening balance is not created, then whatever the balancing in V3 is done, a Cash Difference will be generated for that first day and this will be equal to the opening balance. Any Cash Difference on balancing, generates an accounting entry. This accounting entry will need to be reversed manually by a General Journal in Nav.