POSitive Multi-Site uses data replication to share all data from all sites at all sites. This means, that the data from Site 1 is also at Site 2. So, when looking up Invoice History, how does Site 1 know which data to present?

All POSitive data is stored in what are called "Tables" in the SQL database.  For example, a Table might be called "Invoices".  Within this Table are Records which contain Fields.  For example, a Record might contain the "Invoice Number" field, the "Invoice Date" field, etc.

When you look at the Invoice History list in POSitive, you are looking at a listing of Records from the "Invoices" Table. They are sorted by Date and Time, so that the most recent are displayed first in the list. A very important Field in each Record, is the "Site" field.

The "Site" field, as you may have guessed, is different for each physical location. For example, your Master site might have a Site ID of B000, and your Remote site might have a Site ID of B100. All POSitive has to know is what Site is needs to display, and then it displays only those Records that belong to that Site. So at the Master Site, you would only display records that had a Site field equal to B000.

This data structure makes it easy to view data from any site at any site. All we need to do, is tell POSitive what the Site is. So, in Invoice History, you can use the "Site" drop down, select the Site you want to view, and the Records for that Site are displayed.

Because replication allows us to replicate all data from all sites at all sites, we can write reports that compare this information. So, you can view or print the different stock levels for a particular item across all sites. Or compare overall sales totals across all sites.

POSitive has many of these views and reports included in the program. If there is a specific report you need, a 3rd party reporting product such as Crystal Reports can be used to access this data, and give you the information you want.

Close Window