End of Year Processing Notes

1. Change calendars and other transitory items back to a zero quantity on
   hand, by running Option 3.Q and entering a negative quantity (equal to
   the stock on hand) and a value of zero.
   NOTE: If this write off step is missed, doing it in the first month of
   the new financial year will be fine. The program posts an adjusting
   transaction to the LMTH folder to ensure it is included in the end of
   year figures.

   Run a list of unposted worksheets (Option 5.P). If any of them are not
   valid, cancel them (and run option 5.4).

   ALSO, Ensure all unposted worksheets and invoices have had the stock
         pulled from the shelves (else been cancelled).

   Any committed items in valid worksheets and invoices will be automatically
   subtracted from the quantity printed on the stocktake listing.
   (This covers the post dated invoices and pro forma invoices).

   NOTE: When the program produces the stocktake $ amount, it always adds
   back in the committed quantity.

   Run Option "S" on the main screen to clear any negative stock quantities
   in the quantity at last update.

   Lastly, run Option P.2 "REBUILD" to rebuild the average price. This
   gives a more accurate cost price on all items.

2. Immediately after running Option 8.1 in End Month procedures,
   run Option 8.2 - End of Year Rollover.
 
3. From this point, Reports and Statements in LMTH (Option 9.G sub-option 3)

4. Print Stocktake sheets in LMTH (Option 3.5) using the following choices:

    (a) Filter Option 2 (Sales YTD or Stock On Hand)
    (b) Include Out of Print Titles:  Y
    (c) Print Order: 4 (by bin number)
    (d) Display: Y
    (e) Listing: 2 (medium)
    (f) Specify Supplier Code: N
    (g) Sub-Total and Page Throw: Y
    (h) Option 1. YTD Sales only  2. On Hand Stock only  3. Either: 3

    NOTE: Ensure Write-off Calendars are not counted.

          Ensure any unsent items on invoices or worksheets are not counted
          as the stocktake entry option 3.2 sub-option 7777777 has already
          reduced the quantity on hand by this committed stock.
          (This is different to the "S" option on the Main menu, which does
          not reduce the quantity by the amount of committed stock.)

5. Do all stock adjustments in LMTH (Option 3.2) using the 7777777 option.
      Display Option: 2 (Only non-zero quantities or non-zero sales YTD)
      Rebuild Bin Index: Y (first time only. N for any subsequent adjustments)
 
6. Enter the adjustments carefully (you have up to 1 month to do this).
   Run Option 5.4 in LMTH regularly to update
   these corrected movements to the current month.

7. Run Option 9.W in LMTH to update write-offs.

   It allows you to specify a write-off category against specific products.

   Press Esc to end. If you specify Y to rebuild, this will
   simultaneously update the category on both the LMTH screen as well as
   the current month, and change the status to "W" or "O", depending on
   whether or not there is a quantity on hand.
   Ensure all screens are at the desktop prior to running a rebuild.

8. Rebuild Bins (Option 4.5 - Sub-Option 999).

   Run this twice, once in the LMTH folder, and once in the current month.
   This will establish the "Write Off" bin for all the new write-off products.

9. Zero the Average Cost Price for the stock that has been written off.

   Run this twice, once in the LMTH folder, and once in the current month.

   Option 3.6: Select percentage option 9999.9999 and Y to confirm

10. Run Final Reports. Must all be done in the LMTH folder.

   a. Control Totals (Option 5.6). Run twice, once answering "Y" to print
      normal MTD balances and totals, the second time answering "C"
      to print Current YTD totals.

   b. Stocktake Adjustments (Option 3.8 "S"). Leave the date range blank
      and enter "2" for all adjustments for the year.
      If you rerun and enter "1", you will see the adjustments for the month

   c. Category Summary (Option 5.5.5).
      List Suppliers: "A" - Alphabetically

   d. Write-offs report (Option 3.5).

    (i) Filter Option 2 (Sales YTD or Stock On Hand)
    (ii) Status:  W 
    (iii) Include Out of Print Titles:  N
    (iv) Print Order: 5 (by av.cost * qty)
    (v) Listing: 3 (long)
    (vi) Exclude Products with an Average Cost of Zero: Y
    Answering Y obtains a short report that shows the $ value being
    written off this year.
    Answering N (whih is unnecessary) shows all stock in the write off bin.
    (vii) Option 1. YTD Sales only  2. On Hand Stock only  3. Either: 2

    Then rerun the report choosing Print Order: 3 to obtain w/o totals
    by supplier.


   e. Final Stock Listing & YTD Sales (Option 3.5).

    (i) Filter Option 2 (Sales YTD or Stock On Hand)
    (ii) Include Out of Print Titles:  Y
    (iii) Print Order: 3 (by supplier number)
    (iv) Listing: 3 (long)
    (v) Sub-Total and Page Throw: Y
    (vi) Sort within supplier: 3 (Alpha with writeoffs separate)
    (vii) Option 1. YTD Sales only  2. On Hand Stock only  3. Either: 3
 
   f. Consignments Listing (Option 7)
    (i)  All products on consignment (Option A)
    (ii) Totals by Customer (Option B)

   g. Transfers listing (Option 1.4)
    (i)   Enter customer 9003, sub-option 2
    (ii)  Option I for internal report.
    (iii) Which transactions: I for invoices and credits
    (iv)  View despatch details: N
    (v)   Starting date: 01/04/ (previous year)


** End of Notes
