; Order Holds
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Order Holds

VIEWS: 12 PAGES: 146

  • pg 1
									      DETAILED PROCESSING
            SCRIPTS




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc   Page   1
      08/22/11
TABLE OF CONTENTS

DETAILED PROCESSING SCRIPTS ..................................................................................................................................... 1

TABLE OF CONTENTS............................................................................................................................................................. 2

BUSINESS COMPUTER SYSTEMS LTD.............................................................................................................................. 5
        Warren Pidhirny, CEO........................................................................................................................................................... 5
        Kevin Tribe, President............................................................................................................................................................ 5
        Bob Stinson, VP ...................................................................................................................................................................... 5
        Tom Wilson, VP ...................................................................................................................................................................... 5
WINSOL STRUCTURE.............................................................................................................................................................. 6
    STANDARD WINSOL MODULES: ................................................................................................................................................. 6
    OPTIONAL WINSOL MODULES AND FUNCTIONS: ...................................................................................................................... 6
FORMATS & CONVENTIONS .............................................................................................................................................. 29

CHAPTER TITLE ..................................................................................................................................................................... 29

SUPPORT .................................................................................................................................................................................... 31
    SUPPORT TABLES....................................................................................................................................................................... 31
      Customer Inquiries ............................................................................................................................................................... 31
INVENTORY CONTROL........................................................................................................................................................ 40
    DISPLAYS ................................................................................................................................................................................... 40
      Display Product Availability................................................................................................................................................ 40
ORDER & BACKORDER CONTROL ................................................................................................................................. 47
    PROCESS ORDERS/QUOTES ....................................................................................................................................................... 47
      Enter Orders/Quotes ............................................................................................................................................................ 47
BACKORDER CONTROL ...................................................................................................................................................... 57
        Creating Backorders ............................................................................................................................................................ 58
        Disabling Backorders........................................................................................................................................................... 58
        Backorder Reports................................................................................................................................................................ 60
        Backorder Displays .............................................................................................................................................................. 64
        Backorder Priority................................................................................................................................................................ 66
        Releasing Backorders........................................................................................................................................................... 67
PRE-ALLOCATING IN-TRANSIT INVENTORY ............................................................................................................. 72
        Allocating In-Transits........................................................................................................................................................... 72
        Allocations Displays ............................................................................................................................................................. 73
        Allocation Reports ................................................................................................................................................................ 74
        Allocation Warnings ............................................................................................................................................................. 74
PURCHASING............................................................................................................................................................................ 76
    MAINTENANCE .......................................................................................................................................................................... 76
      Maintain Purchasing Information ....................................................................................................................................... 76
    ENTER PURCHASE ORDERS ....................................................................................................................................................... 82
      Create Purchase Orders ...................................................................................................................................................... 82


 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                                                                              Page            2
       08/22/11
    RECEIVE STOCK......................................................................................................................................................................... 89
      Enter Receipts/In-Transits.................................................................................................................................................... 89
INVOICING ................................................................................................................................................................................ 97
    RETURNED MERCHANDISE AUTHORIZATION........................................................................................................................... 97
      Returned Merchandise Entry ............................................................................................................................................... 97
COMMISSIONS AND ROYALTIES ..................................................................................................................................... 99
    COMMISSIONS / ROYALTIES ...................................................................................................................................................... 99
      Maintain Commission Rates ................................................................................................................................................ 99
      Maintain Royalty Rates ...................................................................................................................................................... 102
ACCOUNTS RECEIVABLE ................................................................................................................................................. 104
    CASH RECEIPTS AND ADJUSTMENTS ...................................................................................................................................... 104
      Post Cash Receipts/Adjustments ........................................................................................................................................ 104
ACCOUNTS PAYABLE ......................................................................................................................................................... 107
    PROCESS INVOICES .................................................................................................................................................................. 107
      Enter Invoices ..................................................................................................................................................................... 107
    DISPLAYS / REPORTS / DIAGNOSTICS ...................................................................................................................................... 111
      Display Vendor Accounts ................................................................................................................................................... 111
    PROCESS COMPUTER CHEQUES .............................................................................................................................................. 112
      Print Cash Requirement Report......................................................................................................................................... 112
      Alter Cash Requirement ..................................................................................................................................................... 113
    PROCESS MANUAL CHEQUES.................................................................................................................................................. 114
      Enter Manual Cheques / Adjustments ............................................................................................................................... 114
GENERAL LEDGER .............................................................................................................................................................. 117
    ENTER JOURNAL ENTRIES ....................................................................................................................................................... 117
      Enter Journal Vouchers ..................................................................................................................................................... 117
    MAINTENANCE ........................................................................................................................................................................ 118
      Maintain Standard Journal Entries ................................................................................................................................... 118
    DISPLAY / DIAGNOSTICS ......................................................................................................................................................... 118
      Display Account Transactions ........................................................................................................................................... 118
ORDER HOLDS ....................................................................................................................................................................... 120
    CREDIT LIMIT HOLDS .............................................................................................................................................................. 120
    DELINQUENCY HOLDS ............................................................................................................................................................ 125
    MINIMUM ORDER VALUE HOLDS........................................................................................................................................... 127
    SHIP COMPLETE HOLDS .......................................................................................................................................................... 129
    MANUAL HOLDS...................................................................................................................................................................... 133
MULTIBIN INVENTORY CONTROL ............................................................................................................................... 135
        Bin Creation and Maintenance.......................................................................................................................................... 135
CUSTOMER PART NUMBERS ........................................................................................................................................... 139

SPECIAL PRODUCTS PROCESSING ............................................................................................................................... 144
    CREATING SPECIAL PRODUCTS............................................................................................................................................... 145
    FOLLOW-UP MAINTENANCE ................................................................................................................................................... 147
    RE-CODING SPECIAL PRODUCTS ............................................................................................................................................. 147
WAREHOUSE REPLENISHMENT .................................................................................................................................... 149
        Inventory Adjustment Transfers ......................................................................................................................................... 149
        Direct Transfers .................................................................................................................................................................. 150


 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                                                                            Page           3
       08/22/11
       In-Transit Transfers............................................................................................................................................................ 155
EXCLUSIVE PRODUCTS ..................................................................................................................................................... 162

REPLACEMENT COST CALCULATION ........................................................................................................................ 166
   BULK CHANGE MAINTENANCE SCREEN ................................................................................................................................ 168




 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                                                                         Page           4
       08/22/11
BUSINESS COMPUTER SYSTEMS LTD.

  An Enterprise Software Supplier with an 18-Year Track Record of
            Steady Growth and Customer Satisfaction
For more than 18 years, Business Computer Systems Ltd. has been committed to developing the
market's best business technology solutions for wholesale distributors. Creating innovative products that
provide continuous improvement for customers.

Warren Pidhirny, CEO

Warren is the founder of the firm. As a graduate of the University of Western Ontario with a Degree in
Computer Science, a large multi-national company hired Warren early in the 1970's. He rose to the
position of National Software Coordinator, then left to become a Partner in a large application software
development firm. In 1980 he formed BCSL with a mandate to develop leading edge accounting and
inventory control systems for distributors. Today Warren is the cornerstone of the BCSL design
philosophy and programming standards and manages our development team.

Kevin Tribe, President

Kevin is responsible for business planning and new account development. Graduating from the University
of Western Ontario with a Degree in Business Administration, Kevin worked with a number of
international computer firms in sales, marketing, and business planning roles. He joined BCSL in 1988.
Kevin's sixteen years experience provides BCSL with a solid understanding of the computer industry and
its trends, successful software marketing and development practices, and sound business planning
strategies.

Bob Stinson, VP

Bob is responsible for managing installations and provides a variety of consulting services for our clients.
Bob graduated from the University of Toronto with a Bachelor's Degree in Industrial Engineering and a
Master's Degree in Business Administration and is registered in Ontario as both a Professional Engineer
and a Chartered Accountant (1975, 1977) He was a Manager in the consulting practice of Arthur
Andersen & Co. with responsibility for their distribution and manufacturing clients. While there, he became
familiar with BCSL's software systems, and he subsequently joined a BCSL client as CFO. After working
closely with BCSL for several years, Bob joined the firm in 1983. With his many years of extensive
experience, Bob provides a strong foundation for application software and business practices consulting.

Tom Wilson, VP

Tom is a graduate of the University of Toronto's Computer Science program, with a minor in Commerce.
His experience in this industry since 1978 includes positions of Programmer, Analyst, Manager and
Director of Software. He joined BCSL in 1988 as one of the division managers responsible for account
implementation and on-going support




 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    5
       08/22/11
WINSOL STRUCTURE

Standard WinSol Modules:                   Optional WinSol Modules and
                                           Functions:
         Inventory / Purchasing:
         IM – Inventory Maintenance                Modules:
         IC – Inventory Control                    WH – Multibin Warehouseing
         PI – Physical Inventory                   CT – Contract Billing
         PO – Purchasing                           SE – Service
                                                   EI – EDI
         Sales:                                    RS – Retail Sales
         SU – Support                              RCS – Remote Customer Service
         OE – Order Entry
         IN – Invoicing                            Functions:
         SA – Sales Analysis                       RMA – Returned Merchandise
                                                   Authorization (IN65 – IN69 & IN88)
         Financial Systems:
         AP – Accounts Payable
         AR – Accounts Receivable                  Laser Forms:
         Gl – General Ledeger                      Invoice
                                                   Purchase Order
         Setup and Utility Systems:                Accounts Receivable Statement
         CC – Company Control                      Quotation
         RM – Recode / Merge                       Bill of Lading
         JS – Job Streaming
                                                   Integrated Third Party
                                                   Products:
                                                   I.Q. – Intelligent Query Report Writer
                                                   MARS – Purchase Planning System
                                                   Radio Beacon – R.F. Warehouse
                                                   Management System
                                                   Fax




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc        Page   6
      08/22/11
FORMATS & CONVENTIONS
                    This document has been created using certain formats and conventions which are
                    standard throughout. For your reference, these styles are listed here:




                                  This heading designates a chapter title. The chapters of this
CHAPTER TITLE                     document correspond to the main program cycles of WinSol.




Chapter Sub-Title        This heading identifies a major title within a chapter.



               Heading                     This heading identifies a main point within a chapter.


Body text                         Descriptive text and narrative will be formatted in this style.



    Action Point                 Action points require you to DO something. You may be asked to
                                  click a button using the mouse, or type something on the keyboard.


 Further detail                  Where additional information is required to explain options or
                                  choices you must make in the program, the description of these options will
                                  be formatted in this style.

    Tips                          Where shortcuts exist or when important information must be highlighted, a
                                  TIPS box will be used to highlight the text.

                                  This icon indicates a main topic for discussion that may only be appropriate
                                  for certain clients. During your demo, you may choose to skip over one point
                                  to the next if that option is not applicable for the customer to whom you‟re
                                  giving the demo.

Type                              The word „Type‟ in this document means that you will be required to key
                                  some data into WinSol by means of the computer keyboard.

Click                             The word „Click‟ in this document means that you will be required to position
                                  your mouse cursor over the appropriate icon, then press and release the left-
                                  hand mouse button once.

Double-click                      The word „Double-click‟ in this document means that you will be required to
                                  position your mouse cursor over the appropriate icon, then press and release
                                  the left-hand mouse button twice, quickly.



 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                              Page        29
       08/22/11
Select                      The word „Select‟ in this document means that when presented with a list box
                            or a drop box, you will be required to highlight a record from the choices listed
                            by double-clicking on the record, or by positioning the highlight bar with your
                            cursor keys, then pressing [Enter].

[Enter] or [Tab]            Words set apart with square brackets represent keys on the keyboard that
                            you will be required to press.




 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                      Page     30
       08/22/11
SUPPORT
                 The Support System controls the maintenance of the Customer Master file and all related
                 tables. The Customer Master supports the Accounts Receivable, Order Entry, Invoicing,
                 Retail Sales, Returned Merchandise Authorization, and Sales Analysis systems, since all
                 of these systems access the Customer Master file.


Support Tables
                 The Support Table programs are used to build and maintain the supporting tables for the
                 Customer Master File. These tables contain user-defined codes that are subsequently
                 assigned to each customer record. These programs include programs that maintain
                 classes of trade, jurisdictions, invoice terms, sales territories, salesreps, sales groups, ship
                 via codes, and attention codes.


         Customer Inquiries

            Place your cursor in the white box in the top left hand corner of the screen and type
             SU45 [Tab].

                 The Customer Inquiries program (SU45) consolidates many frequently accessed lookup
                 routines into one simple to use, powerful, and intelligent query screen.

                 To display a customer‟s account information, simply type the customer code in the
                 „Customer‟ box then press the Tab key. If you‟re unsure of the proper customer code, or
                 perhaps if your company has chosen numeric customer codes, a „lookup‟ window can be
                 displayed by pressing the ? button located directly to the right of the „Customer‟ box.

            Type the code BUSCOM in the „Customer‟ box then              [Tab].

                 Immediately after pressing the Tab key, the customer‟s full name, address, and phone
                 number are displayed along with other important pieces of information.

                 Much more information about this customer is available in each of the „tabbed folders‟
                 displayed in the bottom two-thirds of this screen. These additional queries are organized
                 into three main groupings:

              The Accounts Receivable programs display information about this
               customer‟s account status and payment history.

              The Orders and Sales programs display a customer‟s specially quoted
               pricing, their current orders/quotes/invoices, and their outstanding
               consignment inventory.

              The Sales programs display valuable information about this customer‟s
               overall sales, and their sales grouped by commodity or by product.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page     31
      08/22/11
                 You can access each of these programs by either clicking on the appropriate button with
                 your left mouse button, or by clicking on the folder tab corresponding to that program. The
                 capitalized and underlined letters in the description of each button correspond to the letters
                 on each tab.

            Click on the button A/R STATUS to display Folder T.

                 Near the centre of the A/R Status folder are lines which show you this customer‟s current
                 month-to-date sales from this year, with the figures from the same period last year on the
                 very next line. Additionally, the customer‟s Average Days to Pay (A-days) reports the
                 customer‟s payment frequency, while the High A/R Balance shows you the point at which
                 this customer‟s outstanding balance was highest.

                 The box immediately to the right details this customer‟s current status. In addition to
                 viewing the customer‟s credit limit, their outstanding account balance, and their remaining
                 credit, you can see the value of any shippable open orders for this client, and the value of
                 any post-dated cheques.

            Click on the tab for Folder C to display post-dated cheques.

                 As you can see, in the month of October, the customer Business Computer Systems has
                 submitted a post-dated cheque which will become valid in January. A single click has
                 displayed further information useful in determining this customer‟s overall status.
                 Returning to the summary information screen as another single click away.

            Click on the tab for Folder T.

                 In the centre of the Customer Status display screen near the bottom of the window is a
                 box showing this customer‟s delinquency days. Delinquency days are defined as the
                 number of days late a customer remits payment on an invoiced sale after their agreed
                 upon terms, e.g. a customer making a payment 45 days after the date of the invoice on
                 which Net 30 Day terms were extended would be 15 days delinquent.

                 This display box lists both the entered and the calculated delinquency days. The entered
                 delinquency days are maintained in the Customer Master file and set the point at which
                 new orders for this customer will be held. The system will automatically hold new orders
                 and shippable backorders for a customer when their calculated delinquency days exceed
                 their entered (or allowable) delinquency days. This feature allows you to consider both a
                 customer‟s credit limit and their payment timeliness in deciding whether or not to ship.

                 You‟ll notice that when switching folders some information remains constant. The
                 customer‟s address & phone numbers appear along the top of the window as a header as
                 each folder is accessed. To assist you in navigating between folders, the name of the
                 folder is displayed along a line at the bottom of each folder beginning at the left side of the
                 screen. In the same line at the right side of the window is the current system date.

            Click on the tab for Folder E.

                 The Open Items display lists each open invoice for this customer in summary, and allows
                 you to find the detail associated with each invoice and each payment.

                 For each invoice listed on the summary screen, you can quickly see the reference number
                 (or invoice number), the A/R terms of that invoice beside the original date of the invoice,
                 the total debit to the customer‟s account along with any credits applied to that invoice and

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     32
      08/22/11
                 the resulting balance owing. Additionally, beneath the overdue column is a period
                 indicator which reports to you the overdue category into which each invoice falls, i.e. 1-30
                 days, 31-60 days, etc.

                 Open invoices are displayed on this summary list, as are paid invoices (until you decide to


                                                                                           Customer Notes




                                                                                       Overdue Totals




                                                         Quick Link to A/R Collection Letter
                 purge them). Payments on each invoice can be easily displayed by selecting the invoice
                 then pressing the Payments button.

            Click the invoice N002501, then click the Payments button.

                 In this example, $3000.00 was paid against this invoice in the middle of October, while the
                 remainder was submitted at the end of the month. In each case, the date of payment, the
                 amount of payment, and the customer‟s cheque number is displayed.

            Click the X in the top right corner of the payments window to close this display.

                 In our example, the two cheques combine to pay the invoice in its entirety. The combined
                 total of all payments is displayed in the Credit column, and the resulting outstanding
                 balance, which in our example is zero, is shown in the column at the right of the window.

                 Quite often when making collection calls, the customer will ask what products were
                 invoiced on a particular shipment. To display the original invoice on screen, simply select
                 the invoice you wish to view and press the Invoice button in the bottom left hand corner of
                 the screen.

            Select invoice N002638 then click the Invoice button.

                 Upon pressing the Invoice button, you‟re shown an on-screen version of the original
                 invoice. At this point in the conversation, you‟ll be able to tell the customer exactly what
                 was billed on this invoice, and in what quantities it was shipped. As a security feature, the
                 display of product costs can be restricted on an operator by operator basis. If your
                 operator code is set to allow the product costs to be displayed, the invoice lines will appear
                 with the product costs shown in the rightmost column.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     33
      08/22/11
                 If the customer were to say, “I‟m sorry, but I didn‟t receive that invoice, so I can‟t pay you
                 until I have a copy.” Located at the top of this screen is a button labelled Fax; by pressing
                 this button, you‟ll be able to immediately fax to your customer a copy of the invoice he or
                 she has requested. In this scenario, your response would simply be, “I‟m sending it right
                 now, please watch for it on your fax machine.”

            Click   in the top right corner of the Invoice History window to close this display.

                 If your business occasionally offers customers the opportunity to pay in installments, you
                 have the ability to view the payment schedule by selecting the appropriate invoice from the
                 list and then pressing the Installments button.

            Select invoice N003002.

            Click the Installments button.

                 The terms of the original invoice in our example were 10% due in 30 days, 70% due in 60
                 days, and the remaining 20% due in 90 days. The installment window shows each
                 installment, the date on which each is due, and the amount due.

            Click    in the top right corner of the Installments window to close this display.

                 Based on your conversation with the customer, you may need to produce a formal
                 collection letter. By clicking on the Microsoft Word® icon, you can capture the important
                 information about this customer and import it directly into a pre-formatted collection letter,
                 thus saving time and effort. If the PC from which you‟re working has faxing capability,
                 you‟ll even be able to fax this letter directly to the customer from where you‟re sitting.

            Click the Microsoft Word® icon.

                 WinSol addresses the letter to the accounts payable contact it has stored on the customer
                 master file, inserts the customer address into the header of the form, and even signs the
                 letter with a bitmapped copy of your signature.

            Click    in the top right corner of Microsoft Word® window to exit the program.

            Click on the tab for Folder M.

                 The Payment History display is organized by customer cheque number. To see an on-
                 screen copy of the original invoice, simply select the invoice then press the Invoice button
                 in the bottom right-hand corner of the screen.

            Click on the tab for Folder R.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     34
      08/22/11
                 This Customer/Product Pricing program is primarily used by customer service to answer
                 stock status questions and questions related to a customer‟s selling price for a specific
                 product. Based upon entry of the customer code, product code and proposed order
                 quantity, the pricing routine will calculate and display the selling price that would be
                 charged should that order be placed. The sales extension and method used to calculate
                 the price (ie, group pricing, quantity break pricing, flyer pricing, etc.) will be displayed.
                 Current quantity balances for the product are displayed, with automatic links available to
                 check expected dates for outstanding purchase orders and allowable substitutions should
                 sufficient stock not be available.

            Click on the     button at the top right-hand corner of the SU45 Customer Inquiries
             window. This will set aside the window temporarily.

            In the white box at the top of the WinSol welcome screen, type IM13          [Tab].

                 This is the Product Master File maintenance screen.

            In the product field of program IM13, type 2003       [Tab].

                 Beneath the label Classifications/Groupings, is a field for Commodity. Commodity codes
                 are used to categorize products into various product line with product group sub-divisions.
                 The structure of the four-character commodity code is then a combination of two
                 components: a Product Line code (two characters) and a Product Group code (two
                 characters).

                 An example of a character structured commodity code strategy follows. Numerical or
                 mixed commodity code structures are common too. The line/group sorting is the objective
                 of the coding strategy.

                 Commodity            Product Line     Product Group        Description

                 WMBR                 WM               BR        Widgets - Metal, Bronze
                 WMGL                 WM               GL        Widgets - Metal, Gold
                 WMSL                 WM               SL        Widgets - Metal, Silver
                 WPBL                 WP               BL        Widgets - Plastic, Bakelite
                 WPPE                 WP               PE        Widgets - Plastic, Pete1
                 WPPL                 WP               PL        Widgets - Plastic, Polypropylene
                 WWCD                 WW               CD        Widgets - Wooden, Cedar
                 WWOG                 WW               OG        Widgets - Wooden, Old Growth Red
                 Cedar
                 WWRW                 WW               RW        Widgets - Wooden, Red Wood

                 Every product code must be assigned to a commodity on the inventory master file. If
                 implemented correctly, the distribution of products across product lines & groups
                 (commodities) will provide a powerful level of summarization on inventory and sales
                 reports that can be sequenced, detailed or restricted by commodity code ( Commodity
                 Display & Reporting). The Customer Pricing and Sales Rep. Commissions systems can
                 also be configured to use the commodity coding as a base.

            Click     in the top right corner of the IM13 screen to close this program.

            In the white box at the top of the WinSol welcome screen, type IM18          [Tab].

                 This is the Maintain Group/Customer Pricing screen.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page       35
      08/22/11
            In the Customer entry box, type the customer BUSCOM             [Tab].

                 In this example, the customer Business Computer Systems has been extended a special
                 price for all products in the commodity CPPA – Computer Products, Paper & Labels. This
                 customer has been given a discount of 10% with particular starting & ending dates.

                 Let‟s enter an additional pricing structure for this customer. Create a 20% discount on all
                 Computer Products beginning immediately with no ending date.

            In the Commodity Code box, type CP**         [Tab].

            Tab to the Pricing Type box and type a letter D       [Tab].

            Tab to the % box and type 5      [Tab].

            Click the Update button.

                 Now, Business Computer Systems will receive a 10% discount on Computer Paper &
                 Labels, and a 5% discount on all other Computer Products.

            Click on Folder 2 Specific Products.

            Double-click on the product code 2004 listed in the detail display box.

                 Special prices can also be given to customers for specific products. In our example,
                 Business Computer Systems will receive a special fixed price of $35.00 on the computer
                 paper with product code 2004.

            Click     in the top right corner of the IM18 screen to close this program.

            Click on the Customer Inquiries button located on the taskbar at the bottom of your
             screen (this is the program you minimized earlier).

            In the product code box of the Customer Inquiries – Customer/Product Pricing screen,
             type the product 2003 [Tab].

                 In the centre of this screen you‟ll see the three levels of quantity breaks defined for this
                 product in the Product Master file maintenance screen. Even though the list price for this
                 product is $45.50, you‟re prompted with the special price of $40.95 for this product
                 because of the special 10% discount that we previously viewed in the Customer/Product
                 Pricing program.

            In the quantity box, enter 13     [Tab].

                 The price that is now suggested to you is the quantity break 3 price because it is less than
                 the specially discounted price of $40.95. The system will use „best price logic‟ to calculate
                 the best possible price for this customer/product combination.

            In the product code box, enter the product 2004        [Tab].

                 You‟ll notice that the price suggested to you is the specially fixed price of $35.00 rather
                 than that of the standard quantity breaks.

            In the product code box, enter the product 2001        [Tab].

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page     36
      08/22/11
                 The price that is now reported to you is the flyer price, for this product is currently offered
                 on a flyer. Through settings on the Customer Master file, you may determine how many
                 or how few of the special pricing routines may be used to determine the best price for your
                 customer. In this way, you‟ll find that the pricing program is powerful yet flexible.

            Click on the tab for Folder Q.

                 Note: BUSCOM should be in the Customer box. If not, key it in and press tab.

                 This folder displays order information by customer. The information window displays the
                 order number; the Ship Document Number; the Customer number; Date of the Order; the
                 Customer Purchase order number; total shippable value of the order; any holds put on the
                 order; the Invoice Number if the order has been invoiced; the status of the order and the
                 warehouse the order was entered in.

            Click on order number N02158.

            Click on the Display Details button.

            Click on the detail line in the order.

                 This shows you the order and backorder details.

                 The bottom window shows you the expected receipt date.

            Click     in the top right corner of the screen to close this window and go back to the
             Display Orders window.

            Click on the order number N02158 01, directly under the one that is currently
             highlighted.

            Click on Display Details button.

                 This shows detail information regarding the original order.

            Click on the More Header Info button.

                 This shows you more information such as how the order was shipped, who the order was
                 taken by, the terms code and if there was a commission split.

            Click on the OK button to return to the Display Details window.

                 This window also has a fax button, which would allow you to fax the order information
                 directly from the display window.

            Click on the Note Pad button in the top right hand corner by the Fax button.

                 This feature allows you to enter notes relating to this sales order.

            Click    in the top right corner of the screen to close this window.

            Click    in the top right corner of the screen to close this window.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page      37
      08/22/11
            Click on the tab for Folder V.

                 Note: BUSCOM should be in the Customer box. If not, key it in and press tab.

                 Note: 2001 should be in the product box. If not, key it in and press tab.

                 This folder displays the invoice history for the customer by product by invoice.

                 The information window displays the invoice numbers, the date of the invoice, the quantity
                 shipped, the price the product was invoiced at, the type of pricing the customer received,
                 the discount if there was one given, the profit margin and the cost for that product.

                 Security can be set by password to allow display of profit and cost.

                 This product shows three different pricing methods: Quantity Break 3, Flyer and Quantity
                 Break 1.

            Click on the tab for Folder Y.

                 Note: BUSCOM should be in the Customer box. If not, key it in and press tab.

            Click on the first record button (The first arrow).

                 The first commodity code is displayed.

                 This window displays comparative sales information regarding the product within this
                 commodity that was sold to this particular customer.

                 The arrow buttons can be used to move the display forward or backward by commodity.

            Click on the All button.

                 This window displays comparative sales information regarding all products that were sold
                 to this particular customer.

            Click on the tab to Folder B.

                 Note: The customer BUSCOM should be in the Customer box and ALL should be in the
                 Commodity box.

                 This window displays comparative monthly sales information regarding all products that
                 were sold to this particular customer.

            Click on the tab for Folder S.

                 This folder displays Product sales information by customer.

                 Note: The customer BUSCOM should be in the Customer box.

            Click in the Start at Product box, Key in product code 1001        [Tab].

                 This window displays product sales information, for this particular customer, starting with
                 the product code 1001 showing total number of units, total dollars, and last date that
                 product was purchased.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page   38
      08/22/11
                 You can scroll down to view more product sales information.

            Click on the tab for Folder I.

                 This folder displays product that is currently out on consignment by customer.

                 Note: The customer BUSCOM should be in the Customer box.

            Click on the detail line item for product code 3102.

            Click on the Movement button.

                 This window displays detail information regarding the unit out on consignment such as the
                 date of the Invoice, the Invoice number, the line number on the Invoice, the specific TAT
                 code assigning the product to consignment, the product type, the quantity and the cost of
                 the unit.

                 When products are invoiced with the Consignment TAT code, the inventory within that
                 warehouse is depleted and added to the consignment inventory. Year-end will include
                 consignments and link them to the regular inventory.

            Click      in the top right corner of the screen to close this window.

            Click          in the top right corner of the screen to close this window and exit the
             program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     39
      08/22/11
INVENTORY CONTROL

