Barcode and Text Fields


Topic overview

These form fields are available from the Barcode/text printer labels or the slip printer invoice printing.

Some fields do not work in all places. ie: KEYWORD only prints when printed from a shipping label.

System Five gives you total control over the content of the printed information.
To demonstrate the control that you have, an example of an Sales Warning/Up Sell Comment is used.
In our example, an Inventory Item has the following Sales Warning/Up Sell comment.

  •  All Sales Final!
  •  This item has been discontinued by the Supplier.
  •  To Staff: No Returns or Refunds without a Supervisors Approval.


 System Five views the comment above as 3 separate lines of text, thereby allowing the definition of labels that only print specific desired lines. The amount text printing from each line can also be controlled. For example: to print a label including the complete first line and only a portion of the second, the following syntax is used in the label definition:  

< N.COMMENT:1,-1>   This tells System Five to print the entire first line on the Warning.
< N.COMMENT:2,32> This tells the system to print the first 32 characters in the second line of the Warning.

The third line comment line and the portion of the second line that states 'by the Supplier' does not print. All three lines however are seen when the item is sold to customer or when the inventory item is opened for editing or viewing.

The anatomy of the field codes:
N.COMMENT:1,-1 
(N) = The Prefix
(.) = The period indicates the end of the prefix.
(COMMENT) = The field Code.
(:) = The Full Colon is used to indicate that a number is next.
(1) = The Number indicates the line or list item.
(,) = The Comma indicates that a Length value is next.
(-1 or a number) = The use of (-1) as a length tells the system to print all of the text in the line
= Another number, such as (20) prints the first 20 characters.


Advanced Inventory Control - Locations Examples

The following are some examples of location-specific labels:

Example 1 - Location Fields

N
q816
Q1624,20+0
B80,800,0,1,3,7,100,B,“<PART >”
X20,20,2,800,1000
A22,22,0,2,2,2,R,“<COMPANY.NAME,C >”
A25,100,0,2,2,2,N,“<DESCRIPTION,1>”
A25,200,0,2,1,1,N,“<LOCATE>”
A25,300,0,2,1,1,N,“<SERIAL.NUMBER>”
A100,500,0,4,3,3,N,“<PRICE.0>”
P1

Example 2 - Inventory Location Fields

N
q816
Q1624,20+0
B80,800,0,1,3,7,100,B,“<INVLOCATBARCODE,-1>”
X20,20,2,800,1000
A25,100,0,2,2,2,N,“<INVLOCATBARCODENUMBER,-1>”
A25,200,0,2,2,2,N,“<INVLOCATPART,-1>”
A25,300,0,2,2,2,N,“<INVLOCATPARTDESC,-1>”
A25,400,0,2,2,2,N,“<INVLOCATHIGH,-1>”
A25,500,0,2,2,2,N,“<INVLOCATPICK,-1>”
A25,600,0,2,2,2,N,“<INVLOCATPUTAWAY,-1>”
A25,700,0,2,2,2,N,“<INVLOCATTEXT,-1>”
A25,800,0,2,2,2,N,“<INVLOCATPARTBARCODE,-1>”
A25,900,0,2,2,2,N,“<INVLOCATPARTBARCODENUMBER,-1>”
A25,950,0,2,2,2,N,“<SERIAL.NUMBER,-1>”
P1

Example 3 - Location Fields

N
q816
Q1624,20+0
B80,800,0,1,3,7,100,B,“<LOCATIONBARCODE,-1>”
X20,20,2,800,1000
A25,200,0,2,2,2,N,“<LOCATIONBARCODENUMBER,-1>”
A25,300,0,2,2,2,N,“<LOCATIONCOMMENT,-1>”
A25,400,0,2,2,2,N,“<LOCATIONPREVIOUS,-1>”
A25,500,0,2,2,2,N,“<LOCATIONTEXT,-1>”
A25,600,0,2,2,2,N,“<LOCATIONQUARANTINED,-1>”
A25,700,0,2,2,2,N,“<LOCATIONREQPICKING,-1>”
A25,800,0,2,2,2,N,“<LOCATIONPURPOSE,-1>”
A25,900,0,2,2,2,N,“<LOCATIONDEPTNAME,-1>”
P1




Inventory Fields

