Table of Content
68.7 Conversion from Audit Roll to POS Entry List.
68.7.1 Conversion Script to Upgrade to POS Entry List.
188.8.131.52 POS Payment Method List.
184.108.40.206 POS Payment Bin.
220.127.116.11 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
- POS Payment Method List
- POS Payment Bins
- 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
Is Finance Agreement
Include In Counting
To be Balanced
Bin for Virtual-Count
Condensed Posting Description
Rounding Gains Account
Rounding Losses Account
Mapping of Processing Type Field
"Payment Type"."Processing Type"
"Payment Method List"."Processing Type"
Foreign Credit Voucher
Foreign Gift Voucher
Other Credit Cards
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 Store Code
POS Store Code
Attached to POS Unit No.
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
POS Store Code
POS Payment Method Code
POS Payment Bin Code
PaymentTypePOS."G/L Account No."
Difference Account Type
Close to POS Bin No.
Difference Acc. No.
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:
- All Setups (as per setup section above) must be done beforehand.
- 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.
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.