Displays
                   This suite of programs is used to perform product related inquiries across several WinSol
                   applications. Inventory quantities and costs, sales and booking statistics, consignment
                   and serial/lot inventories, outstanding orders and purchase orders, pricing and substitution
                   masters are just some of the inquiries provided.


           Display Product Availability

              Place your cursor in the white box in the top left corner of the screen, type IC45
               [Tab].

              With the cursor flashing in the Product box, type 2001       [Tab].

                   Once the product code has been entered, the product description and all quantity
                   balances are displayed for the warehouse selected. This summary of information remains
                   at the top of the screen as you move from folder to folder.

              Click on Options in the top left corner.

              Click on Warehouse.

                   This window displays all warehouses.

              Click on 02-Montreal and then click on OK.

                   The information displayed is now for Warehouse 02-Montreal.

              Click on Options, Warehouse, 01-Toronto and OK.

              Place your cursor in the beginning of the Product box, press the delete key to delete
               product code 2001, type 3101 [Tab].

                   Below the Product box is the Picture icon used to view a picture of the product.

              Click on the Picture icon.

              Click     in the top right corner of the Picture to close.

              Click on the forward arrow to view the next product code.

                   The product code 3102 should now be in the Product Box.

              Click on the Picture icon.

              Click     in the top right corner of the Picture to close.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page     40
      08/22/11
            Click on the forward arrow to view the next product code.

                 The product code 3103 should now be in the Product box.

            Click on the Picture icon.

            Click     in the top right corner of the Picture to close.

                 Folder 0 is an Index of all the product display options. The letters within the Index that are
                 capitalized and underscored are the ones used to label each folder. You can access the
                 folders by clicking on the tab corresponding to that letter or by clicking on the button in the
                 index.

            Click in the beginning of the Product box, press the delete key to delete the product
             code 3103, type 2001 [Tab].

            Click on the button labelled All waRehouses.

                 This folder displays information regarding the status of the product for all warehouses with
                 a total at the bottom.

            Click on the tab for Folder T - Bin Location, Lot/Serial numbers.

            Click in the beginning of the Product box, press the delete key to delete the product
             code 2001, type 4001 [Tab].

                 This will display the current inventory status of a lot/serial number for the selected
                 warehouse. Quantity Available is what is available for new sales orders/invoices. As well
                 as displaying the quantity on reserve for customer orders, any quantity reserved on
                 outstanding work orders is also displayed. If the serial number/lot is in-transit or on
                 consignment, those quantities are displayed. The date that the serial/lot record was
                 created, the expiry date and any hold flag are displayed.

            Click on the Display Movement button.

                 This window displays a complete history of all transactions affecting the quantity balance
                 for a serial number/lot (receipts, sales, outstanding commitments to sales orders, and
                 inventory adjustments)

            Click     in the top right corner to close the movement display.

            Click in the beginning of the Product box, press the delete key to delete the product
             code 4001, type 5001 [Tab].

            Click on the Display Movement button.

            Click     in the top right corner to close the movement display.

            Click on the tab for Folder C - Inventory Costs.

            Click in the beginning of the Product box, press the delete key to delete the product
             code 5001, type 2001 [Tab].



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     41
      08/22/11
                 This program displays quantity on hand and inventory costs by product for the warehouse
                 selected and can be password protected. Weighted average cost, latest cost and current
                 replacement cost (per the primary supplier) are displayed.

            Click on the tab for Folder M – Inventory Movement

                 This program displays inventory movement transactions that affect the on hand balance of
                 a product (I.e.: stock receipts, units sold or returned, stock adjustments, physical counts,
                 etc.). When discrepancies between computer quantities and physical count quantities
                 occur, this display and historical Inventory Movement reports can be used to trace a
                 product‟s activity.

                 Sales transactions may be passed to the Movement Master file:

                 -   In full detail: a record is written for each invoice/credit note detail line

                 -   As a daily total: the total movement for the day‟s invoicing is written by product.

                 -   As a month total: the total movement for the month‟s invoicing is accumulated by
                     product.

                 Movement history may be retained for a month, quarter, half year, or any other desired
                 block of time. The Movement File is purged at the discretion of the user via program
                 Purge Inventory Movement, depending upon how much history is desired.

            Click on the tab for Folder X – Explosion.

            Click in the beginning of the Product box, press the delete key to delete the product
             code 2001, type 1100 [Tab].

            With the cursor flashing in the Qty box, type in 130           [Tab].

                 This program is used to check stock availability for assembled sets. The set product code
                 and the quantity required are entered. The program will display the quantity available in
                 pre-packed stock and will also examine stock availability for the set‟s component products
                 and will display how many units could be produced if assembled from components.

            Click on the tab for Folder I – Consignments.

            Click in the beginning of the Product box, press the delete key to delete the product
             code 1100, type 3101 [Tab].

                 This program will display consigned inventory in consignee/product or product/consignee
                 sequence. Display of the consignment average cost and movement transaction costs are
                 password protected.

            Click on the Display Movement button.

                 This displays the Consignment movement history, which lists details of all transactions that
                 affect the consignment balance.

            Click     in the top right corner to close the movement display.

            Click on the tab for Folder Q – Open Orders.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                             Page     42
      08/22/11
                 This program displays details of all orders, backorders or quotes that are outstanding for a
                 specific product.

                 It identifies who is waiting for a product or who has outstanding quotes for a product. The
                 user will be informed if an order/backorder is on hold for any reason. Future orders will be
                 included in the display with the date required.

                 This display may be particularly useful when filling backorders manually (I.e.: the user is
                 deciding who gets how much of a product) or when notifying customer‟s of a delay in
                 shipment of a certain product.

            Click in the beginning of the Product box, press the delete key to delete the product
             code 3101, type 2001 [Tab].

                 The user may choose to restrict the display by selecting an option on the bottom of the
                 screen, to orders only, backorders only, quotes only or all transaction types. The option to
                 view All is the default in this example.

            Double-click on the last order number N02504.

                 Information regarding the order appears in the bottom window. I.e.: Accept Backorders is
                 checked.

            Click on the Order Look-up button in the bottom left.

                 This takes you out of IC45 and into OE45, which is Order Display and shows you all
                 details for the specific order.

            Click on the More Header Info button.

                 This displays more information regarding the Customer.

            Click     in the top right corner to close the display.

            Click     in the top right corner to close the OE45 display.

            Click on the tab for Folder E – Future Orders.

                 This program displays future order detail lines by product. Details are displayed in date
                 required sequence. As well as the customer code, order number, order date and quantity
                 on future order, this program also displays three dates that control the various stages of a
                 future order:

              Date Required is entered when the order is taken and is the date by which
               the this order must be delivered.

              PO Action Date is the date on which the purchasing department must start
               including this future order in any purchasing decisions.

              Release Date is the date on which the future order will be turned into an
               active order. Stock will get committed and the picking slip will be produced
               on this day.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     43
      08/22/11
              A future order detail line is flagged status “f” if it is so far in the future that it
               doesn‟t even impact purchasing decisions.

              A future order detail line is flagged status “F” if it is in the window of time
               between affecting purchasing decisions but is not yet ready to release into
               a live order.

                 The status of a future order detail line is updated by the Release Future Orders program,
                 which changes an order from “far future” to “near future” to “shippable” by comparing the
                 dates described above to the run date of the release program.

            Click on the tab for Folder V – Invoice Lines

                 This program displays invoiced product detail lines in product/customer sequence. It can
                 be used to find out how often a customer has purchased a specific product or to check
                 pricing on past sales to a customer.

            With the cursor flashing in the Customer box, type in BUSCOM and tab.

                 Details are displayed from the Invoice History Master file and include:

              Invoice number; invoice date; quantity shipped; unit price, price type (I.e.:
               price override, quantity break price, contract price, etc. which is valuable
               information if a customer is asking for the same pricing as a previous
               order) per unit of measure, discount and extension.

              The cost associated to that invoice detail line and the calculated gross
               margin percent may optionally be included in the display and is password
               protected.

            Click on the tab for Folder Y – Sales Year to Date

                 This program displays sales statistics by product for the warehouse selected.

                 „This Year‟ statistics are updated by the Invoice Scheduling program, which is typically run
                 once at the end of each day, reporting true „to-date‟ values. Current/next month statistics
                 are rolled by the Close Sales Fiscal Period program, run each month end once all sales
                 reports for the current month closing have been printed.

            Click on the tab for Folder B – Sales by Month.

                 This program displays unit sales and dollar sales by month for the current and previous
                 fiscal years. Statistics are reported by product for a selected warehouse. This is quick
                 way to view sales trends for a specific product.

            Click on the tab for Folder S – Sales by Product/Customer.

            With the cursor flashing in the Customer box type in BUSCOM            [Tab].




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     44
      08/22/11
                 Sales statistics for the customer code entered or for all customers who have purchased
                 this product since the specified „Sales Since‟ date and before the „Sales Until‟ date will be
                 displayed.

            Click on the tab for Folder 1 – Outstanding Purchase Order.

                 This program displays details for outstanding purchase orders by product for the selected
                 warehouse.

                 NOTE: All PO quantities are expressed in STOCKKEEPING UNITS, not buying units.

            Click on the tab for Folder 2 – Purchase Order Information.

                 This program displays information relevant for purchasing decisions.

                 Twenty-four month‟s of demand (not sold) unit history plus demand for current/next
                 month‟s is displayed.

                 Purchasing criteria (ROP-reorder point, ROQ-reorder quantity, Maximum quantiy,
                 Forecast, Lead-time, etc) that relates to the Automated purchasing in viewed in the right
                 side of the window. In the bottom of that same window you will find supplier promo from/to
                 dates, purchase price and discount information, and PUM – Purchasing Units of
                 Measure.buying-to-stock-keeping conversion.

                 Knowledge of booking trends, supplier promotions, your own promotions and your current
                 stock levels will help a purchasing agent make good purchasing decisions.

            Click on the tab for Folder 3 – Purchase Order History.

                 This program will display purchasing history information by product.

            Click on the line displayed.

            Click on the Details button on the bottom right corner.

                 Details regarding the selected purchase order will be displayed.

            Click     in the top right corner to close the display.

            Click on the tab for Folder 4 – Product/Supplier Information.

                 This program displays purchasing information (lead-time, standard pack size, buying unit
                 of measure and price) by product for each supplier. For products with secondary
                 suppliers, this program allows the purchasing agent to easily compare delivery and pricing
                 factors between suppliers.

                 The bottom window will display information pertinent to the supplier for the line item that is
                 highlighted.

              A check mark will appear in the Primary Supplier box for the supplier that
               is indicated as the Primary Supplier in the Supplier Master.

            Double-click on Supplier Code CARSUP.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     45
      08/22/11
                 The bottom window now displays information regarding this selected supplier.

              The Primary Supplier box is now empty.

            Click     in the top right corner to exit IC45.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page    46
      08/22/11
ORDER & BACKORDER CONTROL
                 The Order Entry System controls customer orders from the time of input until they are
                 invoiced. Items are shipped from stock or may be put on backorder until purchased and
                 received from suppliers.

                 Shippable-orders produce shipping documents that are used by the warehouse to fill the
                 order. The completed shipping document is used to confirm quantities shipped and is
                 used as the source document to initiate invoicing of shipped orders.

                 Backorders are created when an order is entered and there is insufficient stock available
                 to fill the order or when an order is invoiced and an item is short-shipped. Backorders are
                 typically released automatically on a first-come-first-served basis when stock becomes
                 available. If a personal touch is required in dealing with backorders, then they can be
                 released manually by order, by product or by customer, or selected customers may be
                 flagged with a higher “backorder priority” code which will insure that their backorders are
                 filled first.

                 The Order Entry System integrates automatically with the Inventory Control, Invoicing and
                 Accounts Receivable systems.