CODE   PRINTED INFORMATION    SYNTAX & USES 
N.COMMENT:L,LEN The Sales Warning/Up Sell Comment L = The line number \\LEN = The length (-1 for all). 
N.FREEHEAD:L,LEN The Free Form 1 Comment Header Text L = The line number \\LEN = The length (-1 for all). 
N.FREEFORM:L,LEN The Free Form 1 Comment Data Text L = The line number \\LEN = The length (-1 for all). 
N.FREEHEAD.2:L,LEN The Free Form 2 Comment Header Text L = The line number \\LEN = The length (-1 for all). 
N.FREEFORM.2:L,LEN The Free Form 2 Comment Data Text L = The line number \\LEN = The length (-1 for all). 
P.COMMENT:L,LEN COMMENT:L;LEN The Invoice Comment Text L = The line number LEN = The length (-1 for all). 
PRICE.N The Selling Price, based on Price Schedule [N] N = The Price Schedule Number. Values from 0 to a Maximum of 99 
PRICE,-1 WHOLE COST The Cost Price PRICE,-1 – The Cost is padded to a length of 10 and Right Justified. WHOLE – The Cost is padded to a length of 7 and Right Justified. COST – The Cost is not padded and is Left Justified. 
CODE.-1 The Cost Price in a coded format. For more information on coded formats, see the link below. 
CODE.N The Selling Price, based on the Price Schedule [N] in a coded format. N = The Price Schedule Number. \\Values from 0 to a Maximum of 99 
SALE.N The Sale Price, based on the Price Schedule [N] N = The Price Schedule Number. Values from 0 to a Maximum of 99 
LIST The List or Price Schedule 0 selling price. 
ONSALE The word 'SALE' is printed if the item is on sale.  
ISALE.N The Sale Price, based on the Price Schedule [N], if the item is on sale.N = The Price Schedule Number. Values from 0 to a Maximum of 99 
TAX.N Tax on PRICE.N based on the taxes set on the item. N = The Price Schedule Number. Values from 0 to a Maximum of 99 
TAXPRICE.N Tax-Inclusive PRICE.N based on the taxes set on the item. N = The Price Schedule Number. Values from 0 to a Maximum of 99 
Category Number 
CATNAME Category Name 
ITEM Item Number 
PART
 PARTNO 
Part Number 
SUP.PART
 SPART 
The Supplier Part Number 
DESCRIPTION,LEN The Description of the Item LEN = -1 for the complete description. Any value between 1 and 255 is permitted. 
DESCINC \\DESCINCH The Description of the item with special formatting for any (“) in the text The (”) is replaced with (\“) to allow printing in accordance with the EPL2 programming language for Epson and Zebra Printers, 
Quantity 
In Stock (Sell Available) 
WO Quantity on Work Order 
LAY Quantity on Layaway 
Quantity on Order 
The High (Max) Quantity 
The Low (Min) Quantity 
LOCATE The Location NOTE: For Select Lot items, in the event that the Lot has not been selected, the Location of the Inventory Item is printed. 


Inventory Location Fields (Advanced Inventory Control Only)

CODE PRINTED INFORMATION 
INVLOCATBARCODE The inventory location record location barcode. 
INVLOCATBARCODENUMBER The inventory location record location barcode human readable number. 
INVLOCATPART The inventory location record part number. 
INVLOCATPARTDESC The inventory location record part description text. 
INVLOCATHIGH The inventory location record high quantity setting value. 
INVLOCATPICK The inventory location record pick priority setting value. 
INVLOCATPUTAWAY The inventory location record put away priority setting value. 
INVLOCATTEXT The inventory location record location text. 
INVLOCATDATERECV \\(Printing from PO Only!) The inventory location record date stock was received on a purchase order. 
INVLOCATPONUMBER \\(Printing from PO Only!) The inventory location record purchase order number stock is ordered on. 
INVLOCATPACKSLIP \\(Printing from PO Only!) The inventory location record packing slip number stock is to be packed for. 
INVLOCATPARTBARCODE The inventory location record part barcode. 
INVLOCATPARTBARCODENUMBER The inventory location record part barcode human readable number. 


Location Fields (Advanced Inventory Control Only)

