Category Articles RSS Feed
Customer Price Checker and Quantity Breaks
Viewed 12723 times since Mon, Nov 25, 2013
Datafile Software Solutions Customer Price Checker and Quantity Breaks Discount Matrix tools allow the facility to set that, for a combination of account code/group and stock code/group, that a discount or price is applied. An additional... Read More
Datafile RTD Excel Add-In
Viewed 7828 times since Mon, Nov 25, 2013
Datafile Software Solutions Datafile RTD Excel Add-In The Datafile system as standard allows reports to be sent to Microsoft Excel as part of the print process. Once the report is in Microsoft Excel however the data is static so when balances... Read More
Confirm Input File and Date - Job Costing Batch Update
Viewed 3130 times since Thu, Jul 5, 2012
Datafile Software Confirm Input File and Date - Job Costing Batch Update Before the update can start you must confirm the input data file that is to be updated to the system. The pathname is usually just accepted, if will not accept this path it... Read More
Windows 10 1803 Update / Windows Defender
Viewed 2340 times since Wed, May 30, 2018
Windows 10 1803 Update / Windows Defender   The latest version of Windows Defender installed with the Windows 10 1803 update can block connections to the HMRC for FPS / EPS submissions in some circumstances – the system reporting a &lsquo... Read More
Forecast Dates - Additional Options
Viewed 2139 times since Fri, May 27, 2016
Forecast dates allow you to analyse date’s in different ways.  Existing option types allow you to add set number of days to a base date, show the Age in years/months/days, show the week in year of the base date and so on. New options... Read More
Order Processing Batch Updates
Viewed 2075 times since Thu, Jul 5, 2012
Datafile Software Order Processing Batch Updates The purpose of these programs is to update the sales and purchase order processing system with orders created elsewhere. These orders may have been created by a special ProFiler order processing... Read More
Batch Update Definition - Order Processing Batch Updates
Viewed 1942 times since Thu, Jul 5, 2012
Datafile Software Batch Update Definition - Order Processing Batch Updates Where the Sales or Purchase Batch Updates have been purchased a new option is available within the Application User Facilities for the Order Processing Application. The... Read More
Create / Update Account Records Before Import
Viewed 1897 times since Wed, Jun 13, 2012
Datafile Software Create / Update Account Records Before Import This feature allows the sales/purchase order processing batch update to process a DFD input file and create/update account details before continuing to create the orders themselves.... Read More
Alternate Allocation Match Option
Viewed 1890 times since Fri, Jun 8, 2012
Datafile Software Alternate Allocation Match Option When importing sales ledger or purchase ledger payment transactions the option exists for the imported payment transaction to record a reference which, if matched to a sales / purchase invoice... Read More
Main Menu Icons
Viewed 1875 times since Wed, Jun 13, 2012
Datafile Software Main Menu Icons The main menu (the left-hand menu) can now include icons on the options. The default, hard-coded menu, will be updated automatically to include a set of icons and these cannot be amended. However, if using a... Read More
Apply Default Nominal Code to Payment Transactions
Viewed 1852 times since Fri, Oct 26, 2012
Datafile Software Apply Default Nominal Code to Payment Transactions When importing sales / purchase transactions the system allows the setting of a default nominal code to be applied to imported transactions. However, this default nominal code... Read More
Data Interchange Omit First Row from Import
Viewed 1835 times since Fri, May 27, 2016
CSV files will sometimes contain column headings on the first row.  This new feature allows for the first row to be ignored from the import.   Omit First Line from Input – set to omit the first row of the CSV from import into the DFD... Read More
Calling a Batch Update Definition - Profiler
Viewed 1812 times since Thu, Jul 5, 2012
Datafile Software Calling a Batch Update Definition - Profiler When defining your ProFiler application you can call aspects of the standard application programs where required. This is achieved via the P-Program option type. Option Type To... Read More
Omit Exclusive File Locks on DFD Import
Viewed 1807 times since Fri, Jun 8, 2012
Datafile Software Omit Exclusive File Locks on DFD Import When running the batch import processes within the Sales, Purchase, Stock and Job Costing Batch Update Accessories the system requires an exclusive file lock on the main application files... Read More
Import Payment Transactions and Summarise
Viewed 1805 times since Tue, Jun 12, 2012
Datafile Software Import Payment Transactions and Summarise The batch update definition allows for the import of individual invoice / credit transactions for a single account but, on update to Datafile, to summarise this input as one invoice (or... Read More
Accept Forward Period Dates on Automatic Imports
Viewed 1804 times since Fri, Jun 8, 2012
Datafile Software Accept Forward Period Dates on Automatic Imports The Datafile Accounting Calendar has a defined number of periods within the financial year and the sales, purchase and (optionally) the stock and job costing applications... Read More
Report Specification - Job Costing Batch Update
Viewed 1793 times since Thu, Jul 5, 2012
Datafile Software Report Specification - Job Costing Batch Update This option allows definition of the output report produced after the transaction import. Print Control This setting controls the page size when the OPTIONS button has not been... Read More
Optional Features - Sales/Purchase Batch Updates
Viewed 1792 times since Thu, Jul 5, 2012
Datafile Software Optional Features - Sales/Purchase Batch Updates The optional features for the Sales/Purchase Batch Updates are displayed over two screens. Screen 1 of 2 Delimiter for ASCII files, default ",” (only if ASCII) ASCII... Read More
Scanning Options on the Ledger Enquiry
Viewed 1782 times since Wed, Jun 13, 2012
Datafile Software Scanning Options on the Ledger Enquiry This option adds the ability to scan a document against an application record, such as a sales ledger account or sales order, from within the Ledger Enquiry. A new option FILES has been... Read More
Data Interchange-Wildcards in Input Filename
Viewed 1779 times since Wed, Jun 13, 2012
Datafile Software Data Interchange – Wildcards in Input Filename This change to the ASCII input procedure in the Data Interchange options, for both ProFiler and Report Generator, allows the ability to specify the input filename using wildcards... Read More
Selection Criteria Range ‘Value’ Input
Viewed 1771 times since Fri, May 27, 2016
Datafile 2015 onwards only When entering selection criteria the Range type prompts for a ‘from/to’ value but allowed a maximum input of ten characters in each input this has now been increased to sixteen characters.  ... Read More
Confirm Update Definition - Stock Batch Update
Viewed 1748 times since Thu, Jul 5, 2012
Datafile Software Confirm Update Definition - Stock Batch Update When you choose the first option from the main batch update menu, you are presented with a list of up to six update definition names.These update definition names are defined in... Read More
Confirm Input File and Date - Stock Batch Update
Viewed 1745 times since Thu, Jul 5, 2012
Datafile Software Confirm Input File and Date - Stock Batch Update Before the update can start you must confirm the input data file and the date that transactions are to be updated to the system as. For stock batch update the date has... Read More
Optional Features - Stock Batch Update
Viewed 1734 times since Thu, Jul 5, 2012
Datafile Software Optional Features - Stock Batch Update The optional features for Stock Batch Update are displayed over two screens. Screen 1 of 2 Delimiter for Ascii Files, Default "," ASCII input files are normally defined to be comma... Read More
Help Manuals
Viewed 1725 times since Wed, Jun 13, 2012
Datafile Software Help Manuals The Help manuals, available from the Help option on the main toolbar, have been brought up-to-date and are now supplied as PDF files. Selecting Help and ‘Help Manuals’ offers a list of the PDF Help... Read More
Link to Map Websites
Viewed 1718 times since Wed, Jun 13, 2012
Datafile Software Link to Map Websites This option allows the facility to link to a map website to display the location of a customer or supplier account based on the postcode. By default the system links to the ‘Multimap’ website... Read More
Input File Structure - Sales/Purchase Batch Updates
Viewed 1712 times since Thu, Jul 5, 2012
Datafile Software Input File Structure - Sales/Purchase Batch Updates This requests the type of file being imported. There are two possible options – D for Datafile database input file, or Afor ASCII/CSV file. Read More
End of Batch Update - Sales/Purchase Batch Updates
Viewed 1712 times since Thu, Jul 5, 2012
Datafile Software End of Batch Update - Sales/Purchase Batch Updates After confirming that the input is completed the system may print an import report showing either the transactions imported or just any transactions rejected from the import.... Read More
Additional Copy Items from Input File
Viewed 1709 times since Wed, Jun 13, 2012
Datafile Software Additional Copy Items from Input File Up to 20 additional items can now be copied from the input file to the SOH and the SOD bringing the total number of copy items from the input file to the order processing files up to 40 per... Read More
List Matrix Entries
Viewed 1703 times since Mon, Nov 25, 2013
Datafile Software Solutions List Matrix Entries This new facility, available for both Customer and Supplier Matrix options allows a ‘list’ option within the Matrix options. The list displays all the entries for a requested... Read More
Batch Update Processing - Sales/Purchase Batch Updates
Viewed 1693 times since Thu, Jul 5, 2012
Datafile Software Batch Update Processing - Sales/Purchase Batch Updates During the batch update, the number of input records is displayed on screen and a progress bar shows the progress of the update. Attention should be given to any records... Read More
Confirm Update Definition - Job Costing Batch Update
Viewed 1688 times since Thu, Jul 5, 2012
Datafile Software Confirm Update Definition - Job Costing Batch Update When you select the post transactions option you are presented with a list of up to six update definition names - these names are defined within the Installation Details... Read More
Input File Pathname - Stock Batch Update
Viewed 1687 times since Thu, Jul 5, 2012
Datafile Software Input File Pathname - Stock Batch Update This requests the pathname of the input file. The <F4-Select> key may be used to help you in looking for the filename. Note, whatever name you enter here can be overridden at the time... Read More
Adding / Updating Account Details - Sales/Purchase Batch Updates
Viewed 1685 times since Thu, Jul 5, 2012
Datafile Software Adding / Updating Account Details - Sales/Purchase Batch Updates If the definition allows the accounts file to be updated for new and/or changed accounts then you will be asked: Add / update any account records before... Read More
Confirm Input File and Date - Sales/Purchase Batch Updates
Viewed 1682 times since Thu, Jul 5, 2012
Datafile Software Confirm Input File and Date - Sales/Purchase Batch Updates Before the update can start you must confirm the input data file that is to be updated to the system. For sales and purchase batch updates the date is very important.... Read More
Confirm Default Reference / Description at Run-time
Viewed 1676 times since Tue, Jun 12, 2012
Datafile Software Confirm Default Reference / Description at Run-time If not importing the reference / description from the import file the batch update parameters allow you to set a default value to be applied on the transactions. This new... Read More
Custom Features - Job Costing Batch Update
Viewed 1670 times since Thu, Jul 5, 2012
Datafile Software Custom Features - Job Costing Batch Update Datafile Software offers a service that allows any Datafile system to be customised to specific requirements on the rare occasion that those requirements cannot be met by the standard... Read More
Optional Features - Job Costing Batch Update
Viewed 1640 times since Thu, Jul 5, 2012
Datafile Software Optional Features - Job Costing Batch Update The optional features for Job Costing Batch Update are displayed on this screen. Delimiter for ASCII files, Default ",” ASCII input files are normally defined to be comma-separated... Read More
Confirm Update Definition - Order Processing Batch Updates
Viewed 1635 times since Thu, Jul 5, 2012
Datafile Software Confirm Update Definition - Order Processing Batch Updates When you choose the batch update menu option you are presented with a list of up to six update definitions. These updates are defined within the order processing... Read More
Create / Update Accounts - Order Processing Batch Updates
Viewed 1630 times since Thu, Jul 5, 2012
Datafile Software Create / Update Accounts - Order Processing Batch Updates If the definition allows the accounts file to be updated for new and/or changed accounts then you will be asked: ok to create/update accounts? If you select ‘Yes... Read More
End of Batch Update - Job Costing Batch Update
Viewed 1626 times since Thu, Jul 5, 2012
Datafile Software End of Batch Update - Job Costing Batch Update After confirming that the input is completed the system may print an import report showing either the transactions imported or just any transactions rejected from the import. This... Read More
Report Specification - Sales/Purchase Batch Updates
Viewed 1625 times since Thu, Jul 5, 2012
Datafile Software Report Specification - Sales/Purchase Batch Updates This option allows definition of the output report produced after the transaction import. Print Control This setting controls the page size when the OPTIONS parameters have... Read More
Report Specification - Stock Batch Update
Viewed 1624 times since Thu, Jul 5, 2012
Datafile Software Report Specification - Stock Batch Update This option allows definition of the output report produced after the transaction import. Print Control This setting controls the page size when the OPTIONS parameters have not been... Read More
Order Processing Batch Update - Import Order Reference
Viewed 1621 times since Wed, Jun 13, 2012
Datafile Software Order Processing Batch Update - Import Order Reference The batch import will now allow import of the order reference as the Datafile order number.Previously, whilst this could be imported it could only be updated to a separate... Read More
Data Items Cross Reference - Sales/Purchase Batch Updates
Viewed 1619 times since Thu, Jul 5, 2012
Datafile Software Data Items Cross Reference - Sales/Purchase Batch Updates The Data Items Cross Reference screen is used to correlate the input file items (on the left) to the sales/purchase transaction file (shown on the right). All... Read More
Negative Discount Amounts on Payment Transactions
Viewed 1617 times since Tue, Jun 12, 2012
Datafile Software Negative Discount Amounts on Payment Transactions Datafile records the payment and payment discount values as positive values on update of the payment to the ledger. When bringing in payment transactions from another system,... Read More
Custom Features - Stock Batch Update
Viewed 1617 times since Thu, Jul 5, 2012
Datafile Software Custom Features - Stock Batch Update Datafile Software offers a service that allows any Datafile system to be customised to specific requirements on the rare occasion that those requirements cannot be met by the standard system... Read More
Confirm Printer - Stock Batch Update
Viewed 1611 times since Thu, Jul 5, 2012
Datafile Software Confirm Printer - Stock Batch Update If your update has been configured to print an update commentary report then you are asked to confirm the printer to be used. The currently selected printer is displayed and you can change... Read More
Data Item Access via Authority Level
Viewed 1603 times since Wed, Jun 13, 2012
Datafile Software Data Item Access via Authority Level This option allows you to set, via a database.ini, the authority level for display and access to data items such as the cost price. If you create a text file in the same location as the... Read More
Post Code Analysis
Viewed 1602 times since Wed, Jun 13, 2012
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... Read More
Batch Update Processing - Stock Batch Update
Viewed 1601 times since Thu, Jul 5, 2012
Datafile Software Batch Update Processing - Stock Batch Update During the batch update, the number of input records is displayed on screen and a progress bar shows the progress of the update.Attention should be given to any records that are... Read More
Data Items Cross Reference - Job Costing Batch Update
Viewed 1601 times since Thu, Jul 5, 2012
Datafile Software Data Items Cross Reference - Job Costing Batch Update The Data Items Cross Reference screen is used to correlate the input file items (on the left) to the job costing transaction definition (shown on the right). All 160 items... Read More
Confirm Update Definition - Sales/Purchase Batch Updates
Viewed 1598 times since Thu, Jul 5, 2012
Datafile Software Confirm Update Definition - Sales/Purchase Batch Updates When you choose the first option from the main batch update menu, you are presented with a list of up to six update definition names.These update definitions are defined... Read More
Job Costing Batch Update
Viewed 1595 times since Thu, Jul 5, 2012
Datafile Software Job Costing Batch Update This application accessory allows for the import of job costing with transactions generated elsewhere. These transactions may have been created by a special ProFiler Job Costing application or might be... Read More
Confirm Printer - Sales/Purchase Batch Updates
Viewed 1581 times since Thu, Jul 5, 2012
Datafile Software Confirm Printer - Sales/Purchase Batch Updates If your update has been configured to print an update commentary report then you are asked to confirm the printer to be used. The currently selected printer is displayed and you... Read More
Confirm Date for Generated Orders - Order Processing Batch Updates
Viewed 1579 times since Thu, Jul 5, 2012
Datafile Software Confirm Date for Generated Orders - Order Processing Batch Updates Before the update can start you must confirm the input date and, optionally, any selection criteria that apply to the update. On confirm of the prompt ‘OK... Read More
ProFiler Options
Viewed 1579 times since Thu, Jul 5, 2012
Datafile Software ProFiler Options Often a batch update process will be used as part of a ProFiler routine – for example, when using Sales Order Batch Update you may import an ASCII file into a Datafile Database, process that database to... Read More
Batch Update Processing - Job Costing Batch Update
Viewed 1576 times since Thu, Jul 5, 2012
Datafile Software Batch Update Processing - Job Costing Batch Update During the batch update, the number of input records is accumulated on the screen. Totals are displayed for the number of records accepted, ignored and rejected.Attention... Read More
Confirm Printer - Job Costing Batch Update
Viewed 1569 times since Thu, Jul 5, 2012
Datafile Software Confirm Printer - Job Costing Batch Update If your update has been configured to print an ‘update commentary’ report then you are asked to confirm the printer to be used. The currently selected print device is... Read More
Input File Pathname - Sales/Purchase Batch Updates
Viewed 1564 times since Thu, Jul 5, 2012
Datafile Software Input File Pathname - Sales/Purchase Batch Updates This requests the pathname of the input file. The <F4-Select> key may be used to help you in looking for the filename. Note, that whatever name you enter here can be... Read More
Disputed Transactions on Allocation Import
Viewed 1561 times since Tue, Jun 12, 2012
Datafile Software Disputed Transactions on Allocation Import When importing payments and allocating against existing invoices and credits with a customer supplied ‘CSV Remittance’ you may occasionally be advised of a ‘disputed... Read More
Sales/Purchase Batch Updates
Viewed 1554 times since Thu, Jul 5, 2012
Datafile Software Sales/Purchase Batch Updates The purpose of these applications is to update the sales and purchase ledgers with transactions generated elsewhere. These transactions may have been created by a special ProFiler order processing... Read More
Input File Pathname - Job Costing Batch Update
Viewed 1549 times since Thu, Jul 5, 2012
Datafile Software Input File Pathname - Job Costing Batch Update This requests the pathname of the input file. <F4-Select> is available to help you in looking for the file, but note that whatever name you enter here can be overridden at the... Read More
Input File Structure - Job Costing Batch Update
Viewed 1549 times since Thu, Jul 5, 2012
Datafile Software Input File Structure - Job Costing Batch Update This requests the type of file being imported. There are two possible options – D for Datafile database input file, or Afor an ASCII file. Read More
System Status - Sales/Purchase Batch Updates
Viewed 1547 times since Thu, Jul 5, 2012
Datafile Software System Status - Sales/Purchase Batch Updates This screen gives an overview of the status of the application concerned showing file sizes and period details. Read More
Include Import Totals on Update Commentary
Viewed 1539 times since Fri, Oct 26, 2012
Datafile Software Include Import Totals on Update Commentary When importing transactions via the Batch Update accessories the system allows a report to be created listing the transactions processed and then provides a summary screen for the... Read More
Run Time Prompt - Sales/Purchase Batch Updates
Viewed 1524 times since Thu, Jul 5, 2012
Datafile Software Run Time Prompt - Sales/Purchase Batch Updates The batch update definition may be set up to ask for a value at the start of each batch update. This can be used to record a standard value to all the transactions written by the... Read More
System Status - Job Costing Batch Update
Viewed 1519 times since Thu, Jul 5, 2012
Datafile Software System Status - Job Costing Batch Update This screen gives an overview of the status of the Job Costing application showing file sizes and period details. Read More
Installation Details - Job Costing Batch Update
Viewed 1519 times since Thu, Jul 5, 2012
Datafile Software Installation Details - Job Costing Batch Update The first time this option is loaded for a company you will be asked to create the definition – the JOBCUPD.XXX (where XXX is the company id). From then on each time you load... Read More
Installation Details - Sales/Purchase Batch Updates
Viewed 1515 times since Thu, Jul 5, 2012
Datafile Software Installation Details - Sales/Purchase Batch Updates The first time this option is loaded for a new company you will be asked to create the definition – the SALESUPD.XXX (where XXX is the company id). From then on each time... Read More
Input File Structure - Stock Batch Update
Viewed 1511 times since Thu, Jul 5, 2012
Datafile Software Input File Structure - Stock Batch Update This requests the type of file being imported. There are two possible options – D for Datafile database files and A for an ASCII file. Read More
Run Time Prompt - Stock Batch Update
Viewed 1509 times since Thu, Jul 5, 2012
Datafile Software Run Time Prompt - Stock Batch Update The batch update definition may be set up to ask for a value at the start of each batch update. This can be used to record a standard value to all the transactions written by this update e.g... Read More
End of Batch Update - Stock Batch Update
Viewed 1507 times since Thu, Jul 5, 2012
Datafile Software End of Batch Update - Stock Batch Update After confirming that the input is completed the system may print an import report showing either the transactions imported or just any transactions rejected from the import. This report... Read More
Data Items Cross Reference - Stock Batch Update
Viewed 1504 times since Thu, Jul 5, 2012
Datafile Software Data Items Cross Reference - Stock Batch Update The Data Items Cross Reference screen is used to correlate the input file items (on the left) to the stock transaction file (shown of the right). All 160 items may be cross... Read More
System Status - Stock Batch Update
Viewed 1489 times since Thu, Jul 5, 2012
Datafile Software System Status - Stock Batch Update This screen gives an overview of the status of the application concerned showing file sizes and period details. Read More
Installation Details - Stock Batch Update
Viewed 1480 times since Thu, Jul 5, 2012
Datafile Software Installation Details - Stock Batch Update The first time this option is loaded for a new company you will be asked to create the definition – the STOCKUPD.XXX (where XXX is the company id). From then on each time you load... Read More
Stock Batch Update
Viewed 1472 times since Thu, Jul 5, 2012
Datafile Software Stock Batch Update The purpose of this application is to update the stock control system with transactions generated elsewhere. These transactions may have been created by a special ProFiler order processing application, for... Read More
Import Payments and Allocate
Viewed 1467 times since Mon, Nov 25, 2013
Datafile Software Solutions Import Payments and Allocate The Sales and Purchase Batch Update definitions allow the facility to import a payment transaction and allocate this payment against an invoice with a matching payment allocation... Read More
Ignore ‘Stock Not Exist’ Error
Viewed 1461 times since Wed, Jun 13, 2012
Datafile Software Ignore ‘Stock Not Exist’ Error If the stock code referenced on the input record does not exist then that input record was rejected.A new option has been added to allow the import to proceed – note though that the... Read More
Network File In Use
Viewed 1310 times since Wed, Feb 12, 2020
Network File In Use – the DIAMOND.D02 is the multi-user control file for the Datafile system and is accessed thousands of times during operations in the Datafile system. As you open a database file or record the system opens this file to update the... Read More
QR Code Image Generator
Viewed 25 times since Thu, Oct 24, 2024
This is a new tool that allows you to create a QR code image based on a data item within a database and to record the image filename within a data item on the same database so that it can be included... Read More