Introducing :

1. Introducing: The Lawson Excel template for Media Specialists

2. What is the Lawson Excel Template? The Lawson Excel Template is a specially designed template that can be used to create title lists for books and AV materials that can be uploaded into Lawson to create purchase orders.

3. What are the advantages of using the template instead of entering data directly into Lawson? • Lawson does not allow for the use of attached lists, therefore each title must be entered into Lawson as a line item. • Vendors, which agree to provide this service, may enter titles for you or you may enter the titles yourself.

4. What are the advantages of using the template instead of entering data directly into Lawson? • Entering titles on the template takes less time than entering titles into Lawson. • You do not need a Lawson account if you use the Excel template to create book or AV materials orders.

5. How does the template work with Lawson? • The completed template can be uploaded into Lawson to create Lawson book and AV materials requisitions. • Library Technical Services will be responsible for uploading the data.

6. Renaming and Saving Your Template • You should save and rename your template BEFORE you enter data into it. • Open the RQ10 Requisition Template in Excel. • Go to the file menu and select SAVE AS. Highlight the File name RQ10 Requisition for Library. • Follow the directions to type a new name for your file.

7. Naming your new file • The file name should be made up of the school name, the vendor name, and the date. • Example: Alafia Follett 2-16-04

8. Naming Other Files • Every file should be given a unique name. • If you create two order lists for the same vendor on the same date, you should add a letter at the end of the date. • Example: Alafia Follett 2-16-04 and Alafia Follett 2-16-04A • Click Save to create a new file. The file will have the name you typed in the File Name box. The original template file, RQ10 Requisition for Library, will still exist under its old name.

9. What do I do if I damage my template? • You can download a copy of the RQ10 Requisition for Library Template from IDEAS. • Log on to IDEAS and then open the Media Specialists folder on the IDEAS desktop. • Next, open the Excel Lawson Template folder. • The file and a copy of the manual will be inside the folder for you to download.

10. Entering Data • The Lawson Excel template contains column headings in rows 1 and 2 which MUST NOT be changed or deleted. • The column headings in row 1 correspond to specific fields in Lawson. For example, in column A, row 1, the corresponding Lawson field title is f4:REQUESTER. The column headings in row 2 describe the information which should be entered into cells in that column. For example, in column A, row 2, the field description is Site.

11. Entering Data Step-By-Step Column A f4:REQUESTER Site • The media specialist enters the school site number into each cell of column A in each row that has a book or video title listed.

12. Quick Tip • Enter the site number for the first book or video title only. • Then use the Excel Fill Down feature to fill in the site number in the remaining cells. • The Fill Down command can be done after all the titles have been entered.

13. Excel Fill Down Directions • Enter data into the first empty cell of the column. • Click on the cell to select it. • Then with the mouse button still pressed, drag the mouse down the column to highlight the cells that need to be filled. • Click on the Edit Menu to select it. • Select Fill from the Edit Menu. • Select Down from the Fill Menu.

14. Column B R16:REQ-LOC R=Ship To school • The media specialist enters the school site number plus the letter R into each cell of column B in each row that has a book or video title listed. • (For example, if the school site number is 0041, the media specialist enters 0041R.) • Enter the R as an upper case letter. • The Rmust be entered in order for the order to ship to the school.

15. Quick Tip • Enter the site number plus the letter R for the first book or video title only. • Then use the Excel Fill Down feature to fill in the site number plus R in the remaining cells. • The Fill Down can be done after all the titles have been entered.

16. Column C f6:REQ NO Assigned by Lawson • The media specialist DOES NOT enter data into any cells in Column C. • The Lawson Requisition number is assigned by the Lawson program and will be added by Library Technical Services when the requisition is created.

17. Column DF47:RQH-VENDOR NO VENDOR NO • The media specialist enters the NAME of the vendor in only one cell of column D. • Example: The media specialist enters the vendor name once. • Library Technical Services enters the vendor number when the requisition is created. • Example: Library Technical Services replaces the vendor name withthe vendor number.

18. Column E f111:PURCH-MAJOR MANDATORY • The media specialist enters LIBR into each cell of column E in each row that has a book or video title listed. • This is a Mandatory field for Lawson so the data MUST be entered.

19. Quick Tip • Enter LIBR for the first book or video title only. • Then use the Excel Fill Down feature to enter LIBR in the remaining cells. • The Fill Down can be done after all the titles have been entered.

20. Column F f133:LINE-COMMENT-CODE PROCESSING CODE MANDATORY • The media specialist enters a processing code into each cell of column F that has a book or video title listed. • This is a Mandatory field for the requisition so the data MUST be entered.

21. Processing Codes

22. Quick Tip • Enter the processing code for the first book or video title only. • Do not fill down.

23. Reminder – Processing Charges • If the vendor charges for processing, then the charges must be entered as the last line item on your template.

24. ColumnGf 59:LINE-FC A=Add • The media specialist enters the letter A into each cell of column G that has a book or video title listed. • The letter A allows Lawson to add the item to the requisition. • Enter the A as an upper case letter.

