Home » Categories » Solutions by Business Process » Utilities

List Matrix Entries

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 customer account/group or a stock record / group and allows you to scroll up/down the list and amend any details required.

On selection the system prompts for the Sales Account and the Stock Code plus, if configured, the Sales Account Group and Stock Records Group. If you leave all the filter items blank the system will list all matrix entries, otherwise you can filter the list by entering combinations of account code/group and stock code/group. Note that if enter both the account code andthe account group then the system will list entries that match either of these two values and operates similarly on the stock code and group.

As you scroll up/down the list <Enter> will act as update and select the currently highlighted entry for amendment but you can also choose from the options at the bottom of the screen to:

 ADD – Allows option to add a new matrix entry

 UPDATE – Allows update of the current highlighted matrix entry

 VIEW – Allows view of the current highlighted matrix entry

 DELETE – Allows the option to delete the current highlighted matrix entry

 EXCEL – Outputs the current matrix list to Excel

 ANOTHER – Allows you to amend the filter list

 EXIT – Returns you to the menu.

Installation

System Profiles

A new option has been added to the Sales and Purchase Ledger System Profiles to prompt for to allow the Matrix List. To update the profiles select Installation from the main menu, lock out all systems, and then select System Profiles and the Sales Ledgerapplication. Screen 5 of the parameters contains the additional option.

Allow Desktop List Entries Option – set this option to enable the list function. When set a pop-up allows you to select up to ten items from the matrix to be displayed. 

Note 

The List option can be called direct from an application menu – program is DT (no .EXE suffix) and parameter is 005611 for the Customer Matrix, and 009111 for the Supplier Matrix.

Custom Fields
  • Release ID: 6.7
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Post Code Analysis
Viewed 1507 times since Wed, Jun 13, 2012
Input File Pathname - Sales/Purchase Batch Updates
Viewed 1466 times since Thu, Jul 5, 2012
Confirm Printer - Sales/Purchase Batch Updates
Viewed 1477 times since Thu, Jul 5, 2012
Data Interchange-Wildcards in Input Filename
Viewed 1664 times since Wed, Jun 13, 2012
System Status - Job Costing Batch Update
Viewed 1411 times since Thu, Jul 5, 2012
Job Costing Batch Update
Viewed 1487 times since Thu, Jul 5, 2012
Datafile RTD Excel Add-In
Viewed 6758 times since Mon, Nov 25, 2013
Data Interchange Omit First Row from Import
Viewed 1702 times since Fri, May 27, 2016
System Status - Stock Batch Update
Viewed 1390 times since Thu, Jul 5, 2012
Alternate Allocation Match Option
Viewed 1785 times since Fri, Jun 8, 2012