Category Articles RSS Feed
Discount Matrix File Structure
Viewed 7301 times since Wed, Jun 27, 2012
Datafile Software Discount Matrix File Structure The matrix database has a pre-defined structure, as described below. The prime index is a composite of the account code or group and the product code or group (and the expiry date if so configured... Read More
Document Parameters - Document Design Manager
Viewed 5610 times since Wed, Jun 27, 2012
Datafile Software Document Parameters - Document Design Manager In addition to the design features accessible from the document mask there are various parameter screens which can be used to configure the printed output and the processing of the... Read More
Add Matrix Entries
Viewed 4375 times since Wed, Jun 27, 2012
Datafile Software Add Matrix Entries On selection of the ‘Add’ entry the matrix entry screen is displayed. Account Group or A/c Code Stock Group or Stock Code You are only offered the ‘Account Group’ option if the... Read More
Prompts: Request Information from Keyboard
Viewed 3570 times since Wed, Jun 13, 2012
Datafile Software Prompts: Request Information from Keyboard The maximum size of the inputs definable within the ‘Prompts: Request Information from Keyboard’ has been increased from 40 to 75 characters (although if updating a data... Read More
Recall Standard Text
Viewed 1837 times since Wed, Jun 27, 2012
Datafile Software Recall Standard Text Recall Standard Text allows you to attach a word or phrase to a specific key combination (such as <SHIFT>+<F1>). For example you might have a series of standard texts to use for the transaction... Read More
Purchase Invoices
Viewed 1352 times since Tue, Jun 26, 2012
Datafile Software Purchase Invoices The ability to use the Invoicer program for purchase invoices serves two distinct purposes.Firstly, you can use it record supplier invoices onto the purchase ledger and as a by-product of the process book... Read More
Print Preview and Test Print - Document Design Manager
Viewed 1344 times since Wed, Jun 27, 2012
Datafile Software Print Preview and Test Print - Document Design Manager You can preview the document to the screen or the printer from the File pull-down menu. Selecting the Print Preview option shows the document on screen. You can use the... Read More
User Instructions
Viewed 1323 times since Tue, Jun 26, 2012
Datafile Software User Instructions This chapter describes how to use the Datafile Software Invoicer system. We assume that you have already learned how to sign on to your Datafile Software system and how to use the Datafile DeskTop facilities ... Read More
Sales Invoices - Printing the Document and Updating Files
Viewed 1306 times since Tue, Jun 26, 2012
Datafile Software Sales Invoices - Printing the Document and Updating Files The final stage of the invoice is to print the document and update the files. Print the Document Confirm ‘Y’ to print the document, or ‘N’ to... Read More
Update Matrix Entries, Enquire Matrix Entries, Delete a Matrix Entry
Viewed 1295 times since Wed, Jun 27, 2012
Datafile Software Update Matrix Entries, Enquire Matrix Entries, Delete a Matrix Entry These options work in a similar way to the Add Matrix Entries option, except that their functions are only to update, look at, and delete matrix entries... Read More
Sales Invoices
Viewed 1203 times since Tue, Jun 26, 2012
Datafile Software Sales Invoices You use this option to prepare and print invoices for customers. The design of invoice documents and their processing is achieved using the Document Design Manager option of the Installation program and need... Read More
System Profiles / Sales (Purchase) Ledger - Discount Matrix
Viewed 1194 times since Wed, Jun 27, 2012
Datafile Software System Profiles / Sales (Purchase) Ledger - Discount Matrix The fifth screen of parameters in the ledger system profiles asks a few extra questions needed for matrix processing. Apply Discount Matrix Look-up Select if you wish... Read More
Set Database Profiles - Discount Matrix
Viewed 1192 times since Wed, Jun 27, 2012
Datafile Software Set Database Profiles - Discount Matrix Although there are no Database Profiles for the matrix files themselves there are settings within the application profiles that control how the matrix options are applied. Sales (Purchase... Read More
Change Company - Discount Matrix
Viewed 1166 times since Wed, Jun 27, 2012
Datafile Software Change Company - Discount Matrix This option lets you change to another company’s discount matrix file. Read More
Add a New Product
Viewed 1165 times since Tue, Jun 26, 2012
Datafile Software Add a New Product This option is used to add products to the product file. At initial set-up time, use this option to enter your existing product details from either your present manual or computerised system. On selection of... Read More
Sales Invoices - Detail Line Entries - Stock and Product Invoices
Viewed 1143 times since Tue, Jun 26, 2012
Datafile Software Sales Invoices - Detail Line Entries - Stock and Product Invoices Whether they are stock-linked, product-linked, or free-format invoices, the prompts follow exactly the same pattern, so are described together below. Certain... Read More
Purchase Credit Notes - File Updating and Ledger Controls
Viewed 1141 times since Tue, Jun 26, 2012
Datafile Software Purchase Credit Notes - File Updating and Ledger Controls The effect on the purchase ledger of entering a purchase credit note is as follows: the outstanding balance is reduced by the total including tax (if not ‘paid... Read More
Product Maintenance
Viewed 1136 times since Tue, Jun 26, 2012
Datafile Software Product Maintenance This part of the program allows you to add, amend and delete products from the product file which applies to this company. There is no need for a separate product file if you are using your stock file for... Read More
Always Change Account Items
Viewed 1135 times since Mon, Jun 11, 2012
Datafile Software Always Change Account Items When record a sales invoice the system displays items from the selected account (usually the name and address detail) for confirmation and asks whether you wish to update these details for this... Read More
Sales Credit Notes - File Updating and Ledger Controls
Viewed 1131 times since Tue, Jun 26, 2012
Datafile Software Sales Credit Notes - File Updating and Ledger Controls When a sales credit note is generated the effect on the sales ledger is as follows: The outstanding balance on the account is reduced by the total including tax, unless a... Read More
Sales/Purchase Account Enquiry, Stock Record Enquiry - Discount Matrix
Viewed 1118 times since Wed, Jun 27, 2012
Datafile Software Sales/Purchase Account Enquiry, Stock Record Enquiry - Discount Matrix For your convenience you can look up specifically to the sales (purchase) ledger and stock system files in exactly the same way as defined under the... Read More
Database Audit
Viewed 1113 times since Wed, Jun 27, 2012
Datafile Software Database Audit Use this option to check the internal integrity of the product database. If you’re sure that a particular record is in the file but you cannot select it via the indexes then you might want to use this... Read More
Product Prices - Database Profiles
Viewed 1103 times since Wed, Jun 27, 2012
Datafile Software Product Prices - Database Profiles Selling Price 1-9 K L M * Up to nine different selling prices can be held for a stock item (5 on Professional Systems, 3 on Compact). Whilst different prices can use different types they... Read More
Extra File Scans
Viewed 1097 times since Wed, Jun 27, 2012
Datafile Software Extra File Scans This option allows you to set the authority level to enable the facility to scan documents against the product record within the Ledger Enquiry. Set the authority level as required (0-9 where 0 is the highest,... Read More
Enter Prices Inclusive of VAT
Viewed 1092 times since Mon, Jun 11, 2012
Datafile Software Enter Prices Inclusive of VAT Within entry options such as direct transaction entry within the Sales/Purchase Ledgers and Cashbook receipt/payment postings the system allows entry of the total value including tax into &lsquo... Read More
Document Processing
Viewed 1087 times since Tue, Jun 26, 2012
Datafile Software Document Processing Invoice and credit notes follow a pattern which is defined by the associated document definitions.The user instructions which follow below describe all the questions which you could be asked. However, it is... Read More
Document Design Manager
Viewed 1068 times since Wed, Jun 27, 2012
Datafile Software Document Design Manager The Document Design Manager is available on the main ‘Installation’ menu for Compact and Professional users, for Diamond and Premier users it is available on the ‘Application Manager... Read More
Fax Printing - Document Design Manager
Viewed 1042 times since Wed, Jun 27, 2012
Datafile Software Fax Printing - Document Design Manager Selected fax software, such as Tobit David and Zetafax, allow programs to pass information to them with regards to fax and contact details. This option allows you to enter those commands... Read More
Application Manager Parameters
Viewed 1040 times since Wed, Jun 27, 2012
Datafile Software Application Manager Parameters You need to set a few parameters and define some extra data items to determine exactly how the discount matrix facility is to work. These are: Read More
Improvements to Product Maintenance
Viewed 1039 times since Wed, Jun 13, 2012
Datafile Software Improvements to Product Maintenance As with the Sales/Purchase Ledger, this release brings a new interface to the product maintenance procedures within Invoicer. The first change is to the menu options available – an ACTION... Read More
E-Mail Settings - Document Design Manager
Viewed 1034 times since Wed, Jun 27, 2012
Datafile Software E-Mail Settings - Document Design Manager The E-Mail Settings option allows you to configure default message details if the document is printed to E-Mail. (This option is not available for all documents – for example cheques... Read More
Product Items - Database Profiles
Viewed 1026 times since Wed, Jun 27, 2012
Datafile Software Product Items - Database Profiles Product Code X (16) The prime index of the product file holding the product code itself Description X (48) Holds the first line of description for the product item. An optional second item is... Read More
Purchase Invoices - Scanning Invoices
Viewed 1016 times since Tue, Jun 26, 2012
Datafile Software Purchase Invoices - Scanning Invoices After updating the purchase ledger (and stock files if appropriate) the system may, if configured, prompt to scan your supplier’s invoice. This scanned file is then saved for later... Read More
Sales Invoices - Header Information - All Invoice Types
Viewed 1001 times since Tue, Jun 26, 2012
Datafile Software Sales Invoices - Header Information - All Invoice Types Document Information After selecting the invoice layout which you wish to use for this invoice you are presented with a screen similar to that below. For all invoice... Read More
Default Nominal Code for Document
Viewed 999 times since Mon, Jun 11, 2012
Datafile Software Default Nominal Code for Document This new feature allows a setting for a default nominal code against the document to be applied for free-format lines (or where nominal code not set against stock/product record or the customer... Read More
Default Transaction Description to Account Item
Viewed 995 times since Mon, Jun 11, 2012
Datafile Software Default Transaction Description to Account Item When posting invoices to the ledger the system prompts for the transaction description, this new feature allows you to set the default description to be picked up from the first... Read More
Application User Facilities
Viewed 986 times since Wed, Jun 27, 2012
Datafile Software Application User Facilities The Application User Facilities allow configuration of the individual Invoicer options – this option is only applicable for Diamond and Premier Users. Read More
Discount/Supplier Matrix Introduction
Viewed 980 times since Wed, Jun 27, 2012
Datafile Software Discount/Supplier Matrix Introduction The matrix facility allows you to define special discount structures based on a combination of an account group (or account code) and a product group (or stock code). It gives support for... Read More
Location of Files - Discount Matrix
Viewed 979 times since Wed, Jun 27, 2012
Datafile Software Location of Files - Discount Matrix You must specify the pathname of the discount matrix file in the sales/purchase entries of this option.A base file is supplied, named BASE-MAT.DFD for the Sales Ledger Matrix and BASE-PLM.DFD... Read More
Create New Account and Stock Record Maintenance Screens
Viewed 978 times since Fri, Jun 8, 2012
Datafile Software Create New Account and Stock Record Maintenance Screens When processing invoice and credit documents the option is available, subject to document configuration, to create a new account or stock record. When creating a new... Read More
Application Manager
Viewed 975 times since Tue, Jun 26, 2012
Datafile Software Application Manager Selecting the Application Manager (Diamond and Premier only) menu option gives a further sub-set of actions. The options available on this menu are discussed in their own sections later on where... Read More
Price Checker - Discount Matrix
Viewed 974 times since Wed, Jun 27, 2012
Datafile Software Price Checker - Discount Matrix Price Checker is an option that allows enquiry of a price that will be charged to a particular customer (or will be charged by a supplier) for a stock item. For the customer price checker it... Read More
Product File Item Screen Design
Viewed 969 times since Wed, Jun 27, 2012
Datafile Software Product File Item Screen Design If Diamond (or Premier and you don’t wish to use the full screen design) then this option allows you to quickly configure the display of up to 32 items from the product file in two columns... Read More
Purchase Invoices - File Updating and Ledger Controls
Viewed 968 times since Tue, Jun 26, 2012
Datafile Software Purchase Invoices - File Updating and Ledger Controls The effect of entering a purchase invoice on the purchase ledger is as follows: the outstanding balance on the account is increased by the total including tax (if not paid)... Read More
Sales Credit Notes - Application User Facilities
Viewed 966 times since Wed, Jun 27, 2012
Datafile Software Sales Credit Notes - Application User Facilities This option puts you into the Document Design procedure to allow you to design up to six different sales credit note document layouts. The specific options for the document... Read More
Sales Invoices - File Updating and Ledger Controls
Viewed 958 times since Tue, Jun 26, 2012
Datafile Software Sales Invoices - File Updating and Ledger Controls When a sales invoice is posted to the ledger the following actions occur: The Outstanding Balance on the account is increased by the total including tax, unless the invoice is... Read More
Purchase Credit Notes
Viewed 956 times since Tue, Jun 26, 2012
Datafile Software Purchase Credit Notes Purchase credit notes are the reverse of purchase invoices. The descriptions given under Sales Invoices above can be followed exactly for purchase credit notes too. You can define up to six different... Read More
Configuring Invoicer
Viewed 955 times since Tue, Jun 26, 2012
Datafile Software Configuring Invoicer Your Datafile Software Invoicer application has a wide range of possible facilities, and you can undertake a great amount of structuring so that it suits your particular operation.Some of the general... Read More
Sales Credit Notes
Viewed 952 times since Tue, Jun 26, 2012
Datafile Software Sales Credit Notes Sales credit notes are the reverse of sales invoices. The descriptions given under Sales Invoices can be followed exactly for sales credit notes too. You can again define up to six different layouts ... Read More
Inserting New Items - Document Design Manager
Viewed 952 times since Wed, Jun 27, 2012
Datafile Software Inserting New Items - Document Design Manager To insert a new item position the mouse where you wish to insert the item and press the right-button on the mouse (hereafter described as right-click). A menu appears for you to... Read More
View System Status
Viewed 949 times since Tue, Jun 26, 2012
Datafile Software View System Status This option displays a summary of the current status of the invoicing system and of the product file. Company Displays the identifying code and name of the company in use. Product File Displays the number... Read More
System Profiles
Viewed 947 times since Tue, Jun 26, 2012
Datafile Software System Profiles The System Profiles set the general configuration options for Invoicer – this option is only applicable for Professional, Diamond andPremier users. Omit Any Link to Sales Ledger / Purchase Ledger Some... Read More
Set Auto Expand Files
Viewed 946 times since Wed, Jun 27, 2012
Datafile Software Set Auto Expand Files Datafile reserves a fixed space for database files and you need to expand that space should the file become full. This option allows you to set internal system parameters sot that it automatically attempts... Read More
Document Watermark - Document Design Manager
Viewed 940 times since Wed, Jun 27, 2012
Datafile Software Document Watermark - Document Design Manager You have the option to add a bitmap behind the entire document to act as a watermark. (If converting an earlier document that had a bitmap background then this is set as the... Read More
General Matrix Enquiries
Viewed 938 times since Wed, Jun 27, 2012
Datafile Software General Matrix Enquiries This option lets you look up the discount matrix file through the prime index (or secondary indexes if you defined them — perhaps on the first two comment lines, for example). You can look up a... Read More
Delete Product
Viewed 937 times since Tue, Jun 26, 2012
Datafile Software Delete Product Again the screen displayed is identical to above. On entering the product code the details are displayed with two buttons DELETE and ABANDON.ABANDON exits the menu; DELETE removes the product from the file. Read More
Set Database Profiles
Viewed 934 times since Wed, Jun 27, 2012
Datafile Software Set Database Profiles Database Profiles are the interface between the program and the databases, allow the program to read/update the data and interpret the values contained within. The data item profiles for Invoicer... Read More
Security and User Manager
Viewed 931 times since Wed, Jun 27, 2012
Datafile Software Security and User Manager The Security and User Manager allows you to set authority levels and passwords on specific application options and to define any user authority overrides. This option is only available for... Read More
Maintain Matrix File
Viewed 929 times since Wed, Jun 27, 2012
Datafile Software Maintain Matrix File The discount/supplier matrix file is maintained from the Datafile DeskTop Tools pull-down menu. When selected the following options are available. Read More
Sales Invoices - Detail Line Entries - Free Format Invoicing
Viewed 927 times since Tue, Jun 26, 2012
Datafile Software Sales Invoices - Detail Line Entries - Free Format Invoicing Free-format invoicing works in a very similar manner to stock or product invoices, except that stock –specific prompts, such as the stock code and which price, are... Read More
Printer Settings - Document Design Manager
Viewed 926 times since Wed, Jun 27, 2012
Datafile Software Printer Settings - Document Design Manager This option allows you to set a default printer and tray for the stock document. Clicking the drop-down list shows the printers available from the pc for you to select, after selecting... Read More
Set Application Code Formats
Viewed 924 times since Tue, Jun 26, 2012
Datafile Software Set Application Code Formats This option allows you to set the prime index format for each of the application databases including the Invoicer product file. The default format for the product file is AA9999 – this forces... Read More
System Status - Application User Facilities
Viewed 922 times since Wed, Jun 27, 2012
Datafile Software System Status - Application User Facilities This screen is for information only and lists the items displayed when the system status display option is selected within the Invoicer program. Read More
Product File Listings - Application User Facilities
Viewed 921 times since Wed, Jun 27, 2012
Datafile Software Product File Listings - Application User Facilities Here you define how the standard product reports are to print. For each report the parameters include the report heading (as offered to the user), print style (type of... Read More
Controls and Audit Manager
Viewed 920 times since Wed, Jun 27, 2012
Datafile Software Controls and Audit Manager The Controls and Audit Manager contains all the utility routines used to check the integrity of the database files and to undertake various housekeeping actions. The tools supplied for Invoicer... Read More
Product Reports
Viewed 915 times since Tue, Jun 26, 2012
Datafile Software Product Reports Up to seven reports, together with the details to be printed on each, can be defined using the Installation program. These report layouts are fixed for Datafile Professional (three reports) and Compact (two... Read More
Maintain Products (Screen Designs) - Application User Facilities
Viewed 915 times since Wed, Jun 27, 2012
Datafile Software Maintain Products (Screen Designs) - Application User Facilities Selecting this option gives you a sub-menu to configure the ‘Maintain Products’ screen and the screen designs used if you create sales accounts,... Read More
Application Screen Layouts
Viewed 909 times since Wed, Jun 27, 2012
Datafile Software Application Screen Layouts This option allows access to the ‘Maintain Screens’ section of the Application User Facilities and allows configuration of the stock maintenance screens. This option is only available... Read More
Sales Invoices - Closing Information - All Invoice Types
Viewed 908 times since Tue, Jun 26, 2012
Datafile Software Sales Invoices - Closing Information - All Invoice Types Additional Charge An additional charge can be configured for your document (Document Design parameter screen ‘Additional Charge / Overall Discount’) The... Read More
Set Company Details
Viewed 901 times since Tue, Jun 26, 2012
Datafile Software Set Company Details The Invoicer documents allow the printing of ‘data’ items for the company name and address details.This can be a useful alternative to entering the address details as text on the document mask ... Read More
Update Existing Product
Viewed 900 times since Tue, Jun 26, 2012
Datafile Software Update Existing Product This displays the same screen as used to add a new product, except that the product code keyed must be that of an existing product record. If not, you are warned accordingly. On input of a valid product... Read More
View Product
Viewed 899 times since Tue, Jun 26, 2012
Datafile Software View Product This is similar to the option described above, except that the product details are view only and cannot be amended. Read More
Sales Invoices - Application User Facilities
Viewed 899 times since Wed, Jun 27, 2012
Datafile Software Sales Invoices - Application User Facilities This option puts you into the Document Design procedure to allow you to design up to six different sales invoice document layouts. The specific options for the document design of... Read More
Product Optional - Database Profiles
Viewed 899 times since Wed, Jun 27, 2012
Datafile Software Product Optional - Database Profiles Text Only ? Applying only to Fast Input Style documents this option prevents the input and print of details after the stock code and description. Append to Description ? Applying to the DOS... Read More
Select Key Definition
Viewed 898 times since Wed, Jun 27, 2012
Datafile Software Select Key Definition Whenever you press <F4-Select> within the Invoicer system the details displayed can be configured to show the items you require. This is done via the Select Key Definition – available to Diamond and... Read More
Product File Full Screen Design (Premier Only)
Viewed 895 times since Wed, Jun 27, 2012
Datafile Software Product File Full Screen Design (Premier Only) In Premier systems you have the option to create a user-defined screen in which to display details from the product file and can be spread over two screens. On selection of this... Read More
Ledger Enquiry Manager
Viewed 894 times since Wed, Jun 27, 2012
Datafile Software Ledger Enquiry Manager The Ledger Enquiry Manager (Diamond and Premier only) allows you to configure the display screen for the Product Enquiry. Enquiries Allowed for this Company Although there are no specific &lsquo... Read More
Save and Exit - Document Design Manager
Viewed 893 times since Wed, Jun 27, 2012
Datafile Software Save and Exit - Document Design Manager The File pull-down allows you to save the document and exit the document design. If you exit without saving you will be prompted to save the changes – if you respond ‘Yes’... Read More
Moving, Deleting and Amending Items - Document Design Manager
Viewed 884 times since Wed, Jun 27, 2012
Datafile Software Moving, Deleting and Amending Items - Document Design Manager You can move an items position by selecting it with the mouse and dragging it to where it’s required.If the ‘Tools’ option ‘Snap to Grid... Read More
Discount/Supplier Matrix in Use
Viewed 874 times since Wed, Jun 27, 2012
Datafile Software Discount/Supplier Matrix in Use Once you have defined a matrix entry the facility operates automatically from within the invoicer and order processing applications. The following operational differences occur: When you enter... Read More
Compact and Audit Database
Viewed 872 times since Wed, Jun 27, 2012
Datafile Software Compact and Audit Database The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted. New records are always added to the end of the file. Therefore, over a period of... Read More
Expand Data Files
Viewed 861 times since Wed, Jun 27, 2012
Datafile Software Expand Data Files If not setting the auto-expand options then this option allows you to manually expand the data files as necessary. Read More
Purchase Invoices - Application User Facilities
Viewed 861 times since Wed, Jun 27, 2012
Datafile Software Purchase Invoices - Application User Facilities This option puts you into the Document Design procedure to allow you to design up to six different purchase invoice document layouts. The specific options for the document design... Read More
Edit System Status Display
Viewed 852 times since Wed, Jun 27, 2012
Datafile Software Edit System Status Display Each application has a ‘System Status’ option that summarises the key facts about it, such as files, their sizes, how full they are, the current period number and period dates plus various... Read More
Memo Facility Configuration
Viewed 850 times since Wed, Jun 27, 2012
Datafile Software Memo Facility Configuration The Memo facility allows you to record notes against product records. Within the Ledger Enquiry Manager you have the option to define, for all applications, where the memo files are stored, whether... Read More
Purchase Credit Notes - Application User Facilities
Viewed 839 times since Wed, Jun 27, 2012
Datafile Software Credit Notes - Application User Facilities This option puts you into the Document Design procedure to allow you to design up to six different purchase credit note document layouts. The specific options for the document design... Read More