CODE PRINTED INFORMATION 
LOCATBARCODE The location record location barcode. 
LOCATBARCODENUMBER The location record location barcode human readable number. 
LOCATIONCOMMENT The location record comment text. 
LOCATIONPREVIOUS The inventory location record part description text. 
INVLOCATHIGH The inventory location record high quantity setting value. 
INVLOCATPICK The inventory location record pick priority setting value. 
INVLOCATPUTAWAY The inventory location record put away priority setting value. 
INVLOCATTEXT The inventory location record location text.
INVLOCATDATERECV \\(Printing from PO Only!) The inventory location record date stock was received on a purchase order. 
INVLOCATPONUMBER \\(Printing from PO Only!) The inventory location record purchase order number stock is ordered on. 
INVLOCATPACKSLIP \\(Printing from PO Only!) 
The inventory location record packing slip number for a purchase order stock is ordered on. 
INVLOCATPARTBARCODE The inventory location record part barcode. 
INVLOCATPARTBARCODENUMBER The inventory location record part barcode human readable number. 


Invoice Fields

CODE PRINTED INFORMATIOM SYNTAX & USES 
DATE Invoice Date 
TIME Current Time (Not Invoice Time).  
TOTAL Invoice Total  
PAID Invoice Paid Amount  
BALANCE Invoice Balance  
SUB-TOTAL Invoice Sub Total  
CHANGE Tendered Change  
TAX NAME [N] Tax Name N = 1 to 8 for each of the 8 Tax Names possible in System Five. 
TENDER.N Tendered Amount N = 1 to 3 System Five allows up to 3 different Tenders on an invoice. 
TENDER.NAME.N The Name of the Tender (eg. VISA or CASH) N = 1 to 3 System Five allows up to 3 different Tenders on an invoice. 
CARD.NUMBER.N Credit Card Number for the Tender N = 1 to 3 System Five allows up to 3 different Tenders on an invoice. 
CARD.AUTH.N Credit Card Authorization Number N = 1 to 3 System Five allows up to 3 different Tenders on an invoice. 
CARD.NAME.N The Name on the Credit Card N = 1 to 3 System Five allows up to 3 different Tenders on an invoice. 
TENDER NAME C Name for the Tender Type C = A to Z were the letter matches the letter assigned in the Tender Setup. 
TENDER AMOUNT C Amount for the Tender Type C = A to Z were the letter matches the letter assigned in the Tender Setup. 
ICK Salesperson / Clerk Number 
CLERK NAME Salesperson / Clerk Name 
I.IPO Invoice PO Number 
TTL.DISC% Total Discount Percent 
TTL.DISC$ Total Discount Dollar Amount 
INVOICE TYPE  Invoice Type 
I.INVOICE NUMBER Invoice Number 
TIME OUT Rental Time Out [Optional Feature Required] The Rental Feature is an option of System Five 
TIME IN Rental Time In [Optional Feature Required] The Rental Feature is an option of System Five 
EARLYPAY TEXT Early Payment Discount Text 
EARLYPAY AMOUNT Early Payment Amount to Pay 
I.NOTE.N Invoice Note Line N = the line number of the note to print. 
I.JOB NUMBER Job Number if one is assigned to the Invoice [Optional Feature Required] Job assignment is a function of the Lighting Store Option for System Five 
I.JOB PO NUMBER Job PO Number [Optional Feature Required] Job assignment is a function of the Lighting Store Option for System Five 


Invoice Line Fields

