Home » Categories » Solutions by Business Process » Utilities

Post Code Analysis

Datafile Software

Post Code Analysis

It can be useful to analyse (say) sales by post code but with the varying lengths of post codes – for example Liverpool is ‘L’, some London areas are ‘EC’, you can’t create a standard item for analysis unless you manually entered these details into a separate data item. This new feature allows you the option to create two sub-items based on the post code that will enable this analysis.

The first, PC-MAIN, takes the initial letters of the post code, the second PC-BREAK, takes the first part of the post code.

Example Post Code PC-MAIN PC-BREAK

CH41 5AZ CH CH41

L3 4BD L L3

EC1M 9RT EC EC1M

Whichever item you require can then be used for sorting and subtotalling in your reports.

Installation

To use either of these options requires you create a sub-item in a database containing a post code (such as the sales accounts file). The data items need to be created with the detail below.

Item Name Type Description

PC-MAIN = Sub-item of the post code, starting at position 1 with a size of two characters. If the second character is a number then this is replaced with a blank.

PC-BREAK = Sub-item of the post code, starting at position 1 with a size equal to the length of the post code field itself.

Custom Fields
  • Release ID: 5.6
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Forecast Dates - Additional Options
Viewed 2202 times since Fri, May 27, 2016
Main Menu Icons
Viewed 1938 times since Wed, Jun 13, 2012
Sales/Purchase Batch Updates
Viewed 1611 times since Thu, Jul 5, 2012
Create / Update Account Records Before Import
Viewed 1966 times since Wed, Jun 13, 2012
Additional Copy Items from Input File
Viewed 1775 times since Wed, Jun 13, 2012
Confirm Printer - Stock Batch Update
Viewed 1670 times since Thu, Jul 5, 2012
Confirm Default Reference / Description at Run-time
Viewed 1739 times since Tue, Jun 12, 2012
Input File Pathname - Stock Batch Update
Viewed 1741 times since Thu, Jul 5, 2012
Stock Batch Update
Viewed 1529 times since Thu, Jul 5, 2012
Report Specification - Sales/Purchase Batch Updates
Viewed 1683 times since Thu, Jul 5, 2012