EDIT MASTERFILES |
---|
Links on this Page Edit Screens Edit Products Edit Departments Edit Customers Edit Finalisations Edit Adjustments Edit Tax Rates Edit Clerks |
Edit Screens |
The edit menu allows you to add, change and delete records in SELLmatix.
In some cases, the data in SELLmatix will be imported from a back
office accounting system, and it will not be necessary to edit the data
in SELLmatix. It is however useful to look at data which has been
imported through the Edit Menu on SELLmatix to ensure that the data
has been entered correctly.
Where you are able to edit information in either the SELLmatix OR the Back Office System, it is important to make a decision of the changes made to one system or the other, but not both because changes in one system or the other would be lost when data is imported or exported. For example, if you changed an item's description in SELLmatix and you changed its price in the Back Office System, and then you exported the data from the Back Office System to SELLmatix, the changed description you had entered in SELLmatix Control would be overwritten when the data was imported. Most options on the Edit Menu require you to select a particular record to edit or delete. The functionality for selecting records is the same for each type of data, and works as follows:- The column headings in the Edit Records window will differ depending on what type of record you are editing. One of the columns is the "active" column which is used for finding records. The "active" column identified by two open angled and two close angled brackets (eg. "<<Description>>"), and the data in the active column is displayed in blue while the text in the other columns is displayed in the normal window text color. Clicking on a column heading will "activate" it for use with the find functions. You can resize the column by dragging the title separators in the column headings.
"Find Where Highlighted Column" Group
"Show Where" Group The first control in the "Show Where" group allows you to specify the column on which the filter condition applies. If you do not wish to apply a filter, then you should set this control to "No Filter". The second control in the "Show Where" group allows you to specify the condition to be used in the filter. The Third control allows you to enter the information you want applied to the filter. Valid conditions are:- "=Equals" means that only records where the specified column is exactly equal to the data entered will be displayed. ">Greater" means that only records where the specified column is greater than the data you enter will be displayed. "<Less" means that only records where the specified column is less than the data you entered will be displayed. "*Contains" means that only records where the specified column contains the data you entered would be displayed. For example, if you were editing products, you could set the filter to only display records where the "Description" column contained "CHOC". After specifying the filter condition, you would apply the filter by clicking the "Refresh" button. You can also perform a "Find" while a filter is active.
"Edit" Button
"Refresh" Button
"Delete Rec." Button
"New Record" Button You can select multiple records by holding the "Control" key and clicking the records. You can copy the selected records to the Clipboard by right clicking on the selected record(s) and choosing "Copy". After copying the records to the Clipboard, you can paste the records into a text such as Notepad or a Spreadsheet such as Excel or OpenOffice.org. |
Edit Products |
The product masterfile contains too many fields to display on the one screen, so a Tabbed Dialog is used to enter/edit
product details. You can select which page you wish to view by clicking on the appropriate Tab at the top. The first Tab shows the
Selling Details of the item. This screen is the only one which contains data that must be entered for SELLmatix to work.
The first Tab appears as follows:-
The fields available on the first Page of the Products Dialog are as follows:-
Description
Alt Desc
Barcode/PLU This is the main way in which SELLmatix identifies a product. This field is typically the UPC/EAN number of the barcode, which is printed on the product's packaging. In some cases however a different product numbering system will be used. This field is required.
Alias for PLU# Examples where this is useful include special promotional packaging of an item which might include a bonus such as a glass with a bottle of whiskey, and a different barcode number is used. Or, where product comes from different manufacturing plants and carries a different barcode number. This field can only be entered when the Product Type is an Alias. There can be any number of alias PLU's pointing to a single master PLU. Alias PLU's can even point to other Alias PLU's, provided that an actual product is found less than 10 levels down. If SELLmatix searches more than 10 levels of Alias PLU's before finding an actual item that can be sold, it assumes that there is a circular referencing of Alias PLU's and generates an error.
Department
Product Type When Weighed pricing is specified and the item is sold, SELLmatix will assume that the product has been placed on an Electronic Scale connected to the POS, and it will interrogate the scale for the weight of the item. The weight reported by the scale is treated as being the quantity purchased and multiplied by the price. Barcode Price indicates that the price of the item is encoded in the Barcode that has been scanned. This is typically used with Barcode Printing Electronic Scales, which are not connected to the POS. For example, in a Deli Section of a Supermarket, a block of cheese may be cut to order for a customer, weighed by the scale that prints a barcode label that is then attached to the packaging. At the checkout, this barcode is scanned and the price encoded in the Barcode is charged. Barcode Scanner Options in SELLmatix POS must be set up correctly to identify such products. Wet stock indicates that the item is a liquid, normally a petroleum product that is dispensed through a pump controller connected to the POS. When an item is flagged as being a Wet stock, SELLmatix interrogates the electronic pump controller connected to the POS for the quantity and price to be charged. This feature is typically used in Self Serve Petrol Stations. Due to the volatile nature of petroleum products and the risks involved should an accident occur, these environments are very highly regulated in most countries, and are also quite different electronically. Only a limited range of pump controllers are supported by SELLmatix, and regulatory approval for use of other devices is usually a long process which is not justified unless there will be a large number of sites using the devices. Product Alias indicates that this item is to be treated as if it were another item. When a product which is Product Alias is sold, SELLmatix looks up the Alias # that has been specified for the product, and processes the sale as if that product had been selected. The only fields that are used for Product Aliases, is the Product Type (to identify that it is an alias) and the Alias Number.
Output Orders To This would typically be used in a restaurant or fast food outlet. Items selected from the refrigerator such as drinks would not print on anything, however the Pizza ordered would print on a kitchen printer. Some sites need orders to be printed on multiple printers. More than one printer can be used where this is required.
Show on Sell Menu This flag is used by PocketPos for processing order on a Pocket PC is a restaurant, as is optionally available in SELLmatix POS. Using a sell Menu is only practical where there are relatively few items that are sold in this manner. If there are more than 15 departments which have more than 20 items in each department which appear on the Sell menu, then navigation becomes difficult.
Selling Prices
If during a "Happy hour", only the prices of a few items are changed, then only the items where the price changes need to have other price levels entered, because SELLmatix will automatically fall back to the next appropriate level. Items with no price are particularly useful where common modifiers are used in food preparation. In this way, an "item" can be set up to be "No Chile" with a zero price, and this can print on kitchen printers etc.
Allow Manual % Discounts
Allow Price Overrides
Allow Customer Department Discount
Price inc. Tax Under normal circumstances, you should set this option to the department default because most items in the department will have the same setting, and if changes need to be made, with the department default option you would need to make one change in the department record instead of changing every product record.
Use Tax Code You should normally have this box checked, and use a rate in the tax rate table, because if the tax changes, then you will only need to make one change to the tax rate table instead of changing every product record.
Item Tax %
Tax Code
Product Buying InformationThe second Page of the product editing screen allows you to enter Product buying Information, and appears as follows:-
Supplier Code
Supplier Name
Supplier Part Number This field is not used by SELLmatix but may be useful for importing and exporting data with a back Office System, or useful information to be able to view.
Source Flag
Buy Unit
Buy Min Qty
Reorder Level
Cost Price
Adjusted Cost This field can be useful if using exported transactions to calculate gross profit reports in a spreadsheet.
Product Stock InformationThe third Page of the product editing screen allows you to enter Stock Information, and appears as follows:-
Track Qty? If this flag is set to Yes, or the setting for the department is yes, then SELLmatix will deduct sales of the item from the Quantity on hand. For items which are made (meals in restaurant for example) this flag should not be set, because large negative quantities will build up in the Qty On Hand field. If you are using another back office system to process inventory, then this flag should not be set, as SELLmatix will not be used to record stock deliveries in that case and large negative quantities would accumulate.
Qty on Hand This Qty on Hand, is not necessarily the quantity available to be sold, because this quantity is not reduced when an item is ordered, but when the item is paid for. For example, if there was stock of 24 items, and 10 of these had been supplied to tables in a restaurant, but not yet paid for, the Qty on Hand would still be 24, and the Qty Alloc'd would be 10 leaving an available stock of 14.
Qty Alloc'd
Category Code
Core Range This field is not used by SELLmatix and is not normally useful. In some cases however this information is supplied along with masterfile data from major suppliers, and this information needs to be preserved for possible future use. Where this is not the case, this field could safely be used to record any other information.
Slow Move
Fineline Class
TUN Code
Shelf Label Required In many countries, there is a "Scanning Code of Practice", and sometimes a legal requirement, relating to instances where the price scanned at the POS is different to the price on the shelf label. When the price charged is lower than what is on the shelf label, there is no problem, because the customer benefits. If the price scanned is higher, however, often the customer is entitled to the item at no charge. Often price updates include both price increases and price decreases. To handle this situation, SELLmatix flags whether a price has increased or decreased. When prices are updated, it is recommended that the retailer print new shelf labels for price-increased good and apply these shelf labels before updating the prices on the POS. After updating prices on the POS, shelf labels for items which have had price decreases, should be printed and applied in the store. In this way customer problems are eliminated.
Prod Label Format
Prod Label Qty
Print Shelf Label
Print Prod Label |
Edit Departments |
Department Name
Department Code
Custom Field 1 Three separate Custom Fields are available which could be used to specify GL accounts for Asset, Income and Cost of Goods Sold.
Custom Field 2 Three separate Custom Fields are available which could be used to specify GL accounts for Asset, Income and Cost of Goods Sold.
Custom Field 3 Three separate Custom Fields are available which could be used to specify GL accounts for Asset, Income and Cost of Goods Sold. Discount Group 1-5 SELLmatix allows up to five discount groups to be specified for each department. Each discount group can have a different discount percentage. Each customer can also be associated with a Discount Group. Customers who belong to Discount Group 1 will automatically be given the discount percentage entered for Discount Group 1 when they buy products that belong to that department. These fields are not required, and if no discount percentage is entered, the discount groups will not be used.
Department Halo This feature is a hangover from old cash register systems designed to trap keying errors. This field is rarely used and if no Halo is entered, Halo checking is ignored.
Standard Department Price
Inventory Items by Default
Prices Include Tax by Default It is possible to have some items where the price includes tax, and other items where the price does not include tax. We recommend however that you make a decision and either have all prices include tax or else have all not include tax. It is also possible to have some items within a department have tax inclusive pricing while other items have tax exclusive pricing. This however would be extremely bad practice. It would also be bad practice to mix items with different tax rates within the one department.
Show on Menu This is designed particularly for restaurants where each "Page" on a printed menu could be set up as a department, and the items on that page of the printed menu be placed in that department, so that the PocketPos Sell menu would closely follow the printed menu to make processing easy. This is not designed for departments which contain a large number of items which are sold using a barcode scanner. |
Edit Customers |
Overview It some cases, it may be necessary to enter additional information regarding customers however that may not be available in the Back Office System about the way sales are processed for this customer. SELLmatix does not maintain Customer Account balances because the POS does not need to be connected to SELLmatix Control or the Back Office System, and consequently balances would be unlikely to be up to date on the POS. The fields which can be entered for customers are as follows:-
Customer Name
Customer Number One potential issue with using Customer Cards, however, is that SELLmatix must be able to determine whether the Barcode is for a Customer Card or for a Product. One way this can be done is to use a character prefix on the customer cards. In addition, we recommend using a numeric prefix between 20 and 29 as this code range has been reserved by the European Article Numbering Association for in store use, and numbers with a prefix in this range will never occur for UPC/EAN product barcodes.
Always Print Docket
Signature Required
Order Number Required
Suspend Sales
Discount Group
Account Type Debtor Accounts allow sales to be paid for, or finalised, by charging to the account. The transaction details are exported to the Back Office System, which is responsible for issuing statements and maintaining account balances. Imprest Accounts are accounts where the customer pays an amount up front putting their account in credit, and sales are deducted from this amount. SELLmatix does not know what a customer's account balance is, and treats Imprest Accounts in the same way as Debtor Accounts. The transaction details are exported to the Back Office System, which is responsible for issuing statements and maintaining account balances. Lay-by Accounts are accounts where the customer makes an initial deposit for an item that is then put aside and not sold to any other customer. The customer that has opened the lay-by account makes regular payments toward the item being purchased and they take delivery of the goods when payment in full has been made. SELLmatix does not know what a customer's account balance is. Sales cannot be finalised to a lay-by Account. Payments on a Lay-by account can be made if the Back Office system supports this. The transaction details are exported to the Back Office System, which is responsible for issuing statements and maintaining account balances. Loyalty Accounts are accounts where transactions are recorded, and some type of incentive scheme is provided to the customer, for example where they receive "points" for purchases made which can then be redeemed for some type of prize or other merchandise. Loyalty Accounts can also be set up for customers if they will be given Department Discounts or Deal Discounts, but will pay for the merchandise at the time of purchase instead of having it charged to their account. Sales cannot be finalised with a loyalty account. The transaction details are exported to the Back Office System, which is responsible for issuing statements and maintaining account balances.
Credit Limit |
Edit Finalisations |
Overview
Finalisation Name
Finalisation Code
Custom Field 1
Custom Field 2
Custom Field 3
Finalisation Type Bankable - Bankable Finalisations are totaled for the cash draw reconciliation. The total amount for each Bankable Finalisation is shown on the X-Reads and Z-Reads so that the store knows how much of each finalisation type should be in the cash drawer. Examples on Bankable Finalisations include Cash, Cheques, Gift Certificates and manually processed Credit Card Charges, which need to be deposited at a bank. Account - Account Finalisations are used when a customer has a credit account with the store. Details of each Account Finalisation are sent to the Back Office System so that the transaction can be recorded in the Debtors Ledger. It is the responsibility of the Back Office System to maintain the Debtor Account, and SELLmatix provides transaction information. EFT - EFT Finalisations are payments made by Electronic Funds Transfer usually through an Online Credit Card Processing Terminal. EFT Finalisations are shown on the X-Read and Z-Read reports as well as being passed to the Back Office system. EFT Finalisations are normally deposited directly into the retailer's bank account and generally the Back Office system will post these transactions to an Electronic Clearing Account to enable the store to reconcile these with bank statements. In some cases SELLmatix will not be directly connected to the EFT online terminal, and the relevant amount will need to be keyed into the EFT Terminal. Certain EFT Terminals can be fully integrated with SELLmatix so that the clerk does not need to key any additional information, and EFT receipts are printed on the SELLmatix POS printer. In either case the Finalisation type should be set to EFT if the proceeds are to be deposited directly into the retailer's bank account.
Tender Amount If the "Force" button is checked, the operator will be required to enter the amount tendered and the system will calculate the amount of change (if any). If the "Prevent" button is checked, the operator will be prevented from keying an amount tendered, and the system will automatically assume that the amount tendered is the balance remaining on the sale and the sale will be completed. This option is rarely used, but may be appropriate fro some type of EFT finalisation.
Show on Menu
Open Cash Drawer
Round Cents If any Finalisation is set to round odd cents, then a Cents Rounding Adjustment must be set so that there is somewhere for SELLmatix to post the cents that have been rounded.
Print N Receipts
Use Invoice Printer |
Edit Adjustments |
Overview
- When a float of money is put into the cash drawer so that change can be given. In each of these cases, the balance in the cash drawer will change either by increasing the amount of cash or decreasing the amount of cash. Adjustment totals are shown on the X-Read and Z-Read reports, and the transactions are exported to the Back Office System. In some cases the Back Office System will post Adjustment transactions to a POS Clearing account so they can later be reconciled. The fields, which can be edited, are as follows:-
Adjustment Name
Adjustment Code
Custom Field 1 This field can also be used to store other information as required by the site.
Custom Field 2 This field can also be used to store other information as required by the site.
Custom Field 3 This field can also be used to store other information as required by the site.
Adjustment Type
Paid In - Increases the amount of money in the cash drawer. |
Edit Tax Rates |
Overview
Tax Rate Name
Tax Rate Code
Tax Rate
Account |
Edit Clerks |
Overview Clerks can log on to SELLmatix Point of Sale either by entering their Clerk Code and pressing the Clerk button, or else SELLmatix Control can print Clerk Cards which contain a Barcode which can be scanned by the Barcode Scanner. For each clerk that uses SELLmatix, a separate Clerk record needs to be set up specify what that Clerk is permitted to do. The fields that can be edited are as follows:-
Clerk Name
Clerk Code One potential issue with using Clerk Cards to log in is that SELLmatix must be able to determine whether the Barcode is for a Clerk Card, Customer Card or for a Product. One way this can be done is to use a character prefix on the Clerk cards. In addition, we recommend using a numeric prefix between 20 and 29 as this code range has been reserved by the European Article Numbering Association for in store use, and numbers with a prefix in this range will never occur for UPC/EAN product barcodes.
Clerk can X-Read
Clerk can Z-Read
Clerk can Configure
Clerk can No Sale
Clerk can Refund
Clerk can Price Override/Manual Discount In order to perform price overrides, the Clerk must have permission to price override, and the product must be flagged to allow price overrides.
Clerk can Override Pricing Rules |