Home

to a PDF version of this document

1. lt CENTER Company Website Address 40 gt lt NEWLINE gt lt CENTER SALES RECEIPT 40 gt lt CENTER alltrim sales pt gt descrip 40 gt lt CENTER alltrim operator gt first_name 240 gt lt CENTER Sale Number IIF sale_hdr gt sale_no sale_hdr gt mastersale ALLTRIM STR sale hdr mastersale 16 0 ALLTRIM STR sale hdr gt sale n0 40 gt lt CENTER DSTR2 sale hdr gt Date time 40 gt lt NEWLINE gt Qty Item Price gt lt Special Discount gt lt I gt lt Details IIF Item TRANS Account Transaction STR extension 8 2 IIF MODIFIER Items gt descrip STR extension tax_amount tax_amt2 disc_amt 8 2 STR quantity 3 0 Items gt descrip STR extension tax_amount tax_amt2 disc_amt 8 2 IIF message alltrim NEWLINE message IIF guest_no 0 ALLTRIM Il NEWLINE alltrim guests gt first_name alltrim quests gt last_name IIF disc_amt 0 NEWLINE ALLTRIM Il NEWLINE IIF ALLTRIM UPPER special CUSTOM Custom Special specials gt descrip STR 1 disc_amt 8 2 NEWLINE gt l
2. Tmp_phone Primary guest phone number Character 8 Tmp pMemol Primary guest user def memo Memo 4 Tmp_pNum1 Primary guest user def numeric 1 Integer 4 Tmp_pNum2 Primary guest user def numeric 2 Integer 4 Tmp_pNum3 Primary guest user def numeric 3 Integer 4 Tmp_pNum4 Primary guest user def numeric 4 Double 8 Tmp_pNum5 Primary guest user def numeric 5 Double 8 Tmp_price Item price Numeric 12 Tmp prntl Ticket 1 layout type Numeric 1 Tmp prnt2 Ticket 2 layout type Numeric 1 Tmp_prnvl Voucher 1 layout type Numeric 1 Tmp_prnv2 Voucher 2 layout type Numeric 1 Tmp_prtmsg Print message DirectNet Character 40 Tmp_ptcomp Pass total comp tickets given Integer 4 Tmp_pts1 Pass points current value Integer 4 Tmp_pts2 Pass Points2 current value Integer 4 Tmp_pTxt1 Primary guest user def text 1 Character 15 Tmp pTxt2 Primary guest user deftext 2 Character 15 Tmp_pTxt3 Primary guest user def text 3 Character 15 Tmp_pTxt4 Primary guest user def text 4 Character 15 52 Tmp_pTxt5 Primary guest user def text 5 Character 30 Tmp_pwarn Number of warnings on pass Integer 4 Tmp_aty Quantity of item sold Numeric 4 Tmp_rrsn Refund reason Character 15 Tmp_saleno Sale number Double 8 Tmp sblvl Snowboard level Character 1 Tmp_sfirst Saved sale f
3. tables are synched Table Sync field Notes access printing tmp_passno Iftmp_passno lt gt 0 and access product accounts sh_save acct_name Iftr save invoice no lt gt 0 alladres printing tmp_gstno Iftmp gstno lt gt 0 alltrans printing sale_no cc trans printing sale no gst pass printing tmp_passno Iftmp_passno lt gt 0 and pass product guests printing tmp_gstno Iftmp_gstno lt gt 0 invoices alltrans invoice_no items alltrans DCI operator alltrans op_code sh_save printing sale_no specials alltrans special tr_save alltrans trans_no utility printing sale_no Graphic Z tape layouts All tables in the local Data folder are open and may be referenced but they may not be synched The following tables are synched Table Sync field Notes csrZTape All transactions from the transact table for that date sale_hdr csrZTape sale no 45 items csrZTape DCI Graphic Tee Sheet layouts All tables in the local Data folder are open and may be referenced but they may not be synched The following tables are synched Table Sync field Notes csrTee Facilities times and descriptions for events Confirmation letters Confirmation layouts are Graphic layouts used with the Salesware Reservations module that are saved in a special directory Siriusware Layouts CONFIRMS This is done for ease of
4. lt F9 gt An OCRA styled font containing Boca s condensed German and British character sets 35 lt F10 gt A bold Prestige font containing Boca s condensed German and British character sets lt F11 gt A script font lt F12 gt An Orator font for tall bold lettering lt F13 gt A Courier style international character set 223 characters Font height and width To specify the height and width of a font boldness use the following command lt HW1 1 gt Increasing or decreasing the numbers controls the height and boldness of the font Once the height and width have been changed from normal a lt HW1 1 gt must be coded for the font to return to the normal size Note Be careful not to build characters into the characters below them by increasing the height too far Printing text To print text using Boca printer commands simply type the beginning delimiter the VFP command alltrim followed by an open parenthesis a double quote the font rotation row and column font style character height and width a closing double quote a closing parenthesis a plus symbol the VFP expression s custom function s table field s and or literal string s followed by an ending delimiter Example lt lalltrim lt RR gt lt RC45 1075 gt lt F6 gt lt HW1 1 gt DAILYCODE ctod tmp_date gt The Boca printer prints the end result of the VFP expres
5. Short lt CENTER COMPANY NAME 40 gt lt CENTER COMPANY ADDRESS 40 gt lt CENTER COMPANY CITY STATE POST OR ZIP CODE 40 ile CENTER COMPANY PHONE NUMBER 40 gt Write To ICENTER COMPANY WEB ADDRESS 40 File lt INEWLINEQ Full x CENTER defaults C name 40 x CENTER defaults address 40 Get From lt CENTER alltrim defaults city defaults gt state defaults gt zip 40 gt File NEVWLINEG Write To CENTER SALES RECEIPT 40 gt x CENTER Sale Number Graphic layouts and Text Merge layouts are associated with their applications for receipts invoices Z Tape Reports and saved sales from Sales gt Tools gt Sales Pt Setup gt Printing Printing Setup gt Page 2 tab as showing in the following four screen captures Page 1 Page 2 Page 3 Windows Printer E Dot Matrix Printer Report Type Receipts Receipt GENERIC EN 40 Column Non Graphic RE k v 85 x Ma Non Graphic 440 Column Graphic GENERIC iv 8 5 x 11 Graphic NONE Taa Invoices NONE w GENERIC sl Saved Sale NONE x GENERIC x NONE vi Page 1 Page 2 Page 3 E Windows Printer Dot Matix Printer Report Type Receipts Receipt GENERIC v 40 Column Non Graphic el Invoices NONE v GENERIC ll NONE iis xx xx 40 Column Non Graphic SENSE
6. Tmp_aDesc Account description Character 25 Tmp admisn Number of admissions per item Integer 4 Tmp aDtime Account user defined date 2 Character 16 Tmp aLimit Account credit limit Double 8 Tmp_aMemol Account user def memo Memo 4 Tmp_aName Account name Character 25 Tmp_aNotes Account notes Memo 4 Tmp_aNuml Account user def numeric 1 Integer 4 Tmp_aNum2 Account user def numeric 2 Integer 4 49 Tmp_aNum3 Account user def numeric 3 Integer 4 Tmp_aNum4 Account user def numeric 4 Double 8 Tmp_aNum5 Account user def numeric 5 Double 8 Tmp_aPhone Account phone number Character 8 Tmp_area Primary guest area code Character 5 Tmp_aState Account state Character 2 Tmp_aTxt1 Account user def text 1 Character 15 Tmp_aTxt2 Account user def text 2 Character 15 Tmp_aTxt3 Account user def text 3 Character 15 Tmp_aTxt4 Account user def text 4 Character 15 Tmp_aTxt5 Account user def text 5 Character 15 Tmp_aZip Account zip code Character 10 Tmp_bage Age of the booked guest Character 3 Tmp_bedt Booking end date Character 10 Tmp_betm Booking end time Character 8 Tmp_bifnm Booking instructor first name Character 10 Tmp_bilnm Booking instructor last name Character 10 Tmp_birth Primary guest birth date Character 10 T
7. el tr vH e ORTUS REDE Ee 22 Toanstall theGenetic Text Only drid ia 25 Example of installing a receipt printer Star TSP with a Receipt Javout non aaa 26 Edit Layout Printer Option missing in Windows 7 ccccsccccesesscceeseneeeeeeneeeecseneeeecseeecesseaeeecesaeeeceueeeceeaeeeessnaeeecseneeeesseeesesseeeeess 27 When editing the layout perform these steps 27 Functions and commands 27 Printer commands io 28 Salesware specific Visual FoxPro VFP functions for Graphic Lavouts nennen nre enemies 28 Custom Salesware layout functions s HEN RUE EUREN FOREN ROTER REP GERE ENEE 28 Supported specialized printers 1 e cereis eee cete ee eee ense eee etn eset en assets asset ens stets esee tense soara stesse sees ens ese eesss sse sense see sesseseesessseeess ZO Sample layouts provided with Salesware sssccssscssccsssssscssssssessscssecssscssessscssesssscssessssessessscsesssscsssssssssssssscsssssscssssssssssssscssssssses ZO Printer commands AAA Cognitive printer COMME A ai tote ut ue Ste pce a i S i tA I a I AA atv eat oa ee cae 30 SERM IR PEE 30 Text justification for Cognitive layouts iio aiii OE Siva eR cea vet Hee aree ces Melee sak aa 31 Font styles and sizes Dltrab entgegen SE EES EE ENEE EE ISR A OO Boldness Spacins Odd EE 32 Col rnins MATOS STEE EE id det 32 Printihg text EE Printing DA oup en Nt RU n t edid eU ema ds m The END command BOCA printer commands
8. Ticket 1 O None Ticket 2 J C Print On Addit O None Receipt Liability O Graphic Layout Stock Text Merge Axess Smart Printer O Shared TM Layout Ignore Oty Voucher 1 O None O Graphic Layout Text Merge 05 O Axess Smart Printer O Shared TM Layout Ignore Oty 9 Graphic Layout O Text Merge 0 O Axess Smart Printer O Shared TM Layout Ignore Oty Voucher 2 None O Graphic Layout d O Text Merge ol Axess Smart Printer O Shared TM Layout Ignore Qty C Multiline print Remote Print On 1 5 2 6 3 7 4 8 Cl Remote print with parent item Rental Contract Department TICKETS m Category ADULT v New Receipts Invoices Summaries Charge Cards saved Sales Remote Receipts and Z Tape Reports Receipt layouts are either short or long Short layouts print to a forty column printer Long layouts print to standard 8 5 x 11 paper Text Merge layouts are associated with their applications for receipts invoices summaries credit cards saved sales remote receipts and Z Tape Reports from Sys Manager gt Preferences gt Miscellaneous gt Salespoint Layouts tab as shown in the following screen capture ci Miscellaneous Preferences Manager Sales Global INI Confirmation E Mail Salespoint Layouts Remote Layouts PA DSS Credit Cards IL Invoices Sales Summary Z Tape Saved Sales
9. substr alltrim str year ctod tmp_date 4 0 3 2 gt 6 2 U C40 6 5 0 500 190 lt jalltrim tmp_dept talltrim tmp_Item gt U A25 2 5 0 500 235 lt IF EMPTY tmp_spct alltrim tmp spct gt U A25 2 5 0 500 326 lt time ee NE spct talltrim str tmp_disc 9 2 gt U A25 2 5 0 500 352 lt alltrim tmp oper dtoc date alltrim FOP alltrim str tmp ext tmp qty 9 2 BT 18X23 0 5 BR code39 3 7 710 500 70 lt if empty tmp date A XX A cencrypt date tmp date encrypt number tmp_access gt END Boca printer Ticket layout lt lalltrim lt RR gt lt RC45 1075 gt lt F6 gt lt HW1 1 gt DAILYCODE ctod tmp date gt lt alltrim lt RR gt lt RC50 1020 gt lt F3 gt lt HW1 aS upper substr CMONTH ctod tmp_date 1 3 alltrim str day ctod tmp_date 3 0 P seses alio mo year eed tene dare 4 0 3 2 LS lt lalltrim lt RR gt lt RC50 980 gt lt F3 gt lt HW1 1 gt al SE dept alltrim tmp Item gt lt lalltrim lt RR gt lt RC50 925 gt lt F3 gt lt HW1 1 gt time alltrim tmp spct alltrim str tmp disc 9 2 gt lt lalltrim lt RR gt lt RC50 830 gt lt F3 gt lt HW1 1 gt alltrim tmp oper dtoc date alltrim FOP talltrim str tmp_ext
10. Layout application Where the layout is associated with its printing application Graphic Text Merge Shared Text Merge Sales receipt SysManager gt Preferences gt Miscellaneous Text Merge layouts Sales gt Tools gt Sales Pt Setup gt Printing Printing Setup gt Page 2 tab Text Merge layouts and Graphic layouts Yes Yes No Invoice SysManager gt Preferences gt Miscellaneous Text Merge layouts Sales gt Tools gt Sales Pt Setup gt Printing Printing Setup gt Page 2 tab Text Merge layouts and Graphic layouts Yes Yes Z Tape Report SysManager gt Preferences gt Miscellaneous Text Merge layouts Sales gt Tools gt Sales Pt Setup gt Printing Printing Setup gt Page 2 tab Text Merge layouts and Graphic layouts Yes Yes Saved sales SysManager gt Preferences gt Miscellaneous Text Merge layouts Sales gt Tools gt Sales Pt Setup gt Printing Printing Setup gt Page 2 tab Text Merge layouts and Graphic layouts Yes Yes Tickets SysManager gt DCIs icon gt Item Edit Form gt Printing tab Text Merge layouts Shared Text Merge layouts and Graphic layouts Yes Yes Yes Vouchers SysManager gt DCIs icon gt Item Edit Form gt Printing tab Text Merge layouts Shared Text Merge layouts and Graphic layouts Yes Yes Yes Passes print from SysManager only SysManager gt DCIs icon
11. left 45 alltrim tmp_oper alltrim tmp_loc alltrim dtoc date t talltrim time gt In the example lt styl lt styl lt styl lt styl e1 gt bold e2 gt condensed e3 V empty single quotes e4 V empty single quotes alignment left line size 45 lt VFP expr gt alltrim tmp_oper alltrim tmp_loc alltrim dtoc date alltrim time TTOC TABLE_NAME gt FIELD_NAME FORMAT Ticket Voucher layouts use TTOC time to character followed by specifications for the desired format o sa dp d oe w o m oe Q d oe c Q oe dp oe d u oe lt Abbreviated weekday name Full weekday name Abbreviated month name Full month name Date and time representation appropriate for locale Day of month as decimal number 01 31 Hour in 24 hour format 00 23 Hour in 12 hour format 01 12 Day of year as decimal number 001 366 Month as decimal number 01 12 Minute as decimal number 00 59 Custom 68 Sp Current locale s A M P M indicator for 12 hour clock 38 Second as decimal number 00 59 SU Week of year as decimal number with Sunday as first day of week 00 53 w Weekday as decimal number 0 6 Sunday is 0 Sw Week of year as decimal number with Monday as first day of week 00 53 x Date representati
12. Setup Information inf 7 Copy manufacturer s files from C Documents and Settings Administrator Desktop y Browse 14 Select the driver and click Open 15 Click OK and then Next to complete installation of the driver To install the Generic Text Only driver 1 Plug the hardware into the computer 2 You are presented with the Found New Hardware Wizard Found New Hardware Wizard Welcome to the Found New Hardware Wizard This wizard helps you install software for FARGO Electronics Inc ID Card 4250 If your hardware came with an installation CD E or floppy disk insert it now What do you want the wizard to do C Install from a list or specific location Advanced Click Next to continue SE Cancel 3 Select the Install from a list or specific location radio button Click Next 4 From the Please choose your search and installation options dialog select the Don t search I will choose the driver to install radio button Click Next 5 From the Manufacturer column select Generic From the Printers column select Generic Text Only Click Next Found New Hardware Wizard Add Printer Wizard A Select the manufacturer and model of pour printer If your printer came with an installation disk click Have Disk If pour printer is not listed consult your printer documentation for a compatible printer Manutactures a ee Fuji Xerox Generic Text Only is E EX Generic IBM Graphi
13. n n 1 un of lt 64 or or or lt 2 gt e Loi H n Cuts the paper fully immediately gt Cuts the paper leaving one point uncut immedi ately Cuts the paper fully after feeding the paper to the cutting position When print start position detect is ON feeds the paper to the next print start position first feeds the paper to the cutting position then cuts the paper fully Cuts the paper fully after feeding the paper to the cutting position When print start position detect1s ON feeds the paper to the next print start position first feeds the paper to the cutting position then cuts the paper leaving one point uncut Converted to decimal and added to the script it appears as SELECT Cut_Code CHAR 27 CHAR 100 CHAR 1 Once this script is completed use Query Analyzer or Management Studio to run it on the SiriusSQL database This adds or updates if the printer name is already in the Printers table the controls for the printer After the Printers table has been updated modify the layouts to use the new entries in the Printers table For example to add the cut_ code function to a standard sales receipt the following line would be added to the end of the layout prunters ceut eode 83 This references the Printers table and the field named cut_code To use another function reference the field in the table such as color 1 bold underline etc The
14. 1 St y 1 OKI MICROLINE 320 321 EPN EMML W N E 4 x OKI MICROLINE 320 321 IBM EMML WwW e E 4G 1 OKI MICROLINE 390 391 PLUS N E M 1 PANASONIC KX P1124 2 f e G 4 PANASONIC KX P1180 e PANASONIC KX P2124 PANASONIC KX P2180 STAR 40 COLUMN STAR 40 COLUMN AUTO CUTTER VERIFONE PRINTER 250 40 COL ITHACA MODEL 80 ESPON TMT88 STAR TSP400 ITHACA ITHERM 280 To use the Printers table you must select the printer you are using from the Sales gt Tools gt Sales Pt Setup gt Printing gt Dot Matrix Printer dropdown Example If you choose STAR TSP400 then the layout uses the codes highlighted in light blue in the screen capture for any layout calls made to the Printers table When making layout calls to the Printers table you replace any printer specific codes you would otherwise use with calls to the Printers table So if the layout is coded with Printers gt doublewide the salespoint pulls the doublewide code for the STAR TSP400 If by accident you selected the STAR 40 Column printer from the dropdown and used the same layout Sales would use the STAR 40 Column row and grab the doublewide code from that row Because the codes are usually different for different printers it is important to select the correct one to get your layout to work properly You can add additional devices if the device you are using is not listed in your table See Appendix C Using the Printers table to handle control codes f
15. gt Item Edit Form gt Action tab choose the Create Pass from the dropdown gt Action Specifics gt Global Settings tab gt Prefer field Graphic layouts only Note This field is rarely used now because most clients print passes through Sales and Sales allows you to prompt the operator with a printer selection or specify a printer to always use for passes Yes Charge Cards SysManager gt Preferences gt Miscellaneous Text Merge layouts only No Yes Remote SysManager gt Preferences gt Miscellaneous Text Merge No Yes No printing layouts only receipt Sales SysManager gt Preferences gt Miscellaneous Text Merge No Yes No summary layouts only Associating layouts with their individual applications This section presents screen captures showing where layouts are associated with their applications in SysManager and Sales as already described by the navigation descriptions in the previous table Tickets and Vouchers Ticket and Voucher layouts can be whatever size you want based on ticket and voucher stock and your printer Tickets and Voucher layouts are associated with their DCIs from within SysManager SysManager gt DCIs gt Item Edit Form gt Printing tab as shown in the following screen capture A i TICKETS Cat ADULT a lok Fundraising Interface Profit ctrs Web Specials Action Printing General Sales Point Type Restrictions
16. 00 am is returned lt expN1 gt Number of hours to add or subtract To add hours enter a positive number To subtract hours enter a negative number lt expN2 gt Number of minutes to add or subtract To add minutes enter a positive number To subtract minutes enter a negative number lt expN3 gt Number of minutes to round up to lt expN4 gt Number of minutes at which to start rounding lt expC2 gt through expC8 Maximum time to be returned for a day lt expC2 gt is Sunday s maximum while lt expC8 gt is Saturday s maximum Enter the string as a time HH MM To set the maximum for a day to be some time during the following day 1 e after midnight enter the time as a military time accounting for moving beyond midnight Example To set the maximum for 2 00 AM the following day enter 26 00 as the maximum lt expC9 gt through lt expC15 gt follow the same format but are the minimum times ENCRYPT_NUMB ER Encodes the base 10 number into a base 38 number primarily for compression of barcodes Example ENCRYPT_NUMBER IMP_PASSNO where TMP_PASSNO 120012005 returns 1JL4UP Custom 66 ENCRYPT_DATE CHAR DATE VALUE Encodes the base 10 character date into a base 38 number primarily for compression of barcodes Example ENCRYPT DATE TMP EDATE where TMP_EDATE 12 25 2002 returns CP C 12 and P 25 in base 38 ENCRYPT_DATE DTO
17. C ProgramFiles Siriusware Sales Layouts In Layouts section of the Sales32c INT file specify layout type see following table and layout name Example Receipt thermal40 txt Note The Sales32c INI file is used to specify locally defined non graphic layouts only Use of local graphic layouts is determined by the Printez INI file locally using a method similar to that described above Additionally you have the option to set up Group Level layouts as defined by the groups listed under SysManager gt Preferences gt Misc gt Global INI In order to take advantage of Group Level layouts you must do the following l 2 Create appropriate Text layout for group level receipts 1 e FBReceipt txt FBSavedSale txt FBCCTOP EXE ete Create a new item under a miscellaneous DCI MISC Receipts FBReceipt Note This item is to act as a vessel to transport the layouts you created to the appropriate salespoints in the Group you add the layouts to e On the Printing tab of the item select Shared Text Merge under Ticket 1 and click on the ellipses e Select the layout you created FBReceipt txt for example e Do the same for Ticket 2 Voucher 1 and Voucher 2 as needed e Save the item Edit the appropriate item tree with which salespoint group s are associated Add the new receipt DCI to the item tree and inactivate the item Go to SysManager gt Preferences gt Misc gt Gl
18. Flexible Can be shared among items Ticket Voucher layouts only Require custom coding of printer commands Not graphically rich Unlike Text Merge layouts Shared Text Merge layouts are used only for tickets and vouchers Like Text Merge layouts they too can be output to a wide variety of specialized printers Most commonly they are used with Cognitive and Boca printers see Printer commands for more information on creating layouts for Cognitive and Boca printers They are also created as t xt files using a text editor but are then shared by several printing applications or items so must be saved Shared Text Merge layouts are stored in Siriusware Layouts For more information on how layouts are stored see Appendix A Packing and unpacking layouts Layout applications This section describes the layout applications that are used in Salesware For some applications you can use more than one layout type For others you must use a specific layout type The methods by which you associate a layout with its printing application using SysManager and Sales are also described Specific layout applications The following table lists and describes the layout applications used in Salesware and where the layout is associated with its printing application from SysManager and Sales See Associating layouts with their individual applications for screen captures showing the interfaces in SysManager and Sales where these associations are made
19. This is the problem with very large blocks of text they don t split between pages If you make the blocks small enough though then they break up in a more desirable way This trick has the added headache of maintaining more individual chunks of text but has the advantage of working better in multi page layouts When you create fake groups you also need fake group variables this is what the fake groups group on To create the layout follow these steps 1 From the layout editor click Report gt Data Grouping 2 Add as many fake groups as you think you might need Use the expression FakeGroup1 FakeGroup2 etc 3 On that same Data Grouping dialog box change the nesting order of the groups so that the real groups are at the bottom and the fake ones are at the top 4 In Reports gt Variables create the same number of variables to match the expressions you used in step 2 FakeGroup1 FakeGroup2 etc Leave the Value to store Initial Value Reset Value and Calculation on their defaults 5 Start filling up the group footers You may have some problems if you are using a summary band but that can usually be solved by moving that information into one of the FakeGroup footer bands Fields for Text Ticket layouts The table below contains field types and their descriptions used for Text Ticket layouts Field type Description Character A string of characters of a defined length from 1 to 255 holds anyth
20. Windows operating system not our applications The removal of the Printers button in Windows Vista and newer operating systems was performed by Microsoft for various internal reasons mostly regarding security and memory stability Unfortunately accesso cannot add this button to a Windows System dialog but there is a workaround that does not require shutting down SysManager and changing the default printer When editing the layout perform these steps 1 Onthe menu bar select Report gt Run Report 2 Highlight the printer you wish to use and click the Apply button followed by the Cancel button 3 Select File gt Page Setup The selected printer will now be active on the Page Setup dialog Functions and commands There are three types of functions and commands used to create layouts printer commands a Salesware specific subset of Visual FoxPro VFP functions and custom Salesware functions These three types of functions and commands are described in the following sections 27 Printer commands Printer commands are commands that are used to control your output device they are unique to the printer for which the layout is designed In general they are used only with Text Merge layouts and Shared Text Merge layouts because Graphic layouts are generally output to printers that use standard Windows drivers A printer command can determine the font size style or position in which the text is printed Currently layouts can be pr
21. a recorded history of every layout that has been edited assigned to a product etc Basically if you touch a layout in SysManager it gets written to the layouts table When a layout is no longer used the layouts table is not pruned Because layouts are not linked to items using the Layouts table there is no active tracking of layout usage that can be used to perform maintenance on the Layouts table Ifa layout is changed and that layout s name exists in the Layouts table the layout s record is updated and the lastmod value is tagged to reflect that a change was made an append was made What does this mean Every time you assign a layout to an item even once or change a layout that was already assigned to an item a record is added or updated in the Layouts table Sales pulls the Layouts table across the network copying changes into the local data version of the Layouts table and PrintEZ application reconstructs local layout files based on the data in Layouts table No files are physically copied Working with the local layouts table from Sales In Sales you have the option to refresh pack re index and unpack layouts The first three operations are performed from Sales gt Tools gt Data Files where you can select the local layouts table Refresh pulls a fresh copy of the layouts table from the SQL Server In this case Pack and Re Index are of no use because this is a fresh copy of the table so no packing or re
22. card receipts Text ID cards Graphic Kitchen receipts Text Mailing labels Graphic Passes Graphic Rental equipment labels Graphic Rental forms Graphic Retail labels for matrix items Graphic Retail labels for tracking items Graphic Sales receipts Text Sales summaries Text Saved sales receipts Text Vouchers Text Z tape Reports Text Account Summary Report Graphic Inventory Receiver Report Graphic Purchase order form Graphic Confirmation letter Graphic Account invoices 40 columns Graphic Account invoices 80 columns Graphic Sales receipt 40 columns Graphic Sales receipt 80 columns Graphic Saved sales receipt 40 columns Graphic Saved sales receipt 80 columns Graphic Tickets Graphic Rental contract with modifiers Graphic In addition over the course of the last several releases of Salesware a variety of layouts have been distributed and there are also many pre supplied layouts that can be obtained through the accesso Siriusware Information Portal under Downloads gt Layouts 29 Printer commands Printer commands are commands that are used primarily from Text Merge and Shared Text Merge layouts to control your printer they are unique to the printer for which the layout is designed A printer command can determine the font size style or position in which the text is printed Layouts can be printed using the Cognitive printer referred to for many year
23. eite ev teer RU ee t edu d ed es e dd Metts Mio Tota OMen ER Rowsatid columnist eenen Topos pc FontistyleSz nto si sa a is D a i eeiam eese eet p itc ea SU Font height and width ee ee ee tee ed Wess Me A I inst ctu 36 Printing text s Example uisu O ege et O eeneg e O kun ie Mec O le hotte ie Dekor tendu 36 Printing barcodess i sodes oasis ttal en de eet a a dtu b da tes eet Jui do chis tione EE 36 Specifying the end of a Boca printer Iowvout eene eene eene nnne nee nhe RR nn RR nn rennen eene re nnne nennen 37 Dotmatrix printer E CEET 38 Example ies E e en et td eet Een geen tee aa Ee Ee sat ttle 38 Sample ticket Printer layouts Cognitive printer Ticket layout e Boca printer Ticket layout geg AE EES RPM ENIM RR o UM NUM 39 Tables and fields available for use from layouts scsscssccssscssscsscssccsscscecsscscesssscsesssscssessscscssssessscsssssssssscsesssscssssssscsssssssssssssses OD Tables and fields available from Graphic layouts sse nennen nnne nene nenne aaa aaa aaa ono rr rennen nn 41 Graphic Ticket and Voucher aa Ua Graphic Receipts and Invoice layouts y Graphic Saved Sale l yQuts i i n rosas Era RE EE Graphic Tee Sheet da yout eet ad data del codos dalt dea de eg ua lente bes do ais aa EE ea CONTI MALO letters 7 a a TR Multi page Confirmation layouts tad To create the layout follow these steps Fields for Text Ticket
24. final step aside from testing is at the salespoint After making changes to the Printers table on the server it is recommended to delete the local Printers table from the Sales Data folder This causes the table to be rebuilt from the server when Sales is launched Launch Sales and log in Go to Tools gt Sales Pt Setup gt Printing and select the Dot Matrix Printer from the list for the printer connected to the salespoint Do this for all layouts that use this printer Now test If the printer does not seem to respond to the control codes verify that they are being sent to the printer This can be done by changing the port for the printer driver to FILE and printing See the documentation for the PrintToFilePath INI setting in the Salesware INI Settings Reference document for information on where the file prints Open the file in Notepad and verify that the characters that were added to the Printers table appear in the file If not this indicates an issue with Sales It s possible that the wrong Dot Matrix Printer is selected in the Printing setup Verify that there is not more than one printer with the same name It s also possible that the modified layout was not updated at the salespoint Finalizing a sale causes it to update For more information on updating layouts see Appendix A Packing and unpacking layouts If the characters do appear in the text file verify that they are correct by checking the programmer
25. gt 0 alladres csrSaleTrans guest_no_a baselodg resrvatn base_lodge Iftransact reserv_no lt gt 0 41 bookinfo transact trans_no and guests guest_no cc_trans transact sale_no csrResDWCards N A Single record table csrResGuest guests guest_no csrSaleGuest csrTrans guest_no csrSaleHdr transact sale_no csrTrans transact trans_no Primary table for printing csrTransGuest transact trans_no dailycod today s month day defaults N A Single record table gst_book guests guest_no gst_pass printing tmp_passno gst_rent guests guest_no guests printing tmp_gstno invoices transact invoice_no Iftransact invoice_no lt gt 0 items transact DCI mktgcode resrvatn mktg_code Iftransact reserv_no lt gt 0 operator transact op_code passinfo printing tmp_gstno pkup_loc resrvatn pickup_loc Iftransact reserv no lt gt 0 prefs N A Single record table prefs_bk N A Single record table printing printing tmp_formno This field holds the rental contract number generated when FormIsTrans TRUE is set in the Sales32c INI file Note The rentinfo form no field can also be used on Graphic layouts alltrim str rentinfo form no 16 0 rentinfo transact trans_no and guests guest_no resrvatn sale_hdr reserv_no sale_hdr transact sale_no 42 sales_pt
26. gt Sales Pt Setup gt Printing gt Page 2 tab 11 From the Windows Printer dropdown select Generic Text Only 12 From the Dot Matrix Printer dropdown select the Star TSP model that you installed 13 From the Report dropdown select 40 Column Non Graphic ATA A Make a sale and see if the device works If it does not print check whether a print job was sent to the device by going to Start gt Printers and Faxes If no print job was sent there is nothing in the queue for that device then there was a problem when you associated the device with the application from Sales gt Tools gt Sales Pt Setup gt Printing If there is a print job in the queue but there was an error then there is a problem with the device you selected from the Dot Matrix Printer dropdown or the device was not installed properly to start with Note If receipt printing is not enabled a receipt does not print Receipt printing of items can be enabled in two different places It can be enabled on an item by item basis from the SysManager gt Activities gt DCIs gt New Edit gt Printing tab gt Print On Receipt button Or you can set the salespoint to print a copy of the receipt for every sale from Sales gt Tools gt Sales Pt Setup gt Miscellaneous gt Print Receipt You can also press the Reprint button in Sales to print a receipt on demand Edit Layout Printer Option missing in Windows 7 The Page Setup dialog is a printer related dialog provided by the
27. layout for remote layout 4 for ALL items Remote4New Salespoint specific remote non Graphic layout for remote layout 4 for NEW items Remote5A11 Salespoint specific remote non Graphic layout for remote layout 5 for ALL items Remote5New Salespoint specific remote non Graphic layout for remote layout 5 for NEW items Remote6A11 Salespoint specific remote non Graphic layout for remote layout 6 for ALL items Remote 6New Salespoint specific remote non Graphic layout for remote layout 6 for NEW items Remote7A11 Salespoint specific remote non Graphic layout for remote layout 7 for ALL items Remote7New Salespoint specific remote non Graphic layout for remote layout 7 for NEW items Remote8A11 Salespoint specific remote non Graphic layout for remote layout 8 for ALL items Remote8New Salespoint specific remote non Graphic layout for remote layout 8 for NEW items Consolidating the Sales and CC Receipt You can consolidate the Sales and CC Receipt using the following layout code This is a modified Receipt layout and does not work if put within the CC Top CC Bottom layout sections lt CENTER lt CENTER lt CENTER lt CENTER O GR Company Name 40 gt Company Address 40 gt City State Zip 40 gt Company Phone 40 gt 14
28. s developer s user s manual If they are correct it s possible to test them out within the printer driver For example to test the cut code for a Star TSP600 in the printer driver open the printer driver properties and switch to the Printer Commands Two fields here can be used for testing control codes Begin Print Job and End Print Job When testing font formatting changes it is recommended to use the Begin Print Job field for cut codes use the End Print Job field Enter the control code in hexadecimal form This can be pulled from the printer s manual as before or converted from decimal using the ASCII chart at the end of this document In our example the characters 27 86 and 1 are converted to 1B 56 and 01 and entered into the End Print Job field as shown 84 2 Plain LPT1 Properties General Sharing Ports Advanced Security Device Settings Printer Commands Font Selection Begin Print Job FO End Print Job lt 1B gt lt 56 gt lt 01 gt Paper Size Select hi Paper Feed Selection Unprintable Margins Units Let o Top fo C 0 01 inches Right fo Bottom j 0 1 millimeters Click Apply and it changes to lt 1B gt V lt 01 gt It is recommended to close the Properties window reopen it and verify that the characters are still listed Often Windows does not save these settings so be certain they are there before continuing After verifying that the change was made print a test page from the driver and t
29. tmp_qty 9 2 gt lt lalltrim lt RC50 575 gt lt X2 gt lt NXL12 gt 1f empty tmp edate AXX A encrypt dat tmp_edate tencrypt_number tmp_access talltrim gt lt alltrim lt RR gt lt RC150 475 gt lt F1 gt lt HW3 2 gt A alltrim str tmp_access gt lt lalltrim lt p gt gt Tables and fields available for use from layouts Layouts can reference any field in any table in the local data but the data that is fetched is valid only if Sales has synced to the table Syncing means that Sales sets the table pointer to the relevant row all fields in the row are then available to the layout 39 Note Layouts don t use lookup fields to find an applicable row they simply start grabbing the fields in the Current row in the table syncing by Sales causes the relevant row to become the current row 1 e the row that is pointed to by the table pointer This section describes the tables that get synced for all types of layouts The following table shows all of the tables and the fields used to sync available to Text Merge and Shared Text Merge layouts The section Tables and fields available from Graphic layouts shows all of the tables and the fields used to sync available to Graphic layouts The tables listed are all those that you can legitimately reference from your layout that contain data relevant to the transaction The Printing table is a special
30. unpacking of layouts because the layouts table has no knowledge of them If you would like to include these layouts in the usual layouts processes then store the masters in the Siriuswarel Layouts folder and reference them from a dummy item that doesn t actually use them In this way they are included in the packing unpacking and updating processes because they are stored in the Layouts table Maintenance recommendations When you have finished layouts for an upcoming season it s a good idea to store unused layouts in an archival folder and pack up all layouts using Sys Manager gt Activities gt Pack Up All Layouts This ensures that salespoints are getting only what they need Preventative maintenance might include packing up all layouts semi annually Ifthe Layouts folder is exposed to heavier traffic then quarterly is more suitable Appendix B How to increase the height of a barcode on a Graphic layout A common requirement when designing passes and other Graphic layouts is to increase the height of a barcode This appendix describes how to do that To increase the height of a barcode on a Graphic Layout 1 In SysManager go to Activities gt Edit Layouts Note For the purposes of experimentation you select Activities gt Copy Layout then Edit and perform these steps on a Test layout lal Report Designer copy of pass basic landscape tnx S 3 0 1 2 3 4 5 sl SIRIUS SOFTWARE GET A GREAT PRODUCT GET A
31. 0 1050 1 This code prints one ticket on a Cognitive printer ticketaty 5 returns 5 GETDAT ESTRING Returns the ticket start date and ticket end date as day of week MM DD as a string Designed to be used in multi day Ticket layouts and uses the fields Tmp_date and Tmp_edate to produce the first three letters of the day of the week the number of the month and the year Tmp_date is the date that the ticket can start being used Tmp_edate is the last date the ticket can be used If the ticket was purchased for one day only the start date prints If the ticket was purchased for more than one day the start and end dates print Example If the ticket was purchased on Monday April 1 GETDATESTRING returns MON 04 01 if the ticket was purchased for one day GETDATESTRING results in MON 04 01 FRI 04 05 ifthe ticket was purchased for more than one day Custom FOP_BRI EAK Returns the payment types used and the breakdown of the purchase as a string Example FOP_BREAK returns CASH VISA 10 35 200 00 Custom BREAKDOWN Returns the payment breakdown used at the time of the purchase as a string Custom FOP Displays the form s of payment used to pay for the sale If Visa and cash were used to pay for the sale VISA CASH are displayed Custom CMONTH DATE_VALUE Converts a date to the literal name o
32. 1 description Memo 4 Tmp mod2 Modifier 2 description Memo 4 Tmp mod3 Modifier 3 description Memo 4 Tmp_mod4 Modifier 4 description Memo 4 Tmp_mod5 Modifier 5 description Memo 4 Tmp mod6 Modifier 6 description Memo 4 Tmp_mod7 Modifier 7 description Memo 4 Tmp_mod8 Modifier 8 description Memo 4 Tmp_mod9 Modifier 9 description Memo 4 Tmp moneyl Pass money current value Currency 8 Tmp money2 Pass money2 current value Currency 8 Tmp_msg Line item message Character 20 Tmp_oper Operator log in name Character 6 Tmp_otlvl Other level Character 1 Tmp_parent Description of modifier s parent item Character 25 Tmp_pasacc Account associated with pass Character 10 51 Tmp_pasamt Amount paid for pass Currency 8 Tmp_passno Pass number for item Double 8 Tmp_pboe Pass blackout end date Character 10 Tmp_pbos Pass blackout start date Character 10 Tmp pChkl Primary guest user def chk box 1 Logical 1 Tmp_pChk2 Primary guest user def chk box 2 Logical 1 Tmp_pChk3 Primary guest user def chk box 3 Logical 1 Tmp_pChk4 Primary guest user def chk box 4 Logical 1 Tmp_pChk5 Primary guest user def chk box 5 Logical 1 Tmp_pDatel Primary guest user def date 1 Character 10 Tmp_pDtime Primary guest user def date 2 Character 16
33. 85 x 11 Non Graphic 3 p 40 Column Graphic Saved Sale NONE ell GENERIC 85 x 11 Graphi Z Tape NONE Windows Printer Dot Matrix Printer Report Type Rec eipts Receipt GENERIC a 40 Column Non Graphic m E Saved Sale NONE x GENERIC x 40 Column Non Graphic Windows Printer Dot Matrix Printer Report Type Receipts Receipt iv GENERIC iv 40 Column Non Graphic Invoices NONE v GENERIC v None Y Z Tape NONE _ v GENERIC v none Saved Sale NONE y GENERIC None 1 Non G raphic 40 Coluran Graphic 8 5 x 11 Graphic 11 The SysManager gt Preferences gt Miscellaneous dialog see screen capture above at the beginning of this section is also used for kitchen printing Kitchen printing refers to the sending of information at save or finalize to a receipt printer The Remote tabs allow up to eight various Remote Receipt layouts to be configured Thus based on what kitchen printer is being used the layout can vary Example Remote printer 1 is used for the bar and remote printer 2 is used for the grill Based on a bartender needing a different layout than a cook the Remote Receipt layouts for 1 and 2 are customized The remote printer that is used is associated with the DCI from SysManager Sys Manager gt DCIs icon gt Item Edit Form gt P
34. A Single record table cc trans printing sale no sale hdr printing Sale no sh save printing Sale no tr save printing Sale no transact printing Sale no utility printing sale no alladres printing tmp gstno Iftmp gstno lt gt 0 guests printing tmp gstno Iftmp gstno lt gt O access printing tmp_passno Iftmp_passno lt gt 0 and access product gst_pass printing tmp_passno Iftmp_passno lt gt 0 and pass product accomdtn resrvatn accommodat Ifsale hdr reserv no lt gt 0 baselodg resrvatn base_lodge Ifsale hdr reserv no lt gt 0 mktgcode resrvatn mktg_code Ifsale hdr reserv no lt gt 0 pkup loc resrvatn pickup_loc Ifsale hdr reserv no lt gt 0 srcecode resrvatn srce_code Ifsale hdr reserv no lt gt 0 usercodl resrvatn user_codel Ifsale hdr reserv no lt gt 0 usercod2 resrvatn user code2 Ifsale hdr reserv no lt gt 0 usercod3 resrvatn user_code3 Ifsale hdr reserv no lt gt 0 wrapcode resrvatn wrap code Ifsale hdr reserv no lt gt 0 accounts sale hdr acct name Iftransact invoice_no lt gt 0 resrvatn sale_hdr reserv_no items transact DCI invoices transact invoice_no operator transact Op_code specials transact special 44 csrTransGuest transact trans_no Graphic Saved Sale layouts All tables in the local Data folder are open and may be referenced but they may not be synched The following
35. C DATE DTOS DATE STOD 19881130 DTOC DATE returns the character value 05 30 87 if the date is May 30 1987 1 returns 19940731 if the date is July 31 1994 returns the character value 19870530 if the date is May 30 1987 Number character conversion functions Function Description Custom or in VFP subset CHR INTEGER_VALUE This function returns the character whose numeric ASCII VFP subset code is identical to the given integer The integer must be between 0 and 255 58 STR NUMBER LENGTH DECIMALS The string function converts a numeric value into a character value LENGTH is the number of characters in the new string including the decimal point DECIMALS is the number of decimal places desired The parameters LENGTH and DECIMALS must be constant If the number is too big for the allotted space s are returned VFP subset VAL CHAR VALUE The value function converts a character value to a numeric value VFP subset Examples CHR 65 returns A STR 5 7 4 2 returns 5 70 The number 5 7 is converted to a string of length 4 In addition there are two decimal places STR 5 7 3 2 returns The number 5 7 cannot fit into a string of length 3 if it is to have two decimal places Consequently s are filled In VAL 10 returns 10 VAL 8 7 returns 8 7 Da
36. C DATE encrypts the current date Custom SHOW lt stylel gt lt style2 gt lt style3 gt lt style4 gt lt alignment gt line size lt VFP expr gt Parses and formats the specified text for printing on a dot matrix printer Used in layouts designed for dot matrix printers only If the printer at the salespoint is a dot matrix printer this function must be used on every line of the Ticket layout SHOW sends the printer an escape sequence before printing each line of the ticket which specifies fonts font sizes and font styles The justification of a line of text right center left can also be specified stylel through lt style4 gt The font styles are available to the ticket designer when designing tickets for a dot matrix printer Availability of specific styles is dependent on the brand of the printer Can be any of the following doublewide doublehigh condensed bold italics underline pitch_10 pitch_12 pitch_15 color_1 color_2 color 3 color_4 nlq_print near letter quality print 7 signifies no style cut_code printer with auto cutter alignment can be left right center Custom 67 line size gt The number of characters on the line that is being printed lt VFP expr A VFP expression that specifies what is to be printed on the line Example lt Show bold condensed
37. DATE printers SET reset Reset doublewide Doublewide doublehigh DoubleHigh condensed Condensed bold Bold italics Italics underline Underline pitch_10 Pitch_10 pitch_12 Pitch_12 pitch_15 Pitch_15 nig_print NLQ_Print color 1 0Color 1 color 2 0Color 2 color 3 GColor 3 color 4 6Color 4 landscape Landscape cut_code Cut_Code WHERE p_name P_Name ELSE NSERT INTO printers p_name reset doublewide doublehigh condensed bold italics underline pitch_10 pitch_12 pitch_15 nlq print color 1 color 2 color 3 color 4 landscape 81 cut_code VALUES GP Name Reset Doublewide DoubleHigh Condensed Italics Underline Pitch 10 Pitch 12 Pitch 15 NLQ Print Color 1 Color 2 Color 3 Color 4 Landscape Cut_Code SELECT FROM printers WHERE p name P Name It is not necessary to understand this entire script but a couple of things are noteworthy First this script adds the printer and codes for a printer that is not currently in the Printers table However if a printer with the same P Name is listed in the Printers table this script updates the codes for it Also the series of SELECT statements in the second section needs to be filled out with the control codes for the printer As seen in this example not all fields can be filled in because not all print
38. EEN 70 PE Z functionalitY EEN el EE 72 Example si IEEE 72 Exar plots ie tosis DI 73 Excariiplets ees O 73 APPENDIX A PACKING AND UNPACKING LAYOUT seen 74 Layouts table AA E AAA 74 Working with the local layouts table from Salles ccccscccsssssscssscssccssscsesssscssesssscsccsssssscssssssssessscssssssccsessssssssssccsssssscssesssscssesssees TD What does pack up all layouts do ccssssccssssssecsscssccssscseessscsecessscssesssscscessssssessscescssssscsessssssssssscssssssccsssssscssesssscsssssscssssssscssssssces TD 2 Maintenance recommendations sssssssccccsssssssssscscccccccssssssccccccsccsssssssccccsscssssscccccccccessssssscccsccsessscsssccssccssssscscssssssscssscssssssscsssssccs 7 7 APPENDIX B HOW TO INCREASE THE HEIGHT OF A BARCODE ON A GRAPHIC LAYOUT 77 To increase the height of a barcode on a Graphic Layout c ooooocccoooccccooononcononcnnnnnnnnnnonononnnnnnnn rn nono nr ron nnne nenne enhn ren enne enne enne T APPENDIX C USING THE PRINTERS TABLE TO HANDLE CONTROL CODES FOR PRINTERS 79 Types of layouts Layouts are used to specify the format of output from Salesware passes receipts invoices etc The following table lists and describes the types of layouts available in Salesware Type of layout Description Graphic Used for passes and other output where graphic richness is more important than speed Designed using the Salesware Layout Designer Sys Manager
39. GREAT TEAM 2 Right click on the barcode and select Copy Z 4 Page Header SIRIUS SOFTWARE Page Header SIRIUS SOFTWARE nan T TEAM 1 III N lalitrim auests fi T 4 www siriusware com sirius siriusware com 800 351 0633 A Page Footer 78 5 Drag the new barcode you created to a position slightly below the original and aligning the vertical bars You can use the left and right arrows on your keyboard to achieve exact alignment Save your pass P ig Report Designer copy of pass_basic_landscape frx kadkad 0 1 2 3 4 5 ela 4 Page Header _ SIRIUS SOFTWARE Iw A alltrim guests la ES www siriusware com sirius siriusware com 800 351 0633 A Detail s 4 Page Footer Appendix C Using the Printers table to handle control codes for printers Control codes are a series of characters usually one to five that the printer recognizes as commands to perform certain functions The most common is for cutting the paper at the end of a receipt but they can also be used to change the color font or style of text being printed The control codes for printers are generally found in a programmer s or developer s manual but some manufacturers include them in the user s manual While it is possible to enter the control codes directly into a receipt or Credit Card Receipt layout it is recommended to use the Printers table and make a generic layout The Printers tabl
40. N A Single record table sh_save transact sale_no specials transact special Iftransact special not blank srcecode resrvatn srce_code Iftransact reserv_no lt gt 0 tmp_inv N A Single record table tr_save trans_no from Sales transact trans_no from Sales usercodl resrvatn user_codel Iftransact reserv_no lt gt usercod2 resrvatn user_code2 Iftransact reserv_no lt gt usercod3 resrvatn user_code3 Iftransact reserv_no lt gt utility transact sale_no wrapcode resrvatn wrap_code Iftransact reserv_no lt gt Tables synched using the pass reprint or IDCard feature Table Sync field Notes defaults N A Single record table prefs N A Single record table sales_pt N A Single record table prefs_bk N A Single record table alladres guests guest_no guests printing tmp gstno Ifnot an IDCard guests gst_pass guest_no If it is an IDCard gst_pass printing tmp_passno items printing DCI Graphic Receipts and Invoice layouts All tables in the local Data folder are open and may be referenced but they may not be synched The following tables are synched Table Sync field Notes csrResDWCards N A Single record table defaults N A Single record table prefs N A Single record table prefs_bk N A Single record table tmp_inv N
41. Sp rem Sp lim dy Sp rem dy Guest no First name Last name Phone Descriptl Descript2 Salespoint Operator Date_time Res_total Bal_due Amt_paid csrResDWCards N A Single record table with In House Cards info accomdtn resrvatn accommodat baselodg resrvatn base_lodge mktgcode resrvatn mktg_code pkup_loc resrvatn pickup_loc srcecode resrvatn srce_code usercodl resrvatn user_codel usercod2 resrvatn user_code2 usercod3 resrvatn user_code3 wrapcode resrvatn wrap_code accounts csrSaleHdr acct_name invoices csrTrans invoice_no guests csrTrans guest_no gst_pass csrTrans type20num bookinfo csrTrans type40num res_schd csrTrans type60num access csrTrans type70num meet loc csrTrans meet locat template items DCI items csrTrans DCI 47 alladres csrSaleGuest guest_no_a However csrSaleGuest is not synched Multi page Confirmation layouts Sometimes you need to get a vast quantity of text on a page but problems may occur when you get to the page breaks To mitigate this you can use fake groups In the Confirmation layout available from http portal siriusware com docs kb data multipagefakegroupdemo zip fake groups were added to break up the one or two very large text blocks Each of the chunks prints entirely on a page or is moved to the next page they are not split up
42. WLINE NEWLINE gt The following lines print daily codes on a sales receipt lt CENTER DAILYC lt CENTER DAILYC lt CENTER DAILYC lt CENTER DAILYC lt CENTER DAILYC Ticket layout functions Dail Dail Dail Dail Dail ycode date 1 40 prints dailycode ycode date 2 40 prints dailycode2 ycode date 3 40 prints dailycode3 ycode date 4 40 prints dailycode4 ycode date 40 prints dailycodel Function Description Custom or in VFP subset TICKETOTY CHAR VALUE Returns the tmp inv quantity and sets the printer to print the Custom specified quantity Used only when designing a layout for the Cognitive printer It extracts the quantity of tickets that the customer purchased on a single line item and prints that amount of identical tickets The ticket designer types the data field name tmp qt y or a number between the parentheses to let the function know how many tickets to print Example If ten tickets or vouchers are sold on a single line item in Sales ticketqty tmp qty prints ten identical tickets The following is an example of the first line of a Cognitive Ticket layout 63 0 100 1050 lt TICKETOTY tmp_aty This code prints one or more tickets or vouchers on a Cognitive printer depending on the quantity sold on a particular invoice line item 0 10
43. and Every Cognitive layout must have an END command at the conclusion of the layout END is on a separate line at the end of the Cognitive layout and must be followed by a new line character carriage return To place a new line character after END simply press the Return or Enter key on the keyboard If END is not at the end of the Cognitive layout the tickets or vouchers do not print If the END command is not followed by a new line character the tickets or vouchers print every other time Boca printer commands Boca printers use a language called FGL Friendly Ghost Language All Boca printer commands that are written for printer layouts must be enclosed in the VFP command alltrim Inthe following example allt rim contains all of the Boca printer commands lt lalltrim lt RR gt lt RC45 1075 gt lt F6 gt lt HW1 1 gt DAILYCODE ctod tmp_date gt Text rotation The Boca printer can rotate text 0 90 180 or 270 degrees The commands listed in the following table rotate the text by the degrees indicated See the previous line of code for the placement of the text rotation command lt NR gt Rotates text 0 degrees 34 Rows and columns lt RR gt Rotates text 90 degrees lt RU gt Rotates text 180 degrees lt RL gt Rotates text 270 degrees The following example indicates to the Boca printer to print on row 100 in column 50 lt RC100 50 gt Fon
44. anufacturer s web site Click Back to return to the Main dialog of the Found New Hardware Wizard Select the Install from a list or specific location radio button Click Next From the Please choose your search and installation options dialog you direct the wizard where to search for your driver In this example we downloaded the driver from the manufacturer s Internet web site to the desktop for installation from there 10 Select the Don t search I will choose the driver to install radio button Click Next 11 Select the Printers hardware type and then click Next 12 Select the Manufacturer and Printer Click Next 13 Found New Hardware Wizard Add Printer Wizard j X Select the manufacturer and model of your printer If pour printer came with an installation disk click Have Disk If your printer is not listed consult your printer documentation for a compatible printer Digital 4250 Card Printer Epson Fuji Xerox Fujitsu roc A This driver is not digitally signed Have Disk Tell me why driver signing is important lt Back Cancel Select Have Disk and Browse to the driver 24 ER Look in O fargo Q m OB E Add Printer Wizard Fe My Recent Documents Y Select the manufactun Cc disk click Have Disk compatible printer Desktop gt My Documents Install Fro My Computer A This driver q Tellme why d LTS File name 14250NT int AAA A Places Files of type
45. aphic layouts A PEZ function has the format PEZ lt Function Name gt Paraml Param2 Many of these functions arose from the need to get server data Some of the functions have become of limited use as Sales has been enhanced to gather more data locally others are still valuable They are included here for advanced users SysManager also has the PEZ PrintEZ functions compiled into the application making them available when printing passes through SysManager This functionality is used primarily to support RFID printing but all PEZ functions are available Caution should be used because some PEZ functions are designed primarily to be run only from the Sales folder Function Short name Description VERSION none Returns the version of this library For example PEZ VERSION PAYMENTSFROMRES PFR Returns all payments made on a reservation regardless of where they were made gets the data from the server For example PEZ PFR reserv no GUESTFROMTRANS GFT Returns the guest name for a transaction in First Last order Can also pass LF to get Last First For example PEZ GFT mastertran FL MAKETIMESTRING MTS Returns a formatted date or time Similar to Excel formatting so for 1 1 2005 DDDD Saturday DDD Sat DD 01 D 1 MMMM January MMM Jan MM 01 M 1 HH or H Hours NN or N Minutes SS or S Seconds AP or AMPM or ap or a
46. ation and the corresponding layouts and images are unpacked into those sub directories Note Activities gt Pack Up All Layouts also packs up the image files that are referenced in the Graphic layouts in the Siriuswarel Layouts folder If they are not referenced by a layout they are ignored Images are always reference by graphic layouts they are never copied into the layout itself If a layout references an image file that is not in the expected place in the Layout s folder you get an error message similar to the following and the packing process completes 1 problems found There are 1 references to missing image files in 1 layout files Layout WIN EYDYCHNPHYP SIRIUSFS LAYOUTS CONFIRMS CONFIRMATION_LETTER FRX Image siriuswarelogo bmp Please correct the layouts and pack again Note Activities gt Pack Up All Layouts ignores any FoxPro labels files Lot 15x These are used from SysManager and ReportManager for creating mailing labels so are not needed at the salespoints Layouts are never edited directly on the salespoint because they are simply overwritten the next time the layout s table in unpacked The following subdirectories are in the Siriuswarel Layouts folder Confirms Graphic Lessons Mailing Labels Print at Home Passes Retail Receipts Rentals Tickets Vouchers 76 If you use INT settings to reference layouts such as receipt then these layouts are ignored in the packing and
47. case Sales writes a record to the Printing table previous to printing and the layout fetches most of the data it uses from this record For descriptions of most of the tables and fields available for use see the SiriusSQL Data Dictionary available from accesso Siriusware Technical Support Note In the following table the A11Adres AllTrans BookInfo Cc Trans Printing and Utility tables are local tables only so are not described in the SirtusSQL Data Dictionary Local table available to Text Field used by Sales to sync to Merge and Shared Text Merge row available to layout layouts Accounts acct_name AllAdres guest_no AllTrans sale_no BookInfo sale_no Cc_Trans sale_no Invoices invoice_no Operator op_code Printers p_name Printing sale_no Resrvatn reserv_no Sale_hdr sale_no sh_info sale_no Sh_save sale_no Shs_info sale_no Tr_info sale_no Also see the DETAILS and ITERATE_OVER functions for other tables that become available when using those custom functions 40 Tables and fields available from Graphic layouts For Graphic layouts the tables available for printing are dependent on the type of printing being done This Trs_info sale Utility sale document covers Graphic layouts that are processed by PrintEZ application e Tickets and vouchers Receipts and invoi
48. ce and select it If the device is connected directly to the computer salespoint select the port to which it is connected However the majority of printer installs for Salesware are done by plugging in the hardware and then installing the generic driver using the Found New Hardware Wizard that automatically pops up The exception to this is setting up the CASHDRAWER printer which is used only to pop the cash drawer the CASHDRA WER printer is a virtual printer with no detectable hardware The CASHDRA WER printer can be connected to a receipt printer or directly to the salespoint For more information on the configuration options for the CASHDRAWER printer see the documentation for the ports INT file in the Salesware INI Settings Reference document and the Sales gt Tools gt Sales Pt Setup gt Cashdrawers button If you are using drivers from the manufacturer be sure to consult your owner s manual because many printers require a very specific order of installation to get the printer to work at all For example many USB printers require running the install disk with the cord unplugged you are prompted to plug in the cord at a specific time during the install or the install fails The printer name is important accesso requests that when printers are installed they are name appropriately for their functions Example When installing a ticket printer rename it to TICKET when installing a receipt printer name it RECEIPT pa
49. ces e Saved sales e Z tapes e Tee sheets e Confirmation letters In every type of printing PrintEZ application first opens up every dbf file in the Sales local Thus all tables in the folder can be referenced However not all of these tables are synched to the data you are printing In some cases the un synched tables have their record pointers set to the first record in the table sometimes to an empty record The following sections comprehensively reveal the synch status of each table and how it is linked to what you are printing Graphic Ticket and Voucher layouts All tables in the local Data folder are open and may be referenced but they may not be synched Ticket and Data folder Voucher layouts use a table named csrTrans to print from This table is created for each print job and is left on disk after the print job is complete It is created in the Sales V Data folder You can close Sales and investigate the contents of this file using Helper utility Tickets and vouchers are printed from Sales by passing the transaction number The following tables are synched Tables synched during normal printing not using the pass reprint or IDCard feature Table Sync field Notes access printing tmp passno Iftmp passno lt gt 0 and it s an access product accomdtn resrvatn accommodat Iftransact reserv_no lt gt 0 accounts sale_hdr acct_name Iftransact invoice_no lt
50. cs Spin Generic 5 Generic IBM Graphics Spin wide Gestetner if MS Publisher Color Printer si up EY uc D bebes Ie eser Have Disk Tell me why driver signing is important lt Back Cancel 6 The wizard installs the driver and the Generic Text Only printer appears on the Start gt Printers and Faxes dialog Alternatively you can use the Add Printer wizard to install a printer and driver as shown in the following example Example of installing a receipt printer Star TSP with a Receipt layout 1 From SysManager gt Preferences gt Miscellaneous gt Receipt Layout check that the Short scroll box contains a valid layout 2 You do not need to associate the Receipt layout with the application because this association is already hard coded into Sales for a listing of layouts and the applications with which they are associated see the table in Specific layout applications 3 Connect the Star TSP receipt printer to the salespoint This is usually done using a serial USB or COM port 4 Launch the Start gt Printers and Faxes gt Add Printer wizard 26 Select Local printer attached to this computer Click Next Select the port probably COM1 Click Next Select Generic from the Manufacturer dropdown Click Next Retain the Generic Text Only name under Printer name Click Next 9 Finish the wizard selecting configuration options as appropriate for your environment 10 Go to the Sales gt Tools
51. d Passes document for information on how to make a pass using a Graphic layout Text Merge layouts The following are the pros and cons of Text Merge layouts Fast Flexible Receipts can be different for each salespoint Require custom coding of printer commands Not graphically rich Text Merge layouts and Shared Text Merge layouts are the most common forms of layouts Text Merge layouts are widely used for receipts tickets and vouchers Text Merge layouts can be output to a wide variety of specialized printers Most commonly Ticket and Voucher layouts are used with Cognitive known for many years as Barcode Blaster and Boca printers see Printer commands for more information on creating layouts for Cognitive and Boca printers Star or Epson model printers are used for saved sale remote and receipt printing They are created as txt files using a text editor and then are copied into a large text field in SysManager where the text is used by the printing application The t xt file doesn t need to be retained after the text has been pasted into the text field For Voucher and Ticket layouts the layout is stored along with the item in the DCI that is to be printed If retained Text Merge layouts are stored in Siriusware Layouts For more information on how layouts are stored see Appendix A Packing and unpacking layouts Shared Text Merge layouts The following are the pros and cons of Shared Text Merge layouts Fast
52. device from the Dot Matrix Printer dropdown as described previously If your particular device is not listed under the Dot Matrix Printer dropdown you can experiment to see whether any similar devices that are listed work or you can add the new device You can also simply select GENERIC from the Dot Matrix Printer dropdown instead GENERIC is simply an entry with no codes at all See Appendix C Using the Printers table to handle control codes for receipt printers for more information 21 Note The label Dot Matrix Printer is retained from older versions of Salesware Other types of printers are now supported by the Printers table as well Note When utilizing Kiosks it is by design that tendrretail d11 require a printer to be set whether named None or HP LaserJet 1020 as in the previous example Even is no Credit Card receipt is to be printed the printer must still be set to None If the printer line is left blank the following error message occurs Printer Error and the transaction may be cancelled How to install a printer and driver To install a printer simply connect it to the network or attach it directly to a salespoint using a serial or parallel port depending on the interface s available for the printer To install a driver go to Start gt Printers and Faxes Click the Add Printer wizard Select whether the device is connected locally or over a network If it is connected over a network navigate to the devi
53. e is selected the user is able to browse and open any Text layout to test after checking the appropriate box Saved Sale Ticket or Credit Card The default directory is the local Layouts folder 4 The user can paste any Text layout onto the left pane of the Layout Test Dialog check the appropriate box Saved Sale Ticket or Credit Card and click Evaluate to test it Changes can be made to the layout and the user can keep evaluating it until satisfied 5 This dialog is designed for testing purposes only The user must copy the final corrected layout to another text editor such as Notepad and save it as a new layout You cannot save from this pane Diagnostic tool AnalyzeFRX The diagnostic tool AnalyzeFRX was added If set to YES in the INT file it looks at all the expressions in a layout and evaluate them prior to printing to help isolate where the problems might be with a layout Any errors encountered are logged along with the expression The current default is NO but consideration for making it YES is under way PrintEZ application now puts all errors received during a print job onto the clipboard for pasting into an email Now remembering what was said on the gray error boxes is not critical The text in the gray error message boxes is not truncated at 254 characters to prevent errors The Clipboard version of the error is not truncated Layout functions and commands Graphic layouts are designed using the Saleswar
54. e Layout Designer Text Merge layouts and Shared Text Merge layouts are created using a text editor In all cases layout functions and commands are used when creating the layout When designing a Graphic layout the person creating the layout provides the functions that are executed at runtime to perform operations such as populating the layout with data In some cases the person creating the layout starts with a Graphic layout that already exists so these functions may have already been added to the layout See the Salesware Memberships and Passes document for a tutorial showing how to create a Graphic layout for a pass When creating a Text Merge layout or a Shared Text Merge layout the person creating the layout almost always starts with a layout provided by accesso and modifies the layout according to the specific requirements of the application Many of the functions and commands used are already included in the layout provided See Printer commands for a description of how to code some of the more common commands used in Text Merge and Shared Text Merge layouts Layouts are output to a variety of printers Graphic layouts are output using standard Windows drivers provided by the manufacturer of the printer Text Merge layouts and Shared Text Merge layouts are printed using a generic text only Windows driver and output commands that are specific to the device and that must be coded by the person creating the layout In addition even when u
55. e accesso SIRIUSWARE Salesware Layouts Version 4 4 accesso 302 Camino de la Placita Taos NM 87571 575 751 0633 www accesso com Copyright Copyright 2015 accesso Technology Group plc All rights reserved NOTICE All information contained herein is the property of accesso Technology Group plc No part of this publication whether in hardcopy or electronic form may be reproduced or transmitted in any form or by any means electronic mechanical photocopying recording or otherwise without the prior written consent of accesso Technology Group plc The software which includes information contained in any databases described in this document is furnished under a license agreement and may be used or copied only in accordance with the terms of that agreement This publication and the information herein is furnished AS IS is subject to change without notice and should not be construed as a commitment by accesso Technology Group plc accesso Technology Group plc assumes no responsibility or liability for any errors or inaccuracies makes no warranty of any kind express implied or statutory with respect to this publication and expressly disclaims any and all warranties of merchantability fitness for particular purposes and non infringement of third party rights Graphic TAY rr CG KN TEE Shared Text Merge layOutsss s0ssoccssansessedaasocescnnsecascassocnodoapeaseseasensasesbensasessnsonsesdnsascesensasdssanessessnas
56. e allows the use of different brands and models of printers that share the layout The Printers table also makes it simpler in the future if the printer for a salespoint is changed to a different brand or model The first step is to verify or add the printer s control codes to the Printers table Many printers control codes already exist in the Printers table You can see all ofthe printers already in the Printers table from the Sales gt Tools gt Sales Pt Setup gt Printing gt Dot Matrix Printer dropdown Note The label Dot Matrix Printer is retained from older versions of Salesware Other types of printers are now supported by the Printers table as well If you need to add a printer you can use SQL Server Management Studio While this document shows entering the codes in the decimal format of their ASCII American Standard Code for Information Interchange value they are displayed in Management Studio and Helper utility as the actual characters see the ASCII character codes charts at the end of this appendix Some of these are not displayable so they show up as a square while others display as normal characters Here is an example of what may be displayed DI 79 To find out what the characters are that aren t displayed they can be copied from Management Studio or Helper utility and pasted into TextPad www textpad com This application shows the decimal format of the ASCII character for example Display this by m
57. e the detail as in the Group Header If you are printing totals in the Group Footer then this isn t very useful PARSE PARSE Parses an XML value from an XML string Useful if you want to use something like items help info to store large text blocks to use on layout Example PEZ PARSE XMLTAG items help_info So for the example above ifthe items help_info field had lt XMLTAG gt This is the stuff I want printed on the layout lt XMLTAG gt lt SOMEOTHERTAG gt blah blah 22 blah blah lt SOMEOTHERTAG gt and then the returned value would be This is the stuff I want printed on the layout LINEINFO El Gets information from the server and allows you to limit the information returned with the last parameter Include any or all of the letters G returns the guest name V returns the lesson level T returns the lesson start time L returns the meeting location I returns the Instructor ID and notations if it is a request N returns the Instructor NAME and notations if it is a request For example PEZ LI trans no GTLI GETRF IDTAGCODE GRTC Returns the codes necessary to program the Tag value of an RFID chip using the ZBRUHFReader dll Ensure the field width is wide enough or the code does not successfully encode the RFID tag Make the font tiny if necessary Example PEZ GetRFIDTagCode PXX trans
58. eneral it has more better options details is often 2433 preferred for listing the transactions because it sync s many of the other tables guests gst pass i items etc lt iterate over transact Sale no Sale hdr gt Sale no STR admissions quantity 3 0 IIF transact Item TRANS Account Transaction Items gt descrip STR quantity 3 0 NEWLINE Transact gt Special STR Transact gt Disc amt 6 2 STR transact gt init price 9 2 STR transact gt extension 10 2 NEWLINE gt The following line is typically one of the first lines on a receipt lt CENTER Sale Number ALLTRIM STR utility gt sale_no 16 0 40 gt The following line is typically one of the last lines on a receipt lt JUSTRIGHT SUB TOTAL STR Utility gt sale sub 10 2 40 gt FOP If Visa and cash were used to pay for the sale VISA CASH are displayed 62 lt CENTER DSTR2 Utility gt Date_time 40 gt This is a common details line for a remote printer kitchen receipt printer that prints all items on the receipt not just those added during the last recall lt Details IIF MODIFIER alltrim printers gt color_1 alltrim printers gt color_2 ATTN Items gt Descrip STR quantity 3 0 IIF Item TRANS Account Transaction Items gt descrip NE
59. ers support all of the functions available When necessary to leave a field blank use two single quotes as shown in the example When filling in a control code the char function is used so that characters that cannot be typed can be entered Also note that the control characters are listed in decimal format Most codes are supplied in the manual as the code and hexadecimal and sometimes decimal Using the manual fill out the codes for all available options Here is an example of how the manual shows a code CTE Select emphasized printing CODE ESC gt E HEX 1B 45 REMARKS Causes subsequent characters to be emphasized This is the information on selecting emphasized bold printing for the Star TSP600 printers In order to add this entry to the script it is necessary to convert the hexadecimal HEX number to decimal This can be done with the ASCII charts at the end of this document Using these charts 1B becomes 27 and 45 becomes 69 These are then added to the script as 82 SELECT Bold CHAR 27 CHAR 69 Some printer functions have variables that give an option for that function For example FUNCTION Cut command to the auto cutter CODE ESC HEX 1B REMARKS n 0 Whith functions like this it is necessary to choose what option is to be used and then add that to the script For example if it is desired to have the paper partially cut without feeding paper first this code would be used 1B 64 01
60. ese fonts are installed as part of the Common Files installation see the Salesware Installation Guide for more information Therefore when designing tickets that contain a barcode you must print the barcode using either the Code39 or Code128 barcode font The 128 barcode font encrypts the data thereby reducing the size of the printed barcode and making the barcode more readable for larger numbers The following line of code prints a Code39 barcode rotated 90 degrees on a Cognitive BR code39 2 6 705 640 100 lt if empty tmp_edate AXX A encrypt date tmp edate encrypt_number tmp access alltrim gt The following code prints a Code39 barcode with no rotation on a Cognitive B Code39 2 6 235 400 95 33 lt lt if empty tmp_edate AXX A encrypt_date tmp_edate tencrypt_number tm p_access alltrim gt The following line of code prints a non rotated Code128 barcode on a Cognitive B code128 2 4 350 500 70 if empty tmp_edate AXX A encrypt date tmp edate encrypt_number tmp access alltrim gt Because the above barcode commands do not print subtext 1t is necessary to print the following subtext line to indicate what characters are contained in the barcode U B25 2 1 90 675 750 lt A alltrim str tmp access 20 0 gt Note The 90 inthe 2 1 90 is signifying 90 degrees of rotation For the non rotation barcodes this value must be set to 0 The END comm
61. f the month Example CMONTH DATE returns April if the current month is 04 Custom 64 CDOW DATE_VALUE Extracts the day of week from the date passed in and returns the day Custom of week as a literal string Example CDOW DATE returns Sunday if the current day of the week is 1 EMPTY DATABASE_FIELD Tests an argument depending on the type for true or false Custom zero or non_zero blank or non_blank and returns a 1 if empty and 0 if not empty This function can be used only with the if function or the iif VFP function DAILYCODE DATE_VALUE Returns the daily code from the dailycode database using the Custom date that was entered as the parameter Example DAILYCODE CTOD TMP_DATE returns the daily code for the date that the ticket or voucher was sold Because TMP_DATE is a character date field it must be converted into a date value using the CTOD VFP function DATLYCODE DATE returns the daily code for the current date IF LOGICAL_VALUE Tests argument 1 for true or false returns argument 2 if true or Custom TRUE_RESULT FALSE_RESULT argument 3 if false When using this function the ticket designer uses a data field or logical expression to be tested for the first parameter The second and third parameters of this function can contain lega
62. form gst_pass pass_no PEZ GRTC gst_pass pass_no For more information see the Salesware Access Control document FORMATMODIFIERS FM Returns a formatted string of modifier data based on the passed template The template can be any text and uses the form F FieldName to reference any of the following fields init_price trans_no disc_amt tax_amount tax_amt2 extension Message quantity Special time_span date_time start_date expires adm_end end_date ret_date and all fields in the Items table Example PEZ FM lt Format Template gt PEZ FM F Descrip at F extension GETROOTVALUE GRV Returns the result of the passed expression from the root item main item of a modifier PEZ GRV items descrip 73 Returns the item description of the main item Any valid FoxPro expression can be used For instance PEZ GRV STREXTRACT items help info div class desceng gt chr 13 chr 10 lt div gt 1 1 GETUSERCODE GUCI Returns the trimmed descrip value of the passed key in user code GETUSERCODE2 GUC tables for Reservations module GETUSERCODE3 PEZ GetUserCode3 Resrvatn user code3 GUC3 PEZ GetUserCodel Resrvatn user codel Appendix A Packing and unpacking layouts There are three types of layouts Text Merge Shared Text Merge and Graphic Text Merge layouts when added to an item in SysManager are stored with the item itself you act
63. gt Activities gt Edit Layouts PrintEZ application is used invoked to print Graphic layouts Text Merge Used for output that needs to print fast and often from specialized output devices Designed using a text editor Unlike Graphic and Shared Text Merge layouts Text Merge layouts are stored along with the item For more information on how layouts are stored see Appendix A Packing and unpacking layouts Shared Text Merge Same as Text Merge except that a Shared Text Merge layout can be shared by multiple items Designed using a text editor Used only for Ticket and Voucher layouts Receipt layouts are either short or long Short layouts print to a forty column printer Long layouts print to standard 8 5 x 11 paper Ticket and Voucher layouts can be whatever size you want based on ticket and voucher stock and your printer The following sections describe the pros and cons of each type of layout and how each is created and used in SysManager Graphic layouts The following are the pros and cons of Graphic layouts Much slower than raw text Can have graphic images e g logos photos etc Easy to create use the Salesware Layout Designer Cannot be printed to many types of specialized printers Graphic layouts are created using the Salesware Layout Designer Sys Manager gt Activities gt Edit Layouts or SysManager gt Activities gt Create New Layouts See the Salesware Memberships and Passes docu
64. he receipt is cut at the end Note Character O the first character in the ASCII chart is the NULL character This character has a decimal form of 0 Some printers do use this character in the control codes for some functions Unfortunately this character does not pass through from Sales to the printer With some functions this can be corrected by using the actual 0 character with decimal value of 48 For other functions it may be possible to use the ASCII character with decimal value of 1 SOH or another character instead of 0 85 ASCII Character Codes Chart 1 o D o A e LL 4 he kd DNS E 8 we 4 E o E 9 F Ji dk k 4 1 SS EA AER ERES ESE RE are et Pt de ae PS AY MA W d D MA GA HM ta Ss ASCI code 127 has the code DEL Under MS DOS this codehas the same etted as ASCI 8 ES The DEL code can be generated by the CT RL BESPhkey tree NE KX ECR AHH SPOS Fe woe AAA os b 86 ASCII Character Codes Chart 2 uw VOR ears d 7oC EAS D gussupBEEgEgEgEHEEETEUE SRL ANK NMS MRS KB SKIi Z S MADA FE gEEHEPEESSVUVEHUEUQROBSOPOGOUGODOBSODS ELE Eh T el g Hl SI Is e es ke 331733233 3 u a S E e e e i x 1 n A 5 2 A 6 o 6 A u H 0 ij f Y R W NZA 87
65. here are more than 1050 rows the Cognitive skips to the next ticket to attempt to print that row If the ticket stock is physically shorter than 1050 rows the Cognitive may skip to the next label The next parameter 1 indicates how many tickets are printed In this case only one ticket is printed This entry could also contain an expression for example TICKETOTY tmp_qty gt Which prints one or more tickets or vouchers depending on the quantity sold on a particular invoice line item TICKETOTY isa custom function written specifically for this purpose 30 Text justification for Cognitive layouts e To print centered text type JUST centered e To print left justified text type JU left justified IFY CENTER on the line preceding the line that contains the text to be STIFY LEFT on the line preceding the line that contains the text to be e To print right justified text type JUSTIFY RIGHT on the line preceding the line that contains the text to be right justified Font styles and sizes UltraFonts Most ticket designers use UltraFonts to design their Cognitive layouts for Sales An example of an UltraFont code 1S U A20 This code is described in the following table Parameter Specifies Options Syntax U Ultrafonts A Font style A rounded corners Must be uppercase B angled corners C bolded horizontal strokes 20 Font size 1 to 65535 No spaces between the fon
66. ht italicized bold and left justified Note that some parameters are not defined empty single quotes are used as placeholders so that show receives the parameters it is looking for in the correct places The lt and gt are required A blank line is generated by including an empty show show t a 40 The following line prints the operator s name in regular type on a twenty character ticket lt show centered 20 alltrim tmp_oper gt The following line prints the literal string Big Fish show bold centered 40 Big Fish gt More than one table field or literal string can be printed on one line Add the text together with the plus sign making sure all fields have been converted to character fields The following prints the location and price right justified with titles in condensed type on a forty character ticket lt show condensed right 40 alltrim str extension quantity 9 2 alltrim tmp_loc gt 38 Sample ticket Printer layouts In the following sample Text Merge layouts for tickets notice that all VFP and Salesware functions are delimited by lt and gt Cognitive printer Ticket layout 0 100 1050 lt TICKETOTY tmp qty JUSTIFY CENTER U C25 4 5 0 500 10 lt DAILYCODE ctod tmp date U C80 vs 5 0 500 75 lt upper substr CMONTH ctod tmp date 1 3 alltrim str day ctod tmp_date 3 0
67. indexing is required In Sales you can also unpack the layouts in the layouts table from Tools gt Action gt Unpack Layouts This action tells PrintEZ application to unpack the layouts in the local layouts table and is used if for example you accidentally deleted a file or one gets corrupted if using this action button doesn t work there might be a problem with PrintEZ application Important Use caution when unpacking layouts in Sales If you have never used this utility in the past please contact accesso Siriusware Technical Support for additional information What does pack up all layouts do Because the layouts table does not maintain itself it must be manually cleaned When you use SysManager gt Activities gt Pack Up All Layouts the first result is that you erase the entire contents of the Layouts table 75 SysManager then prompts you to select the Layouts folder and after you select the Layouts folder it then reads and writes the entire contents of the Layouts folder to the Layouts table At this point you have a layouts table that contains only entries from what is in the Layouts folder at that moment Layouts and images that are stored in sub directories in the Layouts folder are also packed along with a description of the exact path if the path doesn t exist in the Layouts folder on the salespoint the appropriate sub directories are automatically created when the Layouts table is unpacked by PrintEZ applic
68. ing that can be typed on the keyboard Memo A character field with no size limit limited by available memory Integer Number with no decimal places can be positive or negative numbers from 2147483647 to 2147483647 can be stored in 4 bytes 48 Currency Numbers that represent money are normally displayed with two decimal places but store as four decimal places for calculation can be positive or negative Logical Can be true or false stored in 1 byte Numeric A numeric value either integer or decimal Double A double precision floating point number The table below contains many of the most common fields used by Text Ticket layouts Field name Field description Field type and size Tmp_aAddr Address for account Character 25 Tmp_aArea Area code for account Character 5 Tmp_access Access number Double 8 Tmp_aChk1 Account user def check box 1 Logical 1 Tmp_aChk2 Account user def check box 2 Logical 1 Tmp_aChk3 Account user def check box 3 Logical 1 Tmp_aChk4 Account user def check box 4 Logical 1 Tmp_aChk5 Account user def check box 5 Logical 1 Tmp aCity Account city Character 15 Tmp aCont Account contact Character 25 Tmp_aDatel Account user defined date 1 Character 10 Tmp_addr Primary guest address 1 Character 25 Tmp_addr2 Primary guest address 2 Memo 4
69. inted using the Cognitive printer the Boca printer several laser jet printers and several dot matrix printers Each of these printers recognizes different printer commands and some do not require commands at all For specific information about the commands supported by your output device see Printer commands and the manufacturer s documentation Salesware specific Visual FoxPro VFP functions for Graphic layouts Salesware uses a subset of Microsoft s Visual FoxPro functions See Function reference for information about these functions Custom Salesware layout functions Custom Salesware layout functions are provided with the Salesware product See Function reference for information about these functions Supported specialized printers In addition to a wide range of standard printers that run under manufacturer supplied Windows drivers Salesware supports a variety of specialized printers For a complete listing of hardware supported by accesso see the Hardware Compatibility List document Reference Sample layouts provided with Salesware accesso maintains a set of layouts for client use These are available for download from the accesso Siriusware Information Portal Downloads menu gt Layouts The following table lists some of the layouts you can find here Layout description Type of layout Account invoices Text Cognitive tickets Text 28 Boca tickets Text Credit
70. iption on a pass alltrim items descrip 54 Printed pass number Prints P alltrim str gst_pass pass_no 16 0 the pass number on a pass Printed guest number G alltrim str gst_pass guest_no Prints the guest number on a pass Swipe number Printed alltrim gst_pass swipe_no swipe number often used in In House Cards programs Barcode with pass number BC_CODE128 PXX dec2baseXX gst_pass pass_n Standard barcode font 9 BC C128 Narrow Size 28 1s used in a lot of the samples Mag swipe track 1 encoding 19AP alltrim str gst pass pass no 16 0 designed to auto sell an item with a pass number swipe Mag swipe track 1 encoding 1 EP alltrim str gst_pass pass_no 16 0 designed to discount items in a sale with a pass number swipe Mag swipe track 1 encoding 1B alltrim gst_pass swipe_no 2 designed for In House Cards item use Mag swipe in track 2 2 talltrim str gst_pass pass_no 16 0 on encoding of a pass number only numbers are allowed in track 2 Function reference A function can be used as an expression or as part of an expression in a layout Functions return values like operators constants and fields Functions always have a function name and are followed by a left and right bracket Values parameters may be inside the brackets Note This function reference primari
71. irst name Character 10 Tmp_slast Saved sale last name Character 15 Tmp_spcd Special description Character 25 Tmp_spct Special name Character 25 Tmp_state Primary guest state Character 2 Tmp_swipe Swipe number Character 22 Tmp tlgprn Ticket 1 assigned graphics printer Character 32 Tmp_tllay Ticket 1 assigned layout Memo 4 Tmp_tiprt Ticket 1 assigned dot matrix printer Character 30 Tmp_tlaty Ticket 1 quantity for ignore qty Integer 4 Tmp tlwprn Ticket 1 Windows printer Character 100 Tmp_t2gprn Ticket 2 assigned graphics printer Character 32 Tmp t2lay Ticket 2 assigned layout Memo 4 Tmp_t2prt Ticket 2 assigned dot matrix printer Character 20 Tmp_t2qEy Ticket 2 quantity for ignore qty Integer 4 Tmp_t2wprn Ticket 2 Windows printer Character 100 Tmp_tax Tax amount Numeric 12 Tmp_taxa TaxA amount Numeric 12 Tmp_taxb TaxB amount Numeric 12 Tmp_telvl Telemark level Character 1 Tmp_time Time item was sold Character 5 Tmp_totqty Total quantity sold of the line item Numeric 4 Tmp_tranno Transact number Double 8 Tmp_tspan Number of days an item is good Integer 4 Tmp_tuses Pass number of total uses left Integer 4 53 Tmp vllay Voucher 1 assigned layout Memo 4 Tmp_vlprt Voucher 1 dot matrix printer Cha
72. l VFP functions expressions other Salesware custom functions or a combination of legal VFP functions expressions and Salesware custom functions Examples if tmp_spct EMPLOYEE Employee Discount if tmp_extx gt 100 00 Free T Shirt Di ADD TIME lt expC1 gt Returns the time in the form of a character string that has been Custom SE altered by having hours or minutes added or subtracted and the time E Ex 3 rounded and limited according to minimums and maximums for lt expN4 gt each day of the week The time is returned in twelve hour clock lt expC2 gt form only This function accepts up to nineteen parameters lt expC3 gt lt expC4 gt SE Note This function was designed to accommodate time based lt expC7 gt tickets Ifan area allows a customer to buy a two or four hour lt expC8 gt 65 lt expC9 gt lt expC10 gt lt expCll gt lt expC12 gt lt expC13 gt expCl4 lt expC15 gt ticket this function allows the ticket designer to specify the hours of business provide for time in line putting on skis etc Example ADD TIME TMP TIME 2 15 5 0 23 00 23 00 23 00 239004 23 00 26 00 26 00 09 00 09 00 09 00 09 00 09 00 08 00 08500 Assuming today is Friday and the current time is 07 00 10 00 am is returned Assuming today is Friday and a current time is 10 06 12 15 pm is returned Assuming today is Friday and the current time is 24 30 02
73. layOUtS lt siccsscciesssessvvasssoccesstcovssassconsaessenvessascoesssesenssscesenessecsonessecsobissoctensscoevsasseocoanssceucansdsensapsssacconesoactedesenescossess O Common fields on Graphic Pass layouts sscccssessscsssssoccsssssccssscsccsssssscsssscsesssscssesssccssessscssesssscssssssccsssssscssssssscsssssscsssssssssssssssees D Function referencg TETTE H eene DD Character functions DAA e tust fl t fo on iau i ts fun t i tst bet e a dee rt Agen 59 Example t ox E be rasa bubus ebessi eb brc eessen a kee 59 Receipt layout IICA sedes Ee ie e iiie eser sides tese Dit iSt de ads 60 Example sp 63 Example nece eie der de i Ra RAS 64 A m O 64 Examples eS EPIO E GI URGERE RIBUS 64 Excatn de U 65 Ex mple 4 eSI E RAT GI D URGERE ERIS 65 A c E MR 65 Examples aan ERA EELER EE nn 66 Example e E a a a ao E a 66 Example i EB DRERIBSHRETB RE Ee D CY D eden ae ae eas Gee 66 Example irap onn nenne onem eon DNI 67 Example ui REB cei es eda S ae ea Um e noe 68 Example Ga oS as Pe ee ee eel ee a N 69 Axess Smart Printer l vout functions oerte c gen us ins a i a ai tes oi si EE ie deg 70 Axess Smart Printer encoding een Inis e Dee eege E ee
74. ly covers functions used with Text Merge layouts and Shared Text Merge layouts In the Salesware Layout Designer you can also find additional commonly used string math logical and date functions available from the Expression Builder dialog Many of these are used only with Graphic layouts 55 Character functions result is returned Function Description Custom or in VFP subset ALLTRIM CHAR_VALUE This function trims all of the blanks from both the VFP subset beginning and the end of the expression This command accepts only alphanumeric data LTRIM CHAR VALUE This function trims any blanks from the beginning ofthe VFP subset expression This command accepts only alphanumeric data TRIM CHAR VALUE This function trims any blanks off the end of the VFP subset expression This command accepts only alphanumeric data LEFT CHAR_VALUE This function returns a specified number of characters VFP subset Nee from a character expression beginning at the first character on the left The parameter NUM_CHARS must be constant See also SUBSTR RIGHT CHAR_VALUE This function returns a specified number of characters VFP subset EE from the end of a character expression The parameter NUM_CHARS must be constant SUBSTR CHAR VALUE A substring of the character value is returned The VFP subset STARI EPOSTELON NUM CHARS substring is NUM_CHARS long and starts a
75. ly in the DETAILS function Typically used for kitchen printing 61 Used for Z Tape Reports in conjunction with Custom TOTAL DISCOUNT PRICE EXTEN TTERATE_OVER Sums the specified quantity for SION ae DISCOUNT PRICE or EXTENSION fields for all of the records in the ITERATE_OVER statement preceding the TOTALS call Examples The following line is a fairly common details line for basic sales receipts lt Details STR admissions quantity 3 0 IIF transact gt Item TRANS Account Transaction Items gt descrip STR quantity 3 0 NEWLINE Transact gt Special STR Transact gt Disc amt 6 2 STR transact gt init price 9 2 FSTR transact gt extension 10 2 NEWLINE gt The following line is a common details line for remote receipts kitchen printing for new items items ordered after the initial order added to the tab check table sale lt Details IIF MODIFIER alltrim printers gt color_2 ATTN Items gt Descrip alltrim printers gt color_1 STR quantity 3 0 IIF Item TRANS Account Transaction Items gt descrip NEWLINE NEWLINE RUE gt The following is a common iterate_over line for a basic sales receipt accesso is moving towards using details more than iterate_over because in g
76. ment for a tutorial showing how to create a pass using a Graphic layout A Graphic layout is created saved and used as sets of files as described in the following table Graphic layout filename extension Description FRX Equivalent to a dbf file Seen when navigating from Salesware Layout Designer Holds graphic data ERT Equivalent to a xp file Graphic layouts for receipts invoices Z Tape Reports and saved sales must be named according to the conventions specified in the following table Also they must be saved in the Siriusware Layouts Graphic Layouts directory Graphic layouts without required names do not need to be saved in this directory Layout type Required filenames 40 column receipt RECEIPT40 FRX RECEIPT40 FRT 8 5 x 11 receipt RECEIPT80 FRX RECEIPT80 FRT 40 column invoice NVOICE40 FRX INVOICE40 FRT 8 5 x 11 invoice NVOICE80 FRX INVOICE80 FRT 40 column Z Tape Report ZTAPE40 FRX ZTAPE40 FRT 40 column saved sale SAVEDSALE40 FRX SAVEDSALE40 FRT 8 5 x 11 saved sale SAVEDSALE80 FRX SAVEDSALE80 FRT Confirmation layouts are Graphic layouts used with the Salesware Reservations module that are saved in a special directory Siriusware Layouts CONF RMS This is done for ease of selection by the Sales operator See the Salesware Memberships an
77. mp_bloc Lesson location Character 10 Tmp_blvl Booking level Character 1 Tmp_bnum Booking ID Double 8 Tmp_bsdt Booking start date Character 10 Tmp_bstm Booking start time Character 8 Tmp_cat Category nickname Character 10 Tmp_city Primary guest city Character 15 Tmp_copp Access number and expiration date Character 12 Tmp_cprsn Comp person Character 15 Tmp_crsn Comp reason Character 15 Tmp_date Item start date Character 10 Tmp_dept Department nickname Character 10 Tmp_disc Discount amount Numeric 12 50 Tmp dusesl Pass number of uses left today Integer 4 Tmp edate Item end or expiration date Character 10 Tmp ext Item price tax fees Numeric 12 Tmp fee Fee amount Numeric 12 Tmp fname Primary guest first name Character 10 Tmp formno Rental Contract Number Numeric 12 Tmp glno Item GL number Character 12 Tmp gNotes Primary guest notes Memo 4 Tmp_group Primary guest group Character 10 Tmp_gstno Primary guest number Double 8 Tmp_idesc Item description Character 25 Tmp_invno Invoice number Double 8 Tmp_item Item nickname Character 10 Tmp lname Primary guest last name Character 15 Tmp_loc Location or salespoint name Character 6 Tmp modl Modifier
78. mpm provides time suffixes For example PEZ MTS MMMM D YYYY date French and Spanish names for months and days can be returned by adding FR or GSP into the format string MAKEDATESTRING MDS Same as MAKETIMESTRING MODROLLUP MRU Returns a string of all the modifier descriptions and or prices You can specify a pattern and a delimiter Default pattern is DESCRIP and default delimiter is DESCRIP and 71 EXTENSION are replaced in the patter with the actual item values PEZ MRU Pattern lt Delimiter gt Note This function only works on Confirmation Letter layouts It does not work on regular Graphic Tickets and Vouchers Example product Rental package with a helmet and insurance modifiers Sample call PEZ MRU returns Helmet Insurance Yes PEZ MRU DESCRIP EXTENSION returns Helmet 5 00 Insurance Yes 1 00 There is also a GRANDTOTALS option to the ModRo11Up function It returns XML values for all the totals Tax1 Totals Tax2Totals FeeTotals DiscountTotal and ExtensionTotal You can access these values by using the PARSE function along with this new one like this Sample Call VAL PEZ PARSE EXTENSIONTOTAL PEZ MRU GRANDTOTALS This gives you the grand total for the main item with all of the modifiers This is useful for printing totals befor
79. ng Columns and rows The following syntax demonstrates the use of columns and rows U A20 2 4 0 100 10 According to this line of code the Cognitive prints text in the hundredth column on the tenth row Pay special attention to the rotation entry when specifying the column and row If a line is specified to rotate 180 degrees or 2670 degrees the columns and rows start from high to low 900 to 0 and 1050 to 0 Ifa line is specified to rotate 0 degrees or 90 degrees the columns and rows start from low to high 0 to 900 and 0 to 1050 U B40 2 4 180 800 1000 Using the preceding code the Cognitive prints text at 180 degrees upside down starting in the 800th column on the 1000th row This example is useful when the ticket stock comes out ofthe Cognitive bottom first Printing text To print text using Cognitive commands type the font style font size boldness character spacing rotation column row a space the beginning delimiter the VFP expression s custom function s field s and or literal string s followed by an ending delimiter as in the example below U B40 2 4 O 100 10 alltrim tmp oper dtoc date alltrim FOP talltrim str tmp ext tmp gty 9 2 gt The Cognitive prints the end result of the VFP expression custom function and table fields using the specified printer commands Printing barcodes All Salesware components use the Code39 or Code128 barcode font Th
80. ns the month of the date parameter as a numeric value VFP subset from 1 to 12 YEAR DATE_VALUE Returns the year of the date parameter as a numeric value VFP subset Examples TIME returns 12 00 00 if it is noon TIME returns 13 30 00 if it is 1 30 PM DAY DATE Returns 30 if it is the thirtieth of the month MONTH DT FIELD returns 12 if the date field s month is December YEAR STOD 19920830 returns 1992 57 Date character conversion functions Function Description Custom or in VFP subset CTOD CHAR_VALUE The character to date function converts a character value into VFP subset a date value The character representation is always in the format MM DD YY DTOC DATE_VALUE The date to character function converts a date value into a VFP subset DTOC DATE_VADUE 1 character value The format of the resulting character value is MM DD YY If the optional second argument is used the result is in the format CCYYMMDD See also DTOS DTOS DATE_VALUE The date to string function converts a date value into a VFP subset character value The format of the resulting character value is CCYYMMDD STOD CHAR_VALUE The string to date function converts a character value into a VFP subset date value The character representation is in the format CCYYMMDD Examples Crop 11 30 88 DTO
81. obal INI and locate the group under which to place the new layouts Under the Layouts section of that group add the appropriate receipt name Receipt FBReceipt txt SavedSale FBSavedSale txt Note Make sure to remove the semicolon from in front ofthe Layouts section and in front of the receipt type Le Receipt SavedSale Only remove the semicolon in front of the receipt types you are using 13 6 Restart Sales and test your new layout Layout type Description CCBottom Salespoint specific non Graphic layout for the bottom CC Receipt CCTop Salespoint specific non Graphic layout for the top CC Receipt Invoice Salespoint specific non Graphic layout for Invoices Receipt Salespoint specific non Graphic layout for Receipts RemotelA11 Salespoint specific remote non Graphic layout for remote layout 1 for ALL items RemotelNew Salespoint specific remote non Graphic layout for remote layout 1 for NEW items Remote2A11 Salespoint specific remote non Graphic layout for remote layout 2 for ALL items Remote2New Salespoint specific remote non Graphic layout for remote layout 2 for NEW items Remote3A11 Salespoint specific remote non Graphic layout for remote layout 3 for ALL items Remote3New Salespoint specific remote non Graphic layout for remote layout 3 for NEW items Remote4A11 Salespoint specific remote non Graphic
82. on for current locale X Time representation for current locale Sy Year without century as decimal number 00 99 SY Year with century as decimal number SZ Time zone name no characters if time zone is unknown Percent sign Examples To print the transaction date amp time in DD MM YYYY HH MM SS AM PM format you would use TTOC alltrans gt date time 3m d 3Y 1 M S p resultsin 10 24 2005 12 30 45 PM To print the transaction date and time in DD MM YYYY HH MM SS AM PM format you would use TTOC alltrans gt date time 5d Sm SY 1 3M S p results in 24 10 2005 12 30 45 PM departme gt descrip Prints the department description on tickets category gt descrip Prints the category description on tickets mod accX The access number of a modifier is now populated in the mod_accX where X 1 9 field in the printing and tmp inv tables This allows for the printing of multiple barcodes on a single ticket so that a separate ticket no longer needs to be issued for each part of a purchased package 69 Guest Card layout functions Function Description Custom or in VFP subset LKUP GUEST NUMBER Used with any item that collects guest information The guest Custom number is encoded in a barcode and can be used for three different functions 1 It can be scanned in Sales to look up the guest When this is done the Summary tab for the g
83. or receipt printers for a description of how to do this 20 1 Manufacturer supplied drivers are installed and used like any other Windows driver provided by the manufacturer of the device Associating the driver and printer with your layout 1 As already described in Specific layout applications you must associate a layout with one of the specific applications listed on the Page 1 Page 2 or Page 3 tabs available from Sales gt Tools gt Sales Pt Setup gt Printing The Page 1 tab is shown in the following screen capture Y Printing Setup Page 1 Page 2 Page 3 Windows Printer Dot Matrix Printer Report Type Tickets 1 Generic Text Only GENERIC Type Specified by Item Tickets 2 BENE Type Specified by Item Voucher 1 MgalacticAHP LaserJet 1020 vi Type Specified by Item Voucher 2 galactic HP LaserJet 1020 Y Type Specified by Item CC Receipt Generic Text Only GENERIC 40 Column Non Graphic Pass MgalacticiHP LaserJet 1020 Rentals v Type Specified by Item To associate the layout application with an output device select the output device from the Windows Printer dropdown If you are using a manufacturer supplied text or graphics driver then you also need to select GENERIC from the Dot Matrix Printer dropdown If you are using a generic text only driver then select Generic Text Only from the Windows Printer dropdown and select your particular output
84. ou have never used this utility in the past please contact accesso Siriusware Technical Support for additional information Layouts table revealed SysManager and Sales keep layouts updated using the same method that Sales uses to keep its data files up to date To accomplish this SysManager must convert the layout files the t xt or the frx and frt files into database columns in the layouts table Once they are converted they can be sent to Sales through the normal update process via Pool SalesEZ application PrintEZ application then reconstructs the layouts locally at the salespoint by converting those columns in the Layouts table back into the t xt or the frx and frt files It 74 does not do a regular file copy from the Siriusware Layouts directory on the SQL Server There are several ways to get layouts to be listed in the layouts table e You can assign the layout to an item using Sys Manager e You can edit the layout in SysManager e You can pack up layouts in Sys Manager Note Layouts are not linked to products in the Layouts table The layouts table is merely used to facilitate rebuilding Shared Text Merge layouts t xt files and Graphic layouts frx and frt files in the Sales Layouts folder at the salespoint When items reference graphic or shared text merge layouts in a sale Sales searches for the reconstructed files in the Sales Layouts folder The layouts table does not know which layouts are in use it is simply
85. oving the mouse cursor in front of the character that can t be displayed Ifthe necessary control codes or printer needs to be added accesso Siriusware has developed a script to be run in Microsoft SQL Server Management Studio SQL Server 2008 or 2012 Here is a sample script for a Star TSP600 printer DECLARE P_Name VARCHAR 30 Reset VARCHAR 30 DoubleWide VARCHAR 30 DoubleHigh VARCHAR 30 Condensed VARCHAR 30 Bold VARCHAR 30 Italics VARCHAR 30 Underline VARCHAR 30 Pitch_10 VARCHAR 30 Pitch_12 VARCHAR 30 Pitch_15 VARCHAR 30 NLQ Print VARCHAR 30 Color_1 VARCHAR 30 Color_2 VARCHAR 30 Color_3 VARCHAR 30 Color_4 VARCHAR 30 Landscape VARCHAR 30 Cut_Code VARCHAR 7 SELECT P_Name STAR TSP600 SELECT Reset CHAR 27 CHAR 64 SELECT DoubleWide CHAR 14 SELECT DoubleHigh CHAR 27 CHAR 14 SELECT Condensed SELECT Bold CHAR 27 CHAR 69 SELECT Italics SELECT Underline CHAR 27 CHAR 45 CHAR 1 SELECT Pitch_10 SELECT Pitch_12 CHAR 27 CHAR 77 SELECT Pitch_15 CHAR 27 CHAR 80 80 SELECT QGNLQ Print SELECT Color_1 CHAR 27 CHAR 53 SELECT Color_2 CHAR 27 CHAR 52 SELECT Color_3 SELECT QGColor 4 2 SELECT Landscape SELECT QCut Code CHAR 27 CHAR 100 CHAR 3 F EXISTS SELECT p name FROM printers where p name Q8P Name UP
86. proval NEWLINE gt lt NEWLINE gt lt NEWLINE gt lt NEWLINE gt lt Printers gt cut code lt NEWLINE gt lt NEWLINE gt Passes ALLTRIM cOo trans approval NEWLINE Pass layouts are associated with their DCIs from within SysManager SysManager gt DCIs gt New Edit gt Action tab gt Create Pass gt Action Specifics gt Global Settings tab gt Layout field as shown in the following two screen captures ADTUNLMTD Adult Unlimited Pass Fundraising Interface Item Type Create Pass Action Specifics Qs Printing r Validation Sale None Y OForce Optional Template Allow Validation For A Fu Optional Force Pass Entry Optional on Returns UI Template No DebitWare action iv Department PASSES Category UNLIMITED New m v 16 Starting Values GlobalSettings AutoPass Validate Auto Sales Autosale Options Global Setting For All Passes Uses Per Day Uses Per Week it g if a gia Lei Black l if g E Monday Lun ii g if Friday Dates M Tuesday Saturday Wednesday 7 Sunday it g i V Thursday Times e Layout CURRENTPASSIHC FRX a C Enforce time part of start end date Prefer a Revenue Recognition Rule No Revenue Recognition EN Credit Card Program ID E Create check point log entr
87. racter 30 Tmp vlgty Voucher 1 guantity for ignore gty Integer 4 Tmp_vlwprn Voucher 1 Windows printer Character 100 Tmp_v2lay Voucher 2 assigned layout Memo 4 Tmp_v2prt Voucher 2 dot matrix printer Character 30 Tmp_v2qty Voucher 2 quantity for ignore qty Integer 4 Tmp_v2wprn Voucher 2 Windows printer Character 100 Tmp_valno Validation number Double 8 Tmp_wusesl Pass uses per week left Integer 4 Tmp_zip Primary guest zip code Character 10 Additionally you are able to use any field in the guests alladres gst_pass access alltrans transact accounts invoices operator and sale hdr tables Note To use a field other than the fields listed above which are in the Printing table the local table where the field is located must be determined the field name must be known and the following format is used local_table gt local_table field_name Example SALES_PT gt salespoint retrieves the name of the salespoint from the SALES PT table Common fields on Graphic Pass layouts Field Function call Notes Mug shot Prints the guest photo on a pass esppimg guests mug shot 2 Print when not empty guests mug shot First name Prints the guest first name on a pass alltrim guests first name Last name Prints the guest first name on a pass alltrim guests last name Item description Prints the item descr
88. rinting tab gt Print Remote On check boxes See screen capture in the Tickets and vouchers section above The actual printer association for the remote configuration is made from Sales gt Tools gt Sales Pt Setup gt Printing Printing Setup gt Page 3 tab as showing in the following screen capture La Printing Setup Page 1 Page 2 Page 3 Windows Printer Dot Matrix Printer Finalize Save Remote 1 NONE v GENERIC NONE we NONE Remote mm immer im si Remote 3 NONE GENERIC NONE Rem ote 4 NONE F GENERIC um Remote 5 NONE GENERIC e NONE Remote 6 NONE GENERIC NONE gt x m Remote 7 NONE GENERIC NONE Remote 8 NONE v GENERIC wel NONE You can also override any layout specified on Sys Manager gt Preferences gt Miscellaneous This allows you to fully customize any salespoint This functionality is useful if you want to customize a single salespoint using a layout different from any of the resort wide layout choices You have the option of overriding the resort wide credit card invoice receipt and all eight remote layouts To implement this functionality create a set of custom layouts and store them in a folder locally Then in the Sales32c INI file specify the path to the new layouts folder 1 Inthe Data section of the INI file the setting is LayoutPath 12 2 e Default is usually LayoutPath
89. s as the Barcode Blaster printer based on early models the Boca printer several laser jet printers and several dot matrix printers see Supported specialized printers Each of these printers recognizes different printer commands and some do not require commands at all For a complete listing of printers supported by accesso see the Hardware Compatibility List HCL document Cognitive printer commands This section describes the basic commands needed to design a printer layout for the Cognitive printer This printer has traditionally been called somewhat generically the Barcode Blaster printer and is still sometimes referred to that way regardless of which Cognitive model you are using To design more complex layouts please refer to the User s Guide that was included with the purchase of your Cognitive printer Header line The header line is the first line in a Cognitive layout Here is an example 0 100 1050 1 Every Cognitive Header line used in Sales begins with an exclamation point which tells the Cognitive that it is about to print in ASCII mode The 0 indicates to the Cognitive the starting position for printing In this case and almost every other case the starting position is 0 The next parameter 100 is always 100 The next parameter 1050 indicates how many printable rows exist on the ticket stock In this case the total number of rows in this Cognitive layout has to be less than or equal to 1050 If t
90. s guest no SEEK TABLE INDEX VALUE Selects the TABLE sets the index to the INDEX value and seeks Custom to the first record that matches the VALUE in the INDEX field NEWLINE Returns CHR 13 CHR 10 Ge carriage return line feed Custom CENTER EXPRESSION Centers the expression on the page based on the number of Custom NOA 209 character columns you have on the printer typically 40 or 80 JUSTLEFT EXPRESSION Left justifies the text Custom NUM COLS JUSTRIGHT EXPRESSION Right justifies the expression on the page based on the number of Custom NUM COLS character columns you have on the printer typically 40 or 80 FOP Displays the form s of payment used to pay for the sale Custom Note This is only valid on Receipt printing It cannot be used for Saved Sales Additionally this only returns payments made on finalize and not any previous payments DSTR1 TABLEDFIELD Returns a character representation of the Date Time field inthe Custom format CCYY MM DD DSTR2 TABLEDFIELD Returns a character representation of the Date Time field inthe Custom format MM DD CCYY HH MM SS AM PM TIPS EXPRESSION Evaluates the expression if and only if the salespoint has Custom Tips TRUE in the Sales32c INTI file Mostly used only in Ticket layouts e g Charge Cards Ticket layout but is available for Receipt layouts as well MODIFIER Returns T TRUE ifthe item in the All Trans table is a Custom product modifier Used on
91. se the Preferences gt Miscellaneous gt Manager tab gt Save Printer Info In Layouts After Editing check box to indicate the layout is not cleaned of printer specific information after editing This check box is only selected checked if you are sure you are using the exact same printer make model in the field as you are using at design time The SysManager gt Activities gt Remove Printer Info From Layout selection is used to manually remove printer specific information from a selected layout if you are using the Save Printer Info In Layouts After Editing option Connecting printers to salespoints Printers are connected to salespoints in one of three ways over a network by a direct serial connection USB FireWire etc or by a direct parallel connection When connected over a network the driver is installed on the computer that is used to connect the device to the network and on the computer salespoint that is outputting to the device When the device is connected directly to the computer salespoint that is outputting to the device the driver is installed only on the computer salespoint Note In some cases the device is network ready which means that it connects directly to the network without the need for an intermediary computer In these cases the driver is installed only on the computer salespoint accessing the device over the network Types of drivers for use with Salesware There are three types of drivers used with
92. selection by the Sales operator All tables in the local Data folder are open and may be referenced but they may not be synched To print confirmation letters PrintEZ application creates several temporary tables These tables are actually left on disk after the confirmation letter has printed so you can close Sales and use Helper utility to view their contents They are created in the Sales Data folder csrTrans is the primary selected table The following tables are used Table Sync field Notes csrTrans Table created and left on disk for each confirmation letter holds all the tr_save records for the reservation csrSaleHdr Not synched Contains sh_save and sale_hdr records for the reservation csrResGuest N A Single record table Contains guest record with address information for guest attached to Reservation Header esrUtillty Not synched only top record Contains utility records for all sales in csrSaleHdr csrSaleGuest Not synched All guests attached to transactions in the reservation with address information resrvatn reserv no utility printing sale_no Has totals for a reservation and is invaluable in creating confirmations Fields include Sale_no 46 Sale sub Sale_disc Sale fee Sale ext Sale taxa Sale taxb Sale tax Change Acct tot Inv tot Acct chg Acct pay Pms lookup Pms select Saved sale Admissions Dw swipeno Dw cr lim Dw cr rem Sp lim
93. sing a Windows driver provided by the manufacturer some 18 output device manufacturers require that certain custom strings be passed to the printer via special code used with the driver this is done with for example magnetic swipe injection devices In general Graphic layouts work with most printers while Text Merge layouts and Shared Text Merge layouts work with specialized printers only and require considerable hand coding See Sample layouts provided with Salesware for the layouts that are provided with Salesware and the printers with which they work See Supported specialized printers for a list of specialized printers supported by Salesware Layouts that already work with most of these devices are provided with Salesware Installing printers and drivers for use with layouts This section describes how to connect printers to salespoints for use with layouts In general the only time you need to use manufacturer supplied drivers is when doing Graphic layouts Most output devices use Text layouts so you can use the generic driver provided by Microsoft The same holds true for Boca ticket printers With Cognitive ticket printers and pass printers you have to use the manufacturer supplied drivers because these devices don t use Text layouts In some cases clients have used the generic text only drivers for Cognitive printers but usually you need to install the Cognitive drivers Note When editing layouts in SysManager you can u
94. sion custom function and table fields using the specified printer commands Printing barcodes All Salesware components either use the Code39 barcode font or the Code128 barcode font Therefore when designing tickets that contain a barcode you must print the barcode using one of these two barcode fonts Here is an example of a line of code that prints a ladder barcode using Code39 barcode on the Boca printer 36 lt alltrim lt RC50 575 gt lt X2 gt lt NXL12 gt if empty tmp_edate AXX A tencrypt_date tmp_edate encrypt_number tmp access alltrim gt All Code39 data must be bracketed by asterisks on both sides as shown Because the example barcode command does not print subtext it is necessary to print the following subtext line to indicate what characters are contained in the barcode lt alltrim lt RR gt lt RC150 475 gt lt F1 gt lt HW3 2 gt A alltrim str tmp_access gt The following is an example of how to print a picket fence barcode using Code39 barcode on the Boca printer lt lalltrim lt RC50 575 gt lt X2 gt lt NXP12 gt 1f empty tmp_edate AXX A t tencrypt_da te tmp_edate encrypt_number tmp access alltrim gt Code128 is an alphanumeric bar code All Code128 data must be bracketed by carets The letter O is used to select Code128 barcode A typical ladder Code128 barcode would be sent as follows lt lalltrim lt RCO 70 gt lt X2 gt lt OL3 g
95. ss printer PASS and so on This way when you define the printer in the Sales interface it makes sense Also there are many times when more than one Generic Text Only printer is installed and you cannot have two printers with the same name To install a manufacturer supplied driver 1 Plug the hardware into the computer 2 You are presented with the Found New Hardware Wizard 22 Found New Hardware Wizard Welcome to the Found New Hardware Wizard This wizard helps you install software for FARGO Electronics Inc ID Card 4250 lt 6 or floppy disk insert it now If your hardware came with an installation CD What do you want the wizard to do C Install from a list or specific location Advanced Click Next to continue lt Back Cancel 3 Ifyou are installing a manufacturer supplied driver first try selecting the Install the software automatically radio button and click Next 4 You are presented with a dialog that indicates Windows is searching for the driver for the new hardware Please wait while the wizard searches ay e FARGO Electronics Inc ID Card 4250 Cancel 23 Ge If the driver is found complete the remaining steps for the Found New Hardware Wizard and your new printer appears on the Start gt Printers and Faxes dialog If the driver is not found you have to select the driver yourself Obtain the driver from a disk you received with the printer or go to the m
96. ssesdonsessugassesesbasdeseagasessnsansdecosancsecwage O Layout applications Specific layout applications Associating layouts with their individual applications rennen aaa aaa aaa aaa aaa 8 Jackets e EE 8 Receipts Invoices Summaries Charge Cards saved Sales Remote Receipts and Z Tape Reports Example s is nitet p dme vae rap n a eerte es 12 Example eere eu a Heina a e a i niat aime erede 13 In order to take advantage of Group Level layouts you must do the following ooooonoococnnonococonononcnonnncnonnonnnononnnnnnnnnnnnnnnnnnos 13 Consolidating the Sales and CC Recetpt eiii nio Oe HOP E Oe HAE IE 14 NEE 16 Purchase Order PO layouts Retail module p 17 TEXT LAYOUTS TEST ele EEN Ke DIAGNOSTIC TOOL ANAL E ENT LAYOUT FUNCTIONS AND COMMANDS eese nennen nnne 18 Installing printers and drivers for use with layouts oooooommmmmsms 19 Connecting printers to salespoints niei is He HR c Rd THEY HER TH a e eee HE ign 19 Types ot drivers for usewith Salesware eese oe ce ceti t ue e ud ER I E ae Ede ER 19 Example 2 5 eei ehe Associating the driver and printer with your layout How to install a printer and driver Lees ecce eese eee e eee ee eee ene seen ease ease eee eee sasas eee saaa sese sense see seansas ease 22 Example sunis E is 22 To 11stall a nanufacturer supplied drtyer
97. t JUSTRIGHT 40 gt JUSTRIGHT Sub Total STR Utility gt sale sub 10 2 40 gt JUSTRIGHT Tax STR Utility gt sale_tax 10 2 40 gt JUSTRIGHT Total STR Utility gt sale_ext 10 2 40 gt lt JUSTRIGHT 1 40 lt JUSTRIGHT PAYMENTS STR Utility gt amt_paid 10 2 40 1 gt lt JUSTRIGHI BALANCE DUE STR Utility gt bal_due 10 2 40 gt lt JUSTRIGHT 1 40 lt JUSTRIGHT iif Utility gt sale_ext gt 0 00 Payment Types and Amounts 40 lt JUSTRIGHT iif Utility gt sale ext gt 0 00 FOP 40 gt lt JUSTRIGHT iif sale hdr gt pmt amt1 gt 0 0000 alltrim str sale hdr gt pmt_amt1 8 2 1 iif sale hdr pmt amt2 gt 0 0000 alltrim str sale hdr gt pmt_amt2 8 2 1 11f sale hdr pmt amt3 gt 0 0000 alltrim str sale hdr gt pmt_amt3 8 2 iif sale hdr pmt amt4 gt 0 0000 alltrim str sale hdr gt pmt_amt4 8 2 40 gt lt JUSTRIGHT CHANGE DUE iif Utility gt change gt 0 0000 alltrim STR Utility gt change 8 2 40 gt lt NEWLINE gt lt CENTER Thank You 40 lt NEWLINE gt lt iterate over cc trans sale no sale hdr gt sale no F cc trans gt status 3 ALLTRIM Card Number XXXXXXXXXXXX cc_trans gt card_id NEWLINE Card Type cc trans gt card type NEWLINE Amount ALLTRIM STR cc_trans gt total 16 2 15 NEWLINE Ap
98. t if empty tmp_edate AXX A encrypt date t mp_edate encrypt_number tmp_access talltrim gt This would result in a 3 unit wide bar code starting on row 0 column 70 No interpretation is printed A typical expanded picket fence Code128 would be as follows lt lalltrim lt RCO 10 gt lt X2 gt lt 0P5 gt lt BI gt 1f empty tmp_edate AXX A t tencrypt_da te tmp_edate encrypt_number tmp_access alltrim gt This code starts at row 0 column 10 The interpretation is included The BI in the Boca printer command is what causes the interpretation or subtext to print Specifying the end of a Boca printer layout The following line specifies the end of a Boca printer layout If this line does not exist at the end of a Boca printer layout the ticket or voucher does not print lt alltrim lt p gt gt 37 Dot matrix printer layouts All dot matrix printer layouts use the custom function show to specify font style and size line size text justification and text to be printed Every show command indicates a new row in a layout For more information on the show command see Ticket layout functions show uses seven parameters to set characteristics for the text to be displayed Example show doublehigh doublewide italics bold left 20 DAILYCODE ctod tmp date gt This generates the valid daily code using text that is twice normal heig
99. t style and the font size TextFonts Occasionally TextFonts are used when creating Cognitive Printer layouts By utilizing TEXT 1 2 and 3 font sizes with the values in parenthesis you can create Ticket layouts in this fashion An example of TextFont code is TEXT 3 1 0 1 1 e The first character determines the spacing between characters e The second controls the font s clockwise rotation e The third controls a font s horizontal width 21 e The fourth controls a font s vertical height Parameter Options Additional Details Spacing 0 255 If a negative sign is placed before a designated spacing number the font is non proportional and this value sets the character width Rotation 0 90 180 270 Default 0 Width 0 4 Must be used when establishing a Height Default 1 value Height 0 4 Default 1 Boldness spacing and rotation Level of boldness spacing and rotation of text can be specified when using Ultrafonts with the following syntax U A100 boldness spacing rotation This code is described in the following table Parameter Options Default Use boldness 1to 255 Indicates the boldness of the printed character in dots spacing 0 to 10 1 Indicates number of dot columns between characters N causes characters to be spaced disproportionately rotation 0 90 1800r270 0 Indicates the degree of clockwise rotation of the printed character stri
100. t styles The following font styles can be used with the Boca printer Font Style Description lt F1 gt A self styled font containing most of the normal ASCII characters It also includes the German character set and the British pound symbol It is not recommended for use on 200 dpi printers lt F2 gt A self styled font containing most of the normal ASCII characters It also includes the German character set and the British pound symbol lt F3 gt An OCRA styled font containing most of the normal ASCII characters It also includes the German character set and the British pound symbol lt F4 gt An OCRA styled font containing most of the extended non rotated character set no extended graphics characters It does not include lowercase letters in either rotation or the OCRA special character set It is not recommended for use on 200 dpi printers lt F5 gt A self styled font containing most of the normal ASCII characters This font is not recommended for general use lt F6 gt An OCRA styled font containing most of the normal ASCII characters It also contains Boca s condensed German and British character sets lt F7 gt A full OCRA font when printed on a 200 dpi printer lt F8 gt This font is the same as lt F13 gt except for a smaller box size This is the default font size for 8 5 inch wide printers to allow them to easily interface with most word processing programs
101. t the START_POSITION character of CHAR_VALUE The parameters START_POSITION and NUM_CHARS must be constant UPPER CHAR_VALUE A character string is converted to uppercase and the VFP subset Examples LEFT The same result could be achieved with SUBSTR SEQU SEQUITER RIGHT SEQUITER SUBSTR ABCDE 2 SUBSTR Mr Smith 5 3 returns BCD 3 returns SEQ TER 1 3 3 returns TER 1 returns S 56 Logic functions Function Description Custom or in VFP subset ITF LOG VALUE If LOG VALUE is TRUE then IIF returns the VFP subset TRUE RESUDT a i TRUE RESULT value Otherwise I IF returns the FALSE RESULT value Both TRUE_RESULT and FALSE_RESULT must be the same length and type Otherwise an error results Examples F VALUE lt 0 Less than zero Greater than zero F NAME John The name is John Not John Date functions Function Description Custom or in VFP subset DATE The current system date is returned VFP subset TIME The time function returns the system time as a character VFP subset representation It uses the following format HH MM SS DAY DATE_VALUE Returns the day of the date parameter as a numeric value VFP subset from 1 to 31 MONTH DATE_VALUE Retur
102. tabase functions Function Description Custom or in VFP subset DELETED Returns TRUE if the current record is marked for VFP deletion subset RECCOUNT The record count function returns the total number of VFP records in the database subset RECNO The record number function returns the record VFP number of the current record subset Example RECCOUNT returns 10 if there are ten records in the database 59 Receipt layout functions All Text Merge layout receipt lines must be encapsulated by lt gt Function Description Custom or in VFP subset D D ETAI 1S CHAR EXPRESSION ETAILS CHAR EXPRESSION LOGICAL Loops through all of the records in the All Trans table and converts the expression to readable text Similar to ITERATE OVER except it uses only the AllTrans table created just for the DETAILS function and sync s the guests and gst pass tables as well CHAR EXPRESSION is the same as in ITERATE_OVER only the SEPARATOR is included at the end of the expression In the second form if LOGICAL is set to TRUE then the function loops through all of the records in the All Trans table and only prints the record if it is a new item added to the receipt Note With the DETAILS function you are sure to get all of the payments either deposits or acco
103. the printers that are used with Salesware 19 e Generic text only e Manufacturer supplied text drivers e Manufacturer supplied graphics drivers If you are using a Text layout you output to a printer using either the generic text only driver or the manufacturer supplied text driver It is easier to install the manufacturer supplied text driver but your device does not operate as fast as it does with the generic text only driver With Salesware in almost all cases of Text Merge and Shared Text Merge layouts you want to use the generic text only driver When you use the generic text only driver you have the option of accessing the Printers table in the local Siriusware Sales Data folder The Printers table contains a list of printer specific codes used for special printer functions such as bold underline italics and other useful printer functions such as the cut code code used to automatically cut output into individual receipts tickets etc By using the Printers table you can use a single layout for a variety of printer models and you do not have to manually put the character codes into the layouts A portion of the Printers table is shown in the following screen capture p_name reset doublewide doublehigh condensed bold italics underline pitch 10 pitch 12 pitch 15 nl print color 1 HERMES 616 f G E kel 101 IBM PROPRINTER III K lee f e SSC Le vit L IBM PROPRINTER X24 Ka E amp 4 1 OKI MICROLINE 320 321 T ew
104. ually cut and paste the text into the item record using SysManager Text Merge layouts are stored with the item itself in the items table However Shared Text Merge layouts and Graphic layouts are separate files and are accessed as separate files at the salespoint when they are used by the item that references them Graphic layouts are FoxPro Report files frx and frt extensions and Shared Text Merge files are text files txt extension Thus Shared Text Merge layouts and Graphic layouts appear in two places on the server in the Siriusware Layouts folder and on the salespoints in the Sales Layouts folder Sometimes however the layouts in the two locations must be re synced so you must pack up the Shared Text Merge layouts and Graphic layouts in the Siriusware Layouts folder using SysManager and then unpack them on the salespoint In SysManager you pack up from Activities gt Pack Up All Layouts and then when you re start Sales at each salespoint the layouts are automatically unpacked at the salespoints Alternatively in Sales you can unpack from Tools gt Action gt Unpack Layouts Note There are also layouts such as Receipt layouts edited from SysManager gt Preferences gt Miscellaneous that are shared but that are not kept with the items themselves nor do they exist as separate files These are stored in the pref s1 table Important Use caution when unpacking layouts in SysManager If y
105. uest is displayed 2 It can be scanned after clicking on the Other button rightmost on a line item in a sale in order to attach the guest to that item 3 It can be scanned at a Rentals TechStation to look up the form history for the guest Typical code that uses this function in a layout is the following B code128 2 4 400 400 70 lt LKUP alltrim str quests gt guest_no 12 0 gt The is programmed into the scanner For more information see the Salesware Rentals document Axess Smart Printer layout functions Function Description Custom or in VFP subset ClearMedia Correctly cancels all valid segments Axess Smart Printer encoding It is possible to create an item with an Axess Smart Printer layout that only encodes the accesso Siriusware segment of the card no gate validation segments along with a printed lt CardMask gt section and guest photo An activity type 150 record is NOT generated in this scenario because there is no Axess data to forward to the Axess database via the SOAP EDE Verification of an available segment for re encoding during the reload process is more accurate 70 The lt IGNOREONEXCHANGE gt sales action tags function the same for Axess items as all other access and gst_pass items PEZ functionality PEZ functionality is supported by PrintEZ and ResPrint application The PEZ library is a collection of special purpose functions used from Gr
106. unt payments and all relevant information from both the Transact and Tr Save tables The DETAILS function is one stop shopping for all ofyour Sale Hdr Sh Save Transact Tr Save needs Inside the DETAILS function the following tables get synced so are available for use Table Sync field Items Department Category It tems invent_id Guests guest_no AllAdres guest_no Gst_pass pass_no Specials name Custom H ERATE OV ER TABLE INDE PR ER EPARATO ESSION Loops through the specified table for all records that match the filter expression in the table s indexed field and converts the expression to readable text The separator is placed between every line typically NEWLINE Custom 60 When iterating over the tr_save or transact table the following tables get synced so are available for use Table Sync field Items Department Category Item Items invent id When iterating over the tr info tra info sh_info or shs info table the following table gets synced so is available for use Table Sync field Guest
107. y when validating C Allow on the fly discounting Sales Screen action to execute when this item is validated No Validation EN The common fields that are used in Pass layouts are listed in Common fields on graphic Pass layouts Purchase Order PO layouts Retail module The Purchase Order PO creation capability in the Retail module can be configured to use a custom layout The layout must be named xinvent receiver orxinvent poform and must reside in the Layouts folder on the server xinvent receiver is the purchase order creation receiving layout and xinvent poformis the purchase order print Purchase Order layout When one or both of these layouts is stored in the Layouts folder SysManager prints PO forms using this external layout instead of the hard coded one This layout can be edited in SysManager gt Activities gt Edit layouts Text layouts test tool You can test Text layouts in Sales through a Test dialog The Help section on the Layout Test Dialog provides more details but here are some notes on the use of the Test layout functionality 1 Press the Sales gt Tools gt Diagnostics gt Test Layout button or swipe PPPP at the main dialog to bring up the Layout Test Dialog 17 2 Click the Select layout to test dropdown list to select any available Global layout The layout appears Click Evaluate The layout is rendered 3 From the Select layout to test dropdown list if Choose fil

to a PDF version of this document

Contents

Download Pdf Manuals

Related Search

Related Contents