Multi Location Data Status

Location

Shows name of the locations. E.g. Head Office, Branch1, Brach2 etc.

Local Files Export

Number of files present in "export folder" to export to a particular location. It shows number of files pending to be sent to a location.

Note:

•It is related to "method of communication" = Offline or FTP

•It may be ignored if method of communication = IP

Local Files Import

Number of files present in "import folder" after receiving from a particular location. It shows number of files received from a location and yet to be written in the database

Note:

•It is related to "method of communication" = Offline or FTP

•It may be ignored if method of communication = IP

Inbox Data

Number of data present in the Inbox shows number of records received from a location and yet to be written in the database.

Outbox P1

Outbox Priority 1: The data with higher priority such as Home Delivery transaction data.

It shows the number of records present in outbox to be sent to other location.

Outbox P2

Outbox Priority 2: The data with 2nd priority such as masters, settings and transactions.

It shows the number of records present in outbox to be sent to other location.

As the name suggest, the P2 data is sent only after all P1 data is sent.

Outbox P3

Outbox Priority 3: The data with lower priority such as master modified at a branch.

Once the master data is modified at branch, the modified master is reflected at HO in "Outbox P3".

As the name suggest, the P3 data is sent only after all P1 and P2 data is sent.

All Outbox P1, Outbox P2 and Outbox P3 will be viewed at Head Office.

Branch Outbox

To show pending outbox data of the branch. The branch updates this data every 5 minutes. It helps you to know how many records are pending at branch.

Last Sale

It shows the date and time of the last sale voucher for each location.

You need to press button "Incl Sale" in order to see last sale date.

Master Difference

Shows difference of master between branch and head office. The branch updated this data every time RanceLab starts at branch server.

In order to see master difference in detail you need to press enter on the location row.

Note: This works only at HO.

Note:

•If the master difference shows negative value, then it means the branch is having more master

•OR the branch has created product child that are yet come to HO.

Columns in Master Difference:

Buttons in Master Difference:

Buttons are explained in Using Reports (Register). Buttons specific to “Master Difference” is discussed here;

Create ML Data

It shows True = If "Create Multi-Location Data " is set to "Yes" in Location Master. It shows False it is set to No.

This column is used to filter out these location in the ML status report.

Active

It shows True = If "Is Active" is set to "Yes" in Location Master. It shows False it is set to No. This column is used to filter out these location in the ML status report.

IP Last Recd

To show the date and time of the last data received by IP.

IP Last Send

To show the date and time of the last data send by IP.

IP Recd Diff

Difference in Days-Hours-Minutes since the last data received by IP.

IP Recd Diff(Min)

Difference in Minutes since the last data received by IP.

IP Send Diff

Difference in Days-Hours-Minutes since the last data send by IP.

IP Send Diff(Min)

Difference in Minutes since the last data send by IP.

FTP Files

Number files present in FTP server in the folder of that particular location.

FTP Latest Time

The Latest time of the available files in the FTP folder for that particular location. (American Standard Time)

FTP Oldest Time

The oldest time of the available files in the FTP folder for that particular location (American Standard Time)

FTP Diff In Hrs

Difference of ‘FTP Oldest time’ and ‘FTP Latest time’ in Hours.

F5 Refresh

Press F5 to rerun the report without the need to exit and enter into the report.

-F FTP Status

Shows FTP Status. It checks the FTP address and get details of pending files at each location.

-S Incl Sale

Press button "Incl Sale" in order to  see last sale received data. After pressing the button system will show date and time of the last sale voucher received from the location in the "Last Sale" column.

^S Comp Trans

It will work only at branch if Remote Data Service is available.

Click this button or press CTRL + S to see comparison report of selected transaction from the list, between Branch and Ho for a given date range.

You may select Account / Issue to Customer / Issue to Jobber / Opening Stock / Physical Stock / Prepaid Card Transaction / Purchase / Purchase Challan / Purchase Order / Purchase Return / Rate Change / Received from Customer / Received from Jobber / Rejection In / Rejection Out / Sale / Sale Challan / Sale Order / Sale Return / Stock Journal / Stock Transfer / Stock Transfer Indent / Work Order.

Columns in Transaction Comparison:

Note:

•If difference > 0 then send data to HO and if difference < 0 then send data to Branch.

•You may select one or more date rows and click on "^X Export" OR "^E Export ZIP" button to send the data.

Buttons in Sale Comparison:

Buttons are explained in Using Reports (Register). Buttons specific to “Sale Comparison” are discussed here:

Related Faq:

•How can I compare multi location transaction data of Branch with HO ?

-X Back Export

Press ALT + X to carry zip data from the Export folder to Outbox.

Recommended for the IP and FTP users.

^E Export ZIP

Press ^E to create a ZIP file in Export Folder for the selected location from data available in Outbox. Recommended for the Offline users.

-C Loc-Sale

It shows location wise sale for a given date range.