25. Quick Tip • Enter the letter A for the first book or video title only . • Then use the Excel Fill Down feature to enter the letter A into the remaining cells. • The Fill Down can be done after all the titles have been entered.

26. Column H f61:RLN –ITEM TITLE (MUST BE ENTERED WITHOUT COMMAS) • The media specialist or a vendor enters one title per cell in column H. • WARNINGThe titles MUST BE ENTERED WITHOUT ANY PUNCTUATION OR SYMBOLS. • Lawson will not except titles with commas.

27. Column I f62: QUANTITY QUANTITY • The media specialist or the vendor enters a quantity for each title in one cell of column I.

28. Quick Tip • Use the Excel Fill Down feature to save time if the same quantity is used for each title. • Enter the data only in one cell and then use Fill Down to enter the same quantity into the remaining cells.

29. Column J f63:UOM UNIT OF MEASURE • The media specialist or the vendor enters the unit of measure for each title.

30. Quick Tip • The unit of measure must be only 2 letters & must be in caps • Use the Excel Fill Down feature to save time if the same Unit of Measure is used for each title. • Enter the data only in one cell and then use Fill Down to enter the same UOM into the remaining cells.

31. Column K f64:UNIT-COST UNIT COST • The media specialist or the vendor enters the unit cost of one book or AV title per cell in Column K. • DO NOT ENTER FREE ITEMS AS LINE ITEMS. • Free items are entered in the comments section of the requisition by Library Technical Services. • WARNING ! DO NOT ENTER DOLLARS SIGNS $$ OR COMMAS IN COLUMN K.

32. Reminder • Shipping Charges :If the vendor charges for shipping, the charges must be entered as thefirst line item on your template. • Processing Charges: If the vendor charges for processing, the charges must be entered as the last line item on your template.

33. Column L f66:DESCRIPTIONITEM TYPE (BOOKS, VIDEOS, ETC.) • The mediaspecialist or the vendor enters the Item Type of one book or AV title per cell in Column L

34. Quick Tip • Use the Excel Fill Down feature to save time if the same Item Type is used for each title. • Enter the data only in one cell and then use Fill Down to enter the same Item Type into the remaining cells.

35. Column M f68:VEN-ITEM VENDOR ITEM # OR ISBN # • The media specialist or the vendor enters the Vendor Item Number or the ISBN # for each title. • Vendor Item Number -The number assigned to the item by the vendor. • ISBN – (International Standard Book Number) - a unique number assigned to a book by the publisher.

36. Column N f 69:ACCNT-UNIT SITE+PROJ+PROG+FUNC • The media specialist enters the accounting units into Column N. • Enter one account code per cell for each title.

37. Quick Tip • Use the Excel Fill Down feature to save time if the Accounting Unit is used for each title. • Enter the data only in one cell and then use Fill Down to enter the same data into the remaining cells.

38. Site+Proj+Prog+Funcex.0041 9999 610 6200 • Accounting Unit DescriptionSite=Site -The 4 digit school site numberProj=Project -The 4 digit project number assigned to this accountProg=Program -The 3 digit program number assigned to this accountFunc=Function-The 4 digit function number assigned to this account

39. Help Tip • Enter numerals only- No spaces or symbols between numbers. • Lawson Accounting Unit Conversion Charts are located in the appendix of the manual. • and from the Home menu of the Lawson system.

40. Column O f70:ACCT Object • The media specialist enters the 3 digit object code into Column O. Enter one object code per cell for each title.

41. Quick Tip • Use the Excel Fill Down feature to save time if the same Object code is used for each title. • Enter the data only in one cell and then use Fill Down to enter the same Object Code into the remaining cells.

42. Help Tip • Lawson Object Conversion Charts are located in the appendix of the manual • and from the Home menu of the Lawson system.

43. Column P f72:DIST-CO Fund • The media specialist enters the three digit Fund number. The Fund number is referred to as COMPANY in the Lawson system. In this Lawson field, Company means the School District.

44. Quick Tip • Use the Excel Fill Down feature to save time if the same Fund Number is used for each title. • Enter the data only in one cell and then use Fill Down to enter the same Fund Number into the remaining cells

45. Help Tip • Lawson Fund Conversion Charts are located in the appendix of the manual • and from the Home menu of the Lawson system

46. Column Qf 108:OVERRIDE COST Use Requisition Cost • The media specialist enters the letter Y in each cell of Column Q that has a title.

47. Quick Tip • Enter the letter Y for the first book or video title only. • Then use the Excel Fill Down feature to fill in the letter Y in the remaining cells. • The Fill Down can be done after all the titles have been entered.

48. Column R TOTAL LINE ITEM CALCULATES TOTAL • The media specialist and the vendor do not enter data into Column R. The line item total is calculated automatically as the quantity is entered into column I and the unit price is entered into column K.

49. Column S RESERVED FOR LIBRARY TECHNICAL SERVICES USE • The media specialist and the vendor do not enter data into Column S.

50. Column T Grand Total • The media specialist and the vendor DO NOT ENTER data into Column T. • The grand total is calculated automatically as line items are entered.