Label Designer

Action: LETTERS

The label designer is a WYSIWYG editor & lets the user make changes to the layout of garment tags, pickup tags, and mailing labels. You can add text to your labels, or add other fields. The Label designer is an advanced feature and requires a good understanding of graphical concepts and program logic. BBL is available on a consulting basis to help design & create the desired output. To change the contents of a field on the label, double-click on the field. The Report Expression dialog appears. You can then change the field name to the new one. Here are of the more common field names and their meaning. Within this topic is a explanation of a few of the more common field values customers like to print on tags. Also within this topic are some program logic explanations.

Program logic Notes: If you are printing a character type field (TYPE is C), you can add text to the field by typing:

“Stock Number: ” + ALLTRIM(SSSTYLECODE)

This only works on C TYPE fields.

If you are printing a dollar amount, type the following in the Format field:

$$$,$$$,$$$.99

This will put a dollar sign to the left of the value, and round to two decimal places.

You can also use the following format to print a dollar amount with text:

'RETAIL PRICE '+ALLTRIM(TRANSFORM(ssmkdnretl1, '$$$,$$$.99'))

In this case, you don’t need to use the $$$,$$$.99 format.

Some shops like to include a code that represents the receive date of the item being printed and the real vendor style. This logic will print the 1st 3 characters of a vendor style number, then the last 2 digits of the year, then the month, then the remaining characters for the vendor style # if any. example :

vendor style ABCDEFG last received 09/25/2007.

The code printed on the tag would be ABC0709DEFG. The program logic is:

LEFT(SIMANSTYLE, 3) + RIGHT(TRANSFORM(YEAR(GetLastRecvDate(sistylecode))), 2) + TRANSFORM(MONTH(GetLastRecvDate(sistylecode)), '@[email protected] 99') + SUBSTR(SIMANSTYLE, 4)

Most common bar-code types printed on labels/tags. The first is BC 3 of 9. This type is good for codes that will contain letters (A – Z and 0 – 9) & numbers. This barcode type is a larger type. The second is Interleave 2 of 5. This type can only print an even number of numbers (0 –9), i.e. 99, 9999, 9999 …etc up to 12 digits. This type can print a very small barcode.

For 3 of 9 codes use the font called BC C39 3 to 1 HD Wide, regular font style and 42 points. The maximum length of barcode is 12 characters for a 4” wide tag/label. Put an “*” before and after a barcode:

“” + ALLTRIM(SSUSERID) + “”

For Interleave 2 of 5 codes use the font called BCI25 Medium, regular font style and 12 points. This can produce a small barcode The maximum length of barcode is 12 numeric characters (0 – 9, no spaces or hyphens) and must have an even number of digits. ProfitSystem® will not print a barcode if the data being printed is invalid for this barcode type.

I2of5(ALLTRIM(SSUSERID))

QR codes can be printed for any alphanumeric information. The most common use is to include a URL to information about the product. The Profit System has a E-commerce URL field on the Retail inventory form. This is filled in automatically when the inventory item is uploaded to BigCommerce. Also, the field can be filled in manually. To print a QR code, add a Picture/OLE bound control to the label and set the Control source type to 'Expression or variable name' For the Control source, use

QrCodePath(SIECOMMURL, SISTYLECODE)

This will create a QR code for the SIECOMMURL field, which is the e-commerce URL for the style. Any inventory field can be substituted for the SIECOMMURL.

Worth Data Tricoder Alert

The smallest tag readable by the Tricoder’s scanner is a I2of5 medium, regular font, set to 5 point size. It must be dark & clear enough for the read. If he scanner cannot read the bar-code adjust the printer’s heat setting & speed settings via the print driver (when using a thermal printer like a Zebra) and test until you are able to read the bar-code. Please test before printing large quantities.

Bar-code Note: Bar-code scanners from multiple vendors will have different read characteristics. The bar-codes produced from ProfitSystem® should be tested with the reader being used for compatibility. It may require some trial & error testing with different barcode densities and point sizes before they may be read. Do this testing prior to printing a large number of bar-code tags.

BBL has created special functions for some information to make it as easy as possible for the data to be placed on tags & labels. Use these special functions in place of a field name. You can only use the function on the tag/labels shown after Usage.

GetCustName(PVCUSTNUM): Print customer name from pickup inventory
GetCustName(CUCUSTNUM): Print customer name from customer
GetEvDate(PVEVENTNUM): Print the event date for pickup inventory.
GetVendorName(SIVENDNO): Print vendor name from inventory
GetVendorName(PVVENDNUM): Print the vendor name for pickup inventory.
GetEventBride (PVEVENTNUM): Print the bride name for pickup inventory.
GetEventName(PVEVENTNUM): Print the event name for pickup inventory.
GetCustInfo(PVCUSTNUM, [customer field name]): Print any customer info on a pickup tag.

GetTableInfo()...Prints any data from any table. This is a special purpose function that takes four parameters: table name, tag name, key value, field to return. It goes to the record identified by the key value using the index tag named, in the specified table. It then evaluates the field to return and returns that value.

For example: GetTableInfo('CUSTOMER', 'CUSTNUM', PVCUSTNUM, 'CUHOMEPHON') will return the customers home phone number, using the customer number from the pickup inventory table.

For example: GetTableInfo('ACCTCLAS', 'NAME', SIACCTCLASS, 'ATREVENUE') will return the revenue GL account number for a style code.

For example: GetTableInfo('CUSTTYPE', 'TYPE', GetTableInfo('PROSPECT', 'CUSTNUM', PVCUSTNUM , 'PRCUSTTYPE') , 'CTDESC') will return the description for the prospect type for the prospect what was used to create the customer for a pickup inventory item.

For example GetTableInfo('sinvmast', 'stylecode', PVSTYLECODE, 'sinvmast.SIINTSTYLE') will return the Internet Style number from the inventory table.

For example, to print original SA on PickupTag; GetTableInfo('tickitem', 'ITEMNUM', pickinv.pvitemnum, 'tickitem.TIEMPNUM2')

GetBalance()...Prints the ticket or line item balance for a purchase order item. For example: GetBalance(PVITEMNUM, .T.) will return the total balance for the ticket for that pickup inventory item.

For example: GetBalance(PIITEMNUM, .F.) will return the balance only for the PO item.

ShortColors()...Color fields can contain up to 4 colors, separated by spaces. This function will print all four colors in a shortened format. Each color is separated by a /. For example,. the colors might be WHITE IVORY CYAN. Shortened would be WHITE/IVORY/CYAN.

Pickup inventory: ShortColors(PVCOLOR)
Retail Inventory: ShortColors(SSCOLOR)
For retail inventory 1 thru 4 GetColorName(SIMANSTYLE, 1, [vendor number])
Get a color GetColorByNum([color field], [1-4])
For pickup inventory: GetColorByNum(PVCOLOR, 1)

Store name: oApp.icStoreName