CODE PRINTED INFORMATIOM SYNTAX & USES 
PARTNO Part Number 
SUPP PARTNO Supplier's Part Number 
CAT+PART Category + Part Number 
DESCRIPTION Description form the Invoice Line May or may not be the same as the Inventory Item Description. 
PRICE Price of Each Item 
XTOTAL Extended Price (Line Total) 
LIST List Price 
COST Cost of the Item. 
XCOST Extended Cost (Line Total) 
PERC.DISCOUNT.SCHEDULE Discount from Customer's Normal Price Schedule. 
DISC% Discount Percent for the line 
DISC$ Discount Dollar Amount for the line.  
LTAX Taxable Y/N 
QUANTITY Quantity Sold / Shipped 
ORDERED Quantity Ordered 
KEYWORD Keyword Associated with item. 
TG.PART.N The Part Number of a Tag Along Kit Item N = a number representing the Tag Along kit item. Eg. TG.PART.1 would print the first part in the kit. 
TG.DESC.N The Description of a Tag Along Kit Item N = a number representing the Tag Along kit item. Eg. TG.DESC.1 would print the Description of the first part in the kit. 
TG.QUAN.N The number of Kits X the Kit Quantity for the Kit Item. N = a number representing the Tag Along kit item. Eg. TG.QUAN.1 would print the Extended Quantity of the first part in the kit. 
TG.KITQUAN.N The Quantity for the Kit Item as assigned in the Kit. N = a number representing the Tag Along kit item. Eg. TG.KITQUAN.1 would print the Quantity of the first part in the kit. 
RANDOMPRICEBarcode System Five Random Price Barcode 
RANDOMWEIGHTBarcode System Five Random Weight Barcode 
SERIAL.NUMBER The Serial Number of an Item 
SERAIL.NUMASBarcode The Serial Number above in a Scanable Barcode Format. 
SERIALBarcode The Barcode Number assigned to the Serial Number System Five has the optional ability to allow the assignment of a secondary number to each serialized item. See: Inventory Setup > Inventory Options 1 for details. 
LINECOMMENT:0 Dynamically prints the Line Item Comments. Example: If you enter a line item comment that contains 3 lines of text as follows: 5” x 8“ Not cut to size, But cut to fit. All three of the lines print. 
LINECOMMENT:N Prints the specific line item comment line referenced by the value in N N = 1 to ? Although there is no specific limit to the number of lines that a comment can contain, it would be impractical to include too many lines on a receipt or label. However, you may want to use the first line of the comment for a specific purpose and always include that text. LINECOMMENT:1 prints that information. 

Since the fields used for Customers, Suppliers and Brands are the same, System Five utilizes the following prefix values for the available fields:  

Customer Label Fields

The Prefix = C  The [C] prefix should only be used in the creation of Customer, Shipping Container and Shipping Part labels.  



Supplier Label Fields

The Prefix = S  The [S] prefix can be used for Supplier, Shipping Part and Inventory labels.  

Brand Label Fields  The Prefix = BRAND  The [BRAND] prefix can be used for Inventory labels ONLY.  


Ship To Label Fields

The Prefix = SH  The [SH] prefix can be used for Shipping Container and Shipping Part labels.  

The following codes can be preceded by the prefixes listed above to change the source of the information that is printed. Be sure to use the appropriate prefix for the desired label as mentioned above, otherwise errors result.  

CODE PRINTED INFORMATION SYNTAX & USES 
NAME The full name 
ADDRESS 1 The first line of the address 
ADDRESS 2 The second line of the address 
ADDRESS 3 The third line of the address Choose either Address 3 & 4 or City & Postal, but not both as they print similar information. 
ADDRESS 4 The fourth line of the address As Above 
CITY The city As Above 
POSTAL CODE \\PC \\ZIP The Postal or Zip Code As Above 
PHONE 1 Phone 1 
PHONE 2 Phone 2 
PHONE 3 FAX Phone 3 (Fax number) 
TAX NUMBER The Tax Number from the Financial tab. 
CONTACT NAME Contact Name 
INFO Extra Info  
BALANCE Account Balance 
LIMIT CREDITLIMIT The Account Credit Limit 
UNIQUE The Unique Record Number  
EMAIL Email Address 
WEB Web Site Address 
CD DEPT The System Five Department assigned to the Customer, Supplier or Brand 
COMMENT:N The Comment lines N = The line number of the comment that is printed. 
FREEHEAD:N The Free form Header Text by Line Number N = The line number of the Free form Header text that is printed. 
FREEFORM:N The Free form Data Text by Line Number N = The line number of the Free form Data text that is printed. 
CUSTOMER Barcode Prints the account number as a Barcode. - For a Customer: If scanned, starts an invoice for that customer, or changes the customer on a current invoice. Although System Five prints the same information for Brands & Suppliers there is currently no use for these Barcodes.
CUSTOMER QUICK Prints the account number as a Barcode. - For a Customer: If scanned, starts a quick cash invoice for the customer, or changes the customer on a current invoice. Although System Five prints the same information for Brands & Suppliers there is currently no use for these Barcodes. 

You can also create a barcode for a clerk or customer to use in making invoices.  


Shipping Part Label

When creating a shipping part barcode label, the text code to display an invoice line's Z-sheet information is <ZSHEET>. <ZSHEET,-1> ensures that the entire text of the Z-sheet information is displayed.  



Re-Created By Steve Wind May 19 2021

barcode_amd_text_fields.txt · Last modified: 2021/05/27 10:46 (0 seconds ago) by swind