Home » Categories » Solutions by Business Process » Utilities |
Post Code Analysis |
Article Number: 394 | Rating: Unrated | Last Updated: Wed, Jun 14, 2023 at 4:19 PM
|
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. |
Attachments
![]() There are no attachments for this article.
|
Create / Update Accounts - Order Processing Batch Updates
Viewed 1803 times since Thu, Jul 5, 2012
Installation Details - Job Costing Batch Update
Viewed 1673 times since Thu, Jul 5, 2012
Report Specification - Sales/Purchase Batch Updates
Viewed 1776 times since Thu, Jul 5, 2012
Confirm Printer - Sales/Purchase Batch Updates
Viewed 1754 times since Thu, Jul 5, 2012
Batch Update Processing - Stock Batch Update
Viewed 1768 times since Thu, Jul 5, 2012
Custom Features - Stock Batch Update
Viewed 1785 times since Thu, Jul 5, 2012
Installation Details - Stock Batch Update
Viewed 1639 times since Thu, Jul 5, 2012
Stock Batch Update
Viewed 1638 times since Thu, Jul 5, 2012
System Status - Sales/Purchase Batch Updates
Viewed 1691 times since Thu, Jul 5, 2012
Input File Structure - Sales/Purchase Batch Updates
Viewed 1857 times since Thu, Jul 5, 2012
|