NP Retail Support

Search




Table of Contents

68.8 Conversion from Audit Roll to POS Entry List.
68.8.1 Conversion Script to Upgrade to POS Entry List.
68.8.1.1 POS Payment Method List.
68.8.1.2 POS Payment Bin.
68.8.1.3 POS Posting Setup.
68.8.2 Conversion of closing balance from V1 into Opening balance in V3.
68.8.3 Conversion of Audit Roll to POS Entry Checklist



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 Audit Roll to POS Entry List Tool"

The following tables will be created

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


68.8.1.1 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


68.8.1.2 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"



68.8.1.3 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.

Conversion of Audit Roll to POS Entry Checklist

The major difference between using Audit Roll & POS Entry are that in relation to Audit Roll, you will need mainly:

  • Cash Registers setup
  • Payment Types
  • Retail setup

whereas for POS Entry, you will need:

  • POS Stores (It was done in our conversion to Transcendence task)
  • POS Units (It was done in our conversion to Transcendence task)
  • POS Payment Bins
  • POS Payment Methods
  • POS Posting Setup


Steps

Particulars

Comments

0

MAKE SURE that all cash registers are balance before proceeding with conversion.


1

Run the tool: Upgrade to Balancing V3 Setups in NAVIGATE Ribbon from NP Retail Setup

The following tables will be created
POS Payment Method List
POS Payment Bins
POS Posting Setup.
But you need to verify them

2

Verify that the POS Store are all configured


3

Verify the POS Units that were created manually are correct


4

Update the POS Payment Bins if required


5

Verify the POS Payment Methods


6

Lastly verify the POS Posting Setups if you are not satisfied with the ones created by the tool.

Refer to the notes on how to decide on the ways to create the POS Posting setup. It will not be the same logic for each POS Method.

7

Given that the POS Entry is the source of the posting data, then all the printout will be based on it. You need to verify if you have the equivalent of the Print Templates for POS Entry for the one that you are currently using.


8

Now that you are going to replace the balancing method by the Balance V3, you need to prepare a new POS Action or rather button for it in you company. On day one, you will disactivate the current Balancing button & activate the new one.

You might need more than one button. For example, you can be using:
X-Report
Z-Report
Close Workshift
If you are using more than one button, you prepare it in advance & then on day one, just import the POS Menus for it.

9

If the Audit Roll is currently run during the night by a task, you will need to create a new task for Posting POS Entry and disactivate the current task.

The codeunit to schedule is 6150631 "POS Post with Task Queue"

10

Complete the setup for NP Retail, specially when do we want to post the Item Ledger Entry & the General Ledger Entry


11

When all the set have been done, then we need to convert it.

  1. Run Advanced POS Entries Activated. It might take a long time, depending on the data. (e.g Tivolifri took 2.5 hrs to run)
  2. Get out of the NP Retail page so that it refreshes by itself & then re-enter the page to continue with the next step
  3. Advance Posting Activated. This will be quick. (Around 5 mins for Tivolifri)|

Before converting an existing company, it is imperative to Balance all registers using the current balancing function. All Cash Registers must be balanced before-hand.


Also, the conversion tool will take the Default Payment Type as the opening POS Method for the POS Unit.

For example, if you have a Default Payment Type = K-FOOD instead of K, then the opening balance when converted will be K-FOOD and not K. It is important to check the Default Payment Type on each register.|

12On opening the Cash Register, the balance of the previous day will appear, and a POS Period Register will be created

If ever the Cash Register was not balanced the day before, this will not happen. We will need to go into the POS Period Register Table to create a line for it.