Cheque Factory 3.0
Contents
1. x 5 CSV Text file The following illustration shows the input file Cheques csv which contains four entries P cheques csv Bloc notes Fichier Edition Format Affichage gt Date op Payee id Description Amount O1LfOL 2015 100001 Description 1 458 7 45 01 02 2015 100002 Description 243 45 756 20 9271572015 100003 Description l Nef 100004 Description 3 6457 32 6 Visual FoxPro database The following illustration shows the datafile dbc database that contains four tables HE Preview CHEQUES PAYEES id Descriptio Amount EHBARCUDES Description 4587 47 Description 245 48755 200 100003 Description 54879 720 02 16 2015 100004 Description 3 945 320 lt ILL Joins 38 Cheque Factory user manual Note Double click a table to display its contents Click once on the header of a field sorts the table in ascending order of the data in that field Click a second time on this field sorts the table in reverse order 7 Excel workbook The following illustration shows the datafile xls workbook that contains four worksheets Microsoft Excel datafile xls Sel Eat Fichier2. 552 YPIINTN N 9ZII I HIHNGTHI IYI I I2III III I lt 2 I lt IIIIIIIIIIAIII II I III II II IIIIIII IIOIIIII I III IIIZIIAIIIII II IIIIIII IIII II IIIKIII IIZIIIWIIII9IIII III IA IIII I II I2I I I IAII2IIIIIHI IIII IIII II I I II I I III II II lt I III I II5 I9III IKW gt I III IIII IIII I I IIIIIIIII IIIII ZI I3 I I K I AII III I II IIIAIII II II IIII IIIIZIII III IIII I zI I II I I lt OIOI I AII III I I I I I IIIIIIII IXII III lt GGCIIICIGC IIC CIIIII K C
3. Line Size 3 points v m m Color E ter The Signature tool allows to sign your document with the mouse in one stroke Choose a size for the line Choose the color of the signature Clears the signature Starts editing the signature can sign again in one stroke or resume the signature 2 Handling of objects Cut copy and paste objects You can select any Cheque Factory object copy cut and paste to duplicate the object as many times as you want Choose Edit gt Copy Edit gt Cut or Edit gt Paste Click the Copy Cut and Paste buttons of Standard toolbar Use the context menu Use the keyboard shortcuts Ctrl C Ctrl X Ctrl V 34 Cheque Factory user manual Align and arrange objects The Align toolbar contains all the necessary buttons for alignment and arrangement of objects 25 E Er 88 9 BS E55 Eg s You can also choose Edit Align Align Left Align Right DT Align 00 Align Bottom Same Height T TT LIT Same Width Undo and Redo actions You can undo or redo an action at any time during your work Choose Edit gt Undo Edit gt Redo Click the Undo button or Redo of Standard toolbar Use the keyboard shortcuts Ctrl Z Ctrl Y 35 Cheque Factory user manual Vl Examples Business card New check Ticket Barcodes linked to a data file CSV Text file Visual FoxPro datab
4. Remarks The fields that appear in green in this grid are the fields in the table Cheques their names should be Date Op Payee ID Description Amount To print cheques the program uses another table named Payees representing the table that contains the names of payees To print other reports and ensure the management of your bank accounts and manage your checkbooks and bank balances the program uses another table named Ledger representing the general ledger that contains all bank transactions of your company Cheque Factory also uses this table to record automatically any printed or voided cheque Fields that may appear in red in this grid are fields that would not be part of a cheque configuration 5 Print other reports You can access different settings for your reports via the Tools Options menu tab Reports E Options General Mew document Passwords Folders Reports Print Options Print the company logo Print the company name Rich reports colors and shapes Banded lines Page Mumber Insert page numbers Bottom of page CO To top of page Page Number Insert page number and number of pages 20 Cheque Factory user manual Cheque Factory generates reports for your printed cheques voided cheques by bank by payee you can select a particular payee as well as for the overall situation of all your banking transactions for a selected period taking into consideratio
5. Text M __ v Show the human readable text LU Add text Text above Text below x 1 Changes the magnification factor of the bar code which ranges from 1 to 6 2 Increases the margin around the image to add text over and above the bar code 3 Some types of bar code allow you to change the ratio between the narrow bars and the wide bars This ratio can take values 1 2 1 3 and 1 4 2 3 and 4 to 1 4 The type of barcode ITF 14 allows you to choose a type of frame around the bar code a rectangle or two bars one above and one below the barcode 5 Allows you to add text above and below the bar code Insert a WordArt object M onn a uM E ss Text Font Style Enter your text 3 GBC E m Fr o S Show shadow lt Rotation 907 DE 33 Cheque Factory user manual 1 Apply a shadow to your WordArt text 2 Rotates your WordArt text by 90 degrees 3 The Style tab allows you to apply WordArt effects to your text border color or background color gradient or predefined patterns opacity Sign the document with mouse HUNE 1 a a e a a Ei Ei Ei Ei Ei E RC im s immi DI gt 3 Sig nature
6. Edition Affichage Insertion Format utils Donn es Fen tre 2 f x Arial l0 G J 8 je Date p AFayee Id Description Amount 1 1 2015 100001 Description 1 4 587 45 1 2 2015 100002 Description 45 755 20 2172015 100003 Description 1 54 879 72 JS 100004 Descriptions 9 457 32 v M 4 k H cheques payees Z ledger 4 bar lt gt Pret 8 MS Access database The following illustration shows the datafile mdb database that contains four tables 39 Cheque Factory user manual datafile Base de donn es format de fichier Ac Accueil Cr er Donn es externes Outils de base de donn es Compl ments Champs Table 4 r A gt f 4 Affichage oles Filtrer Actualiser Rechercher Mise en forme r i W tout X ly T du texte Affichages Presse papiers Trieretfiltrer Enregistrements Rechercher Tables lt Cheques ES Barcodes Date op E Payee id Description Amount Cl Cheques 01 01 2015 100001 Description 1 4587 45 02 01 2015 100002 Description 2 45756 201 15 02 2015 100003 Description 14 548 79 728 E Payees 16 02 2015 100004 Description 3 8457 32 Enr M 1 4 k HE W Aucun filtre Rechercher Mode Feuille de donn es Verr num 2 s Remarks The file format chosen for these examples is compatible with MS Access 2002 2003 For a default installation of MS Access 20
7. csv Ledger csv and Payees csv Docdbc chf Printing cheques and checkbook management document which data imported from a Visual FoxPro database Printing cheques and checkbook management document with data imported from Excel workbook Docmdb chf Printing cheques and checkbook management document with data imported from a MS Access database Barcodes_csv chf Making and printing barcodes with data imported from CSV text file Barcodes_dbc chf Making and printing barcodes with data imported from a Visual FoxPro database Barcodes xls chf Making and printing barcodes with data imported from Excel workbook Barcodes mdb chf Making and printing barcodes with data imported from MS Access database Datafile dbc Visual FoxPro database containing 4 tables Cheques dbf Ledger dbf Payees dbf and Barcodes dbf Datafile xls Excel workbook containing 4 Excel sheets Cheques Ledger Payees and Barcodes Datafile mdb MS Access database containing 4 tables Cheques Ledger Payees and Barcodes Datafile sql Dump containing 4 tables Cheques Ledger Payees and Barcodes that you can import into your MySQL database Cheque Factory user manual 3 Y Y Y Y Y Y Video tutorials Select Help gt Tutorials Cheque Factory provides 4 tutorials contained in a single downloadable file once from Cheque Factory com Create a check using a scanner Signing a check using the mouse Create a busines
8. number ener number v uta increment 2 31 Cheque Factory user manual 1 Respectively enter the check number the routing number and your bank account number 2 By passing the mouse over these buttons the cursor changes You can move these buttons to change the order of the numbers in the serial number inserted 3 The first number the check number is automatically increased The MICR E 13B font is a special font used for bank checks by USA bank system and major Canadian companies for magnetic identification systems and optical character recognition TT 00 100 10 L3 LOLDODUB 563 11 9 i r PrecisionlD Demo Add a barcode Ba ROVS MAS BO ROMS Bo B Font Style rcade Type Y a a I EAN 13 bul 181234 567837 m m B a Value Ly 5131234557838 T uto ncrement S uffis 1 Allows to select a type of barcode from the 22 available 2 Some types of barcode allow not automatically add a check digit which is 7 in the example above 3 Checking this box will enable incrementing values of the bar code and allow adding a prefix or a suffix 32 Cheque Factory user manual B A l 3 Barcode Font Style uL UR agnification factor 1 2 Margin 90 0 Qs ITF 14 Color Barcode mi Background 2
9. 07 or 2010 or 2013 these examples work without problem However to avoid the message Unable to access the current object and work directly with these examples in MS Access 2003 you have to lower default security level using Tools menu Macro Security choose Low security level Also note that this message can result from a mismatch between the saved password in the Options dialog box and the MS Access database 9 MySQL database The following illustration shows datafile en database that contains four tables 40 Cheque Factory user manual T l chargements E xj idh localhost mysql wampse W J Cu despues phpmyadmin import php PN AAURL O sql php db datafile_ en amp table x YouTube Modem xe Control Tableau de bord 6 1 Logi Blog WordP Autres favoris phpMy Admin Serveur mysql wampserver de donn es datafile_en Table cheques 2 B eu g Afficher Structure j SQL j Rechercher Ins rer plus Tables r centes m I Nouvelle base de donn es f Affichage des lignes 0 3 total de 4 Traitement 0 0004 sec tH i datafile datafile ar SELECT FROM cheques SHa datafile en Eg Nouvelle table J Profilage En ligne Modifier Expliquer SQL Cr er source PHP Actualiser E P barcodes Ed cheques Nombre delignes 25 ledger X payees H dataf
10. 4879 720 02 16 2015 100004 Description 3 8457 320 l eJ CC JoJo oe 4 This grid displays the structure of the selected table 5 Checking this box allows Cheque Factory to manage your checkbook checks issued and bank account balances Text File csv This structure is displayed from a CSV file named Cheques csv Field names are determined from the first line of the CSV file Structure SelFreld Width Ipae cp 10 id Description 15 l gt Remarks CSV files used by Cheque Factory use semi colons to separate fields and text fields are delimited by quotes Cheque Factory user manual The fields that appear in the Structure grid fields are determined from the first line of the CSV file their names should be Date Op Payee ID Description Amount To print cheques the program uses another CSV file named Payees csv representing the table that contains the names of payees To print other reports and ensure the management of your bank accounts and manage your checkbooks and bank balances the program uses another CSV file named Ledger csv representing the general ledger that contains all bank transactions of your company Cheque Factory also uses this file to record automatically any printed or voided cheque Fields that may appear in red in this grid are fields that would not be part of a cheque configuration Visual FoxPro database dbc When you select a Visual Fo
11. Cheque Factory 3 0 Fa User Manual July 2015 Cheque Factory com Contents C ONTENTS AR NAM s Me MM RM NM eae aie RUND Sie RUN Oe HN 2 1 TO pee D IMS Fe t Coe E Go te Pe Gare me 1 SAT SUAS i a ah OA aa 1 LOR TS Reap eu oe CEPS CORN COR ent e eot COTES 2 Windows Vista Windows 7 and Windows 8 2 GETTING STARTED WITH CHEQUE FACTORY 0cceecceccecceccecceccecceccscceccsccsceeces 4 AVEC ANA UNS QUOC QUOS 4 S bend REIS RS EE ts aos RETE RE ME 4 OP MO Y MR LM EL N CR CR T Ma NA 6 HIP CREATE ACDOCUNIBNIUPODPRINID AE oM MM MM Me 7 secs es OM SO Nd S E MI M h Ont t ler ih past por 9 Scu OG lonia YOU IRIONINGION o M es eS PNE w ech tae 11 P ALDI scu epe eue oh oa 14 JT ext LA CA 15 OX ro data Dase 16 FEES VOT 0 ak SOK NE ge es A A Met A asa OC 17 NISsAccessdatabase t imdo6 Wy sts AP RES RE RU e ee 18 GC RT LM Wome Bane 19 SE Brot Or MEM M M MER ME AE 20 6 Print Preview and Print dialog boxes py SSS asas 2 SN yE Sisa AB Gi GND Ae ne
12. Cheque Factory user manual Il Getting started with Cheque Factory 1 Launch Cheque Factory Click Start All Programs Cheque Factory Cheque Factory Cheque Factory runs like any Windows program with the association of file format is The start options are Path Chfactor exe Will start Cheque Factory which the executable Chfactor exe is the specified path Path Chfactor exe Path File chq Will start Cheque Factory and loads the file of configuration File chq which is on the specified path Path Chfactor exe Path File chq Will not start Cheque Factory but Amount change the bank balance of the checkbook File chq in transparent Way Path Chfactor exe Registry Will not start Cheque Factory but register the program default registry keys This is to avoid a complete reinstallation of the software 2 View samples Complete and directly usable examples are provided with Cheque Factory They are located in the subfolder Samples of My documents folder The Samples folder includes 3 subfolders Subfolder Arabic which contains examples for Arabic language Subfolder English which contains examples for English language Subfolder French which contains examples for French language Folder contents of Samples English Cheque Factory user manual Printing cheques and checkbook management document with data imported from CSV text files Cheques
13. NUM 1 This area corresponds to the non printable area of your printer top margin and left margin minimum specified by your printer driver 2 The miniature represents the printable area or the paper size here A4 The area bounded by the blue line corresponds to the surface of the document 3 If your printer driver allows that it is recommended to add a custom print form By checking this checkbox a new form of printing is added to your Print Server The name of your document will be its name The size of this form corresponds to the size of your document with one millimeter in more in length and in width If the driver of your printer manages the custom print forms it will be added to the list of the forms of paper size supported by your printer and will be selected automatically as new format of paper size for printing your documents HP Color LaserJet 5 5M PS Advanced Options EJE3 kt Paper Output Paper Size C EE ______ Cheque Factory user manual You can also add or remove new forms manually Under Windows XP choose Printers and Faxes then Print Server Properties Under Vista or Windows 7 or or Windows 8 choose Control panel Administration Tools Print management then tab Forms in Print Server Properties dialog box It is recommended to use this method if the program fails in its attempt to remove or add new form The program proceeds as follows when it finds a form of the same name that it plans to ad
14. Sen ce SEL ccs Soa oe 36 aro RO etr ae 36 bee DEM ETC EN ID CEN CON SEN DEN CET ERN REA CET 37 jm vro ee Mar Sig Me Mig MR Mgr sim dir Mia E ip e 37 Ae Qu et RD MD NN RD E 38 ESO ENS eat 38 ym 38 TEN ECV OVI OCP ae E C CNRC CUR CLE DID RICH AURIS LT a 39 OA SEA CUOSSTQUEDUSC S eos cc MM MM 39 TS CR cae pee Ate mur mM Mr Nr Rr RET MAD NE CN AIT 40 VIE REGISTER CHEQUE FACTORY SEN ince eee Tee Pool 42 Cheque Factory user manual Introduction 1 Overview Cheque Factory is a simple program that will assist you in creating and printing your checks in three languages Arabic English French This software may also be used to easily create labels or tickets with support for several types of barcodes business cards and other documents to be printed A wizard of a particularly simplified use will guide you during the design of your checks and documents to print Direct acquisition of document images from a scanner easy positioning and resizing of check elements with drag amp drop Choose the custom print size directly from the software Drag images from Windows Explorer or insert shapes and drawings from MS Word Sign your documents directly with the mouse Data can be transf
15. a shape Shape Style 6 Shape Rectangle Rounded Rectangle Gradient Rectangle Circle ellipse O Rhombus Triangle Parallelogram Octagon Star Select a predefined drawing shape The Style tab allows you to apply special effects to your predefined shapes border or background color gradient or patterns shadow Opacity Shape Style Harmal 1 point x E gt Background Transparent Opaque Ho Gradient Fill pattern We Ic c E Show shadow Opacity 100 4 amp 30 Cheque Factory user manual Insert predefined drawing shapes from MS Word In MS Word or any other graphic design software you can choose a predefined shape apply the desired effects and copy it In Cheque Factory choose Paste Special in the context menu Select Edit gt Paste special Using a line m l e e i m ee ee 4 Horizontal pr T Vertical Downward Diagonal oy s k w 78 Upward Diagonal c Morral pg i 4 SH tein i Choose the type of line Choose a style for the line Choose the size Choose a color for the line MICI Using a serial number Font Cheque Ho Routing No Account Prefix Suffix 1 1001 J 04800 A n 304009543249 1 outing number Cheque
16. ase Excel workbook MS Access database MySQL database Oe OS a CU oe ae 1 Business card My Name i S My Company Mon adresse 1 Mon adresse 1 www mwyurl cam www mwyurl cam rrr s ee My Name Mon adresse 1 Mon adresse 1 36 Cheque Factory user manual 2 New check Your Name 12345 9876 1001 123 Your street 20 Your City 123 Street Your Bank 123 their street Their City 123 Street Memo 100 5510 1 5 532 ayer contre cheque non 9 gial Mall il sl s ma Tr E n T Elas gii 23513 E A l ordre de PU dis NR NR ERU NL M C MU TU NN NL NN RE NU eR ei ae Titulaire du compte E E E e E E EDO a Pa e 3 Ticket a aa aia aaa Steve Hackett in Concert Friday BT Amr July 18 2014 8 30 PM Olympia Theatre Paris Wd 0 FEO 3 N Cheque Factory user manual 4 Barcodes linked to a data file cigsorsz S 1000 00000003 2 10
17. ck on the spinners 3 Locations and layout information Click on an element of the document displays its properties that can be changed in the Properties window Click the right button on an element of the document shows a context menu that provides direct access to commands Amount in digits Text Font Amount ta be tested Amount 12 3455 7 589 Using 1000 Separator 1000 Separator Decimal Separator Security character a Apply to the amount in numbers 5 Lett Width ccc MMC 14 5 2 3 3 Height 2 OG 2 l B a Cheque Factory user manual 1 Check this box allows the use 1000 Separator space or for example The character entered will serve as Decimal Separator Or for example You can also Enter a security character 7 or for example and the number of times it will be repeated You can apply this character only to amount in words or payee Note that the settings made here are also applicable to your other reports The Alignment Toolbar for more information see Using a scanned image Check this checkbox to lock an element of the document the selection of this element will appear in red Uncheck this checkbox and this element will not appear in printing The Font tab of the Properties window allows you to select the font from those installed on your Text Font computer the size
18. d Dotted v 4 4 point 9 lt j 2 You can choose style size and color for the border of your background 2 Using a scanned image od Properties x Attijari Background Cheque N d O Default 1 m x 44 13 3 a 4 on E Payez contre ce ch que no NT ume seo From file ev 11 Saut au profit dune banque ou d Saf au profit dune b ou dun o a Lil LOL 1 5 gh From scanner Amount in words 2 m AMPayeg MES From a Payable ei Locality Date From a predefined pater 5 Titulaire du compte case Bignature s say fo o Q 5 Samo lt Print the background 1 Displays the Select source dialog 24 Cheque Factory user manual Select Source Sources Lexmark 2600 Seres TAIN 12 0 32 32 W A Lesmark 2600 Seres 1 0 32 32 W A P nph rique video USE 1 0 32 32 After you select the scanner installed on your machine the software interface of the scanner is displayed Use this software to perform the scan and if it does not automatically close after scanning you may close the scan window Cheque Factory captures the cheque image transmitted by the scanner software and integrate it into your document Place the elements of the cheque in the appropriate fields of the scanned image and resize them with the mouse 2 Checking this box will allow you
19. d it begins by removing the existing form Forms Parts Drivers Advanced Forme an B5 115 paysage Save Farm Farm name w Create a new form Define new form editing the existing name and measurements Then click Save Form Farm description measurements Units Metric English Paper size Printer area margins Width Din Left 10 Din Clin Height 11 00in Right 0 001 Bottom 0 00 Cancel 4 These spinners are used to change the number of records number of columns the left margin the space between rows and the space between columns in your document This slider and the and buttons control the zoom on this design window Remarks The choice of a printer paper size close to the size of the cheque allows greater precision about the location of elements of the cheque when printing 10 Cheque Factory user manual If your printer has specific paper trays for envelopes cards select the printer setting corresponding to type source or tray It is also advisable to perform test printing on paper cut to the size of the cheque and to verify the accuracy through the transparency of the overlay zones Correct any discrepancies by selecting simultaneously Ctrl A in order to move them together all elements of the document To enter the real size of the cheque in centimeters length and width cli
20. ddress This field contains the phone number mo pe This field contains the mobile number E mail address This field contains the E mail address 28 Cheque Factory user manual s Note The fields Barcode Barcode t1 and Barcode t2 are added automatically when your document containing a barcode 15 connected to a data file They are provided to contain the values of the barcode itself and eventually those of the above text and the text below the barcode Add text 5 Text Enter your text 7 x Enter your text Enter your text Alignment Lett Rotation 457 02 1 Change the font size color of text 2 Enter your text here 3 Select an alignment for your text Left right center 4 Rotate your text 45 degrees Using an image Be mb omm be m mtm be mi be x um lm m own um lm mi sm um Rm mi um le c m d Image Image Isometric C 3 Stretch 3 Rotation 90 DB 1 Image keeps its original size is proportional or non proportional to Its original size 2 Allows you to select another image 29 Cheque Factory user manual 3 Apply a mirror effect to your image 4 Rotate your image 90 degrees Using
21. erred back and forth to from the application in formats like CSV Text file Xbase FoxPro Excel and MS Access or MySQL databases to make it easy to work with other applications and to ensure the management of your bank accounts and the management of your checkbooks and bank balances using fully customizable reports You can export your document to several graphics file formats standard file formats are supported The access to the software can be protected by password to prevent unauthorized access Arabic language requirements To display the Arabic language correctly some modifications in the Regional Options of the Control Panel of Windows NT are necessary Click on the Start button then on the menu Parameters choose Control Panel Double click on the icon Regional Options Cheque Factory user manual Windows XP Click on the Start button then on the menu Parameters choose Control Panel Double click on the icon Regional and Language Options Regional and Language Options Regional Options Languages Advanced 1 3 Language For nan LInicade programs This system setting enables non Unicode programs to display menus and dialogs in their native language IE does not affect Unicode programs but it does apply to all users of this computer Select a language to match the language version of the non Unicode programs you want to use Code page conversion tables 10001 MAC Japanese 10002 Traditio
22. ile fr H j information schema Trier sur l index Aucune Options PT Id Date op Payee Id Description Amount H i mysq B j performance schema g Modifier Copier Effacer 1 2015 01 01 100001 Description 1 45756 200 8 9 test amp Modifier Copier Effacer 2 2015 01 02 100002 Description 2 54879 730 a Modifier Copier Effacer 3 2015 02 15 100003 Description 145 4587 460 Ee g Modifier Copier Effacer 4 2015 02 16 100004 Description3 8457 320 1 Tout cocher Pour la s lection 4 Modifier Effacer Exporter Remarks The MySQL ODBC 5 3 driver that you can download from the site Mysql com must be installed on your system Otherwise Cheque Factory generates a message prompting you to directly download this driver This driver called connector lets you connect to a remote or local MySQL server WampServer Xampp EasyPHP When you create or change a password for access to MySQL database via the Options dialog box File gt Options you must save your MySQL connection settings again via the dialog box MySQL connection settings 41 Cheque Factory user manual VII Register Cheque Factory The evaluation version of Cheque Factory is fully functional However its trial period is limited it expires after 14 days of use If you need this software you must purchase it form MyCommerce https shopper mycommerce com checkout cart add 29768 2 When the trial period has
23. n your balances at the beginning and end of the period Cheque management and printing other reports Print cheques Print other reports All payees B Select one payee Ca Voided cheques 05 Bank account balances 2 Payee list 6 Print Preview and Print dialog boxes Print Preview toolbar is used to navigate between the pages to print defines the display type one or more pages at a time and the size of the zoom The Print dialog boxes differ depending on the type of document to print Printing a check The dialog box prevents to insert a blank check in the printer Printing a check with checkbook management The dialog box displays the bank balance and the check number to print and prevents to insert the check that the number is displayed Printing another type of document 21 Cheque Factory user manual Print Range All C3 Curent page Pages To Print Wuantity 8 All pages Copies eT Even pages only Remarks The preview window displays the data of the cheque on their real locations in the form of print paper size chosen to print the cheque Care should be taken to place the cheque in the tray of the printer according to this preview Adjust the paper guides for example when they move together to the middle choose Center in Position in the printing area Otherwise choose one of the other positions left right top bottom according to the movement of paper guides a
24. nal Chinese 10003 MAC Korean 10004 MAC Arabic 10005 Hebrew Default user account settings Apply all settings to the current user account and to the default user profile 3 1 Click on the tab Advanced 2 In the drop down list that is displayed select Arabic 3 When you make a selection in the drop down list the button Apply becomes available Once you have clicked on it a confirmation box and a computer restart is necessary to reflect these parameters Windows Vista Windows 7 and Windows 8 Click on the Start button then on the menu Parameters choose Control Panel Double click on the icon Clock Region and Language choose Region and Language Cheque Factory user manual Region and Language Welcome screen and new user accounts View and copy your international settings to the welcome screen system and new user accounts _ Copy settings Language for non Unicode programs stg terii cora te ed en pg text in programs that do not support Unicode 4 Current for non Unicode Arabic Egypt 1 Click on the tab Administrative 2 Click on the button Change system locale In the drop down list that is displayed select Arabic then click OK The button Apply becomes available Once you have clicked on it a confirmation box and a computer restart is necessary to reflect these parameters
25. nd orientation chosen for printing To enlarge or reduce the preview window click on the corresponding buttons in the Print Preview toolbar use the mouse wheel or the or keys of the numeric keypad For duplex printing choose to print Odd pages only After they are printed turn the stack of paper and choose to print Even pages only 22 Cheque Factory user manual IV Using a background 1 Types of backgrounds Selecting the background type Properties Page setup Background Background l Default From file XO From scanner gt POO From a texture From a gradient From a predefined pattem FI a gt S d Print the DX eU 1 Cheque Factory allows you to integrate backgrounds in your documents from multiple sources From an image file select the image by clicking on the button Browse for a picture file From a scanner For more information see Using a scanned image From an image texture choose the texture by clicking the Browse button From a gradient From a predefined pattern 2 These two buttons display a panel of basic colors in which you can choose colors for your gradients 23 Cheque Factory user manual 3 Applies the selected pattern Note You can drag an image into the design window by drag and drop from Windows Explorer Apply a border to the backgroun
26. not yet expired Choose Help gt Activation Key paste the activation key in the box and then click OK When the trial period has already expired click the Register button that appears in the start dialog Once the key has been pasted into the box a confirmation box will ask you to restart the program M About Cheque Factory mmm Your penod allow pou to Ld TT ei NES d35 5B Tn HU BB Tn 42
27. oe e es fne Poe ese P Tee fce e oe 23 RESI DO O IGG FOL ata A te A e oh 20 bs ote 23 bordertothesbackoeroumds 24 zia WE SEAT DASOANN CG IMA QUSS a Pe o ei 24 MUINSERTING AND ORGANIZING OBJECT Sev i e ele ae wae ee RD APO MeL TED AT 26 CIS Me be eo REDE RET RET S MES UE ME 26 serene ot re oa Cte Fe a oom e a oer ot ECT 27 Adano rnei e Eso a mer SM SD ECL E EM E 28 JACKS Gi eaten onl eaten ICM MC OM MM T MMC M oU OMM 20 e Peru de o f e Tere CTS ve Ere Ca h ne 20 ERSTE VTL NBT EA an EA restet oec e pete ER REN S Sy SA T oe Reus 30 Insert predefined drawing shapes from MS Word 3l TS dit s ately ERU Mitre C PIU ny Men ey COUR a a iE 3l RED DIB JON D OI der ie e Mum se OQ QUE dei pii f d 3l aes ree E OK ANN CAN n LONE 22 p M ME D E 33 ICM the COC EMENT Sot eto en I ECT etr rH ts SE 34 E Daya Co C MC 34 a 34 e oD Alcor ron AU cot 55 A i cM ME SERE ME 35 DUE RI BSL NEUE SER SN ee
28. r 7 Dollars Cent Cents 2 Euro Euros Centime 7 Centimes 2 Number of decimals Pound Pounds Piaster Piasters 2 v 1 Click this first button displays the Printer dialog box to select the printer to use The second button displays the Printer Properties dialog box where you can access the various settings of the printer paper size tray to use print quality For more information it is advisable to refer the documentation accompanying your printer 2 These items become available if your document is a check setup Such information should be provided to the program so that it can manage your checkbook and bank account balances 3 o choose a currency click on the drop down list 4 To enter a new currency insert the name of the currency the name of the subunit and the number of decimals 5 Click this button to add the new currency If the plural of currency or subunit is the same as the singular it is not necessary to enter the forward slash and plural Cheque Factory user manual 2 Page setup Properties x i Page setup Background A Paper size Amountinwords 4 210 297 mm Amount in words 2 c New custom paper size Near printer paper size Columns Margins 2 00 Number of records J 0 0 11 0 0 2 Document Width Height 18 0 8 0 2 gt spese ens Step 2 4 Positions and layout 00 1
29. s card Connecting your document to a MySQL database Printing barcodes which values are contained in an Excel workbook Set up and print a report Cheque Factory user manual Ill Create a document to print To create a new document select File gt New Ctrl N or click the ooh WN button of standard toolbar To modify an existing document select File gt Open Ctrl O or click the button of standard toolbar A wizard will guide you in step by step Printer and currency to use Page setup Using a scanned image Locations and layout information Type and structure of the data file Print preview and Print dialog boxes Remarks To save your current work select File gt Save Ctrl S or click the button he of standard toolbar To save your work as model of document select File gt Save as To export your document to several graphics file formats standard file formats JPEG BMP PNG GIF EMF and TIF are supported se lect File gt Export or click the button of standard toolbar Cheque Factory user manual 1 Printer and currency to use Printer to be used Orientation Name Epson Stylus COLOR 900 ESC P 2 J Printer Portrait Landscape Bank information Name Bank id Cheque Number 4 0 00 Currency to be used Y Select a currency Name of the currency 4 AED 2 Name of the subunit Dinar Dinars Millime 7 Millimds 3 Dolla
30. style and color Fant of each element of the document Ty te Sims un Fini The Font tab of the Properties Tr Algerian window allows you to select the font pies from those installed your Tr Angsana New computer the size style and color Na of each element of the document Tr Arabic Transparent d Style Size J Regular Bald Bold Italic Color 4 J Underline Strikethrough In the case of a TrueType font or you can enter a size between 4 and 99 without using the values contained in the dropdown list 2 Click here to choose the color of the text Cheque Factory user manual 3 Click here to choose the background color of the text Amount in words Amount in words bounded P Do nat bound the amount in word Only the amount in words Fill all the empty space CO Adding the suffix word Only Adding Only and No more Subunit Subunit in words Use for subunit Capital letters F Several settings can be applied to the amount in words Note that it is possible to apply the uppercase while excluding currency Date 07 23 13 mm u Date mark Date format T Short m Tear with 2 digi 1 Click here to view the calendar and choose a date 2 You can change the date separator 3 When you choose long date format the name of the month is displayed with the year in 4 digits When you choose short da
31. te format it is possible to display the year in 2 or 4 digits 4 In the Arabic language month names are different by country You can select the month name of a particular country or the one displayed by the operating system 5 In Arabic language it is also possible to select the Hijri or Muslim calendar instead of the Gregorian calendar To do this you must first select it as the default calendar in the Regional Settings of the operating system The three standard formats of Windows long date 13 Cheque Factory user manual are supported dd MMMM yyyy dd and dd Remarks To move an element just click on it and use either the spinners or the arrow keys of the keyboard For a fast but less moving you can also use the mouse and the drag drop To move from one element to another press the Tab key To enlarge an element hold Shift key and press the Right arrow To contract an element hold Shift key and press the Left arrow To increase the height of an element hold Shift key and press the Up arrow To reduce the height of an element hold Shift key and press the Down arrow You can also use the spinners You can edit the properties of several elements of the cheque or move those items by selecting them at the same time To select all items of the cheque press Ctrl A To select more than one element hold down Shift key and click the next item to be selec
32. ted 4 Type and structure of the data files 1 Format of the data file No data file CSV file csv C Documents and Settings Mes documentssCheque Factory Samples English CHEGUES CSY Visual FoxPro database A Excel Workbook xls 7 MS Access database mdb MySQL datasource Structure of the data file Cheq agement and printing other reports Print cheques 5 Print other reports Structure Data SelField Width Field Date op 10 01 01 2015 Payee id Y 100001 Description 15 Description 1 I lt gt lt gt File types supported by Cheque Factory Cheque Factory user manual Text File csv Visual FoxPro database dbc Excel workbook xls xlsx MS Access database mdb accdb MySQL datasource YY Y Y Y 08 Click this button to locate and select your data file Click this button to browse this file Cheque Factory will start the Windows Notepad for editing Txt files Excel for xls xlsx files MS Access for mdb accdb databases For others data types Cheque Factory displays this screen for direct data entry into the tables The toolbar allows you to navigate search add delete and save your data e f Preview CHEQUES Cheques ER LEDGER A PAYEES Date op id Descriptio Amount S BARCODES 01 01 2015 100001 Description 4567 470 01 02 2015 100002 Description 45 4556 200 100003 Description 5
33. this grid are the fields in the table Cheques their names should be Date Op Payee ID Description Amount To print cheques the program uses another table named Payees representing the table that contains the names of payees Cheque Factory user manual To print other reports and ensure the management of your bank accounts and manage your checkbooks and bank balances the program uses another table named Ledger representing the general ledger that contains all bank transactions of your company Cheque Factory also uses this table to record automatically any printed or voided cheque Fields that may appear in red in this are fields that would not be part of a cheque configuration MySQL datasource When you select MySQL data source and you click Browse button the MySQL connection settings dialog box is displayed 7 MySQL connection settings eannectian settings ata source name Database name server D atafile localhost User root Save Cancel Enter the real parameters of your MySQL configuration and click Save Cheque Factory connects to your database searches for a table named Cheques and determines the names types and sizes of the fields of the table The result is displayed in this erid Structure SelField Type width Id Integer i Date op Date am V Pavee id Character 20 E yy lt gt Cheque Factory user manual
34. to check the degree of precision in the information overlay on the corresponding boxes in the Print Preview window Remarks Cheque Factory only accepts images with resolutions between 96 and 100 DPI otherwise it prompts you to perform conversion of resolution for the scanned image 25 Cheque Factory user manual V Inserting and organizing objects 1 Using predefined fields Cheque Factory provides two types of predefined fields The fields provided for checks setups Other fields can be used for other types of documents to print They are automatically inserted into a new document if you select them in the Options dialog box gt General New document Passwords eh Predefined fields Sizes v Select all Amount in words 1 Amount in wards 2 Deselect Company You can also insert them into your document by choosing Insert gt Cheque member ou Insert gt Other field Via the context menu right click Insert Cheque Factory also provides four predefined sizes of document sizes which you can change at any time during the setup 26 Cheque Factory user manual Fredefined sizes 5 18 0 8 0 O 28 7 em z 21 0 em 8 88 cm 5 08 6 67 cm x 2 54 Column print order From left to right From top to bottom Note Cheque Factory prints columns by default from left to right but it is possible to do it from top to bot
35. tom Insert a cheque member Cheque Factory considers a new document or even a document currently edited as a setup cheque if it contains at least the following four fields Amount Amount in words 1 Payee and Date The internal names of these fields are Amount and Payee_Name Date_op Amount in words is a created field Cheque Factory uses these fields for its specific use multiple documents or to extract and convert data from different supported types of file formats Internal Description name This field contains the amount in numbers Created This field contains the amount field in words Created This field contains the amount field in words Payee_name This field contains the name of the payee 27 Amount Cheque Factory user manual Locality Locality This field contains the name of the locality Note1 This field may contain any other information related to Cheque origin of the transaction Note2 This field may contain any other information related to Cheque origin of the transaction Add another field Other fields may be used for other types of documents to be printed Cheque Factory uses them for its specific use multiple documents or to extract and convert data from different supported types of file formats NECI ON C NN NENNEN CIC NK CEN Address line 2 Address2 This field contains the second line of an address Address line 3 Address3 This field contains the third line of an a
36. ure SelField Type Date rr Payee 19 Standard Description Standard z lt gt Remarks The fields that appear in green in this grid are the fields in the Cheques worsheet their names should be Date_Op Payee_ID Description Amount The order of columns of the Excel worksheet does not matter To print cheques the program uses another worksheet named Payees representing the table that contains the names of payees Cheque Factory user manual To print other reports and ensure the management of your bank accounts and manage your checkbooks and bank balances the program uses another worksheet named Ledger representing the general ledger that contains all bank transactions of your company Cheque Factory also uses this worksheet to record automatically any printed or voided cheque The cells format chosen for all columns including those generated will be respected and used for the rest of the Excel sheet Fields that may appear in red in the grid are fields that would not be part of a cheque configuration MS Access database mdb accdb When you select an MS Access database Cheque Factory searches for a table named Cheques determines the names types and sizes of the fields of the table The result is displayed in this structure SelField Type Width Date Date Payee id Character 255 Z Description Character 255 8 z lt gt Remarks The fields that appear in green in
37. xPro database the program searches a table named Cheques dbf determines the names types and widths of the fields that make up this table The output is displayed in the Structure grid Structure 5 elField Width Date Date oe Paves id Character 20 E Descriptio Character BO lt gt Remarks The fields that appear in green in this grid are the fields in the table Cheques dbf their names should be Date_Op Payee_ID Descriptio Amount To print cheques the program uses another table named Payees dbf representing the table that contains the names of payees Cheque Factory user manual To print other reports and ensure the management of your bank accounts and manage your checkbooks and bank balances the program uses another table named Ledger dbf representing the general ledger that contains all bank transactions of your company Cheque Factory also uses this table to record automatically any printed or voided cheque Fields that may appear in red in this grid are fields that would not be part of a cheque configuration Excel workbook xls xlsx When you select an Excel workbook XLS or XLSX the program searches a worksheet named Cheques determines the field names from the first row of this worksheet Sizes are determined from the first cell of the second row of the worksheet Format is displayed using the representation of Excel for example 9 15 the type string or text format Struct
Download Pdf Manuals
Related Search