Process Orders/Quotes

         Enter Orders/Quotes

            Type OE30     [Tab].

                 Immediately upon entering the Order Entry program, you must choose which sales office
                 in which you will be working. A warehouse is a physical location where product is stocked
                 and shipped. A sales office could also be a physical location, but it is defined as the
                 location from where an order originates. Sometimes they are one and the same. For
                 example:
                     Sales orders taken by the Toronto sales office are shipped out of the Toronto
                     warehouse. Toronto is a sales office and a warehouse.
                     Sales orders taken by the Montreal sales office are shipped out of the Toronto
                     warehouse. Montreal is a sales office only.
            Select the Toronto Sales Office.

                 The following steps show you how quickly orders can be keyed into WinSol. Although
                 WinSol allows each operator to key a large volume of detailed and specific information
                 about each order during order entry, with just a little practice, orders and quotes can be
                 very quickly and accurately entered and processed.

            Type BUSCOM in the customer field         [Tab].

            Click OK when the Alternate Ship to codes prompt is displayed.

            Press the [Tab] key once to move the cursor to the Purchase Order number field.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     47
      08/22/11
            Type 123456 in the Purchase Order field           [Tab] [Tab].

            Type 1 in the Sales Source field        [Tab].

            Click on folder tab 3.

            In the product field, type 3001       [Tab].

            Type a quantity of 2 in the Quantity box [Enter].

            Type the next product 3002          [Tab].

            Type a quantity of 1     [Enter].

            Type the last product 3003      [Tab].

            Type a quantity of 4 [Enter].

             Click on the New Order button.

                 Let‟s examine some of the detailed information associated with each sales order or
                 quotation. Because not all of these fields are mandatory ones which require information to
                 be entered, you the operator are empowered to be as detailed as you feel is necessary to
                 satisfactorily enter a sales order. The information on the order header will not only
                 describe this order, but will also control how this transaction is handled throughout the
                 sales order, picking, shipping, invoicing cycle.

            Type the customer code BUSCOM                [Tab].

            Click OK when the Alternate Ship to Locations are Available prompt is displayed.

            Click the query button      beside the Ship To box.

                 The Maintain Ship-To Addresses program manages a table of frequently used ship-to
                 addresses by customer. It is also able to mange two special types of ship-to records that
                 can be defined to flash a messages onto the transaction programs as the client is
                 accessed, or print a messages on documents for that customer.

            Scroll the list box to the top and then double-click the DOOR14 ship to address.

            Press [Tab].

            Enter 123456 in the Purchase Order box            [Tab].

                 WinSol tracks customer purchase orders; if a purchase order number (other than the
                 current Blanket #) is used against an account more than once, an informative warning
                 message will alert you with the original order number that referenced the purchase order.
                 When you receive this warning, you should ensure that you are not accidentally entering
                 the transaction a second time after you accept the message. This may be normal for
                 some customers but not for others; you may consider describing the customer's re-use of
                 purchase orders in the Customer Notes database so that others will have access to the
                 information on-line.

            Click OK on the PO number has been duplicated warning box.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                            Page      48
      08/22/11
            Click    on the Ship Via box.

            Double-click the Federal Express ship via code.

            Press [Tab].

            Click    next to the Source box.

                 Source codes allow you to specify from where each order originated. By tracking how
                 many orders and how much money was earned from a Trade Show, for example, you‟ll be
                 able to determine the overall effectiveness and profitability of your participation in that
                 show. Likewise, you‟ll be able to monitor the traffic on your fax machine, and identify how
                 many orders are taken over your trade counter.

            Double-click the Trade Show source code.

            Press [Tab].

                 If a customer does not accept backorders and an order is placed for which stock is not
                 available, the order line will be printed on the shipping document with the quantity shipped
                 and the quantity backordered set to zero. A note at the bottom of the order will indicate
                 that backorders were cancelled. When this document is shipped and invoiced, the
                 cancelled lines are printed on the invoice with the word “CANCEL” in the extension
                 column. By showing the cancelled lines on both documents, you ensure that the
                 purchaser will see the cancelled backorders and re-order accordingly (i.e. the shipping
                 document may go to a remote warehouse with the merchandise, while the purchasing
                 department may only receive the invoice).

                 When the Ship Complete option is selected, the order handling process will not schedule
                 the order until all backorders on the order can be filled. This option is typical if the
                 customer accepts only complete shipments. When enabled, an order with backorders will
                 be placed on Ship Complete Hold by one of the order handling processors and no
                 shipping document will be produced until the last backordered line quantity is reserved
                 from stock for the order (its completion).

                 When the Ship Complete option is not selected, the order will be eligible for scheduling by
                 the order handling process and, if the Accept B/O option is enabled, will backorder the
                 quantities that can not be filled at that time. This is the default option.

                 When the B/O Complete option is selected, the initial order will be eligible for scheduling
                 by the order handling process. If the initial scheduled order results in a backorder, the
                 backorder will be placed on Ship Complete Hold by one of the order handling processors
                 and no shipping document will be produced until the last backordered line quantity is
                 reserved from stock for the order (its completion).

                 When the B/O Complete option is not selected, the backorder will be eligible for
                 scheduling each time any backorder quantity (even only a portion of the backorder
                 quantity of one line) can be reserved from stock for the order.

                 When the Manual Hold option is selected, the order will be ineligible for scheduling by the
                 order handing processors, and will be held on Manual Hold until the option is disabled in
                 the Enter Orders & Quotes or the Release Orders on Hold programs.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    49
      08/22/11
                      The GST Registration Number field is designed to capture the customer's GST license
                      number. The default GST Reg. No. is copied from the GST # field of the Customer Master
                      and a value must be provided in this field if GST is to be charged.

                      The PST License field, is designed to capture the customer's PST (Provincial/State Tax)
                      License number for the purposes of exempting the customer from those taxes. The
                      default PST License is copied from the PST # field of the Customer Master and a value is
                      only provided in this field if PST is to be exempt.

                 Click on the Folder 3 tab.

                 Type part number 1001        [Tab].

                 Type a quantity ordered of 1        [Tab].

                 When the insufficient stock message appears, click the YES button.

                      The Substitute Maintenance program is used to set up a cross-reference of valid
                      substitute products for any given product. If the original and substitute products are of
 Product              equal quality, price and character (meaning they are interchangeable), the substitute is
Substitutes           flagged “equivalent” which causes a reverse cross-reference record to be automatically
                      generated (ie, product “A” is an equivalent substitute for product “B” and vice versa).

                      Substitute products are also assigned a priority code. At order entry time if the product
                      entered is out of stock, that product‟s substitute products may be displayed (in priority
                      sequence). The operator may optionally choose to select a substitute product in place of
                      the original product ordered. Substitutions may also be displayed in the Display
                      Customer Pricing program, which is commonly used by customer service for customer
                      stock/pricing inquiries. If the product in question is out of stock, its substitute products can
                      be easily displayed as alternate suggestions to the customer.

                 Double-click on the product code 1002.

                 Click the UDI button.

                      User Defined Information is additional information or instructions about a product or group
                      of products that is over and above the product description. This information may be in the
                      form of open text or may be presented as a set of instructions, product specifications, a
                      quality control checklist, etc.

                 Click    .

                 [Tab] to move to the Qty order field.

                 Type a quantity of 1     [Enter].

                  The discount provided exceeds the maximum allowable for this product.

                 Click Ok in the Discount warning box.

                 Type the part number 1003        [Tab].

                 Click the UDI button.


 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                               Page     50
       08/22/11
                  Notice the difference between the user defined information blocks for products 1002 and
                  1003.

             Click    .

             [Tab] to move to the Qty order field.

             Type a quantity of 2    [Enter].

             Click Ok in the Discount warning box.

                  Customer pricing tables and group pricing tables may define a discount %, markup % or
                  fixed price for a specific product or group of products. Applicable customers are linked to
                  a pricing table via fields Customer Price Code or Group Price Code in the Customer
Special           Master File record. The common price table defines a discount %, markup % or fixed
Pricing           price for specific products only.

                  These tables are examined by the pricing routine which looks for the best price from
                  customer pricing tables, group pricing tables, the common price table, flyer pricing tables
                  and quantity break prices.

                  The following examples depict typical pricing structures:

               All industrial accounts receive a 30% discount on all plumbing supplies
                (Product Line 01) except for bathroom fixtures (Commodity 01BF) which
                receives a 20% discount. All other products are discounted at 15%.

               Industrial account BUSCOM receives 40% on ALL plumbing supplies and
                a fixed price of $115.00 on product 01AS1000.

               Customer XYZCO receives 20% off ALL products.

             Type the product code 2004         [Tab].

                  Notice that the pricing type prompt has changed to reflect the method by which the system
                  has arrived at this „best price‟ for the customer.

             Type a quantity of 3    [Enter].

             Type a product code of 2002        [Tab].

                  Notice the special pricing that WinSol has prompted you to use for this customer, and
                  notice also that the pricing method has changed to reflect this customer‟s discount from list
                  price.

             Type a quantity of 4    [Enter].

                  WinSol provides tools that allow you to edit your work on-screen, thus avoiding
                  unnecessary re-keying when correcting mistakes is required.

             From the detail line display, double-click on product code 2002 to edit the line.

             [Tab] to the price field, then type an override price of 25.00       [Enter].

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page        51
      08/22/11
                  Notice the gross margin warning. On a product by product basis, you may set both an
                  acceptable upper and lower gross margin limit. At order entry time, if these parameters
                  are not met, you will be presented with the warning dialogue box which informs you of
                  potential gross margin violations.

              Click OK.

                  Inventory models are defined as any number of individually stocked products that, when
                  sold collectively, make up a unique inventory item. Unlike Assembled Sets, the
                  components for a model may vary from sale to sale.
Models &
Options           When defining a Model, a product code is created using the Maintain Inventory Master
                  program and its product Type is set to MO for Model. Once created, the Model product is
                  identified on the Models folder of the Models Maintenance program and then Components
                  and Sub-Assemblies are assigned to it to build the model.

                  Components are regular product code records that are also created using the Maintain
                  Inventory Master program; as fully functional products, components can be managed
                  using all of the regular features and benefits of the Purchasing and Inventory Control
                  systems for forecasting, replenishment and handing. When a component is assigned to a
                  model, it can be configured:

                   As a mandatory or optional part of the model.

                   With a minimum and maximum number of units that can be selected
                    for the model during order entry.

                   To contribute to the cost of the model as a whole.

                   To print, or not to print, as a sub-detail line on orders and invoices.

                  Sub-Assemblies are groups of Components, or even other Sub-Assemblies, which are
                  created using the Sub-Assemblies folder of the Models Maintenance program.
                  Components are assigned to a sub-assembly in the same way as a component is
                  assigned to a model. Sub-Assemblies however, are assigned to both Models and other
                  parent sub-assemblies, by configuring:

                   A minimum and maximum number of items from the sub-assembly
                    that can be selected.

                   Whether the system should prompt for optional group items for cases
                    where no minimum selection is required from the items in the sub-
                    assembly, say a group of related options.

                   Whether the group should print on build slips.

                   Whether the up-charged prices from the group items should be added
                    to the models base price.

                  Once a Sub-Assembly has been created, it can be assigned to a Model or to another Sub-
                  Assembly. Assigning sub-assemblies to sub-assemblies allows you to build multi-level


 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                      Page    52
       08/22/11
                    models that can be configured to support very detailed inventory management and pricing
                    structures with ease. The number of sub-levels is unlimited.

               Type product code 1201         [Tab].

                    Note that the price for this model is currently $0.00. This is so because the overall cost
                    and sell prices for this model will be based on which components or options you choose to
                    include when building the model.

               Type a quantity of 1      [Enter].

                Note that the program positions the cursor on the price field since it is still set to zero.

               [Enter] to accept the price of 0.00.

               Double-click on product 6002.

                    Note that an „*‟ has been placed between the Level and Component columns and a
                    number 1 has been placed in the rightmost column to indicate that this line has been
                    chosen as a component of the model.

               Click OK.

               Double-click on product 5002.

                    Note that an „*‟ has been placed between the Level and Component columns and a
                    number 1 has been placed in the rightmost column to indicate that this line has been
                    chosen as a component of the model.

               Click OK.

               Double-click on 3003.

               Type a multiple of 4, then click OK.

               Click OK.

               Double-click on product code 4003.

               Type a multiple of 2, then click OK.

               Click OK.

               Click OK.

               Click OK.

                    Notice that when the model building is complete, WinSol will explode the model header
                    into individual detail lines for purchasing, picking, and packing.

                    Assembled Sets are defined as any number of individually stocked items that, when sold
                    collectively, make up a unique inventory item. You may stock and sell the set already
Assembled           “pre-packed” or you may stock only the components and assemble the set only when new
Sets                orders are received.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                                Page     53
      08/22/11
            Type product code 1100       [Tab].

            Type a quantity of 2    [Enter].

                 You‟re immediately prompted with an on-screen display of all of the goods which make up
                 the assembled set.

            Click OK to accept the Assembled Set.

                 The structure of the product code allows for the attachment of a meaningful character
                 suffix to the end of the product code. This suffix must occupy the last positions of the
Colour           product code and must be proceeded with a separator character. It may denote colour,
and/or           size, etc. For example:
Sizes
                 Product Code                   Colour Code

                 1000-BLUE                      Blue
                 1000-GREEN                     Green
                 2000-SM                        Size Small
                 2000-MD                        Size Medium

                 The high-order characters “1000” identify the root or common product.

                 “Common products” are defined as a series of products sharing the same high-order
                 characters exclusive of the colour/size suffix. They share common master file coding and
                 pricing and their “Common Product Flag” is set to “Y”. The common master file fields are:

                 Commodity Code                         Federal Tax Rate Code
                 Record Type                            Provincial Tax Rate Code
                 Stock Keeping Unit                     Standard Ship Pack
                 G/L Code                               Quantity Break Code
                 Minimum Gross %                        Price Per
                 Maximum Discount %                     Selling Prices
                 Tax Included Flag                      Catalogue Page (primary/secondary)

                 These fields will be equal for all common products. Special updating routines trigger the
                 automatic updating of corresponding common products whenever any of the above fields
                 for any one of the common products is changed. (IE: If prices are changed for a common
                 product, the prices for all corresponding common products will also be updated.)

                 Note that the Purchase Order system similarly passes common coding and pricing from
                 one common product to others. The common Purchasing Information master file fields
                 are:

                 Purchasing Unit of Measure             Price per U/M
                 Standard Pack                          Discount %
                 Convert Purchasing U/M to SKU          Currency Code
                 Weight per U/M                         Duty Code
                 Purchase Price                         Freight Rate/Code

                 This is necessary to maintain the integrity of the product‟s replacement cost (stored in the
                 Inventory Master File record and used in price recalculation formulas that recalculate
                 selling prices based upon markup % applied to replacement cost).


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    54
      08/22/11
                      Products may be reviewed and reports may be printed in product code sequence.

                 Type the product code 1101-*       [Tab].

                      You can place an order for a specific colour or size of this product, or for all colours and
                      sizes. Using the mask *, you‟ll be able to quickly enter an order when the customer asks
                      for one of each colour or size.

                 Click YES.

                 Type a quantity of 3    [Enter].

                      Features of the Serial/Lot Control module…

Lot Controlled/        controls serial/lot numbers on a product by product basis
Serial Numbered        captures lot numbers at time of receipt or as required through the stock
Products                adjustment routine.
                       serial numbers may be captured at time of receipt or at time of
                        invoicing (set via a flag in the product master file record) and as
                        required through the stock adjustment routine.
                       allows assignment of lot holds
                       allows entry of a comment on a lot header record
                       tracks inventory movement of each lot/serial number
                       flags order lines for “ship complete lots only”
                       tracks shelf life
                       tracks warranty periods
                       provides facility to modify, re-code and adjust existing lots and serial
                        numbers
                       produces physical inventory count sheets or tags to facilitate counting
                        and reconciling inventory by lot or serial number

                 Type product code 4001       [Tab].

                 Type 1 [Enter]

                      A lot / serial number commitment window will appear. This window will be used to select a
                      serial numbered item to commit for this sales order. Serialized items may be committed at
                      order entry time, as in this example, or when the item is invoiced.

                 Click on the Bin / Lot / Serial button.

                 Select serial number 25001

                 Click on the Update button.

                 Click on the No button to finish the commitment.



                      If your customers require you to reference their part numbers on packing lists, invoices,
                      and quotations, WinSol provides you with the tools to maintain the cross-reference and
 Customer
 Part
 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                             Page    55
 Numbers
       08/22/11
                 print the documents. Additionally, not only you provide the customer with the information
                 required, but you‟ll also be able to search and query your in-house product database using
                 the customer‟s part numbers. WinSol will even allow you to enter orders by keying solely
                 the customer‟s reference numbers, thus saving valuable time and avoiding the chance for
                 errors.

            Type BCS305      [Tab].

                 This is NOT an in-house product code, but in fact a customer product code. You will be
                 able to enter orders directly from the telephone because your customers need only refer to
                 their own part numbers with which they are familiar.

            Click OK to accept the notice that a backorder is already on file.

            Type a quantity of 1      [Enter].

            Click OK to accept the notice that there is insufficient stock available to fill future
             orders nearing their release date.

            Type BCS405      [Tab].

                 Notice that this is another customer product code, and that your in-house product code is
                 also displayed on the screen.

            Type a quantity of 1      [Enter].

                 Graphics can be displayed to further describe and display images of the products you sell.
                 In this way, your customer service people can be assured that they‟re shipping the proper
                 goods with each and every order.

            Type the product code 3101           [Tab].

            Click the       button to display a picture of this product.

            Click the OK button to collapse the picture display.

            In the product code field, enter product 3103     [Tab].

            Click the       button to display a picture of this product.

            Click the OK button to collapse the picture display.

                 When the order is complete, you may simply go on to the next order or exit the order entry
                 screen, as your order has been saved continually as it was entered.

            Click the                    button to update your order a final time and clear it from the
             screen.

            Click on the X in the top right corner to exit OE30.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page    56
      08/22/11
BACKORDER CONTROL
                 The Backorder Control tutorial reviews the features and benefits WinSol offers in terms of
                 the Internal Stock Control and Internal Backorder Control methods.

            Run Company Control Initialization (CC00) and switch to the OE tab.

                 The Company Control Initialization (CC00) for Order Entry includes option groups to select
                 the Stock Control Method and Backorder Control Method.

                 Stock Control in Order Entry is the process that determines what quantity of product will be
                 committed for an order to ship from the available inventory and what quantity will be
                 backordered. Stock Control occurs at the point when a request for a quantity of a product
                 code is made from the Inventory Control system. WinSol supports two methods of Stock
                 Control, Internal and External.

                 External Stock Control sets the Ship Quantity equal to the Order Quantity. Typically, only
                 the Quantity Ordered column is printed on the picking slip. The warehouse picks what
                 they can and notes the shipped quantity on the picking slip. All changes are entered when
                 the order is invoiced. External stock control allows the user to begin processing orders
                 prior to a final physical count and total switchover to computerized inventory control.
                 External Stock Control can not be used with Internal Backorder Control.

                 Internal Stock Control in the Order Entry system will calculate the quantity to-ship and
                 backorder from the entered order quantity automatically as each line item is entered onto
                 an order. The quantity to-ship and backorder values will be based on availability from the
                 Inventory Control system at the time the line is committed to the system. If there is
                 sufficient availability to fill the entire ordered quantity, the Internal Stock Control system will
                 commit the entire quantity to the order as reserved stock; there would be no backorder
                 quantity in this case. If there is insufficient availability to fill the line, the Internal Stock
                 Control system will calculate the quantity of inventory available to-ship (which could be
                 zero or more), commit that quantity to the order as reserved stock and then calculate the
                 remainder that will become the backorder quantity.

                 Backorder Control in Order Entry determines when backorder picking slips will be printed.

                 Under External Backorder Control, backorder quantities are entered at invoicing time after
                 the goods have been picked. As a byproduct of the invoicing cycle (typically processed
                 daily), backorders are cycled back to the Order Scheduling program. The next time orders
                 are scheduled/printed, the backorder picking slips will be printed and then filed until
                 manually reissued once stock has been replenished.

                 Internal Backorder Control will not produce a backorder picking slip until stock has been
                 received and the order is released by the Release Backorders (OE61) programs. Note
                 that backorders will not be released if an uninvoiced picking slip exists (i.e., you must
                 invoice the original shipment before a backorder picking slip will be printed).

                 There are some limitations associated with the use of External Backorder Control. Refer
                 to topic "Stock Control & Backorder Control Combinations" in WinSol Help.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                            Page      57
      08/22/11
                 The Backorder Control tutorial will highlight Internal Stock Control with Internal Backorder
                 Control methods as it provides the most efficient level of automation of the other
                 combinations WinSol provides.

            Press [Escape] to close the Company Control Initialization (CC00) program.

                 Backorders are created by WinSol when Available inventory for a item can not be
                 reserved for an order. With the Internal Backorder Control method, WinSol holds
                 backorders until inventory becomes available to fill them. The Release Backorders
                 (OE61) program handles this process by examining the current inventory position by
                 product or by customer, reserves the inventory to fill the backorder and releases
                 backorders for scheduling once applicable order hold conditions are met.

                 This tutorial will review some of the programs and conditions that affect the creation of
                 backorders, the release of backorders, and backorder displays and reports.


         Creating Backorders
            Run the Enter Orders & Quotes (OE30) program and accept the default Sales Office.

            In the Customer field, access the Sherman Construction account, SHECON.

            Pick an order Source.

            Switch to the Lines tab by pressing [Alt + 3] or click it.

            Access the Product 1010.

                 In the Product Details display below the Product field you can see the current availability of
                 inventory for the 1010 product. There is zero available.

            Order a quantity of 10 and press [Enter] to update the line.

                 In the Lines list you can now see that WinSol has automatically assessed the inventory
                 position of the item and determined that no quantity of the item can be reserved at this
                 point to ship. It backorders the item and displays the resulting B/O and To Ship quantities
                 so that you can provide instant feedback to your customer in a live order entry scenario.

                 No special processing is required to create a backorder. They can be created on an order
                 with other items that were backordered and/or they can created on orders that will be
                 partially shipped. WinSol provides several automated order holds, including the Minimum
                 Backorder Value, Ship Complete and Ship Backorder Complete holds to assist in the
                 handling of backorders. The features and benefits of these holds were detailed previously
                 in the Order Holds Tutorial.

            Press [Alt + W] or click the New button to release the order and prepare for a new one.


         Disabling Backorders
                 Some customers prefer not to accept backorders. In some industries it is assumed that
                 backorders will simply by cancelled. WinSol provides support for the automatic notification
                 of backorder cancellation using the Accept B/O option.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     58
      08/22/11
            Leave the Enter Orders & Quotes (OE30) program running for use later in this tutorial.

            Switch to the WinSol program menu and run the Maintain Customer Master (SU13)
             program.

            Access the Rent-All customer, RENALL.

                 In the lower right corner of the Maintain Customer Master program is a group named
                 BackOrders. The first option in this group is the Accept B/O option that controls whether
                 or not the customer wishes to have backorders placed with you. If the option is checked,
                 WinSol will create backorders for the customer. If the customer does not accept
                 backorders, the option will be unchecked and orders placed for which no stock is available
                 will result in order lines printed on the shipping document with the quantity shipped and the
                 quantity backordered set to zero. A note at the bottom of the order will indicate that
                 backorders were cancelled. When this document is shipped and invoiced, the cancelled
                 lines are printed on the invoice with the word “CANCEL” in the extension column. By
                 showing the cancelled lines on both documents, you ensure that the purchaser will see the
                 cancelled backorders and re-order accordingly (i.e., the shipping document may go to a
                 remote warehouse with the merchandise, while the purchasing department may only
                 receive the invoice.).

                 Let's disable the Accept B/O option for this customer and examine the effects of doing so.

            Press [Tab] repeatedly until the focus is on the Accept B/O option and then press the
             [Spacebar] to disable the option. Or, click the Accept B/O option so that the check box
             is cleared.

            Press [Enter] to Update the account.

            Leave the Maintain Customer Master program running for use later in this tutorial.

            Switch to the instance of Enter Orders & Quotes (OE30) we left running earlier.

            Access the RENALL customer.

                 On the right side of the program, below the Transaction Type you will find the Accept B/O
                 option. Notice that it is not checked because the customer has been configured such that
                 they do not accept backorders.

            Press [Alt + 3] to switch to the Lines tab or click it.

            Access the Product 8200, order a quantity of 1 and press [Enter] to Update the line.

            Access the Product 1010, order a quantity of 2 and press [Enter] to Update the line.

                 A message appears informing you that you are about to cancel a quantity. This occurs
                 because the customer is configured not to accept backorders and this product has no
                 available inventory. WinSol is cancelling the backorder. If the line could be partially filled
                 form available inventory, for example if we had ordered 10 and 5 were available, WinSol
                 would ship the 5 and cancel the balance.

            Press [Enter] to accept the message.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     59
      08/22/11
                 Once the line is accepted and the Lines list is updated you can see that a quantity of two
                 was ordered, but zero are backordered and zero are to ship.

            Press [Alt + W] or click the New button to release the order and prepare for a new one.

                 Sometimes, a customer configured not to accept backorders will request that you make an
                 exception and backorder a quantity of an item. WinSol allows you to override the Accept
                 B/O option on an order by order basis to support this.

            Access the RENALL account.

                 Below the Transaction Type on the right side of the program is the Accept B/O option. For
                 the Rent-All customer, the default setting is that they do not accept backorders; the option
                 is disabled. We'll enable this option and examine the results of doing so.

            Enable the Accept B/O option: Press [Tab] repeatedly until the focus is on the Accept
             B/O option and then press the [Spacebar] to enable to option.

            Switch to the Lines tab: Press [Alt +3] or click it.

            Access the Product 1010, order a quantity of 4 and press [Enter] to Update the line.

                 Notice that WinSol has added the line to the order with a backorder quantity.

            Press [Alt + W] to release the order and [Escape] to close the Enter Orders & Quotes
             (OE30) program.

                 WinSol provides a number of displays and reports that access information about
                 outstanding backorders. Let's quickly review the reports before we use the displays to
                 learn about other WinSol Backorder Control functionality.


         Backorder Reports
                 From time to time you may to produce a hard copy of items on backorder or open orders
                 (which include backorders) for a customer. The Print Backorders by Product (OE51) and
                 Print Open Order Report (OE50) programs are capable of filling this requirement.

            Run the Print Backorders by Product (OE51) program.

            If you have a Print Device available, select it from the Print Selection list and skip those
             steps below which detail how to print the report to a file for viewing on the PC.

                 The Print Backorders by Product (OE51) program will print to the Screen device, but only
                 the summary the report will be visible. If you do not have access to a printer device, follow
                 the instructions below to print the report to a file and then view it using the Windows
                 Notepad.

            Select File on the Print Selection list and then press [Alt + T] or click the Options button.

            In the File field of the Print Options dialog, type 1010 and press [Enter] to accept it.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                            Page   60
      08/22/11
                 This will configure the WinSol print program to output the report to a text file that will be
                 named using the value of the File field plus an extension of .tmp and created in the
                 WinDemo folder on your computer.

            Press [Enter] again to accept the Print Selection dialog.

            Press [Enter] to accept the Warehouse Selection dialog.

                 The standard WinSol Report Parameters dialog will appear. The Print Backorders by
                 Product program provides several Sequences in which the report can be produced. We
                 will be using the default Product Sequence, which will allow us to specify a range to
                 include only the 1010 product that we created backorders for earlier. The two Supplier
                 sequences can be used to review the backorders in terms of whom the primary supplier is
                 for the products on backorder.

                 While the Sequence affects how we can Range the report From and To one or more
                 products or suppliers, the restrictions let us narrow down the report contents in a variety of
                 ways. For example, the purchasing department may wish to use the Buyer restriction so
                 that only a specific buyer's backorders are reported.

            Press [Tab] repeatedly until the focus is in the From field.

            In the From field, type 1010 and press [Tab] to accept it.

            In the To field, type 1010 and press [Tab] to accept it.

            Press [Alt + O] (that's the letter O as in OK) or click the OK button to begin the print
             program.

                 When you print reports to the File device using WinDemo the print program usually
                 finishes very quickly.

            Press [Alt + O] or click the OK button to accept the Report Complete dialog.

                 Now, in order to view the report that we printed to the file we need to locate the file in the
                 WinDemo folder. There are many ways of getting to that folder…the following is just one
                 the quickest, least painful methods, but it does requires that you know where WinDemo
                 was installed (usually C:\WinDemo…)

            Hold down the start [] key and press [R] to access the Windows Run dialog box. If
             your keyboard does not have a start [] key, you can hold down the [Ctrl] key and
             then press [Esc]; when the Start menu opens, press [R] to access the Windows Run
             dialog box.

            In the Windows Run dialog box, type C:\WinDemo and press [Enter]. If you installed
             WinDemo to some other volume than C, substitute the volume letter for x as in
             x:\WinDemo, or x:\…\WinDemo; wherever you installed it.

            When the Windows Explorer appears, press the letter [W]. This should cause the focus
             to jump to a file named…1010.tmp.

            Press [Enter] to open the file.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     61
      08/22/11
                 If your system has been configured to open .tmp files with a program already, the
                 1010.tmp file will open in that program at this point. If this is the case you can skip the
                 next two steps. Many systems however, do not know which program can display the .tmp
                 file that WinSol creates when you print to a file…any text or word processor will do. The
                 following two steps will register the Windows Notepad as the preferred program for
                 viewing .tmp files so that the next time you press [Enter] on a .tmp file notepad will display
                 it for you.

            In the Description field, type Temporary Text File and press [Tab]

            With the focus now on the list of programs, press [N] repeatedly until the NOTEPAD is
             selected and then press [Enter] to accept it.

                 The 1010.tmp text file, which is a copy of the Print Backorders by Product (OE51) report
                 for the 1010 product should not be displayed.

                 The report will show a header grouping for each product that includes its product code,
                 description, stock classification, ABC classification, and some key inventory availability
                 values. The column labels for the header grouping fields are included in the header
                 grouping; the column labels at the top of each page are for the detail lines. Below the
                 header a detail line will appear for each backordered line of the product. The detail line
                 includes information on who the backorder is for, what quantity was originally ordered,
                 what quantity has shipped already, what quantity is already reserved by WinSol for that
                 backorder, the number of cancelled units, and the quantity remaining on backorder waiting
                 to be filled.

                 Total lines appear for the selected sequence by Product in this case and then for the
                 Report Total. The Level options of the print program can be used to affect the amount of
                 detail and totalling lines that appear in a report. For example, if the Detail Line level was
                 not selected only the header grouping and totals would appear, not the detail lines for
                 each backordered line. Below the Report Total will be a summary of the backorders
                 reported, including a count of the number lines.

            When you have finished reviewing the report, close the program and the Windows
             Explorer.

                 Another commonly required report that includes backorders would be a report of all orders
                 and backorders for all or a specific customer. The Print Open Order Report (OE50)
                 program produces this information.

            Run the Print Open Order Report (OE50) program.

            Select File on the Print Selection list and then press [Alt + T] or click the Options button.

            In the File field of the Print Options dialog, type RENALL and press [Enter] to accept it.

                 This will configure the WinSol print program to output the report to a text file that will be
                 named using the value of the File field plus an extension of .tmp and created in the
                 WinDemo folder on your computer.

            Press [Enter] again to accept the Print Selection dialog.

            Press [Enter] to accept the Warehouse Selection dialog.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     62
      08/22/11
                 The standard WinSol Report Parameters dialog will appear. The Print Open Order Report
                 (OE50) program provides four sequences that can be used to range the report by order
                 number, by customer, by sales-rep+customer and by territory+customer. We will be using
                 the Customer sequence.

            From the Sequence drop-box, select the Customer sequence: Press [Down Cursor]
             twice, then press [Tab]

                 The Print Open Order Report also provides a series of restrictions that can be used to
                 reduce content of the report to specific types of records, for example, Backorders Only or
                 Expired Orders only. One of the restrictions, Orders, Quotes, Both is mandatory; we must
                 select an option from it before we can start the report. Restrictions that are mandatory for
                 a report appear with an asterisk character to the left of it on the list of restriction options. If
                 we forget to select the options for mandatory restrictions, WinSol will prompt us before it
                 starts. Knowing this we could actually skip the selection of the mandatory restriction(s)
                 now and wait for them to be presented to us.

            Press [Tab] repeatedly until the focus is in the From field.

            In the From field, type RENALL and press [Tab] to accept it.

            In the To field, type RENALL and press [Tab] to accept it.

            Press [Alt + O] (that's the letter O as in OK) or click the OK button to begin the print
             program.

                 Since we skipped the selection of the mandatory restriction earlier, WinSol will now prompt
                 us to select the mandatory options before it begins reporting.

            Press [Enter] to accept the Restrictions message.

                 The restriction dialog box for the Orders, Quotes, Both restriction now appears
                 automatically.

            Press [Enter] to accept the Orders option.

            Press [Alt + O] or click the OK button to accept the Report Complete dialog.

            Use the Windows Run command to access the WinDemo directory: Hold down the
             start [] key and press [R] or hold down the [Ctrl] key and then press [Esc]; when the
             Start menu opens, press [R] to access the Windows Run dialog box.

            When the Windows Run dialog box appears the last command displayed should still be
             your WinDemo directory. Press [Enter] to re-issue the command.

            When the Windows Explorer appears, press the letter [R]. This should cause the focus
             to jump to the file named…RENALL.tmp.

            Press [Enter] to open the file.

                 The Print Open Order Report (OE50) differs from the previous report in that the column
                 labels for both the header groupings and detail lines appear at the top of each page. The
                 information provided by the report is useful whenever a printed list of open orders is


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                            Page      63
      08/22/11
                 required, for example, to review a customer's outstanding backorders without being
                 logged into a WinSol session.

                 The Print Open Order Report (OE50) is also used to monitor any open orders, backorders
                 or quotes that have been configured with Order Expiry Dates.

            When you have finished reviewing the report, close the program and the Windows
             Explorer.

                 The same information that WinSol reports through the Print Backorders by Product
                 (OE51) and Print Open Order Report (OE50) programs can be seen online using
                 programs such as the Display Product Availability (IC45) and Customer Inquiries (SU45)
                 programs. The difference in functionality between the reports and displays lies in the
                 selection of transactions to be reported versus displayed. For example, reports can locate
                 backorders across all products or customers and then restrict them to only those with a
                 certain product line while the display of such information would be limited to the selection
                 of one record at a time.


         Backorder Displays

                 There are two primary views of backorders used in WinSol. When you wish to review
                 backorders from an inventory point of view, the Display Product Availability (IC45) program
                 would be used. From a customer's point of view, the Customer Inquiries (SU45) program
                 is used. These programs have been used extensively throughout the tutorials already, so
                 you should have some working knowledge of them at this point.

            Run the Customer Inquiries (SU45) program, select the RENAWIG account and switch
             to the Display Orders (Q) tab.

                 Backorders appear on the Display Orders list in one of two ways. If the original order was
                 partially filled and run through the invoicing cycle the backorder will appear on the list with
                 a status of Backord. If the original was completely backordered, as is the case for the first
                 order on the list for the Rent-All customer, its status will remain at Entered. Selecting an
                 order from the list and then pressing the Display Details button allows you to drill into the
                 Display Orders by Customer (OE45) program with that order.

            Select the first order from the list and click the Display Orders button.

                 The Display Orders by Customer (OE45) program appears and display the order you
                 selected from the list allowing you to review its detail lines. While you are reviewing the
                 details of a backorder for a customer you can use the Order Line Info display at the bottom
                 of the program to provide feedback.

            Click the backorder line for the 1010 Product to review it in the Order Line Info display
             below.

                 When a line is selected in the Display Orders by Customer program, the Order Line Info
                 display below is updated for that product and provides some very useful information. For
                 example, your current inventory status is displayed along the bottom line. Notice that
                 there is less than zero Available for this item, in fact 14 less than zero. This is explained
                 by the fact that we have zero on hand (OH) and 14 on backorder (B/O); only four of which
                 are from this customer's order.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     64
      08/22/11
                 The Order Line Info display includes two clues that can be used as a basis for estimating if
                 and when you can expect inventory to become available to fill backorders; not necessarily
                 this one though… The first clue is the Order quantity, which shows us that only six are on
                 order from a supplier at this time. The second clue is the Next Expected Date, which is
                 the date from the Purchasing system on which it expects the next purchase order (for
                 some quantity) to arrive. Those dates are maintained in the Detail Info of a purchase
                 order by the Create Purchase Orders (PO40) program. Based on this information we
                 know inventory is on route to fill 6 of the 14 units on backorder, but we do not know who
                 will get the six units yet. As Rent-All is an important customer to us, we will take some
                 actions now to identify who else has this product on backorder and whether their
                 backorder will be filled before Rent-All's.

            Press [Escape] to close the Display Orders by Customer (OE45) program.

            Press [Escape] to close the Customer Inquiries (SU45) program

            Run the Display Product Availability (IC45) program, access the 1010 product and
             switch to the Open Orders (Q) display.

                 The Open Orders display of the Display Product Availability (IC45) program provides a list
                 of all orders that include the currently selected product. Each order line listed includes
                 information on the order number, the customer, the date the order was placed, the original
                 quantity, how many have shipped so far from the original quantity, how many have been
                 cancelled (if any), the outstanding backorder quantity, and how many have been reserved
                 from the Available inventory To Ship.

                 The Required Date (Req'd Date) is the last piece of information displayed on each list line.
                 The Enter Orders & Quotes (OE30) program sets it when you are future dating orders,
                 which will be discussed in detail during another tutorial.

                 The Open Orders display is sorted by order number. As we can see, the first order line is
                 a backorder for 10 units for a customer and is dated the same as the backorder for Rent-
                 All (RENALL) which appears on the third line. Between the two backorders we can see an
                 order for two units that was cancelled recently. When there is a lot of activity on this list
                 you can reduce the clutter to the display only the type you are interested in reviewing; in
                 this case backorders.

            Click the Backorders option from the Types group located at the bottom of the
             program.

                 The Types group allows us to limit the Open Orders display to list only Orders, Quotes, or
                 Backorders or to display All types at once.

                 The top portion of the Display Product Availability (IC45) program shows us more detailed
                 inventory availability information than we saw from a different angle earlier using the
                 Display Orders by Customer (OE45) program's Order Line Info display. It still shows
                 however that only six units are on order and we need to ensure that Rent-All gets theirs
                 first; especially since the other backorder alone could receive all six units without
                 completely filling it.

            Double-click the first backorder on the list.

                 When an order is selected from the list, the name of the account, the order's Ship To
                 name and the order hold settings are displayed at the bottom of the program. From this

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     65
      08/22/11
                 we can see that SHECON backorder we selected is for Sherman Construction – not one
                 of your most important customers…but nice people all the same. We can also see that
                 there are no order holds against this backorder at this time; it will compete for available
                 inventory when it arrives. To increase Rent-All's chances of having the inventory allocated
                 to it first we should increase their Backorder Priority using the Maintain Customer Master
                 (SU13) program.

            Press [Escape] to close the Display Product Availability (IC45) program.

         Backorder Priority

            Some time ago we left the Maintain Customer Master (SU13) program running. If it's
             still running, switch back to it. Otherwise, run the Maintain Customer Master (SU13)
             program.

            Access the RENALL account.

                 In the lower right corner of the program is a group labelled Backorders and inside it a field
                 named B/O Fill Priority. The higher a customer‟s B/O Fill Priority value, which could be
                 between zero and nine, the more priority it will have when the Release Backorders (OE61)
                 program is able to reserve available inventory to fill backorders. If two customers have
                 backorders for the same product and have the same B/O Fill Priority, the Release
                 Backorders program fill backorders on a first-come-first- serve basis, with the oldest
                 backorders being filled first.

                 Rent-All's B/O Fill Priority is current set at five; let's increase that to nine so they'll have the
                 best chance possible of having available inventory reserved to fill their backorder before
                 others.

            Set the B/O Fill Priority to 9 and press [Enter] to Update the account.

            Press [Escape] to close the Maintain Customer Master (SU13) program.

                 Now…let's receive that outstanding purchase order and watch where the product will go!

            Run the Enter Receipts & In-Transits (PO60) program.

            Press [Alt + C] or click the Create New Batch button.

            Press [Enter] to accept the proposed GL Posting Date.

            Press [Enter] again or click the Update and Procced button.

            Accept the message displaying your batch number by pressing [Enter] to clicking the
             OK button.

            Accept the default batch type as receipt by pressing [Enter] or clicking the No button.

            In the Supplier field, type DAITEK and press [Tab] to access the Daisytek Canada
             supplier.

            In the Packing Slip field, type 212202 and press [Tab] to set supplier's reference.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                             Page     66
      08/22/11
            Press [Alt + 3] or click the Receiving tab.

            In the PO No. field, type 003025 and press [Tab] to accept it.

            Press [Tab] repeatedly until the focus in on the Process All button and then press
             [Enter].

            Press [Alt + B] or click the Update Batch button.

            When the update batch confirmation dialog appears, press [Y] or click the Yes button to
             process the receipt in the batch.

            When the create another batch confirmation dialog appears, press [N] or click the No
             button to exit the program.

                 The products have now been received. Let's use the Release Backorders (OE61)
                 program to allocate the newly available inventory to backorders.


         Releasing Backorders
            Run the Release Backorders (OE61) program.

                 The Release Backorders (OE61) program allows you to control when available inventory
                 is reserved to fill backorders. When a backorder is allocated available inventory To Ship
                 with, it may or may not make the order schedulable by one of the order handing
                 processors. The order must still pass the system requirements for Credit Limit,
                 Delinquency, Minimum Backorder Value, Ship Complete/Backorder Complete, and
                 Manual holds.        If all of the requirements are met, the next time an order handling
                 processor is activated the order will be scheduled and then printed.

                 Release Backorders (OE61) provides three scopes of release: Release All, Release by
                 Customer and Release by Product.

                 The Release All scope, the default, will simply examine all open orders for the selected
                 Warehouse and determine if any Available inventory can be allocated to fill outstanding
                 backorders. When the Release All Backorders method is used, WinSol will fill backorders
                 by product by customer priority by order date by order.

                 In our last cliff-hanging tutorial episode we had configured the Rent-All customer with the
                 highest possible B/O Fill Priority (SU13) in hopes that we could provide an advanced level
                 of service for this important client. Let's tune in now for the exciting conclusion.

            In the Warehouse field, type 01 to specify Toronto and press [Tab] to accept it.

            Press [Alt + A] to Release All Backorders.

            Press [Escape] to close the Release Backorders (OE61) program.

            Run the Display Product Availability (IC45) program, access the 1010 product and keep
             your fingers crossed as you switch to the Open Orders (Q) tab.

                 The list should show that the backorder for RENALL has been allocated 4 units To Ship,
                 which has completely filled its backorder. The SHECON backorder however, has only


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     67
      08/22/11
                 been allocated 2 units To Ship and 8 remain on backorder for it. If the B/O Fill Priority for
                 RENALL had not been increased the SHECON backorder would have been allocated all
                 six units that were received.

            Press [Escape] to close the Display Product Availability (IC45) program.

                 The two other scopes of release provided by the Release Backorders (OE61) program are
                 used to manually allocate available stock for a single customer or product. There are few
                 situations in which this would this is necessary. Let's illustrate one for each. Before we
                 begin however, we need to receive some inventory.

            Run the Enter Receipts & In-Transits (PO60) program.

            Press [Alt + C] or click the Create New Batch button.

            Press [Enter] to accept the proposed GL Posting Date.

            Press [Enter] again or click the Update and Procced button.

            Accept the message displaying your batch number by pressing [Enter] to clicking the
             OK button.

            Accept the default batch type as receipt by pressing [Enter] or clicking the No button.

            In the Supplier field, type GLOEXP and press [Tab] to access the Global Express
             supplier.

            In the Packing Slip field, type 362200 and press [Tab] to set supplier's reference.

            Press [Alt + 3] or click the Receiving tab.

            In the PO No. field, type 003026 and press [Tab] to accept it.

            Press [Tab] repeatedly until the focus in on the Process All button and then press
             [Enter].

            Press [Alt + B] or click the Update Batch button.

            When the update batch confirmation dialog appears, press [Y] or click the Yes button to
             process the receipt in the batch.

            When the create another batch confirmation dialog appears, press [N] or click the No
             button to exit the program.

                 The products have now been received. Let's use the Release Backorders (OE61)
                 program to manually allocate this inventory to some important backorders already waiting
                 for it.

                 Some shipping departments Release All backorders only during off-peak order handing
                 hours so as not to create a back log of work that could affect their ability to fill regular
                 orders. If a customer service situation arises and we wish to release the backorder(s) for
                 a single customer, the Release by Customer option will assist is in providing that service
                 without having to release all of the backorders.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     68
      08/22/11
            Run the Release Backorders (OE61) program, select the 01 Warehouse for Toronto and
             switch to the Release by Customer tab by pressing [Alt + 2] or click it.

            In the Customer field, select the Tasca Inc. account, TASCA.

            Press [Alt + D] to Display All backorders for the TASCA account.

                 The list below will now show all of the outstanding backorders for the currently selected
                 account; in this case two separate orders. The list shows two kinds of detail lines. Order
                 header lines will have labels for the ORDER, DATE, shipping document number (SDN)
                 and the customer's PO#. Under each order header line will be the backorder detail lines
                 for that order. The labels for the detail line columns appear at the top of the list. The
                 information provided for detail lines includes the Product Code, Line number from the
                 order, the original Ordered quantity, how many units have Shipped already, have many
                 are reserved To Ship from available inventory already and how many remain on
                 backorder (B/O Qty). The final column displays the most important value for this process,
                 the quantity of Available inventory that could be reserved to fill backorders (Avail-BO).

                 Tasca Inc. has asked us to rush ship their order (PO. NO 0333) for ergonomic seating
                 accessories as soon as it arrives. As we can see from the list, both products show
                 quantities available to fill backorders.

                 The Release by Customer scope of the Release Backorders (OE61) program will allow us
                 to Release All backorder for this customer, to select just a single order (Release Order) for
                 release, or to release just a single line Release Line. Of course, no matter which method
                 is selected there must be inventory Available to reserve for the backorders.

                 We only need to release the order with the PO. NO 0333, so we will the Release Order
                 method.

            In the Order No field, type the order number with has the PO.NO of 0333 and press
             [Tab] to accept it.

                 The list will be refreshed to reflect only the lines from that order.

            Verify that you have the correct order for with the PO.NO 0333 for the 3151 and 3150
             product codes.

            Press [Alt + O] to Release Order or click the button.

                 The Release Backorders (OE61) program will process only the currently selected order for
                 the customer. When it is completed, you could press [Alt + D] to Display All backorders for
                 the customer again and you should see that the order for with the PO.NO 0333 for the
                 3151 and 3150 product codes no longer appears as a backorder.

            Leave the Release Backorders (OE61) program running for now.

            Switch to the WinSol Program Menu and run the Schedule Orders for Printing (OE32)
             program.

            Schedule orders as usual for the Toronto warehouse and All Ship Vias.

            Print the orders to the Screen device using the Print Shipping Documents (OE34)
             program to complete the cycle.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                            Page      69
      08/22/11
            Run the Customer Inquiries (SU45) program.

            Access the TASCA customer and switch to the Open Orders (Q) tab.

                 The Open Orders list should show two orders for the Tasca Inc. account; only one of
                 which will show a status of Printed.

            Select the order with the Status of Printed and then click the Display Details button.

                 When the Display Orders by Customer (OE45) program appears you will be able to
                 confirm that we have successfully released, scheduled and printed just the one backorder
                 for this customer. And we were able to do that without having affecting any other
                 backorders in the system that would have been released if we had chosen to Release All
                 backorders.

            Press [Escape] to close the Display Orders by Customer (OE45) program.

            Press [Escape] to close the Customer Inquiries (SU45) program.

                 Another situation in which it would be convenient to manually release backorders might
                 occur with the receipt of items requiring special handling. In our last receipt of goods, we
                 received two extremely large printer stands, product 8000. These items happen to be so
                 large that the shipping department has a special freight carrier to handle them. It would be
                 most convenient if the shipping department could produce the backorders for these items
                 without having to release all of the backorders though.

            Run the Display Product Availability (IC45) program, access Product 8000 and switch to
             the Open Orders (Q) tab.

                 The list shows us that the backorders for the product 8000 belong to two orders from
                 different customers. Let's use the Release by Product scope of the Release Backorders
                 (OE61) program to allocate the stock to the backorders so that they can be scheduled and
                 printed before the carrier arrives for them.

            Leave the Display Product Availability (IC45) program running for now.

            Switch back to the Release Backorders (OE61) program we left running earlier.

            Press [Alt + 3] to switch to the Release by Product tab or click it.

            Press [Tab] to move the focus to the Product field.

            Type 8000 and press [Tab] to access the product.

                 When the product is accessed, the Release by Product display will show you all of the
                 outstanding backorders for this product in the selected Warehouse. The list provides
                 information about who the backorders are for, what quantity they originally ordered, how
                 many are reserved To Ship for that backorder already, and the remaining backorder
                 quantity. Above the list we can see number of units that are available to fill backorders
                 (Avail-BO).

                 In our example here we have a sufficient quantity of available inventory to fill all of the
                 outstanding backorders for this product. If however we did not, the Release by Product
                 scope allows us to select individual backorder lines and release to that line a specific

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    70
      08/22/11
                 number of units from the Available inventory. Selecting the line from the list, setting the
                 Qty field and then reserving it for that backorder using the Release Line command would
                 accomplish this. This is particularly convenient from a customer service point of view
                 when you wish to spread the received inventory across a number of customers to prevent
                 one customer from receiving all of the available inventory. The Release All option would
                 allocate available inventory by the customer's B/O Fill Priority (SU13) first, then by order
                 date, then by order number until all backorders were filled or all of the available inventory
                 is allocated. If the first backorder in that sequence is for a quantity greater than availability
                 it will be allocated all of the units and the others will remain on backorder.

                 Since we have a sufficient quantity to fill all backorders we will simply use the Release All
                 command.

            Press [Alt + A] to Release All backorders for this product or click the button.
            Press [Escape] to close the Release Backorders (OE61) program.
            Switch to the WinSol Program Menu and run the Schedule Orders for Printing (OE32)
             program.
            Schedule orders as usual for the Toronto warehouse and All Ship Vias.
            Print the orders to the Screen device using the Print Shipping Documents (OE34)
             program to complete the cycle.
            Switch back to the Display Product Availability (IC45) program we left running earlier.
                 We will need to refresh the display to see the updated information.
            Press [Ctrl + Tab] and then [Ctrl + Shift + Tab] to switch away from and back to the
             Open Orders display.
                 The Open Orders list should now show that we have indeed released the backorders for
                 the product 8000. And by using the Release by Product scope we have been able to
                 handle this special situation without affecting shipping's regular schedule for releasing all
                 backorders.
            Press [Escape] to close the Display Product Availability (IC45) program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page     71
      08/22/11
PRE-ALLOCATING IN-TRANSIT INVENTORY
                 The Pre-Allocation programs provided with WinSol allow you to reserve the anticipated
                 quantities from in-transit purchase orders to fill outstanding backorders. On arrival of the
                 in-transit the allocated quantities are released automatically to their orders before the
                 balance of inventory is released to available inventory.

         Allocating In-Transits
                 The Pre-Allocation Entry (OE40) program is designed to assist you in the allocation of
                 anticipated In-Transits.

            Run the Pre-Allocation Entry (OE40) program.

            In the In-Transit field, type 00229 to access an in-transit purchase order from Crestar.

                 The Line field of the Pre-Allocation Entry program is used to select the purchase order line
                 of the product that you wish to allocate inventory from. If you are looking at printed copy or
                 display of the purchase order the Line number you wish to access may be visible.
                 Otherwise, you can use the Receipt Lines Query to locate the product.

            In the Line field, press [Shift + F2] or click the button on the right side of the field to
             access the Receipt Lines Query.

                 The Receipt Lines Query provides you with a view of the purchase order in line number
                 order. It includes the Product, the quantity expected for receipt and the amount from that
                 receipt that has already been allocated to backorders so far.

            Press [Tab] repeatedly until the focus is on the list.

            If necessary, use the cursor keys to select the line you wish to select and press [Enter]
             to select it and return to the Line field.

                 The program retrieves and displays some additional information about the product
                 expected on that in-transit line, including its description and its Expected Arrival date (if
                 maintained) while the quantifies expected, allocated and available appear in the group to
                 the right.

                 The Order Info Entry list below displays all outstanding backorders and future orders for
                 the product expected from that In-Transit Line. Each line includes the Order & Line
                 numbers, the Status of that order as B for backorder and f/F for future orders, the
                 backorder/future order quantity, the Quantity Allocated from this In-Transit Line, the Total
                 Allocated from all In-Transit Lines, the Customer account and Name. The list can be
                 reduced to display only those orders with allocated quantities from this In-Transit Line if
                 the Display Only Allocated Orders option is enabled in the top right corner of the program.

            The Order Info Entry list below displays an order for Birks Canada. Type its Order
             number and press [Tab] to accept it.

            Type the Line number from the Birks Canada order below and press [Tab] to accept it.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     72
      08/22/11
                 With the Order and Line set, the Pre-Allocation Entry program now proposes a quantity to
                 allocate to this backorder from the current In-Transit Line's Remaining quantity.

            Press [Enter] to accept the proposed quantity of 2 and Update the allocation record.

                 The list is updated to reflect the changes you have made. Note that an A appears in the
                 first column of the list to reflect that the order has been allocated a quantity from the
                 currently selected In-Transit Line.

            Click the Display Only Allocated Orders option to reduce the list to allocated records.

                 When modifying an In-Transit Line for an item with many backorders, the Display Only
                 Allocated Orders option makes locating the record you wish to change much easier to find.

            Press [Alt + W] to release the In-Transit Line.

            Press [Escape] to close the Pre-Allocation Entry (OE40) program.

         Allocations Displays
                 When Pre-Allocations have been made against products in-transit, WinSol shows an
                 indicator on the Display Product Availability (IC45) Open Order (Q) list, and provides drill-
                 down access to the details behind the allocation.

            Run the Display Product Availability (IC45) program, select the Product 8220 and switch
             to the Open Orders (Q) tab.

                 The list shows that there are two outstanding orders for the product, both on backorder.
                 Notice that next to the BckOrder column for the two lines appears the symbol A indicating
                 that at least part of the backorder quantity has been allocated to an in-transit purchase
                 order.

            Double-click on one of the order for Birks Canada (BIRCAN) to update the order display
             along the bottom of the program.

                 When an order from the list is selected (double-clicked) for display, you can always use
                 the Order Look-up command to drill through to the Display Orders by Customer (OE45)
                 with the order. If the order has been pre-allocated you will also be able use the Pre-Alloc
                 Look-up command to drill through to the Pre-Allocation Details.

            Click the Pre-Alloc Look-up button.

                 The Pre-Allocation Details dialog lists each of the In-Transit Lines that have a quantity
                 allocated to the selected order. The details provided on each In-Transit include the
                 quantity from it for the selected order, the Vendor it is expected from, which Vessel and
                 the Expected Date of arrival of that vessel.

            Press [Escape] to close the Pre-Allocation Details dialog.

            Press [Escape] to close the Display Product Availability (IC45) program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     73
      08/22/11
         Allocation Reports
                 The Print Pre-Allocations Report (OE41) program can be used to produce a listing of the
                 outstanding allocations by product code. For each product with allocations, the In-Transit
                 Line is listed with those orders that have been allocated a quantity from it.

         Allocation Warnings
                 WinSol keeps track of all order lines that have had pre-allocations committed to them and
                 all in-transits from which pre-allocations have been made. If an order line is modified or
                 deleted, or if the in-transit quantity is reduced below the pre-allocated quantity or deleted
                 or cancelled altogether, WinSol will log a warning message to a file to act as an audit trail
                 for the Purchasing staff responsible for managing pre-allocations. The Print Pre-
                 Allocations Warnings (OE42) program produces this audit trail.

                 Let's experiment with one of the warnings by deleting an order with pre-allocations and
                 then run the Pre-Allocations Warnings program to see the results.

            Run the Enter Orders & Quotes (OE30) program.
            Accept the Toronto Warehouse.
            Press [Tab] repeatedly until the focus is on the Order field.
            Type M00010 and press [Tab] to access a pre-allocated order for Gold Coast Gifts.
            Press [Alt + O] to delete this order.
            Press [Y] to confirm the deletion.
            Press [Y] to confirm that this is a customer cancellation.
            Press [Escape] to close the Enter Orders & Quotes (OE30) program.
            Run the Print Pre-Allocations Warnings (OE42) program.
            Select File on the Print Selection list and then press [Alt + T] or click the Options button.
            In the File field of the Print Options dialog, type 8220 and press [Enter] to accept it.
                 This will configure the WinSol print program to output the report to a text file that will be
                 named using the value of the File field plus an extension of .tmp and created in the
                 WinDemo folder on your computer.
            Press [Enter] again to accept the Print Selection dialog and start the print job.
            Press [Alt + O] or click the OK button to accept the Report Complete dialog.
                 Now, in order to view the report that we printed to the file we need to locate the file in the
                 WinDemo folder. There are many ways of getting to that folder…the following is just one
                 the quickest, least painful methods, but it does requires that you know where WinDemo
                 was installed (usually C:\WinDemo…)

            Hold down the start [] key and press [R] to access the Windows Run dialog box. If
             your keyboard does not have a start [] key, you can hold down the [Ctrl] key and
             then press [Esc]; when the Start menu opens, press [R] to access the Windows Run
             dialog box.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     74
      08/22/11
            In the Windows Run dialog box, type C:\WinDemo and press [Enter]. If you installed
             WinDemo to some other volume than C, substitute the volume letter for x as in
             x:\WinDemo, or x:\…\WinDemo; wherever you installed it.
            When the Windows Explorer appears, press the number [8]. This should cause the
             focus to jump to a file named…8220.tmp.
            Press [Enter] to open the file.
                 If your system has been configured to open .tmp files with a program already, the
                 8220.tmp file will open in that program at this point. If this is the case you can skip the
                 next two steps. Many systems however, do not know which program can display the .tmp
                 file that WinSol creates when you print to a file…any text or word processor will do. The
                 following two steps will register the notepad as the preferred program for viewing .tmp files
                 so that the next time you press [Enter] on a .tmp file notepad will display it for you.
            In the Description field of the Open With dialog, type Temporary Text File and press
             [Tab]
            With the focus now on the list of programs, press [N] repeatedly until the NOTEPAD is
             selected and then press [Enter] to accept it.
                 The 8220.tmp text file, which is a copy of the Print Pre-Allocations Warnings (OE42) report
                 should now be displayed.
            When you have finished reviewing the report, close the program and the Windows
             Explorer.
         Releasing Pre-Allocations
                 When the in-transit purchase order arrives and is processed by the Receive In-Transit to
                 Stock (PO63) program, backorders pre-allocated to receive inventory from the In-Transit
                 will be released.
            Run the Receive In-Transit to Stock (PO63) program.
            Press [Enter] to accept the default GL Posting Date.
            In the Receipts field, type 00229 and press [Tab] to access the In-Transit receipt.
            Press [Alt + I] to Initiate Receipt of the List of Receipts.
                 The Receive In-Transit to Stock (PO63) program will now receive the in-transit purchase
                 order to stock and process the pre-allocations.
            Run the Display Product Availability (IC45) program.
            Access the 8220 Product.
            Switch to the Open Orders (Q) tab.
                 The Open Orders list should now show that the order for Birks Canada, which was
                 previously on backorder with a pre-allocated quantity from the in-transit we just processed,
                 has had inventory reserved To Ship for it.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page       75
      08/22/11
PURCHASING
Maintenance

         Maintain Purchasing Information

            Place your cursor in the white box in the top left corner of the screen, type PO13
             [Tab].

                 To maintain purchasing info records, you must first identify the supplier whose records you
                 wish to work with by entering it into this field.

            Type CARPAP        [Tab]

                 The information for that supplier, name, country and currency, is retrieved from the
                 supplier master.

                 To View an existing Purchasing Info Record:

            Type 2001     [Tab]

                 The product record‟s information will be retrieved and displayed in the form for review and
                 maintenance.

                 If a record for the product code exists in the purchasing master file, it will be retrieved and
                 displayed. If the record exists in the inventory master files but not in the purchasing
                 master file, a new record will be prepared.

                 If no other supplier has been established as the primary supplier for that product, the
                 Maintain Purchasing Info program will prepare a new record using the established defaults
                 in the form‟s fields.

                 If another supplier has been established as the primary supplier for that product, a warning
                 box will alert you with “Product … not set up for this supplier. Defaults from…” to inform
                 you that rather then using the established defaults to create this new record, the program
                 is copying the values from the primary supplier‟s purchasing info record. This is especially
                 convenient when you are creating an alternative supplier for a product, i.e., from a
                 wholesaler versus the distributor or manufacturer, as in many cases the copied values will
                 be better than the generic defaults. Certain values may require maintenance though, i.e.,
                 a wholesaler may allow you to purchase a smaller quantity of the product, therefore the
                 standard pack size might be reduced

                 With the record selected and displayed now, you are able to continue with the process of
                 creating your new Purchasing Info record by maintaining the values of the form‟s fields.

              The record status panel displays the following indicators:




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     76
      08/22/11
                 Record Flagged for Deletion - When a Purchasing Info record has been flagged for
                 deletion, the “Record flagged for deletion!” message will appear on the left side of the
                 status panel.

                 Last Price Change: The date of the last price change to the current purchasing info record
                 is displayed in the centre of the status panel.

                 Replacement Cost: The Replacement Cost of the purchasing record is calculated and
                 displayed on the right side of the status panel.

                 The Primary Supplier checkbox is used to flag the purchasing info record's supplier as the
                 preferred supplier for this product when it can be purchased from multiple suppliers.

              For a new product with no other purchasing info records on file, the default
               setting for Primary Supplier checkbox will be checked; otherwise, when
               additional purchasing info records are created for a product from alternate
               suppliers the default setting will be unchecked.

              If an alternate supplier's purchasing info record is checked as the new
               Primary Supplier the old supplier will automatically be unchecked.

              In most programs where the replacement cost of a product is displayed or
               reported, unless it is specifically associated with a supplier reference you
               can assume that it is the primary supplier's replacement cost being
               displayed or reported.

                 The Supplier's Product Code field is used to capture the identification code that the
                 supplier uses for their product. This code is printed on purchase orders issued to this
                 supplier and various other reports throughout WinSol to assist you in identifying the
                 product.

            [Tab] [Tab] [Tab] to advance to the lead time field.

                 The Lead Time Days field for a product represents the number of days normally required
                 to receive merchandise from a supplier once an order has been placed. This field may be
                 set manually when the Purchasing Info record is being built or may be automatically
                 calculated and updated as a by-product of running the Forecast, Purchasing, Lead-time
                 Recalculation program. If the value of this field is “0”, then the recalculation routines will
                 use the lead-time from the Supplier Master record.

                 The expected delivery date for purchase order detail lines is calculated by adding the lead-
                 time to the purchase order date. The expected delivery date is used by the Outstanding
                 PO Report to report overdue purchase orders.

                 A product‟s lead-time is also used by the Release Future Orders program to determine if
                 stock should be ordered now to satisfy future orders nearing their release date.

            [Tab]   to leave at 30 days.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     77
      08/22/11
                 The Purchasing U/M represents the smallest unit in which this product can be purchased
                 from this supplier.

            Click ? to access the Unit of Measure Query

                 This shows you the options for current Units of Measures set up in the table and how the
                 factors for each on are applied.

            Click     in the top right corner to exit the Unit of Measure Query

            [Tab]   to accept the default Purchasing U/M

                 The Standard Pack Size represents the minimum purchase order quantity (expressed in
                 the Purchasing Unit of Measure). If applicable, the Forecast, Purchasing, Lead-time
                 Recalculation program will round the calculated reorder quantity to a multiple of the
                 standard pack size.

            [Tab]   to accept the field

                 The Purchasing Criteria code points to a table entry that defines the parameters to be
                 used in the recalculation routines for maximum stock, safety stock, line point, and order
                 point. The method to be used to calculate the re-order quantity is also stored on this table.

            [Tab]   to accept the field

                 The UPC field is used to capture the supplier's universal product code for their product.

            [Tab]   to leave at 0‟s

                 The Conversion Factor fields can be configured to allow the purchase of the product using
                 the supplier's stock keeping unit (SKU) and receive the product into your inventory using
                 your SKU.

              For example, if you purchase a product in dozens but stock by each, then
               the conversion equation will be 1 BU = 12 SKU. IE, if 6 buying units are
               received, 72 SKU‟s will be added to stock on hand.

                 The equation will multiply the receipt quantity by the SKU side of the equation and then
                 divide by the buying side of the equation. For example, if you purchase in kilograms but
                 stock by the pound, the conversion equation would be set as 10,000 KG = 22046 LB.

                 IE: 1KG received = (1 X 22046) / 10,000 = 2.2046 LB.

                 From Purchasing Unit: The From Purchasing Unit field controls the buying side of the
                 equation used to convert the buying unit of measure into stock-keeping units.

            [Tab]   to accept the field

                 The to Stock Keeping Unit field controls the stock-keeping side of the equation to convert
                 buying units to stock-keeping units.

            [Tab]   to accept the field



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     78
      08/22/11
                 The Standard Pack U/M Weight & Volume fields capture information used to calculate the
                 total weight and cubic volume of products on a purchase order. As you create purchase
                 orders, the sum of the purchase order's weight and volume is displayed in the top right
                 corner of the program's form.

                 Landing Factors can be configured to calculate landing charges based on Weight or Cubic
                 Volume.

                 Weight: The value of the Weight field will be used to calculate the total weight for a
                 purchase order. If this supplier has a minimum weight requirement then the total weight of
                 a purchase order must be greater than the specified minimum weight to meet the
                 "generate purchase order" requirements as reported on the Preliminary PO Report.

                 Be certain to use your purchasing department's standard unit of weight measurement (i.e.,
                 kilograms, pounds, tons)

             [Tab]   to accept the field

                 Volume: The value of the Volume field will be used to calculate the total cubic volume for
                 a purchase order.

            [Tab]    to accept the field

              The Inventory Master record also stores the Weight and Volume of the
               product. Given differences in buying units of measure versus stock-
               keeping units of measure plus variations in packaging, the purchasing
               weight/cube and stock-keeping weight/cube may differ.

            [Tab]    to go to Folder 2 – Pricing Info

                 The Purchase Price field is used to establish the purchase price for the product from this
                 supplier. When creating a purchase order, the default purchase price will come from this
                 field.

            [Tab]    to accept it

                 The value of the Price per U/M code's pricing factor is used to factor a purchase price into
                 a price that matches the purchasing unit of measure. For example, an item priced by the
                 dozen but purchased by the each requires a Price per U/M code with a pricing factor of 12.

            [Tab]    to accept the default Price Per U/M




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    79
      08/22/11
                 The calculated value of the Discount % field reduces the Purchase Price by the
                 percentage discount. For example, a 3% discount on a Purchase Price of $100.00 will
                 result in a price of $97.00. The discount value can be represented as a straight, fractional
                 or chain discount as shown in the following examples:

                         Straight Discount:  33
                         Fractional Discount 33.333
                         Chain Discount      30/10/5


                 When creating a purchase order, the default discount will come from this field.

            [Tab]   to skip the entry of a discount

                 The MSL Price field is used by the Recalculate Selling Prices program to recalculate the
                 first quantity break level selling price if the recalculation method is “Specified” and the
                 product‟s quantity break record defines a discount percent.

            [Tab]   to default the MSL Price as being equal to the Purchase Price

                 The Currency Code field is the currency used to calculate a product‟s replacement cost
                 but is not necessarily the currency used to calculate a product‟s landed cost.

            Click ? to access the Currency Code Query

                 This shows your options that have been set up for currency and the rates they are set at.

            Click     in the top right corner to exit the Query

                 Once a Currency Code has been selected the current currency rate will appear below the
                 field.

                 When a new purchase order is entered, all products on the PO must be coded with the
                 same currency code (i.e., you cannot mix currencies on a single PO). The currency of the
                 first PO detail line determines the currency of the PO. This is also true if stock when stock
                 is received via the Enter Receipts & In-Transits program.

            [Tab] to accept the currency code

                 The Duty Code combined with the supplier‟s country code will point to the appropriate duty
                 rate on the Duty Code table to be applied in the calculation of landed cost for this product.

            Click ? to access the Duty Rate Code Query

                 If the Excise Type flag for this Duty Code/Country combination is “R” or “P”, then an “*” will
                 be displayed beside the duty rate. This will indicate that this product is subject to excise
                 tax, which is calculated by the Receive In-Transit to Stock program and, therefore, is not
                 reflected in the calculated replacement cost that is displayed at the bottom of the screen
                 for this product.

            Click     in the top right corner to exit the query




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     80
      08/22/11
                 The current Duty Rate‟s will appear below the field.

            [Tab]     to accept the duty code

                 Landing Factors are add-on costs that can be applied at the supplier, product and
                 receipt/in-transit level for the purpose of accurately adding-on to the purchasing cost of a
                 product the values that affect the true Landing Cost of that product.

                 Landing Factors are assigned at the product level here on the purchasing info records to
                 reflect predictable add-on expenses from this supplier for this product. For example, if
                 your supplier charges you specific freight or packaging expenses for this product,
                 assigning a landing factor with that rate will result in a more accurate landed cost when
                 receipts from that supplier are processed.

                 The Maintain Landing Factors program provides a Bulk Maintenance utility to assist you in
                 managing the assignment of and the assigned rate for product level landing factors.

                 The list box shows the Landing Factor that has already been applied to this product.

            Click ? to access the Landing Factor query

                 This shows you the Factors that have been set up.

            Double click on Package

            Type .1     [Tab]

            [Enter]    on the + button

                 When the landing factor has been updated it will appear in the list of landing factors below.

              To Modify an Existing Product Level Landing Factor, Double click the
               landing factor you wish to modify and adjust the Rate/Pct field as required
               and press Tab.

              To Delete a Product Level Landing Factor, double click the landing factor
               you wish to delete. Verify that you have selected the correct landing factor
               assignment that you wish to delete. Click the - button to delete it.

            Click on the tab for Folder 3 – Promotion

                 This is where you would enter the supplier‟s promotional price and/or discount.

                 If you enter a purchase order between the promo Start/End dates, then the promotional
                 price and/or discount will be assigned instead of the supplier‟s normal purchase price.

              Folder 4 – Custom is available for additions that may be required at a later
               date.

            Click on Find




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     81
      08/22/11
                 The Purchasing Info Lookup displays information linking suppliers and products.

              Start From:         The lookup list will focus on the key of the sequence
               selected in the Sort By drop-box list that is the closest match to the
               contents of this field.

              Sort By: The lookup list will display records from the database sorted by
               the sequence selected here.

            Click on the down arrow on the right side of the Sort by box.

                 This lists the sequences available to the Purchasing Info Lookup program:

                         Supplier + Product
                     Product + Supplier
                     Supplier + Supplier‟s Product + Product
                     UPC + Supplier + Product
                     Supplier‟s Product + Product

            Click on Product + Supplier

                 The lookup list displays the following fields: Supplier, Product, Product Description,
                 Supplier‟s Product and UPC.

              The Query button provides access to the Supplier Master Query program
               to retrieve a Supplier Code for use in the Start From field.

              The Print button prints the contents of the lookup list.

            [Esc]   to close the lookup program

            Click     in the top right corner to exit




Enter Purchase Orders

         Create Purchase Orders

                 The Create Purchase Orders program (PO40) is used to enter header information,
                 product detail lines and remark lines for purchase orders. Each purchase order is
                 assigned a PO number (by the system or by the operator); details of all purchase orders
                 are kept on file until the goods are received into stock. Any default values (purchase
                 prices, etc.) may be overridden at entry time for one-time changes without affecting
                 subsequent purchase orders.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page     82
      08/22/11
            Place your cursor in the white box in the top left corner of the screen, type PO40
             [Tab]

                 When creating a new purchase order a supplier code is entered into the Supplier field.

            With the cursor in the Supplier box type TECPLU         [Tab]

                 A Message appears notifying you that “There is one Message for this supplier dated …”

            Click OK

                 The Supplier information from the Supplier Master (PO11) will appear in the display below.

                 The Messages button provides access to the Enter Supplier Messages program. Supplier
                 messages are a convenient location to store important information about a supplier online.

            Click Messages

            Type TECPLU in the Supplier box        [Tab]

                 Messages that have been entered will be displayed in the bottom test box.

            Double-click on the message line.

                 Message Lines 1, 2 and 3 are displayed.

            Click      in the top right corner to close the Supplier Messages (PO35) box.

                 The Ship-to address is provided to suppliers as the location to which goods or materials
                 from this purchase orders should be shipped. The default ship-to address for your most
                 common purchase orders should be assigned in the Maintain Ship-to Addresses program
                 (PO01) to the ship-to code "DEFLT"; this code will appear as the default for all new
                 purchase orders.

                 You may select one from file or manually type one in by typing in M in the Ship-to box, tab
                 and that takes you to the Ship-to address field or, using the mouse pointer, click the Ship-
                 to Address fields.

                 To select another Ship To you could key in the Ship-to code and press Tab to accept it or
                 you can retrieve it from the Ship-to table.

            Click ? beside the Ship-to box to enter the query.

            Double-click on the TORONT Ship-to

                 The Ship-to Address fields now hold the information attached to that Ship-to code and the
                 cursor jumps to the Date Required field.

                 The PO date defaults to the system run date and can be overridden. This date is used to
                 calculate the expected delivery date of each purchase order detail line (only for products
                 coded with lead-times).




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    83
      08/22/11
                 The Date Required defaults to the Purchase Date plus the lead-time from the Supplier
                 Master File for the current supplier and can be overridden. This is a memo field only,
                 which prints on the purchase order.

                 If a purchase order is recalled for revision and this date is changed, the following message
                 is displayed: "Reset expected date for all detail lines?" Responding with Yes will set the
                 expected date for all detail lines equal to the revised required date. Responding with No
                 will not revise expected dates.

            [Tab] [Tab] to move to the date required field.

            [Tab]    to except default Date Required.

                 Cancellation Date is a memo field for your information.

            [Tab]    to leave the cancellation date blank.

                 The Terms field defaults to the Terms description from the Supplier Master File for the
                 current supplier. This is a memo field only which prints on the purchase order.

            [Tab]    to accept the default terms description.

                 The Buyer code can be selected from a table containing all of the purchasing agents. The
                 buyer name for the code entered in this field will print on the purchase order when faxed or
                 printed.

            Type 1    [Tab]

                 The Buyer‟s Name will appear to the right of the field.

                 The Ship-Via default value is from the Ship-Via field of the Supplier Master File and can be
                 overridden. The description in this field will print on the purchase order when faxed or
                 printed to inform your supplier of which freight-carriers your purchase order should be
                 shipped with.

            [Tab]    to accept the default Ship-Via description.

                 The F.O.B. default value is from the F.O.B. field of the Supplier Master File.          The
                 description for this field will print on the purchase order when faxed or printed.

            [Tab]    to accept the default F.O.B. description.

                 The Freight Terms selected in this field default to the Supplier's Freight Terms and print on
                 the purchase order.

            [Tab]    to accept the supplier's default Freight Terms.

            [Tab]    to leave Discount Default blank.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     84
      08/22/11
                 The Update Master check-box can be used to enable logic within the Create Purchase
                 Orders program that will pass back updates from the detail lines to the Purchase Price
                 and/or Discount % of the Purchasing Info records. If a supplier has changed their price or
                 your discount for a product, this is a convenient way to update your database while you
                 are creating a purchase order for the same items.

                 If checked, each time a purchase order line is updated with a Purchase Price and/or
                 Discount that differs from the Purchasing Info record values a message will appear asking:
                 "Do you wish to update purchasing master file with new pricing factors?" Answering Yes
                 will pass the update back; No will not update.

            Click on the box to put a check in it to activate it      [Tab]

                 The memo box allows you to type information for display purposes only.

            [Tab]     to bypass memo box.

            [Tab]     to bypass the Message Button and open Folder 2 – Detail Info.

                 This brings you to the detail entry of the program.

                 The Product field allows for the entry of product codes on to the purchase order.

            Type 1002      [Tab]

                 The purchase order quantity is expressed in buying units.

            Type 50     [Tab]

                 The Purchase Price field for a new purchase order line will default to the Purchase Price
                 assigned to the purchasing info record for this supplier and product but can be overridden.

            Type 75      [Tab]

                 The Per field for a new purchase order line will default to the Price Per U/M assigned to
                 the purchasing info record for this supplier and product.

            [Tab]     to accept the default Price Per U/M.

                 The Discount field will default to the Discount % assigned to the purchasing info record for
                 this supplier and product.

                 A Discount reduces the Purchase Price by the percentage discount. The discount value
                 can be represented as a straight, fractional or chain discount as shown in the previous
                 examples.

            [Tab]     to accept the default discount.

                 The Expected Date is critical for expediting overdue purchase orders. If the purchase info
                 record for this supplier and product has a Lead-time, the default expected date will be
                 calculated by adding the number of Lead-time days to the purchase order date. If the
                 purchasing info record Lead-time was not set (is zero), the expected date will be
                 calculated in the same way as the purchase order's Date Required: the purchase order


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page         85
      08/22/11
                 date plus the number of lead-time days (if any) assigned to the supplier master record for
                 this vendor.

                 The expected date should be updated during entry or whenever the supplier confirms or
                 alters the delivery time. If a supplier confirms that all purchase order lines should be
                 expected on the same date (or substantially all*), updating the purchase order's Date
                 Required provides an option to update all detail lines at the same time. *If one or more
                 lines will have a different expected date, update the expected date(s) individually after the
                 update provided by a change in the Date Required.

            [Tab]   to accept the default expected date.

            [Enter] on the Update button to add the line to the Purchase Order.

                 A message appears noting the Purchase Order number 003024.

            Click OK

              Note that since you changed the price and the Update Master option was
               enabled before this line was entered, a message appears after the line is
               updated asking: "Do you wish to update purchasing master file with new
               pricing factors?" Answering Yes will pass the update back; No will not
               update.

            Click NO

              Now it will affect only this line and will not update the purchasing info
               record.

                 You can order product from a supplier that is not the mail supplier.

            In the Product code box, type 1001       [Tab]

                 If the purchase order's supplier has not been established as a supplier of the entered
                 product, a warning will alert you with: "The Supplier Product Record is not on file. Do you
                 want to create it?" Answering No returns to the Product field.

                 Answering Yes will prepare a new record for the supplier and product in the Purchasing
                 Info database using the defaults from the product's nominal supplier.

            Click Yes

                 A message will appear informing you of the supplier code the defaults have been drawn
                 from.

            Click OK

                 In the Supplier Master you can modify the new Purchasing Info record for use with this
                 supplier.

            Click UPDATE to accept the defaults.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     86
      08/22/11
            Click      in the top right corner to return to the Purchase Order.

            [Tab]     to enter the Quantity.

            Type 50     [Tab]

            [Tab]     to accept Purchase Price and [Tab] again to accept Per.

            Type in a discount value 25        [Tab]

            [Tab]     to accept the expected date.

            Click Update

              Note that since you put in a discount and the Update Master option was
               enabled before this line was entered, a message appears after the line is
               updated asking: "Do you wish to update purchasing master file with new
               pricing factors?" Answering Yes will pass the update back; No will not
               update

            Click NO

                 The comment button can be used to insert a comment line which will appear in the list of
                 purchase order detail lines and print on the purchase order. To add a new comment line:

            Click Comment

            Type No substitutes for this product please.

            Click Update

            Click on the down arrow to the right of the Expected Date of the order line.

                 This displays all lines entered, including your comment line.

                 You can move and insert lines in the Purchase Order. For example, the comment you just
                 entered you may want it to refer to line 001 for product code 1002 instead of line 002 for
                 product code 1001.

            Click Move Lines

            In the Lines to Move From Line type 002         [Tab]

            In the Lines to Move To Line type 002         [Tab]

                 Leave the Insert Before Line 001 as is.

            Click OK to Start

            Click on the down arrow to the right of the Expected Date of the order line.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page   87
      08/22/11
                 This shows how the lines have been moved.

            Click on line 002.

            Click Stock

                 This takes you into the Display Product Availability program (IC45).

            Click      in the top right hand corner to return to the Purchase Order.

              Note the PO value, weight and volume information in the top right corner.

                 When you have completed your purchase order lines, and have updated the last line, you
                 can prepare the program to create another purchase order by clicking on the New button
                 or exit the program.

            Click      in the top right corner.

                 Once assigned, an existing purchase order may be recalled for review, modification or
                 deletion.

            Type PO40 in the top left box     [Tab]

            [Tab]   to go to PO box, type 3024        [Tab]

                 Tip: It is not necessary to type the leading zeros in Purchase Order Numbers.

            Click on the Detail Info tab.

            Click on the down arrow to the right of the Expected Date of the order line.

            Click on line 001.

            [Tab] [Tab] to go to Order Qty, Type 20           [Tab]

            Click Update

                 The Purchase Order has now been revised.

            Click on Garbage Can

                 A message appears “Delete Header and all it‟s details?” This would delete the complete
                 Purchase Order.

            Click NO

            Click      in the top right corner to exit.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page   88
      08/22/11
Receive Stock

         Enter Receipts/In-Transits

                 The Enter Receipts & In-Transits program is used to generate stock receipt or in-transit
                 transactions from existing purchase orders or on the fly without a previously entered
                 purchase order. Regardless of which type of transaction is being generated, the primary
                 controls and instructions for the program are the same. In-Transit transactions however,
                 which are essentially notifications of the purchase order on route, will be processed further
                 into receipts as they arrive using the Receive In-Transit to Stock program.

            Place your cursor in the white box in the top left corner of the screen, type PO60
             [Tab]

                 The Batch Control, in the Enter Receipts & In-Transits program, allows you to process a
                 batch of transactions before committing the changes to the system using the Update
                 Batch button. The Batch Control list displays the open batch numbers, users who created
                 them, batch & GL posting dates and the status of their current use (if in use).

            Click Create New Batch

            [Enter] to accept the G/L Posting date.

                 Note that for Receipt type batches (chosen later in this process) the GL Posting Date
                 becomes inventory movement date when the Update Batch command is issued.

            [Enter] to Update and Proceed

            Make a note of batch number in case you exit the program and need to select it as an
             existing batch later and click OK

              A confirmation message will appear asking if you wish to accept the
               default batch type of Receipts (which will update the on hand quantities,
               average cost, latest cost and on purchase order values when the Update
               Batch command is issued); or to switch to In-Transit (that will decrease the
               quantity on purchase order, increase the quantity in-transit and calculate
               the unit landed cost when the Update Batch command is issued)

            [Enter] to accept the default for Receipt type transactions.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     89
      08/22/11
                 For Receipts type batches, when the current warehouse uses the Multi-Bin system, a
                 confirmation message will appear asking, "Should all receipts be assigned to the General
                 Receiving Area?"

                 To receive all receipts into the general receiving area, press Y.

                 To assign each receipt line to one or more or the Multi-Bin locations, press N or click the
                 No button.

                 To Use an Existing Batch you can highlight the batch you wish to work with, Press Enter
                 twice to Update and Proceed with the batch.

                 If another user created the batch you have selected, the program will ask you to confirm
                 that you wish to work with a batch that was created by another user. Confirm that the
                 batch you selected is indeed the batch you intended to select to be certain that you are not
                 affecting someone else's receiving work.

                 Once a batch has been selected using one of the methods above and the Enter Receipts
                 & In-Transits entry form appears, the current batch information will appear in the Batch
                 Info display.

            In the Supplier field type TECPLU       [Tab]

                 The Supplier's Packing Slip Number will appear on the documentation that accompanies
                 the shipment of goods that you wish to receive into the inventory system. It is a piece of
                 information, entered using up to 15 characters, that will be used later by the Accounts
                 Payable program to recall the receipt detail lines in order to validate them against the
                 supplier‟s invoice (for Receipts Accrual processing only).

            Type P01     [Tab]

                 If the packing slip for this receipt shows the invoice number the supplier has assigned to it,
                 you can enter it into the Invoice field.

            Type I01    [Tab]

                 The Update Master check-box can be used to enable logic within the Enter Receipts & In-
                 Transits program that will pass back updates from the detail lines to the Purchase Price
                 and/or Discount % of the Purchasing Info records. If a supplier has changed their price or
                 your discount for a product, this is a convenient way to update your database from the
                 point at which you discover a change is required.

                 If checked, each time a transaction line is updated against a PO or without a PO with a
                 Price and/or Discount that differs from the Purchasing Info record values they will passed
                 back automatically (without confirmation.)

                 Update Warning: If the Update Master option is enabled and the Process All button is
                 used to receive the lines on a purchase order, differences in the Prices and Discounts
                 between the purchase order and the current purchasing info records will be updated
                 automatically to the values on the purchase order.

              Note the Currency information and the Batch Info in the bottom of the
               window.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     90
      08/22/11
                 If the transaction originates from a foreign supplier and currency information appears on
                 the documentation it can be captured using the Currency input fields.

                 Code: The default Currency Code is based on the current supplier's currency setting from
                 the supplier master file.

                 Date: The current system date is the default.

                 Rate: This is the default rate that is drawn from the current currency code's rate. It is used
                 to calculate the landed cost of ALL products being received on this receipt. The product‟s
                 currency code is used to calculate it‟s replacement cost, but not its landed cost.

              Receipts can be processed against or without an existing on-line purchase
               order.

                 To receive manually, line-by-line, against a PO already on-line:

            Click on the Against PO folder tab.

                 The PO # field in the Against PO folder can be used to select or display the purchase
                 order number of a receipt line. When processing against a purchase order manually, this
                 field will be used to specify the purchase order you wish to work with before you can select
                 lines from it using the Line field. When editing records processed against a purchase
                 order automatically by the Receiving folder, this field is used only to display what purchase
                 order number the receipt line originated from.

            Click on the ? button on the right side on the PO # box.

            Double-click on 003024, which is the PO you want to receive against            [Tab]

                 The purchase order Line field in the Against PO folder can be used to select or display the
                 purchase order line number of a receipt line. When processing against a purchase order
                 manually, this field will be used to select the purchase order line you wish to add to the
                 receipt. When editing receipt lines processed against a purchase order automatically by
                 the Receiving folder, this field is used only to display what purchase order line number the
                 receipt line originated from.

                 This field is not used to select an existing receipt line; use the Rec.Line field to select an
                 existing line. It's easy to get confused between receipt line numbers and purchase order
                 line numbers. You will be creating receipt lines using this program by processing the
                 purchase order line numbers that were created earlier by another application.

            Type 002    [Tab]

              Note the outstanding quantity and pricing information appear in the input
               fields for editing.

                 The Qty Rec field in the Against PO folder can be used to edit the quantity received
                 against a purchase order line.

                 In the case of new lines being processed against a purchase order manually, the initial
                 value of the quantity to receive will be set to the outstanding quantity against the specified
                 purchase order line.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     91
      08/22/11
                 If less than all of the outstanding quantity of a purchase order line is being received, the
                 amount in this field will be edited to reflect the actual receipt and the amount in the Can
                 field (cancelled amount) maintained if necessary.

                 If your supplier has shipped more than the outstanding quantity of a purchase order line
                 and you elect to receive it, you can set the quantity received to an amount higher than the
                 outstanding quantity.

            Type 25      [Tab]

                 The Can or cancel field is used to maintain the cancelled PO line quantity. Since the
                 quantity is less than the outstanding quantity of a purchase order line that was entered for
                 receipt in the Qty Rec field, the cancelled amount will be set to the difference between the
                 outstanding quantity and the received quantity so that the outstanding PO quantity will be
                 cancelled. If the supplier has not cancelled the outstanding quantity; if they have
                 backordered that quantity as opposed to cancelling it, this amount should be changed to
                 zero.

            [Tab]     to accept the calculated amount.

                 The Price field for a new receipt line will default from the Purchase order price assigned to
                 the purchase order line when it was created or last edited.

            [Tab]     to accept the default price if it is correct.

              Note that changing this price would affect only this line and would not
               update the purchasing info record unless the Update Master option was
               enabled before this line was selected for entered. If the Update Master
               option was enabled before the line was Updated and the value in the Price
               field differs from the purchasing info record values for this supplier and
               product, it will be passed back automatically (without confirmation) to the
               purchasing info record.

                 The Per or Price Per U/M divides the Purchasing Price down to a price that matches the
                 purchasing units using value of the Pricing Factor associated with that U/M from the Unit
                 of Measure table. For example, an item priced by the dozen but purchased by the each
                 requires a Price Per U/M with a Pricing Factor of 12.

                 The Per field for a new receipt line will default to the Per assigned to the purchase order
                 line when it was created or last edited. If you are modifying an existing receipt line the
                 previously updated per will be displayed in the field.

            [Tab]     to accept the default Price Per U/M.

                 A Discount reduces the Price by the percentage discount. For example, a 3% discount on
                 a Price of $100.00 will result in a line total of $97.00. The discount value can be
                 represented as a straight, fractional or chain discount as shown in the following examples:

                 Straight Discount:     33

                 Fractional Discount 33.333

                 Chain Discount         30/10/5

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page   92
      08/22/11
                 The Discount field for a new receipt line will default to the Discount % assigned to the
                 purchasing info record for this supplier and product. If you are modifying an existing line
                 the previously updated discount will be displayed in the field.

              Note that changing this discount will affect only this line and will not update
               the purchasing info record unless the Update Master option was
               enabled before this line was entered. If the Update Master option was
               enabled before the line was Updated and the value in the Discount field
               differs from the purchasing info record values for this supplier and product,
               they will passed back automatically (without confirmation) to the
               purchasing info record.

            [Tab]   to accept the default discount.

                 The Dedicated PO check-box will appear checked only for those purchase orders that
                 were created by the Generate PO process of the Enter Orders & Quotes program. When
                 the purchase order is dedicated to an order, a reference to that order can be found in the
                 comments of the purchase order shown on the Receiving folder's list.

                 The Update button is used to add new receipt lines or save modifications to existing
                 receipt lines. Each receipt line must be updated before another receipt line, receipt
                 number or another program tab is accessed. If a receipt line is not updated the additions
                 or changes will not be saved. Note that changes to the Header Info folder input fields are
                 updated automatically; the Update button is used only to update receipt lines in this
                 program.

            Click on Update

                 The line is transferred into the body of the Receipt.

              The Delete button is used to delete only the currently selected receipt line.
               Select the line you wish to delete by double-clicking it on the receipt line
               list, verify it is the line you wish to delete and when confirmed click the
               Delete button. To delete an entire receipt transaction, use the Delete
               Receipt button.

              The New button is used to prepare the program to enter a new receipt.
               When you have finished editing a receipt, make sure you have Updated
               any changes to receipt lines before pressing it the New button. When
               pressed, the receipt form will be reset for a new record (if a receipt was
               displayed it will be put away...not deleted) and the focus will switch to the
               Supplier field.

                 To change a line on the Receipt:

            Double-click on the line 001 (or type in the line number in the Rec. line box).

            Double-click on the Can box and change the Cancelled quantity to zero          [Tab]

            Click on Update



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page   93
      08/22/11
            Click on the tab for Folder 3 - Receiving

                 When the current PO No. selected in the Receiving folder has remaining detail lines (i.e.,
                 those not yet processed or on backorder) the Outstanding PO Line list will display those
                 lines.

                 To process all of the detail lines into a receipt or in-transit, you could click on the Process
                 All button.

                 To Process some lines, if less than all of the detail lines will be processed:

            Double-click on PO line number 002.

                 As each line is selected the ">" symbol will appear to the left of the PO Line column.
                 When all of the lines you wish to process are selected:

            Click Process to generate the transaction.

            Click on the tab for Folder 2 - Against PO.

                 How to Cancel a PO Line while Receiving:

            Click on line 002 and then click on Delete

                 If the supplier has cancelled an entire purchase order line (i.e., discontinued product - not
                 available), the outstanding purchase order line quantity can be cancelled by setting the
                 Qty Rec amount to zero. In doing so, the Cancel quantity will assume the outstanding
                 quantity and when the line is updated the outstanding quantity against the PO will be
                 reduced to zero.

                 To automatically receive against a PO already on-line you could switch to the Receiving
                 folder.

            Click on the tab for Folder 3 – Receiving

            Click on Process All

                 To receive without a PO you could switch to the Without PO folder.

            Click on the tab for Folder 4 – Without PO

            In the Product field type 1003 [Tab]

            In the Quantities Received field type 50       [Tab]

            Click Update

                 If the supplier's packing slip shows amounts for landing factors, such as freight, packaging,
                 and etc, you can switch to the Landing Factors folder.

            Click on the tab for Folder 5 – Landing Factors




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                            Page    94
      08/22/11
                 For each landing factor to be applied to the receipt, a landing factor code is entered into
                 the Factor field. The Maintain Landing Factors program manages the Landing Factor
                 table.

            Click ? by the Factor box to view codes.

            Double-click on Broker

                 The Landing Factor‟s Name will appear to the right of the field.

            [Tab] to the Value box

                 The landing factor Value field captures the amount of the landing factor. The value should
                 be entered in terms of the currency assigned to the factor as displayed to the right of the
                 value field.

            Type 50       [Tab]

              Effect on Product Landing Charges:

                       Add:        By default, landing factors at the point of receipt are applied in addition to
                                   individual product landing factors from the supplier's purchase info records (if
                                   any).

                       Replace:If the landing factor being should replace the products individual landing
                              factors, select the Replace option from the Effect on Product Landing
                              Charges.

            Click Replace

              The Landing Factors List displays the details of each landing factor that
               has been applied to the receipt. The list includes the following columns:

                 Factor:           The Factor entered into the Factor field.

                 M: The Calculation Method from the Landing Factor's record.

                 B: The Cost Base from the Landing Factor's record.

                 Add:              The setting from Effect on Product Landing Charges field: Add or Replace.

                 Dutiable:         The Dutiable status from the Landing Factor's record.

                 Value             The value entered into the Value field.

                 Curr.             The Currency from the Landing Factor's record.

                 The Landing Factors List can be used to select an existing landing factor from the receipt
                 by double-clicking the list item.

              Domestic Value Entered



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                              Page     95
      08/22/11
                 At the bottom of the Landing Factors List the calculated sum (in domestic dollars) of the
                 landing factors applied to the receipt appears in the Domestic Value Entered field.

            Click Update (immediately below the Add / Raplace radio buttons).

                 The information is transferred to the information box.

                 To completed the receipt(s) in this batch:

            Click Update Batch to permanently commit the transactions.

                 A confirmation message will ask if you wish to update the current batch to the live files.

            To begin the update click Yes

                 A Batch Update progress dialog will appear while the batch is being processed. When the
                 batch update has been completed another confirmation message will prompt you with:
                 "Do you want to Create or Select another batch?"

            Click No to exit the program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     96
      08/22/11
INVOICING

Returned Merchandise Authorization

         Returned Merchandise Entry

                     This program will generate/maintain the header information, product detail lines,
                     comment lines and supplementary charges for RMAs. An RMA is assigned a number
                     by the system. Details lines are kept on file until the RMA is cancelled or converted to
                     an order/invoice/credit note.

            Place your cursor in the white box in the top left hand corner of the screen and type
             IN67 [Tab].

            [Enter] to accept Toronto.

            Type BUSCOM [Tab].

            [Tab] [Tab] to accept the ship-to address and the return date.

            Type UPS [Tab] to choose an anticipated method of shipment.

            Type 12345 [Tab] to enter a customer reference.

                     This is optional.

            [Tab] to accept the freight terms.

                     The program will open folder 2 at this point.

            Type 2001 [tab] to choose a product to be returned.

                     You will be presented with a window displaying the invoice history for this customer /
                     product combination. The „available‟ quantity represents the portion net of prior
                     returns.

            Double-click on the first item.

                     The product will be returned to the RMA entry program. The quantity will default to
                     the remaining „available‟ quantity. In this example, we are going to return only five
                     units.

            Type 5 [Tab] to set the quantity.

            [Tab] [Tab] [Tab] to move to the „TAT‟ field.

            Click on the ? and select „DMG‟ – Damaged Goods then [Tab] to select the TAT code
             and move to the reason code field.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     97
      08/22/11
                     Note that the T.A.T. code will flow to the credit. It can be altered at any
                     time prior to the credit being finalized. The T.A.T. code is attached to
                     the detail line. Multi-line returns can have a variety of T.A.T. codes.

            Click on the ? and select „DMG‟ – Damaged Goods then [Tab] to select the reason code
             and move to the status code field.

            Click on the ? and select „RET‟ – Awaiting Return from Customer [Tab] to select the
             status code.

            [Enter] to update the detail line.

                     Note that two lines are generated. The first line will control the return.
                     The second line is a comment line referencing the invoice to which the
                     return is referenced.

            Click on the „Comment‟ button.

            Enter a comment. Suggestion: “Goods appear to be damaged.”

            Click on „Update‟ (or [Enter] after typing the comment).

                     We will stop the return process at this point. Note that additional detail
                     lines could be added as could supplementary charges, such as
                     restocking charges.

            Click on the „X‟ in the upper right corner of the screen.

                     The normal process would be to print the RMA receiving document
                     using program IN69. Once a return is received, the RMA can be used
                     as a reference to generate a credit note in program IN41 or to generate
                     a replacement sales order in program OE30. Note, also, menu
                     selections IN68, Print Outstanding RMA Report and program IN88,
                     Purge Converted RMA‟s.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page      98
      08/22/11
COMMISSIONS AND ROYALTIES

Commissions / Royalties

         Maintain Commission Rates

             The Maintain Commission Rates program manages a table of commission rates for each
             Sales-Rep+Commission Group+Commission.

             Commission rates may be assigned based upon the sales discount given on the invoice (i.e.,
             the higher the discount given, the lower the commission rate may become) or commission
             rates may be assigned based upon the profit margin achieved on the product detail line (i.e.,
             the higher the profit margin, the higher the commission rate may become).

             Tables may be defined for one or more specific sales-rep(s) while all other commission-based
             sales-reps are assigned to the default sales-rep rate (keyed as sales-rep **, two asterisk
             characters).

             Within a sales-rep‟s table, rates may be defined for specific customers or groups of customers
             with all other customer commissions could be based upon the default table entry (keyed as
             commission group code ******, six asterisk characters).            Grouping of customers is
             accomplished by assigning the same Customer Master File Commission Group code to all
             customers' who share common commission structures. The Maintain Commission Group
             program manages Commission Group codes.

             The Sales-Rep Code plus Commission Group Code combine to form the primary portion of the
             key to the Commission Rate table. Within each Sales-Rep/Commission Group Code
             combination, rates may be defined for specific Commission Codes while all other
             commissions could be based upon the default Commission Code (keyed as ****, four asterisk
             characters). Commission Codes are managed by the Maintain Commission Codes program.

             Based upon an invoice‟s sales-rep code and customer code (which identifies the commission
             group code) and the product‟s commodity code (or commission code, as applicable), the
             appropriate commission rate record is extracted.

             The formula for selecting the appropriate commission is:

             If invoice discount % (or profit %) is greater than or equal to Level 1 %, use that commission
             rate, else go to next level. (If reach Level 6 and test still fails, Level 6 rate is used.) Note that
             commission is calculated on each product detail line (commission rates may vary from
             commodity to commodity on any one invoice).

             Example A: Table if commission depends upon sales discount

             Sales-Rep Code:            **

             Commission Group Code:              ******

             Commodity (or commission code) :             ****


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                            Page     99
      08/22/11
             Sales/Gross Profit:       Sales

                                       Level 1 Level 2 Level 3 Level 4 Level 5 Level 6

             Discount/GP%:             50.00    40.00    30.00    20.00    10.00    0%

             Commission % Rate:        2.00     3.00     4.00     5.00     6.00     7.00

             The above rate table applies to all salesreps, all customers coded Commission Rate Code
             “******” and all commodities (i.e., products).

             If sales discount % =     60%      then commission rate = 2%

                                       45%                                 3%

                                       20%                                 5%

                                       0%                                  7%

             Example B:Table if commission is one set rate no matter what the invoice discount is.

             Sales-Rep Code:           **

             Commission Group Code:             ******

             Commodity :      ****

             Sales/Gross Profit:       Sales

                                       Level 1 Level 2 Level 3 Level 4 Level 5 Level 6

             Discount/GP%:             0.00     0.00     0.00     0.00     0.00     0.00

             Commission % Rate:        5.00     0.00     0.00     0.00     0.00     0.00

             The above rate table applies to all salesreps, all customers coded Commission Rate Code
             “******” and all commodities (i.e., products).

             If sales discount % =     60%      then commission rate = 5%

                                       45%                                 5%

                                       20%                                 5%

                                       0%                                  5%

             If sales discount is equal to or greater than zero, commission rate will = 5%.

             Example C: Table if commission is based upon invoice profit margin.

             Sales-Rep Code:           **

             Commission Group Code:             ******


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     100
      08/22/11
             Commodity :       01**

             Sales/Gross Profit:      Sales

                                      Level 1 Level 2 Level 3 Level 4 Level 5 Level 6

             Discount/GP%:            50.00    40.00    25.00   10.00    1.00    0.00

             Commission % Rate:       7.00     6.00     5.00    4.00     3.00    0.00

             The above rate table applies to all salesreps, all customers coded Commission Rate Code
             “******” and all products in product line “01”.

             If gross profit % =      60%      then commission rate = 7%

                                      20%                                4%

                                      0%                                 0%

                                      10%                                0%



            Place your cursor in the white box in the top left hand corner of the screen and type
             SA02. Press tab.

            Click on the „First Record‟ button.

            Double-click on the item in the listbox.

                      This example illustrates a default scenario. The use of „*‟ to fill the
                      sales rep, commission group and commission code results in a
                      commission structure that will be used in the absence of a more
                      detailed structure.

            Click on the „Next Record‟ button.

                      This example illustrates commission rates that are applicable to a specific sales rep
                      for selected ranges of products.

            Click on the „Next Record‟ button.

            Double-click on the item in the listbox.

                      This example illustrates a commission rate based on the gross margin
                      of the item. In addition, the commission will be split. 20% of the
                      calculated commission will go to sales rep „GS‟. The remaining 80%
                      will apply to sales rep „SY‟.

            Click on the „X‟ in the upper right corner of the screen.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     101
      08/22/11
                     We will not process any transactions in this section. Note, however,
                     the menu selections within the sales analysis module.


         Maintain Royalty Rates

            Place your cursor in the white box in the top left hand corner of the screen and type
             SA05. Press tab.

            Double-click on the first item shown in the list box.

                     This example illustrates a royalty rate that is applicable to a specific product. Note that
                     the „Group‟ field is disabled when the record is recalled. Royalty rates may be defined
                     for either specific products or for a group of products (as defined by a commodity
                     code). „*‟ filling is not supported in this program. Royalties are calculated as a fixed
                     percentage of the net sales amount.

            Click on the „X‟ in the upper right corner of the screen.




Month-End Closing Procedures


                     The Sales Analysis system allows the user to process invoices for the
                     next month prior to completing all invoices/credit notes for the current
                     month open. As invoices are processed, their corresponding sales
                     statistics update either “this month” sales fields or “next month” sales
                     fields (based upon the invoice date) in the Sales Analysis master files.

                     Once all invoices/credit notes for the current month open have been
                     processed, all desired customer and product sales reports must be
                     printed. Upon completion of all sales reporting, the month-end Close
                     Sales Fiscal Period program is run.

                     The Close Sales Fiscal Period program closes the invoicing cycle for
                     the current month open. “This month” and “next month” sales fields
                     are automatically reset (i.e., any “next month” business moves into the
                     “this month” fields; “next month” fields are cleared). The invoicing
                     control date, which internally identifies the current month open for
                     invoicing, is incremented to the next month end date. All subsequent
                     invoices/ credit notes must be dated within the “new” current month
                     open or may be dated one month into the future (i.e., dated within the
                     next month).



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     102
      08/22/11
                    The updating strategy used for Sales Analysis master files allows the
                    user to print sales reports or perform sales inquiries, on demand, as of
                    the current month open or up to and including any business recorded
                    in the “next” month.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc               Page    103
      08/22/11
ACCOUNTS RECEIVABLE

Cash Receipts and Adjustments

         Post Cash Receipts/Adjustments

                 The Cash Receipts / Adjustments program (AR30) is used to enter cash receipts and
                 account adjustments. Cash received from a customer may be applied to specific invoices
                 or may be paid on account. Discounts taken by the customer are captured at the same
                 time. Payments on account will remain on file as outstanding items until they are applied
                 to specific invoices.

                 Program AR87 (Delete Paid Off Invoices) will clear all invoices that have been fully paid as
                 of the last period end or as of a specified date.

                 Miscellaneous cash (cash received that does not affect a customer account) is also
                 processed through program AR30. The offsetting credit is output to a General Ledger
                 account entered by the operator. This allows the system to provide the user with a
                 complete audit trail of all cash received.

                 AR30 processes all adjustments affecting a customer‟s account but not involving cash
                 received, such as:

                 ·   apply payments on account to specific invoices

                 ·   write off bad debts

                 ·   re-apply payments posted to the wrong account or against the wrong invoice

                 ·   capture discounts missed in original entry

                 ·   to post debit notes received from the customer

                 In some cases, such as write-offs, an offsetting entry to the General Ledger is required.

                 Details of a customer‟s account may be reviewed at any time in order to aid in determining
                 payment/adjustment distributions.

            Place your cursor in the white box in the top left hand corner of the screen and type
             AR30

             Prior to posting cash, you must create a new „batch control‟. The batch total
             for this exercise is 15000.00. Use the displayed demo date for the batch.

            Press the enter key to choose „Create New Batch‟

            [Tab] to accept the default posting date, then type 15000 in the „Total‟ box.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page    104
      08/22/11
            Click „Update and Proceed‟. When presented with the message box indicating the
             batch number, click „Ok‟.

                     The batch total is used as an internal control to ensure that all cash is
                     entered. The batch number is used as a system control. Multiple
                     batches may be simultaneously processed by one or more operators.
                     Batches may be suspended and re-entered at a later time.

            Enter „BUSCOM‟ in the „Payor‟ box and then press „Tab‟.

            Enter „12345‟ in the „Cheque‟ box and then press tab.

            Enter „2744.50‟ in the „Amount‟ box and then press tab.

                     The payor represents the organization issuing the payment. The
                     cheque number and amount are used as references and proof totals
                     respectively. Folders 1, 2 and 3 are used to select and pay open
                     accounts receivable items. Folder 4 is used to make adjustments
                     directly to the general ledger. The typical posting process consists of
                     initially selecting invoices via folder 2 and then, to the extent required,
                     making adjustments to the selected invoices using folder1.

            Click on folder 2 (Open Invoices).

                     One line for each unpaid invoice is displayed. Note that the customer
                     code could be changed, allowing the „payor‟ and „customer‟ to be
                     different.

            Double-click on each of the first three invoice lines.

                     As you double-click on a detail line, note the „>‟ appearing at the
                     extreme left. This is an indicator that the line has been selected. It can
                     be de-selected by a second double-click. In this example, we are
                     selecting three invoices for payment. After the initial selection, we will
                     adjust the payment on one invoice to illustrate a partial payment.

            Click on the „Pay selected invoices‟ button.

                     The three selected invoices are processed as „paid‟. The program flips
                     to folder 1 and re-displays the three items. We can then recall an item
                     and change the payment (credit) amount. Note the „proof‟ amount of
                     274.75-.

            In folder 1 (Invoice Payment), double-click on the third invoice (N002893).

                     This will recall the invoice. The payment amount is highlighted in the
                     „credit‟ box. We are going to adjust this payment to $1,000.00,
                     representing a partial payment on the invoice.

            Enter 1000 in the „Credit‟ box and click „Update‟

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page   105
      08/22/11
                     The invoice information is updated and the proof is recalculated to
                     zero, representing a balanced cheque.

            Click on the „New‟ button.

                     The screen will clear and you will be positioned at the „Payor‟ field.
                     The cheque posting is complete. We can examine other aspects of
                     the program.

            Click on folder 3 (Automatic Payment).

                     We will not be processing anything in this folder. Note, however, that
                     we could select ranges of invoices by specifying a range of invoice
                     numbers or invoice dates or by specifying a single Advance Shipment
                     Notice Number. The ASN references are generated by the EDI and
                     invoicing modules.

            Click on folder 4 (General Ledger)

                     We will not be processing anything in this folder. Note, however, that
                     this folder can be used to process adjustments to accounts receivable.
                     It can also be used to process cash receipts that are not related to
                     accounts receivable. We will illustrate these points by selecting
                     choices from the menu bar at the top of the screen.

            Click on „Adjustment‟ (in the menu bar at the top of the screen). Then type „1‟ as the
             bank code and [Tab]. Finally, click „Ok‟.

                     Adjustments are made to match debits and credits within accounts
                     receivable or to write-off outstanding open items (as discounts, interest
                     income or as other general ledger postings, such as bad debts). Since
                     there is no deposit amount, there is no need for a payor, cheque
                     number or cheque amount.

            Click on GL Trans (in the menu bar at the top of the screen). Then click on „Misc Payor.

                     Note that the program can be used to process payments received from
                     organizations and individuals who are not customers. In such cases,
                     the distribution of the cheque amount will be made directly to the
                     appropriate general ledger account.

            Close the „Miscellaneous Payor Name and Bank‟ window by clicking on the „X‟ in the
             upper right corner.

            Click on „GL Trans‟ (in the menu bar at the top of the screen).

                     We are not going to process transactions in this folder but note that
                     you may record interest income or „quick pay‟ discounts in this folder.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                      Page    106
      08/22/11
                     You may also select a general ledger account make any other
                     adjustment that may be required.

            Close the „Post Cash Receipts/Adjustments (AR30) program by clicking on the „X‟ in the
             upper right corner. Pause to note the warning message and then click on the „Yes‟
             button to exit the program.

                     We had entered a batch total when we first came into the program.
                     The program checks the proof at both the cheque level and at the
                     batch level. You must balance each cheque. You have the option to
                     exit the batch even though the batch proof is not zero. You may then
                     recall the batch at a later point and continue processing.

                     This ends the cash posting tutorial.



ACCOUNTS PAYABLE

Process Invoices

         Enter Invoices

             Program AP30 is used to enter vendor invoices and credit notes. Invoices are posted against
             a specified bank code. The program checks for entry of a valid vendor code and ensures that
             the invoice being posted is not already on file. Paid invoices are kept on file until the user via
             program AP88 deletes them. This reduces the risk of double posting an invoice that has
             already been paid. The invoice due date for payment and discount date are calculated based
             on the vendor‟s term‟s and the invoice date. The operator may accept the calculated
             due/discount dates or enter a specific date. If the due date is entered as “H”, the invoice will be
             put on hold and will not be released for payment until a valid due date is assigned.

             For each invoice, a message may be typed that will print along with the invoice details on the
             cheque stub. Invoices may be coded with a flag that will tell the cheque writing cycle to
             produce a cheque for that invoice separate from any other invoices being paid for that vendor.

             Invoices may be further categorized by branch in a multiple branch environment. This will
             allow running of the aged trial balance by branch giving an outstanding payables listing by
             branch office.

             Each invoice can be assigned a bank code at time of entry. If the bank is designated “Foreign”
             the operator can enter the G/L distribution in either foreign or domestic currency. If “Foreign”
             currency is entered the system will automatically convert to domestic for posting to the general
             ledger.

             Invoices for the current open period or for future periods may be entered in the same batch. A
             routine to handle recurring future invoices (ie, rent invoices) will automatically duplicate the
             invoice amount and GL distributions. The operator need only enter the invoice number and
             date.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     107
      08/22/11
             Freight dollars particular to an invoice will update freight analysis statistics for the vendor.
             Posting of a freight invoice/credit (ie, a courier bill) will allow the user to distribute a portion of
             the freight bill to multiple vendors, thereby updating vendor freight analysis statistics.

             Distribution to the General Ledger is captured by account for as many accounts as are needed
             to fully distribute the invoice amount. Future invoices will generate GL Collector File records
             dated same as the invoice date. Consequently, future invoices will update future GL balances.

             For American Users, GST is not applicable. To disable GST calculations, go into program
             IN01 and set the rate to zero for codes „GB‟ and „GC‟.



            Place your cursor in the white box in the top left hand corner of the screen and type
             AP30. Press tab.

             Prior to posting cash, you must create a new „batch control‟. We will ignore
             the batch total for this exercise. Use the displayed demo date for the batch.

            [Enter] to choose „Create New Batch‟

            [Tab] [Tab] to accept the default posting date and the batch total of zero.

            Click „Update and Proceed‟. When presented with the message box indicating the
             batch number, click „Ok‟.

                      The batch total may be used as an internal control to ensure that all
                      invoices are entered. The batch number is used as a system control.
                      Multiple batches may be simultaneously processed by one or more
                      operators. Batches may be suspended and re-entered at a later time.

            Enter „CARSUP‟ in the „Vendor‟ box and then [Tab].

            Enter „123456‟ in the „Invoice‟ box and then [Tab].

                      The vendor represents the organization from whom the purchase has
                      been made. Folder 1 is used to enter summary invoice information.
                      The distribution of the invoice is accomplished by using some
                      combination of folders 2,3 and 4 depending on whether receipts
                      accrual is enabled.

            [Tab] [Tab] to move to the invoice date.

                      The type „Payable‟ will be outlined. We will not be changing the type.
                      Note, however the five types of entries. The default transaction Type
                      for the program is „Payable‟. Press Tab to accept the default or select
                      one radio buttons for the transaction type required:

                       Payable Invoices - By definition, a Payable invoice is an invoice
                        dated within the current or next fiscal AP period. GL distributions
                        will be dated per the displayed GL posting date. If an invoice is to

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                             Page     108
      08/22/11
                         be distributed under a different GL date than displayed, change the
                         GL Posting Date.

                      Credit Notes - A supplier Credit item, which actually debits
                       Accounts Payable on your books, has the same dating rules as
                       „Payable‟ invoices.

                      Future Invoices - A Future invoice is an invoice dated beyond the
                       current or next fiscal A/P period. GL distributions for these invoices
                       will be dated per the Invoice Date. Within the „Future‟ invoice
                       posting routine, recurring invoices may be created.

                      Freight Invoice - A Freight invoice is the same as a Payable invoice
                       except instead of entering a single freight amount for the supplier in
                       the Freight, the Modify & Review Freight Invoices program will
                       automatically be called and you may distribute freight dollars to
                       specified vendors. I.e., if the invoice being posted is from UPS,
                       then you may want to distribute those dollars to several vendors.
                       Input in the Freight field will be skipped.

                      Freight Credit - A Freight credit is the same as a Credit invoice
                       except the freight credit may be distributed to specified vendors in
                       the same way as a Freight invoice is processed.



            [Tab] six times until you arrive at the Gross Amount field.

                     As you tab through the fields, note the dates, the check boxes for
                     holding the invoice and for forcing a separate cheque. Also not the
                     message field. Contents of this field will print on a cheque stub.

                     Feel free to change any data in these fields.

            Enter an amount and [Tab]. Suggestion: 214.00 for Canada, 200.00 for the US.

                     For Canadian users, note the default GST amount of 14.00

            [Tab] five times. You will arrive at the end of folder 1.

                     Note the fields as you pass them:

                      Discount: The amount of 4.00 represents 2% applicable for this
                       vendor (gross amount, net of GST).

                      Branch and Bank code: Defaults from the vendor master file.

                      Pay To Vendor: Defaulted from the vendor file.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     109
      08/22/11
                      Enter Receipt Accruals checkbox: Used to select receipt accrual
                       matching via folders 3 and 4. This tutorial will not process
                       transactions through receipt accrual processing.

            [Tab] once more. You will arrive at folder 2.

            For Canadian users, the GST amount (14.00) is displayed. [Enter] to update the detail
             line.

                     Updating the GST input tax credit generates an entry to the general
                     ledger to recover the GST associated with the purchase. The amount
                     is defaulted based on the gross amount of the invoice. The default
                     occurs only for domestic accounts.

            Type 150 [Enter].

                     The default value of 200.00 represents the remaining amount to be
                     distributed. The general ledger account is defaulted from the vendor
                     file. By keying an amount or 150, the invoice remains with a proof of
                     50.00. This amount must be distributed to another general ledger
                     account.

            Click of the ? to the right of the general ledger field. Select any general ledger account
             and then press tab to move to the debit field.

            Type 50 [Enter].

                     By entering an amount equal to the proof, the program will proceed to
                     the point of entering a new invoice.

            Press shift + tab to go to the vendor field.

            Enter CARPAP [Tab].

                     Note that the bank code has changed from „1‟ to „2‟.

            Repeat the above steps, entering an invoice amount of 200.

                     Note the domestic equivalent of 295.00. This represents the invoice
                     amount converted to domestic currency. The accounts payable
                     system will control the invoice in foreign currency but will update the
                     general ledger in domestic.

            [Tab] several times until you arrive at the second folder.

            [Enter] to accept the displayed amount.

                     The invoice is now balanced.

            Click on folder 3 and then on folder 4.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                      Page        110
      08/22/11
                      Note the ability to match accrued receipts, updated via the purchase
                      order receiving process, with accounts payable entered via this
                      program. For a functional review of receipts accrual, refer to the help
                      text.



             Click on the X in the upper right corner of the screen to exit the program.

             Click on Yes to confirm that you wish to exit the program.

                      The batch total is checked prior to exiting. You may exit and recall a
                      batch at a later time. The batch will be updated by printing the audit
                      trail using program AP31.

Displays / Reports / Diagnostics

          Display Vendor Accounts

             Place your cursor in the white box in the top left hand corner of the screen and type
              AP45 [Tab].

                      This will take you into the accounts payable display program.

             Enter AMEEXP [Tab].

                      Recall American Express. Note the open ivoices.

             Click on folder 2 (or press alt+2 to choose folder 2).

                      Note the invoice detail invoices in the history folder. Note that the
                      sequence is in reverse chronological order. The purging of history is
                      controlled by the user.

             Click on folder 3 (or press alt+3 to choose folder 3)

                      Note the payment details. The sequence is in reverse chronological
                      date of payment.

             Click on folder 1 and then click on the first invoice.

             Click on folder 4.

                      Note the general ledger distribution for the selected invoice.

             Click on the X in the upper right corner of the screen to exit the program.

                      We will now review the computer cheque generation / control process.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page   111
      08/22/11
Process Computer Cheques

         Print Cash Requirement Report

            Place your cursor in the white box in the top left hand corner of the screen and type
             AP40 [Tab].

                     The function of this program is to generate the “payments due” file that is used to print
                     computer-generated cheques.

                     Two date parameters are entered by the operator that dictate the selection of invoices
                     to be paid:

                      Limiting Due Date: Each invoice‟s due date is compared to this
                       date. If the invoice‟s due date is prior to or equal to the limiting due
                       date, that invoice will be selected for payment

                      Discount Qualification Date: An invoice may not be due for
                       payment per its due date but may, however, be due for payment in
                       order to take advantage of vendor‟s discount terms. Each invoice‟s
                       discount date is examined to be within the range of discount
                       qualification date and limiting due date. If this test is satisfied, that
                       invoice will be selected for payment even though its DUE date may
                       be beyond the limiting due date.

                     Discounts will be applied if the invoice‟s discount date is within the range of discount
                     qualification date and limiting due date or if the discount date is equal to or greater
                     than the invoice‟s due date. I.e., this condition indicates that you wish to take a
                     vendor‟s discount no matter when the invoice is paid.

                     The Cash Requirements Report may be altered via program AP41. Once any
                     alterations have been made, the “payment due” file is used by program AP42 to print
                     computer cheques. If a reprint of the Cash Requirements Report is desired following
                     alterations via program AP41, it may be obtained by selecting format 2 of this
                     program.

                     Upon entry into this program, the “payment due” file is checked to see if any records
                     exist. If the file is empty, the generation process will begin per the parameters entered
                     by the operator. If records do exist, the operator may choose to keep the file or
                     regenerate it. (IE, AP40 may have been run but you now wish to regenerate it with
                     different dates). This allows you to re-run this program as many times as you wish
                     until you produce the desired Cash Requirements Report, which may then be “fine-
                     tuned” via program AP41. Note that if you have already entered alterations via
                     program AP41, they will be lost if you choose to regenerate! Also, if there are records
                     in the file and you want to find out what they are, simply choose format 2 to print the
                     current file contents.

                     Upon selection of this program the forms selection message is displayed. Load the
                     appropriate paper and select the desired printer.

            Select a printer (or you may select „screen‟). Click „Ok‟.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     112
      08/22/11
                     We want to generate a cash requirement report. If desired, you may
                     use the copy in the appendix.

            [Tab] four times to select format 1, sequence 1, skip the requirement for a page break
             and to accept all displayed levels of detail.

                     Two formats are offered. The initial run (format 1), generates the
                     requirements report. Format 1 must be run using sequence 1. Once
                     generated, alterations may be made via program AP41. A re-print of
                     the revised cash requirement report may be obtained by re-running the
                     report using format 2 and sequence 2. Format 2 must be run using
                     sequence 2.

            For each of the four restrictions, double-click on the restriction and respond
             accordingly.

                     Each of the restrictions is mandatory.

                      Limiting Due Date: Enter „011598‟ to select January 15, 1998.

                      Discount Date: Enter „14‟ and press tab to select December 14,
                       1997.

                      Print Not Due Amount: Select the restriction and then click „Ok”.
                       There is no need to print invoices that are not due.

                      Bank Account String: Enter „1‟, press tab and then click „Ok‟ to
                       choose bank „1‟ only.

            [Tab] four times to select the range.

                     This will generate range number 001, selecting from „Start‟ to „End‟.
                     The focus will be on the final „Ok‟ button..

            Click „Ok‟ to run the report.

            At the end of the report, click „Ok‟ to accept.


         Alter Cash Requirement

            Place your cursor in the white box in the top left hand corner of the screen and type
             AP41 [Tab].

                     Program AP41 will allow us to alter the newly generated cash
                     requirements prior to printing cheques..

            Click on the „First Record‟ button.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page   113
      08/22/11
                     Account „AMEEXP‟ is displayed. Two invoices are selected for
                     payment. We will not change either of these.

            Click on the „Next Record‟ button.

                     Account „CARSUP‟ is displayed. We will alter two of the invoices here.
                     In one case, we will partially pay the invoice. In a second case, we will
                     choose to not pay one of the invoices.

            Double-click on invoice 18433.

                     This will recall the invoice.

            At the „Author. Payment‟ field, type „1000‟ [Enter].

                     This will update the authorized payment to 1000.00, representing a
                     partial payment for the invoice.

            Double-click on invoice 18566.

                     This will recall the invoice.

            Click on the „Delete‟ button (or press alt+D)

                     The invoice is deleted from the payment selection. Note that the
                     invoice has not been deleted from the list of outstanding invoices. The
                     deletion relates to the payment process.

            Click on the „X‟ in the upper right corner of the screen to exit the program.

                     We will not print the cheques at this time. Note, however, that the
                     printing of cheques happens in program AP42. The cheque register is
                     printed via program AP43. This can be illustrated by showing the
                     menu selections within „Accounts Payable‟, „Process Computer
                     Cheques‟.

Process Manual Cheques

         Enter Manual Cheques / Adjustments

            Place your cursor in the white box in the top left hand corner of the screen and type
             AP50 [Tab].

                     This program can be used to process manual cheques, bank transfers
                     or bank drafts. In this example, we will process a bank transfer in a
                     foreign currency. In this case, the exchange rate has changed
                     between the time of entering the invoices and the time of payment.

            Double-click on bank account # 2 to select the account.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page    114
      08/22/11
                     You will enter the program and be positioned at the vendor code.

            Enter „CARPAP‟ [Tab].

            Click on the „Transfer‟ radio button.

                     Note that the „Generate #‟ button is enabled.

            Click on the „Generate #‟ button.

                     An internal control reference number is generated and the default date
                     is displayed.

            [Tab] to accept the default date.

            Type 29543.07 [Tab].

                     This represents the total amount of the two invoices we are paying.

            [Tab] to get to the invoice field.

            Type 003572 [Tab].

                     The invoice is displayed.

            [Enter] to update the invoice.

                     Note the foreign and domestic amounts and the proof.

            Type 003877 [Tab].

            [Enter] to update the invoice.

                     Note that the foreign total matches the amount of the transfer but a
                     proof of 590.86 remains. In our example, the foreign exchange rate
                     has gone from 1.455 to 1.475. The 0.02 difference applied to the
                     invoice total of 29543.07 is 590.86. This difference should be written
                     off to an exchange loss account in the general ledger.

            Click of folder 2 (or press alt+2).

            Click on the „Exchange‟ radio button.

                     The exchange general ledger account is defaulted.

            Enter a comment in the remark field then press tab.

                     Suggested comment: Dollar dropped.

                     Note that the „domestic‟ radio button is defaulted.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                    Page   115
      08/22/11
            [Tab] to move to the debit field.

            Type 590.86 [Enter].

                     The transfer is balanced.

            Click on the „X‟ in the upper right corner of the screen to exit the program.

                     We will not print the remittance advice at this time. Note, however, that
                     the printing of cheques happens in program AP52. The manual
                     cheque register is printed via program AP51. This can be illustrated by
                     showing the menu selections within „Accounts Payable‟, „Process
                     Manual Cheques‟.

                     This is the end of the accounts payable tutorial.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page    116
      08/22/11
GENERAL LEDGER

Enter Journal Entries

         Enter Journal Vouchers

            Place your cursor in the white box in the top left hand corner of the screen and type
             GL30 [Tab].

            Type 12345 [Tab] to specify a voucher number.

            [Tab] to accept „Normal‟.

            Note that an accrual entry will generate both a journal entry for the date specified and a
             reversing entry dated at the end of the next accounting period.

            [Tab] to accept the date.

            Type a description (suggestion: Provision for Income Taxes) [Tab].

            Type 11506010 [Tab].

             This will choose the Income Tax Provision account

            Type 10000 [Enter].

             This enters a detail line with a debit entry for 10,000.00. Note the debit amount, credit amount
             and proof amount in the upper right hand corner of the window.

            Type 11212010 [Tab] [Tab].

             This will choose the Income Taxes Payable account and position you at the credit field.

            Type 10000 [Enter].

             The proof is now zero. You may exit the program or go on to another journal entry.

            Click on the „X‟ in the upper right corner of the screen.

             Note that the printing / posting of the journal entry occurs using program GL31..




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     117
      08/22/11
Maintenance

         Maintain Standard Journal Entries

             This program allows the user to maintain a file of recurring journal entries that can be posted
             monthly with little or no additional operator effort.

            Place your cursor in the white box in the top left hand corner of the screen and type
             GL20 [Tab].

            We will not be creating any additional entries in this tutorial. Rather, we will be reviewing
             entries that already exist.

            Click on the „First Record‟ button.

             Note that this entry has the „recurring‟ radio button active. Recurring journals post constant
             amounts to the same GL accounts each period; once they have been set up, they do not
             change until such time as they require altering or deleting. Clearing journals post different
             amounts to the same accounts monthly. Amounts need to be set up each period in GL20.
             Once posted, the amounts are reset to zero.

            Click on the „Next Record‟ button.

             Note that this entry has the „clearing‟ radio button active.

            Click on the „Next Record‟ button several times, examining the entries on file.

            Click on the „X‟ in the upper right corner of the screen.




Display / Diagnostics

         Display Account Transactions

            Place your cursor in the white box in the top left hand corner of the screen and type
             GL45 [Tab].

            Type 11103010 [Tab] to specify an account number.

            Click on the Display Details button

            All entries in the general ledger collector file will be displayed.

            Click on the ? to the right of the Source Code field.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                             Page      118
      08/22/11
            Select IN - Sales Invoice Register

            Click on the Display Details button
             Only the transactions with the source code „IN‟ will be displayed.
            Click on the ? to the right of the Source Code field.

            Select ** - All entries

            Click on the ? to the right of the Starting Date field.

            Select December 12.

            Click on the Display Details button.

             Only the transactions dated on or after December 12 will be displayed.

            Click on the „X‟ in the upper right corner of the screen.

             We will not examine other programs in detail as part of this tutorial. Note, however, the various
             programs in the general ledger system.

            At the WinSol Demo Company menu, click on the Program menu option.

            Position the cursor on the General Ledger system option.

            Move the cursor right to Maintenance.

             Note the various set-up and maintenance programs.

            Move the cursor down to Control Budgets.

             Note the various programs in this area.

            Move the cursor down to Enter Journal Entries.

            Move the cursor down to Display / Diagnostics.

            Move the cursor down to Management Reporting.

             Financial statements are generated using report parameters entered and updated in programs
             found in the Maintenance section.

            Move the cursor down to Month-End.

            Move the cursor down to Year-End.

            Move the cursor down to Reporting Future Periods.

             At year-end, users may report future periods in the new year prior to closing the current
             year.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     119
      08/22/11
ORDER HOLDS
                 The WinSol Order Holds tutorial assumes that you have completed the WinSol
                 introductory tutorials and that you now have a working knowledge of the WinSol
                 environment. This tutorial employs many programs including customer maintenance,
                 customer displays, order entry, order scheduling, order printing, backorder releasing,
                 receiving, and order hold processing programs. They are used repetitively in some cases
                 to build experience with them.

                 WinSol provides six types of order holds that are designed to manage credit risks, prevent
                 unprofitable order handling, and support customer service. Let's examine each order hold
                 type along with a typical scenario that illustrates how the hold would be set, where
                 notification would occur and how we would handle them.


Credit Limit Holds
                 Credit Limit holds are an important line of defence in preventing costly credit exposure.
                 WinSol allows you to set credit limits on a customer by customer basis and will prevent
                 customers who have exceeded, or will exceed, their credit limit from receiving orders. It
                 does this by automatically assigning Credit Limit Holds to orders for that customer. The
                 following example illustrates one way in which a Credit Limit Hold situation might come
                 about.

                 Your accounts receivables department is concerned about a customer named Renforth
                 Estates, who has been irregular with their payments. You suspect they may become a
                 credit risk so to protect yourself you are going to check and if necessary change their
                 credit limit to reduce your exposure.

             Run the Maintain Customer Master (SU13) program and access Renforth Estates
              account, RENEST.

                 You notice their credit limit is set quite high at $2,500 and decide to reduce it to $500 to
                 ensure that you will have the opportunity to review their account before the risk increases.
                 WinSol keeps track of the value of all outstanding transactions and receivables for each
                 client and compares this information against the value of new transactions before it allows
                 them to be processed.

             Set the focus into the Credit Limit field, type 500, press [Enter] to Update the account
              and [Escape] to close the program.

                 Several days later Renforth Estates calls into your order desk and attempts to place an
                 order for 24 printer ribbons:

             Run the Enter Orders & Quotes (OE30) program. Access Renforth Estates account
              RENEST and prepare for an order by setting a Source Code. Then press [Alt + 3] to
              switch to the Lines tab.

             In the Product field, access the 1500 product, set the Qty order to 24 and press [Enter]
              to Update the line.

                 The order entry is complete, but before ending the customer call the order desk clerk
                 always attempts to release the order for processing.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    120
      08/22/11
            Press [Alt + W] or click the New button.

                 A warning message appears about the credit-limit issue. WinSol has examined the
                 customer's Credit Limit, assessed their current credit position, including what they owe and
                 what is on open orders and determined that this order would put the customer over their
                 assigned limit. Here we have a front line opportunity to handle the credit-limit issue with
                 the client, to skilfully hand the client off to the accounts receivable department, or to simply
                 accept the credit hold and let the order flow down stream where it will be handled by the
                 order hold processing.

                 In some organizations, the sales manager or supervisor may have the authorization from
                 the accounts receivables department to override a credit hold at the point of order entry.
                 WinSol supports this delegation of authority by providing an override. If the credit limit
                 warning message "Put the order on hold?" is answered with No, a password dialog box
                 will appear requesting the override password confirmation.

            Press [Y] or click the Yes button to accept the Credit Limit hold and allow it to be
             handled down stream. When the Enter Orders & Quotes program resets from the order
             press [Escape] to close the program.

                 When Credit Limit order holds are handled downstream from the order entry processing,
                 WinSol provides a number of tools that can be used to manage the orders on hold. The
                 most important of these tools is the Print Order Hold File (OE53) program that can
                 produce a current listing of those orders on any or all order hold types for any or all sales
                 offices.

            Run the Print Order Hold File (OE53) program. If you do not currently have access to a
             printer choose the SCREEN option.

            When the Order on Hold Report Restrictions dialog box appears, enable only the Credit
             Limited Exceeded option for now and accept the dialog.

            When the Warehouse Selection dialog box appears the All Warehouses option will
             already be selected. Accept the dialog as is and the report will be produced.

                 In an organization with multiple sales offices, the Warehouse Selection dialog can be
                 configured to a single sales office/warehouse so that each sales office can manage their
                 own order hold processing.

                 The Order Hold File report produces a listing by Customer and Order of all orders
                 matching the selected order hold type(s) for the selected warehouse(s). On this report
                 you should see the order being held because of a Credit Limit hold for the Renforth
                 Estates.

            If you printed to the screen, make a note of the order number being held for Renforth
             Estates.

            Accept the report.

                 Armed with this information your accounts receivable staff can now determine how they
                 will respond to this credit exposure before it becomes a credit risk.

                 Let us imagine then that our accounts receivable department has spoken with the
                 accounts payable contact from Renforth Estates, who has assured us that they can do a

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page     121
      08/22/11
                 better job of paying our invoices in the future. You agree to release this order but ask that
                 they pay it promptly to prevent future orders from being held.

            Run the Release Orders on Hold (OE65) program.

                 The Release Orders on Hold (OE65) program provides an on-screen list of orders being
                 held for order hold types across all sales offices/warehouses. The list is sorted by hold
                 type, by customer and then by order number and includes a series of yes/no columns
                 under each of the order hold types named above. You can use the list to locate the
                 customer whose order you wish to release and double-click its list item to select it. Or, you
                 can specify the order number directly using the Order field.

            In the Order field, type the number for the Renforth Estates order being held for a Credit
             Limit and press [Tab] to select it.

                 When an order is selected for release in the Release Orders on Hold program, the
                 Release field(s) for any order hold against it will be activated for entry. You can release
                 the hold(s) against the order by enabling the Release field(s).

            Press [Tab] to set the focus on the Credit Limit Release option and press the
             [Spacebar] to enable it for release or click it so that a checkmark appears. Then, press
             [Enter] to Update the order or click the Update button.

                 Assuming that all other conditions have been met, the order is now configured for release
                 downstream by one of the order handing processors.

                 The Credit Limit amount set for customers in the Maintain Customer Master (SU13)
                 program is the key to using Credit Limit holds effectively. If the Credit Limit is set to zero,
                 no credit holds will be set.

                 There are four situations in which an order would be put on credit hold. The first was
                 illustrated above as the customer's outstanding accounts receivables plus open orders
                 exceeds their assigned Credit Limit (SU13). To illustrate the second and third situations,
                 let's imagine that you have heard that another client, Humberland Designs, has become a
                 serious credit risk and they have outstanding receivables with your company. You decide
                 that you are not going to release any order to them unless they clear up all of the
                 outstanding receivables first.

            Run the Maintain Customer Master (SU13) program and access the HUMDES account.
             Change the Status from active (A) to hold (H), Update the record and exit the program.

                 This will result in new orders being put on Credit Limit hold automatically.

            Run the Enter Orders & Quotes (OE30) program and access the HUMDES account.

                 When the account is accessed the message "Customer Status is 'H' This order will go on
                 credit hold." appears to alert your order entry staff. Again, we have a front line opportunity
                 to handle the credit-limit issue with the client while still being able to provide the customer
                 with service by taking and holding the order. It is most critical that the importance of the
                 Credit Limit hold be understood by all and that the Credit Limits and authorization to
                 release an order on Credit Limit hold be held by those responsible for the managing credit
                 risks.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     122
      08/22/11
            Press [Enter] to accept the message, press [Alt + W] or click the New button to reset the
             program, and then press [Escape] to close it.

                 We have prevented new orders from shipping to Humberland Designs, but what about
                 open orders? Let's see what happens to open orders against this account now that it is on
                 credit hold.

                 Imagine that in the background right now there is an outstanding backorder against the
                 HUMDES account…and a truck is pulling up to the warehouse dock at this very moment
                 with stock to fill that backorder. First we will simulate a receipt of stock that will fill the
                 backorder, then we'll release the backorder and see what happens to it given the
                 account's Hold Status.

            Run the Enter Receipts & In-Transits (PO60) program.

            Press [Alt + C] or click the Create New Batch button.

            Press [Enter] to accept the proposed GL Posting Date.

            Press [Enter] again or click the Update and Procced button.

            Accept the message displaying your batch number by pressing [Enter] to clicking the
             OK button.

            Accept the default batch type as receipt by pressing [Enter] or clicking the No button.

            In the Supplier field, type DAITEK and press [Tab] to access the Daisytek Canada
             supplier.

            In the Packing Slip field, type 123456 and press [Tab] to set supplier's reference.

            Press [Alt + 4] or click the Without PO tab.

            In the Product field, type 1501 and press [Tab] to access the product we need to
             receive.

            In the Quantities Received field, type 144 and press [Enter] to Update the receipt line.

            Press [Alt + B] or click the Update Batch button.

            When the update batch confirmation dialog appears, press [Y] or click the Yes button to
             process the receipt in the batch.

            When the create another batch confirmation dialog appears, press [N] or click the No
             button to exit the program.

                 The product for the backorder has now been received. Let's release the backorders now
                 using the Release Backorders (OE61) program that will examine the stock position for all
                 backorders and reserve stock for the order now that it's available.

            Run the Release Backorders (OE61) program.

            In the Warehouse field, type 01 and press [Tab] to select the Toronto warehouse.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     123
      08/22/11
            Press [Alt + A] or click the Release All Backorders button.

            When the focus returns to the Warehouse field the release program is complete. Press
             [Escape] to close the program.

                 Our backorder should now be ready for release by one of the order handling processors.
                 If we were to look at the order details at this point we would note that the On Backorder
                 quantities will have converted into To Ship quantities.

                 Keep in mind that this is happening in the background and that our accounts receivable
                 staff is unaware that the backorder is ready to ship. If they were looking at this point the
                 first indication to an accounts receivable clerk that open orders are involved in this
                 situation would be the Shippable amount displayed on the AR Status tab of the Customer
                 Inquiries (SU45) program.

            Run the Customer Inquiries (SU45) program, access the HUMDES account and press
             [Ctrl + Tab] to switch to the Customer AR Status tab or click the tab labelled T.

                 On the right side of the screen is displayed information about the customer's current AR
                 status. The last figure in the group is the Shippable amount. If this amount is greater than
                 zero then at least one open order is involved.

            Switch to the Orders tab by pressing [Alt + Q] or click the tab labelled Q.

                 The Orders tab shows us any open orders against Humberland Designs' account. The
                 backorder is the order showing a Purchase Order of 682138. Note the Holds column in
                 the middle of the list. If the backorder were already on Credit Limit hold a C would appear
                 under the Holds column. The Status column towards the right side of the list informs us
                 that the backorder is still in the Entered state, which means that it has not yet been
                 scheduled and we are still able to edit it if we wish to do so. In a situation where you were
                 just setting the account hold, if the status showed Scheduled or Printed we would need to
                 contact the shipping department to get them to hold the order physically as it is already
                 being processed for shipment. If we needed to contact shipping about this order we can
                 access additional information about the order to assist us in that conversation.

            Select the backorder on the list (Purchase Order 682138) by clicking it, then click the
             Display Details button.

                 The Customer Inquiries program will call up the Display Orders by Customer (OE45)
                 program and show us the order we selected, including its detail lines. As mentioned
                 earlier, when the Release Backorders (OE61) program reserved the stock for this order
                 the B/O quantity was converted to Ship quantities.

            Click the More Header Info button.

                 The Order Header Info display is presented and shows us additional information that may
                 be important in describing where the shipping department will find this order (if it had
                 printed already and you wanted to hold it physically.) Specifically, the Ship Via code may
                 be used by shipping to stage orders for delivery. Since this order has not been scheduled
                 or printed yet, let's see what will happen to it when it is.

            Press [Escape] twice to close the Order Header Info display and the Display Orders by
             Customer program. We will leave the Customer Inquiries program running for now so
             that we can access it again later.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     124
      08/22/11
            Switch to the WinSol Program Menu, run the Schedule Orders for Printing (OE32)
             program and answer Yes to the prompt to schedule orders.

            From the Warehouse Selection dialog, accept the Toronto warehouse.

            When the Ship Via dialog appears, press the [Spacebar] to enable the All Ship Vias
             option and accept the dialog box by pressing [Enter], which will Start the scheduling.

                 When the Schedule Orders for Printing program finishes, it will display a summary of the
                 number of orders scheduled and the number of orders to be printed.

                 If the number of orders to be printed is greater than zero, please run the Print Shipping
                 Documents (OE34) program after to the screen so that the file will be empty for other
                 examples later.

            Accept the summary message and if necessary run the Print Shipping Documents
             (OE34) program.

            Switch back to the Customer Inquiries (SU45) program that we left running earlier.

                 You may note that the Order tab is still displayed, and that the order line appears to be
                 unchanged.

            Press [Ctrl + Tab] and then [Shift + Ctrl + Tab] to refresh the display.

                 This action will switch to the next tab and back again, which causes the Customer
                 Inquiries program to redisplay the information in the orders list. Notice how the backorder
                 for Humberland Designs (Purchase Order 682138) now shows a Credit Hold in the Holds
                 column. By changing the customer's Status to Hold in the Maintain Customer Master
                 (SU13) program we have prevented the order from being released automatically by
                 putting it on Credit Hold (the third situation) and it can now be addressed by those
                 responsible for managing the Credit Holds.

                 Like all other order holds, Credit Holds can be reported using the Print Order Hold File
                 (OE53) program. When Humberland Designs clears up its credit issues with your
                 company, you will change its Status in the Maintain Customer Master (SU13) program
                 back to Active and then use the Release Orders on Hold (OE65) program to configure
                 their held orders for release.

                 The forth way in which orders will be put on Credit Hold is actually a feature that WinSol
                 provides for customer service. Order for customers with a Pending Status will be put on
                 Credit Hold automatically. This allows you to create the customer account in Maintain
                 Customer Master (SU13) and take orders against it that will then be held until the
                 accounts receivables staff approves the account.


Delinquency Holds
                 Delinquency order holds are another important safety mechanism that WinSol provides to
                 control credit risks. The delinquency status of a customer is calculated as the number of
                 days between the system date and the customer's oldest debit item (invoices) in the
                 accounts receivable module. Each time a customer is accessed in one of the sales
                 transaction programs, i.e., Enter Orders & Quotes (OE30), their delinquency status is
                 calculated and compared against the number of days configured against the customer


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     125
      08/22/11
                 account by the Maintain Customer Master (SU13) program. If the calculated delinquency
                 status is greater than the entered number of days a Delinquency Hold will be set against
                 the open orders for that customer by one of the order handling processors. Let's illustrate
                 this process.

            Run the Maintain Customer Master (SU13), access the BUSCOM account, change the
             Delinq. Days field to 60 days, Update the record and close the program.

            Run the Customer Inquiries (SU45) program, access the BUSCOM account and switch
             to the AR Status tab.

                 The Customer Inquiries (SU45) AR Status tab includes a Delinquency Days panel that
                 displays both the Entered and Calculated values. When the Calculated value exceeds the
                 Entered value the customer is said to be delinquent in paying their invoices.

            Run the Enter Orders & Quotes (OE30) program, access the BUSCOM account, and
             accept the Alternate Ship-To message.

                 As the BUSCOM account is now delinquent a warning message appears to alert you that
                 the condition exists.

            Accept the delinquent message by pressing [Enter] or click the OK button.

            Set the Source and press [Alt + 3] to switch to the Lines tab.

            Order up a dozen 8201 pens and accept the line.

            Release the order by pressing [Alt + W].

                 Another warning message appears now to remind you that the customer's account is
                 delinquent and that the order will be held; it does not offer to release the order. Here we
                 have another front-line opportunity to handle the accounts receivable situation with the
                 client or to let the situation flow downstream where perhaps the AR staff will be able to use
                 the situation as leverage in securing payment against the items causing the delinquency.

            Accept the message and exit the program.

            Run the Customer Inquiries (SU45) program, access the BUSCOM account, and switch
             to the Orders tab.

                 If we review the orders list we can see that the order we just released shows a D under
                 Holds column representing the Delinquency Hold. The Print Order Hold File (OE53)
                 program would report delinquency holds and once the decision is made to allow the
                 orders to ship the Release Orders on Hold (OE65) program would be used to remove the
                 holds.

            Run the Maintain Customer Master (SU13) program, access the BUSCOM account,
             change its Delinq. Days back to 120, press [Enter] to Update the record and [Escape] to
             close the program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     126
      08/22/11
Minimum Order Value Holds
                 There may be a point under which it becomes unprofitable for your organization to ship
                 orders to a customer due to the overhead costs associated with handing and the freight for
                 each shipment. WinSol assists with those orders by implementing Minimum Order Holds
                 and Minimum Backorder Holds.

                 The minimum holds automate the process of watching out for these inefficiencies, holding
                 them when they are found and releasing them in some cases automatically along with
                 other orders or after a period of time.

                 Let's examine how the minimum order holds are configured and how they are handled
                 normal course of processing.

            Run the Company Control Initialization (CC00) program and switch to the OE tab.

                 On the left side of the screen is a group named Quantities within which are the order hold
                 triggers for the Minimum Order Value and Minimum Backorder Value. These controls are
                 configured during the Company Set up and Initialization phase of loading WinSol based
                 on values collected during the Implementation Process.

            Note the setting of the Minimum Order Value and press [Escape] to close the program.

            Run the Enter Orders & Quotes (OE30) program, access the Kerr, Kerr & Associates
             account, KERKER, set the Source and switch to the Lines tab.

            Select the 1500 product, order up a quantity of 2 and Update the line.

            Release the order by pressing [Alt + W].

                 A warning message appears informing you that the order is below the minimum order
                 value by some amount. This is perhaps an opportunity for you to encourage your
                 customer to increase their order size to meet the minimum order value. If you wish to
                 return to the order to increase its value you would select the Cancel option. To avoid the
                 Minimum Order Value Hold and configure the order for release, you will require the
                 authorization password. This can be used to implement a level of authorization
                 requirement that the order entry clerk must request from the supervisor, floor manager,
                 etc.

                 In this case however, our client is happy to place the order as is and to have the order held
                 until the value of other orders they place adds up to the meet the minimum requirement, at
                 which time you could release all the orders.

            Press [Y] to accept the order on Minimum Order Hold.

                 Moments later another contact at Kerr, Kerr & Associates calls up and places another
                 order.

            Access the KERKER account and switch to the Lines tab.

            Select the 8201 product, order up a quantity of 1 and Update the line.

            Release the order by pressing [Alt + W].


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     127
      08/22/11
                 Again the warning message appears about the minimum order value. This time however,
                 after checking with the Customer Inquiries (SU45) program's Display Orders tab you
                 notice that between the two orders, this one and the previous one put on Minimum Order
                 Hold, you have enough to meet your companies minimum order requirements if you
                 release them at the same time.

            Press [Y] to accept the order on Minimum Order Hold and the press [Escape] to close
             the Enter Orders & Quotes (OE30) program.

            Run the Customer Inquiries (SU45) program, access the KERKER account and switch
             to the Orders tab.

                 You can see that two orders are now outstanding against the KERKER account, both
                 showing M's under the Holds column representing the Minimum Order Value Holds you
                 accepted moments ago. The Order Values of the two orders are below the minimum
                 requirement separately, but together they would meet the minimum.

                 We'll leave the Customer Inquiries program running while we access the Release Orders
                 on Hold (OE65) program to release the orders. Releasing orders may be handled
                 downstream of the order entry process in some organizations using the Print Order Hold
                 File (OE53) program. For the sake of the illustration however, we'll perform the release
                 and attempt to schedule these orders.

            Switch back to the WinSol Program Menu and run the Release Orders on Hold (OE65)
             program.

            If necessary, toggle back and forth between the Customer Inquiries (SU45) program
             and Release Orders on Hold (OE65) so that you can see the order numbers you need to
             access and release.

            For each of the orders, in the Release Orders on Hold (OE65) program type the Order,
             press [Tab] twice, press the [Spacebar] to enable the Min Order Value Release option,
             and press [Enter] to Update the order.

            When you have released both orders, run the Schedule Orders for Printing (OE32)
             program so we can observe the release. Answer Yes to the prompt to schedule orders,
             select the Toronto warehouse, enable the All Ship Vias option and Start the scheduling.

                 When the scheduling is complete the summary should report that at least two orders were
                 scheduled and two are to be printed.

            Accept the scheduling summary, run and accept the Print Shipping Documents (OE34)
             program to the screen so that the order file will be ready for other scheduling later.

            Switch to the Customer Inquiries (SU45) program. Refresh the Display Orders tab by
             switching to another tab and back again.

                 The Orders list should now show that the two orders that were previously being held on
                 Minimum Order Holds no longer show holds and have been scheduled; their Status'
                 should show them as Printed.

                 Minimum Backorder Holds offer more automation than Minimum Order Holds as
                 backorders are processed in the background (when the internal backorder control method
                 is employed). Backorder lines are released to scheduling when the Release Backorders

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page    128
      08/22/11
                 (OE61) program can reserve inventory To Ship them. When one of the order handing
                 processors examines a backorder line, if the shippable value of the backorder as a whole
                 – the value of all shippable lines – is below the Minimum Backorder Value (CC00), the
                 backorder will be put on Minimum Backorder Hold.

                 There are three situations that result in Minimum Backorder Holds being removed
                 automatically. The first occurs when the last line of the backorder is released To Ship.
                 The second occurs when an additional line of the backorder is released To Ship and the
                 value of that line plus the value any other shippable lines from the backorder reaches the
                 Minimum Backorder Value. The third occurs if a new order is scheduled for a customer
                 who has backorders on Minimum Backorder Hold. In this situation the held backorders for
                 that customer would be automatically released along with the new order allowing the
                 shipping department to pack/deliver the backorder with the new order, thereby incurring
                 less freight expense.

                 In the event that no new order is processed for the customer over a period of time, the
                 Release Orders on Hold (OE65) program provides an Auto Release utility that removes
                 Minimum Backorder Holds for orders that have been held for more than the specified
                 number of days. Otherwise, like all other order holds, Minimum Backorder Holds can be
                 reported using the Print Order Hold File (OE53) program and configured for release by the
                 Release Orders on Hold (OE65) program.


Ship Complete Holds
                 The convenient automation provided by the Minimum Backorder Value (CC00) and
                 Minimum Backorder Holds assists in preventing the scheduling of unprofitable orders until
                 such time that their value justifies the shipping and handling costs. This does not however
                 prevent a single order from becoming multiple shipments and invoices; both of which
                 increase the cost of processing the order for you and your customer. WinSol provides the
                 Ship Complete order hold to assist with this problem.

                 The Enter Orders & Quotes (OE30) provides two options to configure the Ship Complete
                 holds. We'll create two separate orders to illustrate the difference.

            Run the Enter Orders & Quotes (OE30) program

            Select the York Lawyers Association account, YORLAW, and set the Source code.

                 On the right side of the screen, below the Transaction Type are the controls for configuring
                 order holds.

            Click the Ship Complete option to enable it.

                 The Ship Complete option will configure the order to be held until such time that the entire
                 order can be scheduled at once; i.e., until all backorders are filled. Let's illustrate this by
                 creating a order that is partially shippable.

            Switch to the Lines tab, access the Product 8200, order a quantity of 1 and press [Enter]
             to Update the line.

            Access the Product 8202 to create a backorder for it.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     129
      08/22/11
                 When you access the 8202 product on this second order, WinSol will report to you that
                 other backorders exist against this product. This is a feature to assist you in managing
                 backorders.

            Press [Enter] to accept the Backorders Already on File dialog.

            Order a quantity of 2 and press [Enter] to Update the line.

            Press [Alt + W] to release the order.

            When the program resets, access the YORLAW account.

                 Again, on the right side of the screen, below the Transaction Type are the controls for
                 configuring order holds.

            Click the B/O Complete option to enable it.

                 Assuming no other holds, the B/O Complete option will allow any initially shippable lines
                 from this order to be scheduled and printed by one of the order handing processors. Any
                 backorders from this order however will then be held on a Ship Complete hold until they
                 are all shippable – until the backorder can be shipped complete.

            Switch to the Lines tab.

            Access the Product 8200, order a quantity of 1 and press [Enter] to Update the line.

            Access the Product 8202 to create a backorder for it, press [Enter] to accept the
             Backorders Already on File dialog, order a quantity of 2 and press [Enter] to Update the
             line.

            Access the Product 8203 to create a backorder for it, press [Enter] to accept the
             Backorders Already on File dialog, order a quantity of 4 and press [Enter] to Update the
             line.

            Press [Alt + W] to release the order.

            Press [Escape] to close the Enter Orders & Quotes (OE30) program.

                 Now, let's see the effect on the orders as they are scheduled.

            Run the Schedule Orders for Printing (OE32) program as usual.

                 The scheduling summary should report that at least two orders were scheduled but only
                 one is to print. Let's print that order and then look at the status of it and the others using
                 Customer Inquiries (SU45) after.

            Accept the scheduling summary.

            Run the Print Shipping Documents (OE34) program to the Screen to clear the order
             print file for its next use.

            Run the Customer Inquiries (SU45) program, access the YORLAW account and switch
             to the Display Orders tab.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     130
      08/22/11
                 The two orders just created appear at the top of the list in reverse-chronological order.
                 The first, showing a Printed status, was the order created with the B/O Complete option.
                 The item from that order that was shippable was scheduled and printed. If you wish,
                 select the order and then click the Display Details button. When the order appears you
                 can use the More Header Info button to see which order holds were configured.

                 The second order was created and configured with the Ship Complete option. One of its
                 two lines resulted in a backorder. Therefore, its status remains at Entered as it is not yet
                 complete and could not be scheduled with the Ship Complete option enabled. The S
                 under the Holds column represents the Ship Complete Hold. When inventory arrives to fill
                 this backorder, the Release Backorders (OE61) program will reserve the stock and
                 remove the hold so that one of the order handing processes will be allowed to schedule
                 and print the order. We'll simulate that in a moment.

                 The third order appearing on the list is an outstanding backorder for this customer. This
                 order was entered, scheduled and printed in exactly the same way as the order you
                 created using the B/O Complete option. It was then invoiced (the reference to the invoice
                 appears as the forth line) and the invoicing cycle was run through a day-end making the
                 backorder available for printing again if the stock should arrive for both of its backorder
                 lines.

            Press [Escape] to close the Customer Inquiries program (or leave it running in the
             background if you wish).

                 Now, let's receive the item that would complete the first order with the Ship Complete
                 option, but only partially fill the backorder with the B/O Complete option.

            Run the Enter Receipts & In-Transits (PO60) program.

            Press [Alt + C] or click the Create New Batch button.

            Press [Enter] to accept the proposed GL Posting Date.

            Press [Enter] again or click the Update and Procced button.

            Accept the message displaying your batch number by pressing [Enter] to clicking the
             OK button.

            Accept the default batch type as receipt by pressing [Enter] or clicking the No button.

            In the Supplier field, type CRECAN and press [Tab] to access the Crestar Canada
             supplier.

            In the Packing Slip field, type 100999 and press [Tab] to set supplier's reference.

            Press [Alt + 4] or click the Without PO tab.

            In the Product field, type 8202 and press [Tab] to access the product we need to
             receive.

            In the Quantities Received field, type 144 and press [Enter] to Update the receipt line.

            Press [Alt + B] or click the Update Batch button.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    131
      08/22/11
            When the update batch confirmation dialog appears, press [Y] or click the Yes button to
             process the receipt in the batch.

            When the create another batch confirmation dialog appears, press [N] or click the No
             button to exit the program.

                 Inventory for the product that will complete one of orders and partially complete the
                 backorder has now been received. Let's release the backorders now using the Release
                 Backorders (OE61) program that will examine the stock position for all backorders and
                 reserve stock for orders now that it's available.

            Run the Release Backorders (OE61) program.

            In the Warehouse field, type 01 and press [Tab] to select the Toronto warehouse.

            Press [Alt + A] or click the Release All Backorders button.

            When the focus returns to the Warehouse field the release program is complete. Press
             [Escape] to close the program.

            Run the Schedule Orders for Printing (OE32) program as usual.

                 The scheduling summary should report that one order was set to print. Let's print that
                 order and then look at the status of it and the others using Customer Inquiries (SU45)
                 after.

            Accept the scheduling summary.

            Run the Print Shipping Documents (OE34) program to the Screen to clear the order
             print file for its next use.

            Run the Customer Inquiries (SU45) program, access the YORLAW account and switch
             to the Display Orders tab. Or, if it is already running, switch to it and refresh the
             display.

                 The list should now show that the second order, the order configured with the Ship
                 Complete option no longer shows a Ship Complete Hold (S) under the Holds column and
                 its status has been updated to Printed. When we received the inventory that completed
                 the order and then released backorders, the Ship Complete hold was removed and the
                 order was processed.

                 The third order remains with a Ship Complete Hold (S) and its status is still listed as
                 BackOrd as only one of its two backordered lines were filled by our last actions. This
                 order was configured with the B/O Complete option; its initially shippable order lines were
                 printed on a order earlier and now it is waiting on Ship Complete Hold for that final item to
                 be shippable before the backorder portion of the order is printed. If you wish, repeat the
                 last series of actions above starting with the Enter Receipts & In-Transits (PO60) program,
                 except this time receive the product 8203. Once this product is available the third order on
                 the list here can be scheduled and printed.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     132
      08/22/11
Manual Holds
                 Manual Holds can be applied to an order to prevent it from being scheduled by the order
                 handing processors. For example, while processing an order received by fax, you
                 discover that the customer will have to be contacted before the order can be processed.

            Run the Enter Orders & Quotes (OE30) program, select the YORLAW account, set the
             order Source and switch to the Lines tab by pressing [Alt + 3]

            Access the Product 8202, press [Enter] to accept the Backorders Already on File dialog,
             order up a quantity of 4 and press [Enter] to Update the line.

                 At this point you notice that the York Lawyers Association has issued their purchase order
                 listing 8202 as the product code, but their description states that it is a WATERMAN STERLING
                 SILVER SWORD PEN. The 8202 however, is not the sterling silver version of this pen, it is
                 silver but it is not the 8201 sterling version which costs a little more. You wonder if they
                 simply mixed up the part numbers and decide that you'll need to contact them later to sort
                 this out.

            Switch to the General tab by pressing [Alt + 1] or click the tab.

            On the right side of the screen, under the Transaction Type is the Manual Hold option.
             Press [Tab] repeatedly until the focus in on the Manual Hold option and then press the
             [Spacebar] to enable it (or click it).

                 The order will now be held back from the order handling processors. Perhaps you'll write
                 the order number down on their purchase order and use it as a reminder that you have
                 their order on hold.

            To the right of the Orders field is the Order Notes button. Position the cursor over the
             button and hold it for a moment until the control tip appears and confirms that you have
             the Order Notes button and not the Customer Notes button which is similar looking.

            Click the Order Notes button.

                 We can use the Order Notes database to store some information about why this order
                 was put on manual hold. This may be very helpful to us or other people working with this
                 account later if they should happen to access it and wonder why the order is on hold.

            Type a description of why to order is on hold: "Purchase Order says 8202 but
             description says STERLING…should this be 8201?" and press [Alt + U] or click the
             Update button to save the note.

            Press [Escape] to close the Notes dialog.

            Press [Alt + W] to reset the program.

                 With their order on Manual Hold, you can proceed with work on other orders and return to
                 release it later when you can contact them about which version of the pen they would like
                 to have.

            Press [Escape] to close program.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     133
      08/22/11
            Run the Customer Inquiries (SU45) program, access the YORLAW account and switch
             to the Display Orders tab.

                 On the Customer Inquiries (SU45) list of orders, the first should be the order you just
                 created and put on Manual Hold. Under the Holds column should be an H representing
                 that hold. We can use the Display Details button to view the order in the Display Orders
                 by Customer (OE45) program, which in turn provides us with access to the Order Notes
                 database which may have information as to why the order is on hold. Try it now if you
                 like…

            Press [Escape] to close the Customer Inquiries (SU45) program.

                 Manual Holds, like all other order hold types, can be reported using the Print Order Hold
                 File (OE53) program.

            Run the Print Order Hold File (OE53) program.

            Choose the Screen as the output device if necessary.

            Press [Tab] until the focus is on the Manual Hold option and then press the [Spacebar]
             to select the option (or click the option if you must).

            Press [Enter] to accept the dialog box.

            Press [Enter] again to accept the All Warehouses option.

                 If you printed to the screen, in the background now you should be able to see the output of
                 a Manual Hold report. The report also lists if the order on that hold type is on any other
                 hold type at the same time.

            Mark down the order number if necessary and press [Enter] to accept the report.

                 We can use one of two different programs to release an order with a Manual Hold. If you
                 happen to be using the Enter Orders & Quotes (OE30) to edit the order prior to release,
                 we can simple uncheck the Manual Hold option on the General tab and release the order.

                 The Release Orders on Hold (OE65) program also provides a way to configure an order
                 on Manual Hold for release.

            Run the Release Orders on Hold (OE65).

            Type the order number on Manual Hold into the Order field, press [Tab] twice to move
             the focus to the Release Manual Hold option, press the [Spacebar] to enable it and then
             press [Enter] to Update the order.

            Press [Escape] to close the program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     134
      08/22/11
MULTIBIN INVENTORY CONTROL
                 The WinSol Multibin Inventory Control tutorial assumes that you have completed the
                 WinSol introductory tutorials and that you now have a working knowledge of the WinSol
                 environment.

                 The Multibin functions in WinSol provide inventory control in situations where a given
                 product is stored in more than one warehouse bin location. Quantities are controlled
                 within each bin. The bin contents are maintained and bin capacity is monitored. Picking
                 priorities may be set to minimize the picking effort. Options are provided to accommodate
                 pick and bulk areas. Additional options are available when product is received to facilitate
                 efficient backorder releasing and stock put-away.


         Bin Creation and Maintenance

                 Warehouse layout is specified by defining a series of bins. The bins are organized in the
                 WinSol system by specifying any combination of zones, aisles, sections and levels. The
                 location code may be a maximum of eight characters. This tutorial uses a structure „zaasl‟
                 representing a single character zone (1 through 9), a two character aisle (01 through 99),
                 a single character section (A through Z) and a single character level (1 through 4).

            Run the Warehouse Layout Maintenance (WH10) program.

            If the warehouse selection window appears, choose 02 – Montreal; Make Default; Ok. If
             the warehouse selection window does not appear, make sure warehouse „Montreal‟ is
             indicated at the top of the WH10 screen. If not, select the Montreal warehouse from the
             Options drop box and make it the default warehouse.

            Click on the First Record button.

                 Note the characteristics of bin 101A1 (zone 1, aisle 01, section A, level 1). It is a primary
                 pick bin with a capacity of 128 (cubic feet) and 8000 (lbs).

            Click on the Auto Creation button.

                 We are going to define a series of bins in aisle 3. These will be bulk bins, each having the
                 same capacity as bin 101A1. Because these are bulk storage, we want to give them a
                 lower picking priority (a higher number in the picking order).

            Enter data in each field according to the following and then click on the Update button.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     135
      08/22/11
         Note that we have created 16 new bins from „103A1‟ through „103D4‟.

            Press [Escape] to close the window.

                 We return to main warehouse layout maintenance program (WH10).

            Click on the question mark („?‟) to enter the bin / location query. Then scroll down the
             list box until you see the new bins that were created. Select bin 103A1.

                 Note that the new bin has been created as a bulk bin with an order of picking set to „02‟. .

            Press [Escape] to close the program.

                 We will now receive inventory, placing it into some of the bulk bins..

            Run the Enter Receipts/In-Transits (PO60) program and create a new batch with the
             default date.

            Allow the entry method to remain as „RECEIPT‟ by answering No at the option to
             change to in-transit.

            When asked if all receipts should be assigned to the general receiving area, respond
             with No.

                 There are two methods of receiving and recording the put-away bin locations.

                 One method requires that the bin locations in which the product is placed be specified at
                 the time the receipt is recorded. This method is appropriate if receipts are generally put
                 away shortly after they arrive, prior to releasing any sales backorders. We will use this
                 method in this tutorial.

                 The second method provides for the receipt to be assigned to a general receiving location
                 (specified as „FLOOR‟ in the tutorial system). If this method is used, the recording of the
                 subsequent transfers to individual bins is accomplished via the Warehouse Relocate


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     136
      08/22/11
                 Stock (WH30) program. Prior to relocating the newly received stock, sales backorders
                 may be released and picked from the general receiving location. In cases where there are
                 significant backorders, this method will reduce the amount of inventory handling. By
                 running the Suggested Put-away and Replenishment (WH81) program, newly received
                 inventory can be matched with existing inventory in the warehouse.

            In the customer field, type CWLCOR and then [tab].

            In the packing slip field, type 1234 and then [tab].

            Press Alt+3 to change to the „Receiving‟ folder.

            In the PO No. field, type 3024 and then [tab].

             We will assume that the supplier has shipped the order complete.

            Click the „Process All‟ button.

                 The „Receive Lots and Serial Numbers‟ widow will appear. Since we are NOT receiving to
                 a general (FLOOR) area, we must specify the bins in which we are placing the product.
                 We will proceed to specify the receipt as follows:

                  Product                Bin         Quantity           Hold & Comment

                  3101                   103A1       25                 No

                  3102 (split bin)       103B1       20                 No

                  3102 (split bin)       103B2       15                 No

                  3103 (split bin)       103C1       29                 No

                  3103 (split bin)       103C2       1          Yes Hold Code „DIT‟
                                                                „Bent Left Arm‟
            Follow the prompts in the Receive Lots and Serial Numbers window, entering the
             receipt according to the above table. As each item‟s received quantity balances,
             respond No to the question “The received quantity balances with the entered quantity.
             Continue Entries?”.

                 Once the bins have been specified for all items, the „receive lots‟ window will close and the
                 program will return to folder 3.

            Click the Update Batch button and respond Yes to the confirmation question.

            Respond No when prompted for another batch.

                 The inventory has been received into the specified bins. .

                 We will now transfer some of the recently received inventory between bins.

            Run the Warehouse Relocate Stock (WH30) program.

            At the „From Bin / loc‟ field, type 103A1 and then [tab].

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page        137
      08/22/11
            Double click on product 3101.

            At the To Bin /loc field, type 101A2, then [tab].

            At the Quantity field, type 5, then [Enter] to update the transaction.

                 This action builds a work file of entries. The transaction is not complete until the „Update
                 Inventory‟ button is clicked. Prior to the final update, any transaction may be recalled and
                 modified or deleted.

            At the Product field, type 3101, then [tab].

            At the To Bin / loc field, type 101A3, then [tab].

            At the Quantity field, type 2, then [Enter].

             The selected bin already has other products in it. A warning is provided to ensure that the user
             wishes to mix product in a given bin.

            Respond Yes at the Continue prompt.

            Click on the Update Inventory button and respond Yes at the confirmation prompt and
             then Ok at the GL date prompt.

             The bin transfers have now been processed. The program will close and exit.

            Run the Display Product Availability (IC45) program.

            At the Product field, type 3101 and then [tab].

            Click on the T folder (Binloc / LoT / Serial).

             Note that quantities exist in three bins..

            Double click on the line showing bin 103A1.

             Note the quantities shown at the bottom of the window.

            Click on the Display Movement button

             Note that the movement shows the initial receipt and the two transfers.

            Press [Esc] to close the movement window.

            Click the Next Record button twice to display product „3103‟.

            Double click on the quantity of 1 in bin 103C2.

             Note the comment and the hold code at the bottom of the window.

            Press [Esc] to exit the program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page    138
      08/22/11
CUSTOMER PART NUMBERS
                 The Customer Part Number cross-reference system in WinSol can used to provide a
                 higher level of service for a customer who has their own part numbers for items they
                 purchase from you. The cross-reference system works by registering your customer's
                 internal part numbers against your product codes so that during the order entry process
                 (or on their purchase orders) your customer can specify their own internal numbers rather
                 than having to know yours.

                 Let's build a Customer Part Number cross-reference table for the York Lawyers
                 Association company.

            Run the Maintain Customer Part Numbers (IM40) program.

                 Customer part number cross-references are built against the customer‟s paying office
                 code. If a chain or group of customers share a common paying office and reference a
                 common part number list, then the cross-references are built once under the paying office
                 customer code but will be accessed any time an order/invoice is processed for any of the
                 customers in the chain/group.

            In the Paying Office field, type the account code for York Lawyers Association,
             YORLAW, and press [Tab] to accept it.

                 When customer part number cross-reference tables are initially created, you will usually
                 work from a list of your customer's products that you have matched or related to your own
                 product codes. The list below is an example of York Lawyers Association' product list.
                 The last column of the list is the product code from your system that you have matched.

                 YLA Part     Description                              WinSol Part     Updated
                 GP05         Gift Pen – 5 Years Service               8203
                 GP10         Gift Pen – 10 Years Service              8201
                 GP25         Gift Pen – 25 Years Service              8200


            From the list above, type the first Customer's Product Code and press [Tab] to accept
             it.

            From the same line, type the WinSol Part and press [Enter] to Update the reference.

                 The Maintain Customer Part Numbers (IM40) program also provides a series of Product
                 Information fields that can be used for some custom WinSol applications; they are not
                 used in this demonstration.

            Repeat the previous steps to complete the creation of cross-references.

            Press [Escape] to close the program.

                 From time to time you have need to maintain individual cross-reference records using the
                 Maintain Customer Part Numbers (IM40) program. Sometimes the entire cross-reference
                 table needs to be reviewed with the customer. WinSol provides the Customer Product


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page     139
      08/22/11
                 Codes Report (IM43) program to produce a report or a text file from the customer's cross-
                 reference table.

            Run the Customer Product Codes Report (IM43) program.

            Select File on the Print Selection list and then press [Alt + T] or click the Options button.

            In the File field of the Print Options dialog, type YORLAW and press [Enter] to accept it.

                 This will configure the WinSol print program to output the report to a text file that will be
                 named using the value of the File field plus an extension of .tmp and created in the
                 WinDemo folder on your computer.

            Press [Enter] again to accept the Print Selection dialog.

            When the Report Parameters dialog appears, press [Tab] repeatedly until the focus is in
             the From field.

            In the From field, type YORLAW and press [Tab] to accept it.

            In the To field, type YORLAW and press [Tab] to accept it.

            Press [Alt + O] (that's the letter O as in OK) or click the OK button to begin the print
             program.

                 When you print reports to the File device using WinDemo the print program usually
                 finishes very quickly.

            Press [Alt + O] or click the OK button to accept the Report Complete dialog.

                 Now, in order to view the report that we printed to the file we need to locate the file in the
                 WinDemo folder. There are many ways of getting to that folder…the following is just one
                 the quickest, least painful methods, but it does requires that you know where WinDemo
                 was installed (usually C:\WinDemo…)

            Hold down the start [] key and press [R] to access the Windows Run dialog box. If
             your keyboard does not have a start [] key, you can hold down the [Ctrl] key and
             then press [Esc]; when the Start menu opens, press [R] to access the Windows Run
             dialog box.

            In the Windows Run dialog box, type C:\WinDemo and press [Enter]. If you installed
             WinDemo to some other volume than C, substitute the volume letter for x as in
             x:\WinDemo, or x:\…\WinDemo; wherever you installed it.

            When the Windows Explorer appears, press the letter [D]. This should cause the focus
             to jump to a file named…YORLAW.tmp.

            Press [Enter] to open the file.

                 If your system has been configured to open .tmp files with a program already, the
                 YORLAW.tmp file will open in that program at this point. If this is the case you can skip
                 the next two steps. Many systems however, do not know which program can display the
                 .tmp file that WinSol creates when you print to a file…any text or word processor will do.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     140
      08/22/11
                 The following two steps will register the notepad as the preferred program for viewing .tmp
                 files so that the next time you press [Enter] on a .tmp file notepad will display it for you.

            In the Description field, type Temporary Text File and press [Tab]

            With the focus now on the list of programs, press [N] repeatedly until the NOTEPAD is
             selected and then press [Enter] to accept it.

                 The YORLAW.tmp text file, which is a copy of the Customer Product Codes Report (IM43)
                 for York Lawyers Association should now be displayed.

            When you have finished reviewing the report, close the program and the Windows
             Explorer.

                 Now, let's see the Customer Part Numbers in action using the order entry system.

            Run the Enter Orders & Quotes (OE30) program, select the YORLAW account, set the
             order Source and switch to the Lines tab.

            In the Product field, type any one of the YLA Part numbers from the list above (i.e.,
             GP25) and press [Tab] to accept it.

                 When the customer's part number was submitted, WinSol did a quick lookup against the
                 table from the Maintain Customer Part Numbers (IM40) program. When it finds a match in
                 the table WinSol will redirect the customer's part number to the related product code from
                 the table. Notice how the value of the Product field now shows the WinSol product code;
                 the customer's part number is shown below on the Product Details display (just below the
                 More Details button).

            Try any of the order YLA Part numbers from the list above. You can return the focus to
             the Product field quickly between product lookups by holding down the [Shift] key
             while you press [Tab] three times.

            When you have completed your tests of the YLA Part numbers, leave the Enter Orders
             & Quotes (OE30) running…we'll use it again in a moment.

            Switch to the WinSol Program Menu and run the Maintain Customer Part Numbers
             (IM40) program.

                 In the Order Holds tutorial earlier, York Lawyers Association almost accidentally ordered a
                 8202 plain silver Waterman pen when they meant to order the sterling silver version, 8201.
                 Luckily you caught the problem and held the order. Your customer asked if there was any
                 way you could prevent them from making the same mistake in the future, and the
                 customer part number table will help providing they use their part numbers instead of
                 yours. But what would happen if you created a customer part number cross-reference
                 between a customer part of 8202 and your product of 8201?

            In the Paying Office field, access the YORLAW account.

            In the Customer's Product Code field, type 8202 and press [Tab] to accept it.

            In the Our Product Code field, type 8201 and press [Enter] to Update the cross-
             reference record.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     141
      08/22/11
            Leave the Maintain Customer Part Numbers (IM40) program running and switch back to
             the Enter Orders & Quotes (OE30) program we left running earlier.

            In the Product field, type 8202 as if York Lawyers Association was accidentally ordering
             the wrong silver pen again and press [Tab] to accept it.

                 WinSol looks takes the 8202 entry you made, locates a record in the Customer Part
                 Numbers table that matches it and then redirects the customer part number to the WinSol
                 product code registered as the cross-reference to it. If you try to access the 8202 product
                 by product code (even using the Product Browser) WinSol will redirect to the cross-
                 reference. You can still select the 8202 product by description or using one of the browse
                 methods though.

            Press [Escape] to close the Enter Orders & Quotes (OE30) program. If you created an
             order you can delete it by press [Alt + O].

                 As mentioned previously, the Maintain Customer Part Numbers (IM40) system is used to
                 build cross-reference tables using the Paying Office account code for a customer. The
                 Paying Office of a customer is set in the Maintain Customer Master (SU13) program and
                 is designed to support a group of customers whose invoices are paid centrally by a head
                 (paying) office. When there is no paying office involved, the Paying Office account is the
                 same as the Customer account.

                 The use of the Paying Office account can be quite convenient when you need to maintain
                 a customer part number table that is common to more than once account; you need only
                 maintain the Paying Office's table to update all of the Customer accounts subscribing to
                 that Paying Office. If you wish to use the customer part number table with a client that
                 requires more than one Customer account but does want to use a Paying Office scenario
                 you will need to maintain a separate tables for each Customer account. The Maintain
                 Customer Part Numbers (IM40) program assists you here by providing Copy Customer
                 Product Data utility.

            Switch to the Maintain Customer Part Numbers (IM40) program we left running earlier.

            At the bottom of the program there is a button to the right of the New button. Position
             the cursor over the button and hold it there for a moment to view the control tip. The
             button will be identified as the Copy Customer Product Data button. Click it.

                 The Copy Customer Product Data dialog allows you to specify the Customer code of the
                 account you wish to copy the cross-reference table From and the Customer code of the
                 account you wish to copy the cross-reference table to. In a situation where the client
                 requires more than once account, designate one of them as the master account for the
                 Customer Part Numbers table, maintain the account's table and then use the Copy
                 Customer Product Data utility to copy from that account to the associated accounts.

            In the From field, type YORLAW and press [Tab] to accept it.

            In the To field, type KERKER and press [Tab] to accept it.

            Verify that you have selected the correct accounts before you being the copy process.

            Press [Enter] to start the copy utility.

            Press [Enter] to accept the Copy Complete message.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     142
      08/22/11
            Using the Paying Office field, access the KERKER account to verify the results.

                 The Kerr, Kerr & Associates' account should have a Customer Part Numbers table of its
                 own now. The copy utility does not remove records; if you have deleted cross-references
                 from the master account's table they may still exist in the tables of accounts that they were
                 copied to in the past. In this case, you may need to use the Delete Records button
                 against the related accounts prior to copying the master account's table over to them. Be
                 very careful performing this task…you do not want to accidentally delete the master's
                 table.

            Verify that you have the KERKER table selected.

            Click the Delete Records button (the trash can) that appears to the right of the Record
             Review Bar. When the Delete confirmation message appears, click the Yes button or
             press the [Y] key.

            Press [Escape] to close the Maintain Customer Part Numbers (IM40) program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     143
      08/22/11
SPECIAL PRODUCTS PROCESSING
                 WinSol's Inventory Control system provides product selection services to the Order Entry
                 and other sales transaction oriented systems. Product selection is built on top of product
                 records from the Inventory Master system and references between products and suppliers
                 in the Purchasing system. When a new product is required for use in the Order Entry
                 environment, an Inventory Master (IM13) record and a Purchasing Info (PO13) record
                 must be created before the product can be accessed in that environment.

                 In a sales environment there may be situations where a product required will not exist in
                 the Inventory Control system. The required product may be transient or temporary in
                 nature. It need exist only long enough to be used on one order to prompt the Purchasing
                 system to order it, the order handing processors to fill it and the Invoicing system to charge
                 the customer for it. At the end of its path through these systems it will no longer be
                 required. There are a number of scenarios in which this would be common:

                        Custom ordered products
                        New products
                        Non-stock, unlisted products

                 The sales process in these scenarios usually involves some research to locate the type of
                 product required, a suitable supplier for it, an offer to the customer and an acceptance
                 from the customer; an order for a product that does not yet exist in the Inventory Control
                 system. The maintenance required to create an Inventory Master (IM13) record and a
                 Purchasing Info (PO13) record before you are able to book the order however could
                 seriously slow down the sales process. WinSol assists at this point with access to the
                 Quick Product Creation (IM99) from within the order entry environment.

            Run the Quick Product Creation (IM99) program.

                 The Quick Product Creation (IM99) program allow you to create both the Inventory Master
                 (IM13) and Purchasing Info (PO13) records for a product you have researched on-the-fily
                 while you are booking the order. The program requires only the most basic information
                 from you to do this. You provide a description of the product, the commodity, the stock
                 keeping unit, the inventory/GL type, the price you wish to sell it at, a commission code,
                 who it could be purchased from and for how much. It does the rest automatically; even
                 providing the Product number.

            Press [Escape] to close the Quick Product Creation (IM99) program.

            Run the Company Control Initialization (CC00) program and switch to the Inventory
             Masters (IM) tab.

                 Below the Rounding Rules group, on the right side of the program you will find three
                 controls relating to the Quick Product Creation system. The Special Product Mask
                 dictates the structure of the product code that will be proposed for use in the Quick
                 Product Creation program when Special Products are created from the Enter Orders &
                 Quotes (OE30), Enter Invoices, Direct Bills & Credits (IN41), Create Purchase Orders
                 (PO40) or Quick Product Creation (IM99) programs. The mask assigned should consist of
                 the following:



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     144
      08/22/11
                        One or more leading characters. (Entry of this character(s) in the above
                         mentioned programs will trigger creation of a new product on the spot in the
                         originating entry program.)
                        A series of # symbols which will be replaced by the next available number.
                        Any suffix to complete the format to the maximum number of characters in a
                         product code.

                 For example the mask 9####-00 will generate product codes 90001-00 to 99999-00. The
                 mask ZZ###### will generate product codes ZZ000001 to ZZ999999.

            Press [Escape] to close the Company Control Initialization (CC00) program.


Creating Special Products
                 Let's try using the Quick Product Creation program from the point of order entry. Imagine
                 that the York Law Association has just called into your order desk asking if you could
                 supply a couple of Parker Sonnet Fountain Pens. You do not stock this product nor do
                 you have a product code for it at this time so you decide to create a special product to
                 handle to order.

            Run the Enter Orders & Quotes (OE30) program

            Accept the Toronto Warehouse

            Access the YORLAW customer

            Set the order Source.

            Switch to the Lines tab: [Alt + 3]

                 To access the Quick Product Creation (IM99) program from the Product field of programs
                 such as the Enter Orders & Quotes (OE30), Enter Invoices, Direct Bills & Credits (IN41)
                 and Create Purchase Orders (PO40) you will enter the leading characters of the Special
                 Product Mask (CC00/IM). In WinDemo, those characters are ZZZZ (4 capital Z's).

            Type ZZZZ and press [Tab] to accept it.

                 When the value submitted in a product code field of one of these programs matches the
                 leading characters of the Special Product Mask (CC00/IM) you will be prompted with
                 "Create a Special Product?"

            Press [Y] to confirm that you wish to create a special product.

                 The Quick Product Creation (IM99) program will be accessed at this point and WinSol will
                 propose a new Special Product number for you automatically.

            Press [Tab] to accept the proposed Product.

            In the Commodity field, type the letters OSWI and press [Tab] to specify that this
             product belongs to the Office Supplies Writing Instruments group.

                 The Commodity coding of Inventory Master (IM13) is an important dimension in WinSol.
                 The Inventory Control, Inventory Masters, Purchasing, Physical Inventory, Sales Analysis,


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page     145
      08/22/11
                 Commissions and other systems use this dimension on reports for sequences, ranges,
                 restrictions, on displays for views of specific product lines and groups, and in tables for
                 active cross-referencing. Care should be taken to provide the staff responsible for working
                 with the Quick Product Creation (IM99) program with the knowledge required for setting
                 the Commodity properly. If there will be cases in which a Special Product can not be
                 properly classified into an existing Commodity a special temporary commodity should be
                 selected. Downstream, the staff responsible for maintaining the Inventory Master (IM13)
                 can produce a list of those products assigned to the temporary commodity so that they
                 can be properly reclassified.

            Type the description of the product as "Pen Parker Sonnet Fountain" and press [Tab] to
             accept it.

                 WinSol provides an additional description and then alternate language description fields.
                 For the purposes of this example, we will not be using them.

            Press [Tab] repeatedly to move the focus to the Stock Unit field.

                 A product‟s stock-keeping unit code (SKU) must represent the smallest unit in which the
                 product is stocked and sold. When orders/invoices are processed, the transaction
                 quantity is expressed in this unit of measure (i.e. Order Qty = 12 EA, not 1 DOZ. This will
                 reduce inventory quantity on hand by 12, not 1.)

            Press [Tab] to accept EA as the Stock Unit.

                 The General Ledger Code is a two-character code that is used to catagorize each product
                 for GL interfacing purposes. We will accept the value of 00 for this product. For additional
                 information on the Inventory/GL interfacing refer to the functional and program help for
                 Maintain GL Codes (IM06) in WinSol Help.

            Press [Tab] to accept the General Ledger Code.

                 The Commission system in WinSol can be based on the Commodity or Commission
                 codes assigned to each Inventory Master (IM13) record (as configured by Company
                 Control Initialization/OE). The system uses the code along with the transaction's Sales
                 Rep and the Commission Group (SU13) of Customer to access the appropriate
                 Commission Rates Table (SA02).

            Type AAAA and press [Tab] to assign the product to the General Items Commission
             Group.

            Type 155 and press [Tab] to assign the Selling Price of $155.00.

            Type CRECAN and press [Tab] to specify that the product can be purchased from
             Crestar Canada.

            Type 85815 and press [Tab] to specify Crestar's part number for this item that
             Purchasing will need when ordering the product.

                 Crestar prices the products that It supplies you with as a discount off of the manufacturers
                 suggested list price, which happens to be the price you sell the product at.

            Type 155 and press [Tab] to set the Purchase Price.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    146
      08/22/11
            Type 40 and press [Enter] to set the Discount and Update the Special Product.

                 Once the product is updated the Quick Product Creation (IM99) program will close
                 automatically, control will be returned to the program that accessed the Special Product
                 functionality and the new Special Product just created will be selected in the Product field.

            In the Qty Order field, type 2 and press [Enter] to create the backorder.

            Press [Alt + W] to release the order.

            Press [Escape] to close the Enter Orders & Quotes (OE30) program.

                 With Special Product created and a backorder for it, the Purchasing System will be
                 signalled to reorder the product automatically.


Follow-up Maintenance
                 Because this program sets so many of the data fields in the Inventory Master (IM13) and
                 Purchasing Info (PO13) records based upon default values, follow-up maintenance is
                 almost always required. This program‟s primary purpose is to serve the Special Product
                 processing feature. The order desk enters enough information about a product to proceed
                 with entering the order (which generates a backorder that in turn instigates purchasing).
                 Typically, it is the purchasing staff‟s responsibility to check the coding of new products and
                 process any follow-up maintenance.


Re-coding Special Products
                 From time to time someone may find the need to reuse a special product on an additional
                 order which is possible. If the special product will required for again in the future it should
                 be brought to the attention of the purchasing staff so that they can consider establishing
                 and/or re-coding the special product into a permanent product code – even if it is still
                 considered a non-stock item. There are two reasons why this should be considered.
                 First, most purchasing departments do not maintain the Purchasing Info (PO13) records of
                 special products after their initial use, which could lead to orders for products no longer
                 available or outdated purchase prices. The second reason is that periodically, large
                 numbers of old special product records may be merged into one or more records to
                 reduce their number, which would eliminate the product if no orders were outstanding for it
                 at that time.

                 Over time the number of special products created in WinSol will build up. These products
                 are available to and are reported by all of the systems that receive product selection
                 services from the Inventory Control system. To reduce the number of inactive special
                 products, WinSol provides the Auto Merge Special Products command in the Enter
                 Products to Re-Code & Merge (RM81) program.

            Run the Company Control Initialization (CC00) program and switch to the Re-
             Code/Merge (RM) tab.

                 The Auto Merge Special Products command will generate merge records for each product
                 with-in the range specified by the Start Range and End of Range fields of the Company
                 Control Initialization (CC00) program's Re-Code/Merge (RM) tab. The records will be
                 configured to merge the special product into a single record or into multiple records based
                 upon the special product‟s Commodity. The Merge to Code specifies the product to be


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     147
      08/22/11
                 merged to. If the product includes CC or CCCC in it, the two-character Product Line or
                 four-character Commodity from the special product will be substituted into the merge to
                 product code. For example, the special product code ZZ000123 with a Commodity of
                 ABCD could be merged into product ZZ999999, or ZZ99AB00, or ZZ99ABCD.

            Press [Escape] to close the Company Control Initialization (CC00) program.

            Run the Enter Products to Re-Code & Merge (RM81) program.

                 The Auto Merge Special Products command button is located in the lower right corner of
                 the Enter Products to Re-Code & Merge (RM81) program.

            Press [Alt + A] to activate the Auto Merge Special Products command.

                 If there were records within this range to be merged the Auto Merge Special Products
                 command would add them to the list of records to be processed by the Execute Product
                 Re-Code & Merge (RM82) program. Once merged, special products will report under the
                 merged product code on Inventory Control and Sales Analysis reports.

            Press [Escape] to close the Enter Products to Re-Code & Merge (RM81) program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                      Page    148
      08/22/11
WAREHOUSE REPLENISHMENT
                 WinSol supports three methods Warehouse Replenishment. The first two methods
                 require manual input while the third can automate the replenishment from the primary
                 distribution centre.


         Inventory Adjustment Transfers

                 When shipping documents are not required to handle the transfer of inventory, which
                 might be the case if transferring stock from your warehouse to a storefront cash counter,
                 transfers may be simply processed using the Enter Inventory Adjustments (IC50)
                 program's Transfer (3) tab.

                 Let's illustrate the use of the Enter Inventory Adjustments (IC50) program for an item that
                 is out of stock in our secondary warehouse.

            Run the Display Product Availability (IC45) program.

            Switch to the Montreal warehouse: Press [Alt + the letter O], then press [W] to access
             the Warehouse Selection dialog.

            Press the [Down Cursor] and press [Enter] to select the Montreal warehouse.

                 Notice how WinSol displays the currently selected warehouse in the title bar of the
                 program. If you position the pointer over the Windows Taskbar button for the Display
                 Product Availability (IC45) program and hover there for a moment a control tip will be
                 displayed that also reports the warehouse that the program is working with. This can be
                 particularly helpful in selecting an already running program to work in the correct
                 warehouses when you have multiple programs and/or warehouses open at once.

            In the Product field, type 1002 and press [Tab] to specify the LaserJet Toner Cartridges.

            Switch to the All Warehouses (R) tab.

                 Here we can see that although the Montreal warehouse does not have stock in the 1002
                 product, the Toronto warehouse does. We will imagine for a moment that Montreal
                 warehouse represents a retail storefront attached to the Toronto warehouse. We can see
                 that there is stock in the warehouse for this product so we are going to retrieve some from
                 the warehouse and transfer it to the storefront.

            Press [Escape] to close the Display Product Availability (IC45) program.

            Run the Enter Inventory Adjustments (IC50) program.

            Accept (or confirm) the GL Posting Date by pressing [Enter]

                 When this method is used, the operator simply enters the product code, the quantity and
                 the receiving warehouse to transfer the inventory to. The quantity on hand from program's
                 current warehouse (as shown in the title bar) is reduced and the receiving warehouse's


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     149
      08/22/11
                 increased in real time. The inventory control accounts to be adjusted are identified by
                 cross-referencing the warehouse and product's assigned G/L Code (IM13) through the
                 table managed by the Inventory Adjustment GL (IM44) program. The Print Stock
                 Adjustments Report (IC51) program provides an audit trail of these transactions.

            In the Product field, type 1002 and press [Tab] to specify the LaserJet Toner Cartridges.

            Switch to the Transfers tab: [Alt + 3]

            Set the focus into the Quantity field: Press [Tab]

            Type a quantity of 2 and press [Tab]

                 Notice below that the On Hand and Cost in TO whse displays have been updated to show
                 the Before and After values that the proposed transfer will result in if updated.

                 The Montreal warehouse happens to be using the Multi-Bin Warehousing system which
                 wouldn't be typical for a retail storefront; we'll just set a valid bin location here to continue
                 with our scenario and update the transfer.

            Type 101A1 and press [Enter] to update the record.

            Press [Escape] to close the Enter Inventory Adjustments (IC50) program.

                 Now, let's see the outcome of our transfer.

            Run the Display Product Availability (IC45) program.

            Switch to the Montreal warehouse again: Press [Alt + the letter O], then press [W] to
             access the Warehouse Selection dialog.

                 The default warehouse to be selected by programs can be configured by an operator
                 using the Make Default button in this dialog (we'll leave it at Toronto for now). A WinSol
                 administrator can pre-configure the default warehouse for other operators using the
                 Maintain Operator Password & Privileges (CC03) program.

            Press the [Down Cursor] and press [Enter] to select the Montreal warehouse.

            In the Product field, type 1002 and press [Tab] to specify the LaserJet Toner Cartridges.

            Switch to the All Warehouses (R) tab.

                 We can now see that the 2 units transferred from Toronto to Montreal using the Enter
                 Inventory Adjustments (IC50) program have been updated immediately.

            Press [Escape] to close the Display Product Availability (IC45) program.


         Direct Transfers

                 The direct transfer method takes advantage of the Order Entry, Inventory Control and
                 Invoicing modules. The Enter Orders & Quotes (OE30) program is used to create transfer
                 orders against specially coded customer records. The orders are then processed along


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                           Page      150
      08/22/11
                 side of regular orders by the system, are invoiced and then cause transfers to occur
                 between warehouses when the Schedule Invoices & Credits (IN43) program posts the
                 invoices.

                 Let's create a direct transfer account and then create a warehouse transfer order against
                 it.

            Run the Maintain Customer Master (SU13) program.

            In the Customer field, type 02 and press [Tab].

            In the Name field, type "Transfer to 02 Montreal" and press [Tab].

            Press [Tab] repeatedly until the focus is in the Terms Code field, type A and then press
             [Tab].

            Move the focus to the Interest Code field, type N and press [Tab].

            Move the focus to the Ship Via field, type OT and press [Tab].

            Switch to the Info tab: [Alt + 2].

            Move the focus to the C.O.T. field.

                 The Class of Trade for a direct transfer customer must be configured as the built-in code
                 of STO. When orders are processed against an STO account the Transaction Analysis
                 Table or TAT code will be automatically set to TRN to configure the transfer process.
                 Invoice lines with the TRN TAT codes will cause the inventory in the order's warehouse to
                 be reduced while the inventory in the Sales Office (SU13) assigned to the order's
                 Customer will be increased.

            Type STO and press [Tab].

            In the Territory field, type EAS and press [Tab].

            In the Sales Group field, type MIS and press [Tab].

            In the Sales Rep field, press [Shift + F2] to access the Sales Rep Query.

            Set the focus on the Maintenance button (the folder icon) and press [Enter] or click the
             button.

                 The Maintain Sales Reps (SU09) program appears. We will create a sales rep named
                 Internal Use to assign to the transfer account.

            Type IU and press [Tab].

            In the Name field, type Internal Use and press [Enter] to Update the record.

            Press [Escape] to close the program.

            Use the cursor keys to highlight the Internal Use sales rep and then press [Enter] to
             select it.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page   151
      08/22/11
            Press [Tab] to move the focus to the Sales Office field.

                 As mentioned previously, the Sales Office assigned to the direct transfer customer will
                 determine which warehouse's inventory will be increased by the quantity of a product
                 invoiced against it. The inventory will be decreased in the order's warehouse.

            Type 02 to specify the Montreal warehouse and press [Tab] to accept it.

            Move the focus to the Jurisdiction field, type 05 and press [Enter] to Update the record.

            Press [Escape] to close the program.

                 We have now configured the 02 customer to act as a direct transfer account. Let's
                 process an order against it now.

            Run the Enter Orders & Quotes (OE30) program.

                 As we wish to create a direct transfer order from Toronto to Montreal we will select the
                 Toronto sales office. We could also select the Montreal sales office at this point and
                 switch to the Toronto warehouse using the Warehouse command.

            Select the Toronto Warehouse.

            In the Customer field, type 02 and press [Tab] to access the Transfer to Montreal
             account.

                 A warning message appears informing you that the customer you have selected is
                 assigned to the Montreal warehouse. This message is designed to alert you when
                 processing regular customer orders that it may be more efficient to process the order from
                 the sales office assigned to the customer; which would presumably be the closest location.
                 For direct transfers however, the message is not applicable.

            Press Y to continue.

            Set the focus to the Source field, type C and press [Tab].

                 The Source code "C - Warehouse Transfers" itself does not provide any special
                 functionality. We have created a special source code just for transfers so that we do not
                 skew the statistics of other source codes used to track regular orders.

            Switch to the Lines tab: [Alt + 3].

            In the Product field, type 1002 and press [Tab].

            In the Qty order field, type 2 and press [Enter]

                 When the line is created, WinSol will automatically assigned the TRN TAT code to it. If
                 you wish, recall the line you have just created and verify the TAT code which can be found
                 in the More Details dialog.

            Make a note of the Order number created for use later in this tutorial.

            Press [Alt + W] to release the order.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page    152
      08/22/11
            Press [Escape] to close the Enter Orders & Quotes (OE30) program.

                 Now, let's schedule and print the order so that the shipping department can process the
                 transfer.

            Run the Schedule Orders for Printing (OE32) program.

            Press Y to confirm that you wish to schedule orders.

                 The direct transfer order that we created was keyed into the Toronto warehouse against
                 the Montreal direct transfer (STO) account. We will select the Toronto warehouse to
                 schedule and print the order that will be transferred to Montreal.

            Select the Toronto warehouse.

            In the Ship Via dialog, enable the All Ship Vias option and Start the scheduling process.

            Accept the scheduling summary message.

            Run the Print Shipping Documents (OE34) program

            Select the Screen device.

            Select Toronto as the warehouse.

            Answer No to the "Print all copies of EDI shipping order(s).

            Accept the job when completed.

                 When shipping finishes picking and packing the order, they will pass the paperwork onto
                 the invoicing staff for processing.

            Run the Enter Invoices, Direct Bills & Credits (IN41) program.

            Select the Toronto sales office.

            Set or Accept the GL Posting Date.

            If the Transaction Type is not set to Invoice, select Invoice and confirm the GL Posting
             Date.

            In the Order field, type the order number you recorded earlier when our transfer order
             was created and press [Tab] to accept it.

            Accept the Invoice without changes by pressing [Enter] at this point.

            Release the invoice by pressing [Alt + W].

            Close the Enter Invoices, Direct Bills & Credits (IN41) program: [Escape].

                 Now, let's run through a typical day end invoicing cycle by printing the invoices, scheduling
                 the invoices and printing the register. When this process is complete our transfer will have
                 been processed from the Toronto warehouse into Montreal's.


e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     153
      08/22/11
            Run Print invoices, Credit Notes (IN42) program.

            Select the Toronto Sales Office.

            Select the Screen device.

            Select the All option from the EDI Invoices dialog.

            Accept the report when completed.

            Run the Schedule Invoices & Credits (IN43) program.

            Select the Toronto Sales Office.

            Confirm that you wish to start the update: Press [Y].

            Run the Print Invoice Register (IN44) program.

                 The Print Invoice Register (IN44) program produces a register of transactions and a
                 summary of the General Ledger postings that were created as a result of processing those
                 transactions. When you are experimenting with WinDemo, examining the effect that one
                 transaction has on the register can be very helpful in understanding how WinSol
                 processes specific types of orders through to the General Ledger. In this example, we
                 would be able to isolate the effect of a transfer from one warehouse's inventory to
                 another's. If you wish to see the detail, consider choosing to print the register to a file
                 rather than to the screen in the next step.

            Select the Toronto Sales Office.

            Select the Screen device.

            Accept the default Print GL option.

            Accept the report when complete.

                 Our inventory transfer should now be complete. Let's examine the outcome.

            Run the Display Product Availability (IC45) program.

            Access the 1002 Product and switch to the All Warehouses (R) tab.

                 The display should confirm that Montreal now has a quantity of four 1002 cartridges.

            Switch to the Inventory Movement (M) tab.

                 The Inventory Movement tab while the Toronto warehouse is selected shows in reverse-
                 chronological order the direct transfer we just processed, the inventory adjustment transfer
                 we made earlier and a receipt from some time ago.

            Use the Options menu to select the Montreal warehouse.

                 When the Montreal warehouse is selected we can see the transfer of the inventory into the
                 warehouse as opposed to out as we were seeing when the Toronto warehouse was
                 selected. Notice how the Transaction Type and Transaction Identification refer to the

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    154
      08/22/11
                 direct transfer account we used and the invoice number we created to perform the
                 transfer.

            Press [Escape] to close the Display Product Availability (IC45) program.

            Run the Company Control Initialization (CC00) program.

            Switch to the IN1 tab.

                 The IN1 tab of the Company Control Initialization (CC00) program includes an option
                 which enables or disables the updating of invoice history from warehouse transfers
                 processed by direct or in-transit transfers. As the option is currently enabled, we would be
                 able to locate the details of the transfer we just processed in invoice history using a variety
                 of displays and reports. This information in invoice history can be very helpful in
                 troubleshooting or auditing inventory situations later. In some installations however, the
                 frequency of transfers would result in excessive resource allocation for information that is
                 partially duplicated by the existence of the inventory movement records you were
                 examining a moment ago; the option to disable invoice history updates for these
                 transactions is provided for this purpose.

            Press [Escape] to close the Company Control Initialization (CC00) program.


         In-Transit Transfers

                 The third method, In-Transit Transfers, differs only slightly from the Direct Transfer
                 method. With Direct Transfers, accounts coded with the STO class of trade are
                 automatically assigned TAT codes of TRN and the invoicing cycle adjusts the inventory of
                 the two warehouses directly. In-Transit Transfer accounts are coded with the WHS class
                 of trade and order lines processed against them will be automatically assigned the TAT
                 code of WHS. When the invoicing cycle processes the WHS TAT code, the inventory
                 from the sending warehouse is decreased but only the In-Transit levels in the receiving
                 warehouse are increased. A reference to the order In-Transit is added to the branch
                 transfers list. When the order arrives at the receiving warehouse, the Receive Branch
                 Transfers (IC55) and Warehouse Receipt Stock Audit Trail (IC56) programs will convert in-
                 transit to on hand inventory.

                 In-Transit Transfers handles two issues not addressed by the direct transfer method.
                 First, if the direct transfer orders can not be shipped to the receiving warehouse over night
                 the inventory from the transfer may be available in the warehouse before the order has
                 arrived. This can cause timing problems with the release of backorders, future orders and
                 make accurate inventory audits difficult in the receiving warehouse. The in-transfer
                 method avoids this issue by holding the inventory from the transfer in-transit until the order
                 has been received.

                 The second issue is the automation of Warehouse Replenishment. WinSol provides a
                 series of Warehouse Replenishment programs in the Inventory Control module. The
                 system can be configured to reorder stock for an alternate warehouse from the primary
                 warehouse using manually assigned restocking information or it can calculate the values
                 for you.

            Run the Maintain Inventory Master (IM13) program.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     155
      08/22/11
            Access the 2002 Product.

            Switch to the Whse Stocking (3) tab: [Alt + 3].

            Move the focus to the Warehouse field.

            Select the 02 Montreal warehouse: type 02 and press [Tab].

                 WinSol tracks separate Restocking Info for each warehouse.              The Warehouse
                 Replenishment programs will compare the warehouse's current stock availability plus
                 outstanding order for it against this information to determine if an replenishment order
                 should be placed with the Main Warehouse. The Restocking Info can be maintained
                 manually or the Warehouse Transfer Criteria (IC16) and Recalculate Warehouse Forecast
                 (IC23) programs can be used to calculate them from the on booked unit history for the
                 warehouse.

                 Let's manually adjust this product's Restocking Info so that we can see how the
                 Recalculate Warehouse Forecast (IC23) program can set them for us later.

            Move the focus to the Reorder Point field.

            Set the Reorder Point to 50, the Line Point to 60, the Minimum to 25, the Maximum to
             100, and the Monthly Forecast to 200.

            Update the Warehouse Stocking information by pressing [Alt + U] or clicking the
             Update button.

                 Press [Escape] to close the Maintain Inventory Master (IM13) program. On a regular
                 basis the Restocking Info should be recalculated to account for changes in the demand for
                 an item. Let's examine how the Warehouse Replenishment system handles the
                 recalculations.

            Run the Warehouse Transfer Criteria (IC16) program.

            In the Warehouse Number field, type 02 and press [Tab] to accept it.

                 The Warehouse Transfer Criteria will be used by the Recalculate Warehouse Forecast
                 (IC23) program to update the Restocking Info values. The Lead Time in Days value
                 represents the number of days that you required to pick, pack and ship an order for this
                 warehouse. It will be used in the calculation of the Minimum, Order Point and Maximum
                 quantities.

                 Each Inventory Master (IM13) record is assigned a Forecast Calculation Code (PO07)
                 used to weight demand for a product over specific periods in history during the calculation
                 of the monthly forecasted usage. If the Forecast Calculation Code of the Warehouse
                 Transfer Criteria is set to 000 the product's assigned Forecast Calculation Code (IM13) will
                 be used in the calculation of the warehouse's monthly forecasted usage; otherwise the
                 Forecast Calculation Code assigned to the Warehouse Transfer Criteria will be used.

                 The Reorder Criteria Code (PO08) determines what strategy you will use to calculate the
                 Minimum and Maximum quantities from the monthly forecasted usage and which reorder
                 method will be employed.

                 Product Forecasting and Purchasing Criteria is covered in detail in other tutorials.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     156
      08/22/11
            Press [Escape] to close the Warehouse Transfer Criteria (IC16) program.

            Run the Recalculate Warehouse Forecast (IC23) program.

                 The Recalculate Warehouse Forecast (IC23) program will build proposed Reorder Info for
                 the alternative warehouses which will can report and update later using the Print
                 Warehouse Forecast Edit (IC24) program.

            Move the focus through the Range's From and To fields to set a Start to End range.

            Start the calculation by pressing [Alt + the letter O].

            Answer Yes to the "re-set Edit file" prompt.

            Run the Print Warehouse Transfer Pre-List (IC26).

            Answer Yes to print the report before updating.

            Select the File device and set the file name in the Options dialog.

            Accept the report when complete.

            Answer Yes to update the Inventory Masters.

            Locate the file you printed to and examine the report.

                 For the 2002 product you should be able to see that the old Monthly Forecast that we set
                 manually to 200 has been recalculated and new Reorder Info values have been set. Let's
                 confirm that be examining the Inventory Master (IM13) record again.

            Run the Maintain Inventory Master (IM13) program.

            Access the 2002 Product.

            Switch to the Whse Stocking (3) tab: [Alt + 3].

            Move the focus to the Warehouse field.

            Select the 02 Montreal warehouse: type 02 and press [Tab].

                 The values that we manually changed have been replaced with recalculated values based
                 on demand history for this product in this warehouse. Let's see how the replenishment
                 system will act on them now.

            Press [Escape] to close Maintain Inventory Master (IM13).

            Run the Generate Transfer Pre-List (IC25) program.

            Set the Warehouse to 02 and press [Tab].

                 The Generate Transfer Pre-List (IC25) program provides product ranging fields that could
                 be used to generate for less than all of the products.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page   157
      08/22/11
            Press [Tab] to accept the default values for the Start and End fields and when the focus
             is over the Start Generation Now button press [Enter].

                 The Generate Transfer Pre-List (IC25) program will examine the stock position of all
                 products within the specified range against the Reorder Info for that product in this
                 warehouse. When the available stock plus the quantity on open orders for the warehouse
                 is below the reorder point the program will suggest a reorder of the product.

            Answer Yes to reset the file before generation.

            Press [Escape] to close the Generate Transfer Pre-List (IC25) program.

            Run the Print Warehouse Transfer Pre-List (IC26) program.

            Select the File device and set the file name in the Options dialog.

            Move the focus through the Range's From and To fields to set a range from Start to
             End, then press [Alt + the letter O] to start the report.

            Select the 02 Montreal warehouse.

            Accept the report when complete.

            Locate the file you printed to and examine the report.

                 The report will show the suggested reorder quantities in the last column. Let's continue
                 with this proposed reorder to see how it processed through WinSol.

            Run the Confirm Warehouse Transfer (IC27) program.

            Select the 02 Montreal warehouse.

                 The Confirm Warehouse Transfer (IC27) program displays the proposed reorder for the
                 02 Montreal warehouse. The program can be used to edit the proposed reorder prior to
                 generating the order.

            In the Product field, type 2002 and press [Tab].

            In the Transfer Qty field, change the quantity to 50 and press [Enter] to Update the line.

                 Now, let's generate the transfer order.

            Press [Alt + G] or click the Generate Order button.

            Answer the "Generate an order" prompt with Yes: Press [Y].

                 While the order is being generated, normal inventory warnings will be presented to the
                 operator. Accept them as they appear. When the order generation is complete a
                 message will report the order number (record it for use later in this tutorial) and the number
                 of lines.

            Accept the warning messages.

            Record the order number created and accept the completion message.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     158
      08/22/11
            When the Warehouse Selection dialog appears, select 02 Montreal again.

                 The program offers us the Warehouse Selection dialog again in the event that we wished
                 to generate for another warehouse. By selecting a warehouse with no pre-list, as
                 Montreal would no longer have since we generated from it a moment ago we will be
                 offered to opportunity to exit the program.

            Answer Yes to exit the program: Press [Y].

                 Our warehouse replenishment order is now ready for scheduling and printing.

            Run the Schedule Orders for Printing (OE32) program.

            Press Y to confirm that you wish to schedule orders.

                 The in-transit transfer order was created in the Toronto warehouse to replenish Montreal.
                 We will select the Toronto warehouse to schedule and print.

            Select the Toronto warehouse.

            In the Ship Via dialog, enable the All Ship Vias option and Start the scheduling process.

            Accept the scheduling summary message.

            Run the Print Shipping Documents (OE34) program

            Select the Screen device.

            Select Toronto as the warehouse.

            Answer No to the "Print all copies of EDI shipping order(s).

            Accept the job when completed.

                 When shipping finishes picking and packing the order, they will pass the paperwork onto
                 the invoicing staff for processing.

            Run the Enter Invoices, Direct Bills & Credits (IN41) program.

            Select the Toronto sales office.

            Set or Accept the GL Posting Date.

            If the Transaction Type is not set to Invoice, select Invoice and confirm the GL Posting
             Date.

            In the Order field, type the order number you recorded earlier when our transfer order
             was created and press [Tab] to accept it.

            Accept the Invoice without changes by pressing [Enter] at this point.

            Release the invoice by pressing [Alt + W].

            Close the Enter Invoices, Direct Bills & Credits (IN41) program: [Escape].

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                       Page     159
      08/22/11
                 Now, let's run through a typical day end invoicing cycle by printing the invoices, scheduling
                 the invoices and printing the register. When this process is complete our transfer will have
                 been processed out of the Toronto warehouse and into an in-transit state in Montreal's.

            Run Print invoices, Credit Notes (IN42) program.

            Select the Toronto Sales Office.

            Select the Screen device.

            Select the All option from the EDI Invoices dialog.

            Accept the report when completed.

            Run the Schedule Invoices & Credits (IN43) program.

            Select the Toronto Sales Office.

            Confirm that you wish to start the update: Press [Y].

            Run the Print Invoice Register (IN44) program.

            Select the Toronto Sales Office.

            Select the Screen device.

            Accept the default Print GL option.

            Accept the report when complete.

                 Our in-transit order will now be available for receipt in Montreal now. (Note that freight
                 may optionally be added into the product cost using the Maintain Shipping Addon Rates
                 (IM05) program.)

            Run the Receive Branch Transfers (IC55) program.

                 The Receive Branch Transfers (IC55) program displays a list of the in-transit transfers
                 pending receipt. Note that while this program updates the quantity balances in the
                 Inventory Master file record (in the receiving warehouse), the General Ledger distribution
                 entries are reported and updated by the Warehouse Receipt Stock Audit Trail (IC56)
                 program we will run following the receipt.

                 If any products being received are serial number controlled from the point of receipt, the
                 serial numbers sent from the sending warehouse are displayed in a window for
                 acceptance. The operator should validate that those serial numbers were in fact the ones
                 received and then accept, reject or modify as required.

            Type the Order No + Shipment number or press [Shift + F2] to access the query.

            Press [Alt + R] to click the Receive button to process the in-transit into inventory.

            Press [Escape] to close the program when completed.



e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     160
      08/22/11
                 The inventory will now be on hand in the receiving warehouse. If you wish, you can use
                 the Display Product Availability (IC45) program's Inventory Movement (M) display to see
                 the transaction details.

            Run the Warehouse Receipt Stock Audit Trail (IC56) program.

            Select the 02 Montreal warehouse from the Warehouse Selection dialog.

            Select the File device and set the file name in the Options dialog.

            Accept the report when complete to update the General Ledger.

            Locate the file you printed to and examine the report.

                 If you are going to enable Shipping Addon Rates (IM05) consider experimenting with
                 WinDemo to isolate your in-transit transfer on this to report to see the effect they will have.

                 WinSol provides two additional report programs, the In Transit Shipment Report (IC57)
                 and the In Transit Report by Product (IC58) which can be used to report on outstanding in-
                 transit transfers.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     161
      08/22/11
EXCLUSIVE PRODUCTS
                 The Exclusive Product system provided by WinSol can be used support marketing
                 agreements that you make with your customers. For example, you currently distribute a
                 very successful line of fine Waterman pens to retailers in the gift business. Recently, your
                 marketing staff signed a contract between a new customer and the manufacturer of
                 Waterman pens. The contract is designed to expand the distribution of the product line
                 into a new retail market. Part of the agreement includes the exclusive rights to resell a
                 new series of pens for a limited time, during which the manufacturer and retailer will co-
                 promote the products. After the co-promotion period, any of your customers will have
                 access to the product.

                 To ensure that this new product line is available only those participating in the program we
                 will configure WinSol to prevent others from access the products involved.

            Run the Maintain Exclusive Products (IM38) program.

            In the Customer field, type BIRCAN and press [Tab] to access the customer
             participating in this program, Birks Canada

                 The products to be made exclusive have been assigned by the Maintain Inventory Master
                 (IM13) program to a Commodity Code with a Product Line specific to this to this program;
                 PL, the Platinum Gift Series. The Platinum Gift Series product line has one product
                 assigned to it at this time; the 8210 Waterman Platinum Sword writing pen.

            Type PL and press [Tab] to select the Platinum Gift Series.

                 The Exclusivity Options will allow us to configure in what areas and for what duration the
                 products in the selected Product Line will be exclusive to this Customer. In this situation,
                 we wish to make the Platinum Gift Series exclusive to Birks Canada until Jan 15/98 across
                 all of our territories.

            Press [Tab] to accept the Territory *** which represent all territories.

            Press [Tab] to accept a blank Starting Date.

            Type Jan15/98 and press [Enter] to set the Enter Date and Update the Exclusive
             Product Line Record.

                 When updated, the Exclusive Product Line list below will display that the PL Product Line
                 has been configured as exclusive across all territories (as shown by the three asterisks)
                 with an ending date of Jan15/98.

                 Let's test the exclusivity now.

            Leave the Maintain Exclusive Products (IM38) program running for now.

            Switch to the WinSol Program Menu and run the Enter Orders & Quotes (OE30)
             program.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    162
      08/22/11
            In the Customer field of Enter Orders & Quotes (OE30), access the BIRCAN account,
             set the order Source and then switch to the Lines tab.

            In the Product field, type 8210 to access the Platinum pen and press [Tab] to accept it.

                 As the Birks Canada account has access to this exclusive product, the details of the
                 products availability are displayed and the focus moves to the Qty order field where you
                 could create an order for it.

            Press [Alt + W] to reset the program.

                 What happens we attempt to order the exclusive product for a customer without access?

            Select the York Lawyers Association's account, YORLAW and switch to the Lines tab.

                 The York Lawyers Association commonly buys Waterman pens from you that they award
                 to its members for years of service. This year, they are hosting the American Bar
                 Association's annual meeting on Feb1/98 and are therefore responsible for providing the
                 key note speakers with a token of appreciation. One of the executives at York recently
                 saw a television commercial promoting the new Waterman Platinum Sword and has
                 suggested to the committee that they give these pens as gifts to the most important key
                 speakers. What happens when your order desk staff attempts to select the exclusive
                 product for the YORLAW account?

            In the Product field, type 8210 to access the Platinum pen and press [Tab] to accept it.

                 An error message is displayed to the operator explaining that the product they have
                 selected is exclusive to one or more customers and provides the account number of those
                 customers.

            Press [Enter] to accept the message

                 The Enter Orders & Quotes (OE30) will not create an order line for a product that is
                 exclusive to others.

                 Your order entry staff quickly reviews the details of the Platinum Gift Series promotion and
                 discovers that while they are not available to the York Lawyers Association at this time,
                 they will be available in the future after Jan15/98. As the product is not required until
                 Feb1/98, your staff offers to take a Future Order for the product by setting the Date
                 required beyond Jan15/98. York agrees to place the order with you now and wait for them
                 to become available.

            Switch to the General tab: Press [Alt + 1] or click it.

                 The Date required field is not in the forward tab order of the Enter Orders & Quotes
                 (OE30) program. You can access the field however, without having to use the mouse, by
                 moving the focus to the next field after it (Ship Via) and then using [Shift + Tab] to move
                 the focus back onto it.

            Set the focus into the Date required field.

            Type Jan16/98 and press [Tab] to accept it.

            Switch to the Lines tab: press [Alt + 3] or click it.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    163
      08/22/11
            In the Product field, type 8210 to access the Platinum pen and press [Tab] to accept it.

                 As this is now a Future Order beyond the End Date of the exclusive product you are able
                 to create an order for it.

            Order up a quantity of 2 and press [Enter] to Update the order.

                 You may notice that WinSol has not allocated available inventory to the order as it is not
                 required until a date in the future. The Future Order Control tutorial provides more
                 information on this process.

            Press [Alt + W] to reset the program.

            Press [Escape] to close the Enter Orders & Quotes (OE30)

            Switch back to the Maintain Exclusive Products (IM38) program left running earlier.

                 The Exclusivity options of the Maintain Exclusive Products (IM38) program can also be
                 configured to support territorial exclusivity. For example, say that Birks and Waterman
                 have agreed that they will have exclusive access in only your eastern territory while
                 another retail chain, Gold Coast Gifts will participate in the western territory. Let's
                 reconfigure the exclusivity to support this.

            The Maintain Exclusive Products (IM38) program should still be displaying the BIRCAN
             exclusive products table. If it is not, select the BIRCAN Customer now.

            With the BIRCAN Customer selected, press [Tab] as necessary to move the focus to the
             Product Line field.

            Type PL and press [Tab] to access the existing Product Line record for modification.

            In the Territory field, type EAS and press [Enter] to Update the change.

                 The Exclusive Product Line list will show that you have updated the Platinum Gift Series
                 line to be exclusive to Birks Canada in only the EAS Territory.

            Press [Alt + W] to reset the program.

            Type GOLCOA and press [Tab] to select the Gold Coast Gifts customer.

            Type PL and press [Tab] to select the Platinum Gifts Series.

            Type WES and press [Tab] to specify the West Territory as an Exclusivity option.

            Press [Tab] to accept no starting date.

            Type Jan15/98 and press [Enter] to specify the Ending Date and update the record.

            Press [Escape] to close the Maintain Exclusive Products (IM38) program

                 With one exclusive record with Birks for the East territory and another for Gold Coast for
                 the West territory, only those accounts in those territories will have access to the product
                 until after Jan15/98. Any other accounts in the EAS or WES territories will be denied
                 access to the product except for Future Orders beyond the ending dates in their territory.

e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page    164
      08/22/11
                 Accounts in territories other than EAS and WES will have unrestricted access now that the
                 all territories (***) exclusivity has been removed.

                 The Exclusive Products system is permissive in assessing access to exclusive products
                 when an overlapping territory situations exists. For example, if one customer has been
                 granted exclusive access for one territory while another has all territories (***) the system
                 allows access to both customers granted the exclusivity while it restricts access to all
                 others.

                 WinSol provides the Exclusive Product List (IM39) program to report on the configuration
                 of the exclusivity settings. This program can be used to report the Exclusive Product Line
                 details by Customer, Product Line or Territory and offers restrictions for the Exclusivity
                 Options. In cases where conflicts exist between two customer setting, the report lists the
                 account number(s) causing the conflict which can be used to determine if the conflict
                 intentional or not.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                         Page     165
      08/22/11
REPLACEMENT COST CALCULATION




         M – Method of Calculation

         V – Landing cost is calculated as a percent of selected „Base‟ value
         W – Landing cost is calculated as a dollar value per SKU weight (pound/kilo)
         C – Landing cost is calculated as a dollar value per SKU volume (cubic foot/meter)
         U – Landing cost is calculated as a dollar value per unit purchased

         B – Base Dollar Value

         1 –Domestic NET unit purchase price
         2 –Value For Duty. This value used to calculate the duty amount. It is the Net Purchase Price
                 plus any Landing Costs that are flagged „dutiable‟.
         3 –Duty Paid Value. This is the sum of Value For Duty plus the duty amount.
         D – Dutiable Flag

         N – Duty is not charged on this landing cost.
         Y – Duty is charged on this landing cost.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                        Page     166
      08/22/11
Landing Factor     Calculated As:                                                Domestic Equivalent per
                                                                                 SKU
                   Domestic Net Purchase Price                                       1,800.00
                   300000.0000 YEN X .01 exchange = 3,000.00 less
                   40%

INFRGHT            $.20 / lb X 2 lbs                                                         .40
  Inland Freight
OCFRT              US$.25 / cu‟ X 1.40 exchange X 5 cu‟                                     1.75
  Ocean Freight
PACKAGE            US$10.00 / unit X 1.40 exchange                                         14.00
  Packaging
BROKER             1% of Value for Duty (1814.00)                                          18.14
  Brokerage
DUTY               20% of Value for Duty (1814.00)                                        362.80

INSURANCE          5% of Duty Paid Value (2176.80)                                        108.84

                   Replacement Cost                                                     2,305.93


                   Base 1 (Net Purchase Price):             1,800.00

                   Base 2 (Value For Duty):                1,814.00
                   + 14.00 (Packaging)

                   Base 3 (Duty Paid Value)          2,176.80
                      1800.00 + 14.00 (Packaging) + 362.80 (Duty)


             Other Comments:
                    The sole function of landing factors attached to a supplier in program PO11 is to define
                    default landing factors when building new purchasing information records in program
                    PO13. If landing factors do not exist for the PO13 record, then the landing calculation
                    program will not go back to use the supplier‟s default factors from PO11.

                    In Solution, you were forced to process receipts via the In-Transit method if you wanted to enter
                    landing cost dollars. In WinSol, you can now do this for direct (domestic) receipts via Folder 5 in
                    program PO60 and avoid the two-step process.

                    When you override landing factors in PO60 or PO63, you may enter the cost in foreign currency--you
                    no longer have to calculate the domestic value of the cost. Each landing factor record now contains
                    a currency code that is used to automatically calculate the domestic cost.

                    When you enter a landing factor in PO60 or PO63, you also dictate if the entered amount replaces
                    the PO13 rate or is in addition to the PO13 rate.

                    For landing costs calculated based upon weight or volume, if you enter the cost (freight)
                    amount then that value will be apportioned into the cost of each product in the receipt by
                    first calculating the total weight/volume of the receipt and then figuring out what percent of
                    the total weight/volume each receipt line is. That receipt line then receives that portion of



 e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                              Page      167
       08/22/11
                 the total freight cost entered. For example, if a receipt line represents 75% of the total
                 shipment‟s weight/volume, then 75% of the freight cost will be applied to that receipt line.




                 PO03 is used to define landing factors. In that program there are two new functions:

                 Bulk Change a Factor is used to do a mass update of PO13 landing factors.

                 Where Used Query is used to find out which PO13 records are coded for a specific
                 landing factor.


Bulk Change Maintenance Screen
                 You may process a bulk change for a specific supplier, commodity or range of products.
                 Asterisks in the Supplier Code and/or Commodity fields will process all suppliers or all
                 commodities.

                 If you are changing the rate of an existing landing factor across the board, leave the “Old
                 Rate” field .00 If you wish to change only those records that have a specific old rate (ie,
                 change rate from .25 to .27) then enter the old/new rates. Only records meeting that
                 criteria will be changed (ie, if the old rate was .24, then that record would not be changed).

                 If you wish to create new landing records (ie, you need to add a packaging cost for a
                 certain series of products), then check the “Create New Records” box. This routine will
                 also be used to build landing factors by supplier following electronic conversions.




e3445d92-b1c8-4620-a780-a2406ea9e6bd.doc                          Page     168
      08/22/11

								
To top
;