coglog
Services Limited
Integrated Business Solutions

STOCK

OVERVIEW

Stock Control Files:

8SCQ01C- PRODUCT LOOKUP

Information is displayed in various ways; select an inquiry type and scroll through the file.

SCQ01B

Toggle F2 to hide / show all costs except Price 1, can be set per user.

F5 Availability, Prices, Branch totals and "Aged Stock" (if applicable). The following displays how Availability changes when different activities are performed:
"Free" stock = Available - Reserved (Allocated) + Coming in (Supp. Order)

What can be sold What can be seen What is owned Gone - not processed Here - not counted Reserved Coming in Here - not counted Action
FREE AVAIL ON HAND ISSUED REC'D CUST ORD SUPP ORD RETN  
6 6 8 2         Opening Stock
5 5 8 3         Entered Invoice
4 5 8 3   1     Customer Order
5 5 8 3   1 1   Supplier Order
5 6 8 3 1 1     SO Received
5 6 9 3   1     SO Costed
5 6 8 2   1     Update Invoice
5 5 8 3         Fill Cust. Order
5 5 7 2         Update Invoice
6 6 7 2       1 Entered Credit
6 6 8 2         Update Credit

During Invoicing, Stock quantities are displayed across the "Totals" line for each item.

F6 Profile, Prices, Codes, Supplier etc.

F8 Demand / Purchase: a history of stock movements. Month and Year to Date Sales and Purchases, Average, Maximum, Profit and Stock Value.

8SCL01C2 TRANSACTIONS

The Stock Transaction program is not used much any more - Invoicing, Customer Orders, Supplier Orders and Stocktake handle most stock transactions. Also see Re-Ordering.

N.B. If an incorrect transaction is processed, a reversing transaction is needed to correct it.

Select Batch Type:

Key Description Explanation
B Back order Customer Order.
C Credit Credit your company against Supplier.
D Demand Lost sale.
I Issue Un-updated customer Invoice or P/Slip.
M Movement Inter-branch transfer.
N In Production Being manufactured.
O Purchase Order Supplier Order.
P Purchase Receipt Received Supplier Order.
Q Quantity adjustment Reduce / increase "On Hand" (a minus sign to decrease).
S Sale Customer Invoice.
T Text Text only
V Variance From Stocktake - alter "On Hand" quantity.
Z Adjust On Hand From Stocktake - replace "On Hand" quantity.

8SCL01C2 OPTIONS

F5 to add new item, accesses Product Maintenance.
F8 to attach text lines to a transaction.
F6 to Change. Use "hot" column to change quantity and Enter to accept.
F6 again to change any line details.
Key in 10 at the Record Sequence box to change Header details.
F7 to Delete a line and F2 to Confirm.
F7 to Delete the whole document F2 to Confirm. Esc to leave the program; the work file remains open. You will be prompted to delete it or to continue with it when the program is re-entered.
F9 to End and Save. Enter to accept Total or Esc to make any corrections.
Error messages: press any key and make corrections.

At Options Menu:
F9 to Process or
F6 to return to correct the unprocessed document.

8SCL03 PRICE CHANGES

This program provides fast price recalculations on selected items. You can e.g. increase Price 1 by 20% based on a particular suppliers' Last Cost, recalculate all your Selling Prices according to a pre-set mark up code, clear specific price codes, or round prices to two decimal places etc. Non-current items are not changed.
N.B. Back up first.
F4 for changes without a printout,
F5 for only a printout - no changes made or
Enter for changes and a printout.
The text at the top right hand of the screen will dispaly your choice.

Selections:

SCL03
Options:

A program can be used to restore price from Back Up if ranges are accidentally deleted with Price Change. Check with us first

8SCL07 PRICE IMPORTS - COGNOSCO

COGNOSCO is Latin for I recognise and XENO is Latin for stranger: this process translates a supplier's product list into data that Cogito can use.
The group of programs is designed to make bulk changes to your product list and / or Supplier's Product codes and descriptions (handy for ordering), barcodes, and prices. It will only update the products that match the codes on your system.
It takes a Supplier's spreadsheet (.csv) and inserts data from your records. The system uses “Import Templates” to describe each supplier's spreadsheet, and “Markup Formulae” describing your method of calculating prices from suppliers' costs. Add your stock code into the spreadsheet, tell the system what "shape" the spreadsheet is, and all the information will be updated. After the initial setup the process can be run very quickly.

    SCL07

  1. Select your Import template F3to select e.g. "AS": this will create eg. "OLAS.csv".
    The template can be used to generate or translate a spreadsheet in preparation for:
    updating Xeno data (supplier product code, barcode, etc.)
    a Supplier's new price list
    New product ranges or product changes
    The template (usually 1 for each supplier) carries information to "translate" his price list to a standard CogNosco spreadsheet.
    See option 20: CogNosco Templates, or "Stock Setups" (rSCL29C0), Subject 14 "Import Templates".
    A template can alternatively carry a "Generator" code which will call a designated Product Export routine with an attached "Report Filter". This option allows you to “build” a CogNosco spreadsheet from your own Product table to prepare for changes you wish to make.
  2. (optionally) build a spreadsheet or use one from the Supplier (option 3)
    To produce a "basic” spreadsheet the selected Import template must specify an export in the “Generate using” option:
    SCL29-14

    e.g. template AS can build spreadsheet OLAS.csv using program 8SCPO2KA with filter AS. The spreadsheet is produced and changes can be made (e.g. re-calculate Std. Cost) before being imported into CogNosco using option 3.


  3. SCP02KA

    Create a report for this spreadsheet. In the Layout Screen: set to eXport, give it an Export name OLAS.CSV and set to Replace each time it is run.


  1. "Import" a spreadsheet and convert to CogNosco format
    Care is needed to not let the spreadsheet program take control of how the data is imported: it is comma separated, and some columns (especially "codes") may need to be identified as e.g. "text".
    This function takes an imported spreadsheet (or the one produced in step 2 above) and "processes" it into a standard "CogNosco" worksheet. "Missing" details are automatically inserted from the Product and / or Xeno tables.
    Once Xeno products are loaded, Cognosco will automatically fill in "our" Product Codes, along with our Description, category and sales codes, short description and current prices.
  2. Update using 8SCL03 PRICE CHANGESPrice Calculator The optional "price calculator" program (rSCL03) can now process a CogNosco spreadsheet using "markup formulae".
    See program option 11: "Markup Formulae", or "Stock Setups" (rSCL29C0), subject 11 "Markup Formulae".
    NOTE that this process only populates the spreadsheet.
    It does NOT update the prices onto the Product table.
    (see option 6: "Update our Product table").
    A "markup formula" can be assigned to an Import Template, an individual Supplier, or per row (line) in the spreadsheet.
    New prices are calculated using the formula and placed into the spreadsheet, which can then be reviewed.
    It is probably best to assign a Markup Formula code to each product. This can be achieved by assigning a code to each supplier (or each category), then updating your products using the new toolkit program (rSCX06MF). This checks each product which doesn't currently have a Markup Code and assigns one – firstly by checking the “main supplier”, and then the product's “category” code. You could also assign markup codes using a generated CogNosco spreadsheet or by using the “gang change” toolkit (rSCX06MU).
  3. Review results
    Opens the created spreadsheet e.g. PRICE.CSV
    This option now allows you to select an imported ”raw” spreadsheet, or a generated CogNosco spreadsheet for reviewing or changing with your specified spreadsheet program - e.g. Open Office Calc or Microsoft Excel.
    The spreadsheet can be "fixed" in any way you like except that you must retain the original "shape" – i.e. don't insert, delete or re-arrange the columns in any way.
    There are 2 "work" fields which can be used for whatever you like, but remember that a .csv file does not retain spreadsheet calculations.
    Any number of columns can be added after the last column.
  4. Re-process (after fixing) This option can be used if you are spending a long time preparing a spreadsheet - e.g. fixing Product Codes, pricing, descriptions etc.
    You will be asked to select the Import Template (option 1) and the the spreadsheet name (option 13).
    The program will then fill in any other data (as per option 2).
  5. Update our Product table Once the spreadsheet is finalised, use this option to update your Product Table (ccSCM) - using program "rSCX41K1".
    Note that only "non-blank" (and "non-0") items will be used, and only if they are different from what is already on the Product record.
    New products will also be added, provided that there is enough information - Code, Category, Status, Description, prices.
  6. Update "Xeno Supplier Product" table If there is enough relevant information in the spreadsheet, this process (rSCX42K1) will populate the Xeno table with the following data per Supplier Product:
    Their Product Code
    Their Description (up to 2 lines)
    Bar Code
    Latest Cost

  1. Product Lookup program (rSCQ01C2) so that you can check codes, pricing etc.
  2. Xeno Product Lookup (rSCQ03C1).

  1. Change / create an Import template (rSCL29C0 Subject 14).
  2. Markup Formulae: edit or create a new markup formula for this supplier: (rSCL29C0 Subject 11).
  3. Export Filter: You can create a "blank" CogNosco spreadsheet (rSCP02EO) with report maintenance.
  4. Using spreadsheet: Allows you to select which spreadsheet you are using. F3 allows you to select from a list of available spreadsheets, showing the "newest" first.

8SCL09C- PRODUCT MAINTENANCE

The Product Master File contains a record for each item. This program may also be accessed during invoicing.

N.B. Know what you are doing should you want to change a key code, this affects sales analysis and other reports. Check first - there is a specific re-coding option available. Defaults can be set to save keying-in time. Stock levels should only be changed when you initially load your records, after that the "delete" function should be turned off and you should use postings. Not all fields need to be filled but you will be prompted if an essential field is left blank.

At the prompt F3 to pluck and change any existing record
OR enter a new code and F5 to Add OR F8 to Copy the last record on screen.

The Stock File has 4 main categories: the Stock Category, Category 2 / 3 and a Sales Code.
Also see Stock report subjects and Sales Analysis Tables for reportable fields.
Keep these divisions in mind when setting up your Product File; many of the programs (such as Price Change and Tool Kits) are designed around these categories.

8SCL09C- DESCRIPTIONPRODUCT MAINTENANCE
Code Description Action Group
A Alias Is actually "alternate-1" with different code/desc/price.   FS PR NC    
B Buy In Cannot Order in without Ref to a Sale Document - Customer Order ST FS        
C Current Normal ST FS PR   RO VC
D Discount similar to "O" service   FS        
E Exclude "Current" but to be excluded from "re-ordering". ST FS PR NC   
F Final BOM Bill of Material Kit - "Built" ST FS PR     VC
G Freight     FS PR     VC
I Serialised Has "Serial Number Tracking" ST FS PR   RO VC
K Kit The header record for a "Kit" - of components   FS PR     VC
L Labour For Job Costing   FS PR     VC
N Non-Stock A "generic" item (no stock figures kept)   FS   NC   
O Other Services Consultancy (no stock figures kept)   FS PR     VC
P Production item Can Order - cannot Invoice. Component item for BoM         RO 
Q Group Item product for which there are multiple sizes or flavours           
R Reference for suppliers' Bar Codes           
S Suspended Not currently for sale. Cannot Invoice or Order       NC   
X Discontinued Invoices "Alternate" item, Order suggests "Alternate".       NC   
Z For Deletion Cannot Invoice or Order, to be deleted.       NC   

8SCL09C- TEXTPRODUCT MAINTENANCE

SCL09a


Flags 1 - 4: this 4 column Header sets the defaults for displaying and printing extra text attached to a record. A Flag at an individual line over-rides the setting in the column header - X per line suppresses the column heading.

Column Header:
Space to ignore text in lookups and printing. Text does not display, is not "turned on". Just handy for notes to yourself when in stock maintenance.
OR * for all options
OR I, p etc. as described below
OR (applicable to Column 4 only) A,B,C,D behaves like a * but also includes security level: eg. D allows only those users with unlimited access to see the text.
    Each column represents a different "condition":
  1. Printing on Sales:
    Print only on Invoices, Orders, Packing slips or Quotes (upper case)
    * print on all
    OR print on all documents EXCEPT invoices, orders, packing slips or quotes (lower case).
  2. Printing on Reports:
    Print only on Price lists, Re-orders, Valuations.
    N.B. only if "Extra Text" is selected in the Report.
  3. Printing on Purchasing:
    Print on Orders, Receipts, Costings.
    OR print on all documents EXCEPT orders, receipts, costings.
  4. Display:
    During Sales (Invoicing etc.), Purchases, or Query (Lookups)
8SCL09C- PRICESPRODUCT MAINTENANCE
8SCL09C- CODESPRODUCT MAINTENANCE
8SCL09C- STOCKPRODUCT MAINTENANCE
(Or use the Stock Maintenance program.)
8SCL09C- SALES AND PURCHASESPRODUCT MAINTENANCE
8SCL09C- PURCHASINGPRODUCT MAINTENANCE
8SCL09C- ALTERNATE UNITSPRODUCT MAINTENANCE
For setting up a regime to sell items in different units based on the way you normally buy and sell this item. Any change to the sell price impacts on the alternate unit prices.

SCALT SCALTA Either method may be used - or a mixture of multiplication and division.
Note that only 2 not 5 alternate units are available at this stage.

The alternate unit Price is calculated by taking the sell price, multiplying by the Factor, then dividing or multiplying (depending on the "Indicator") by the ratio.
Sum: Sell Price x Factor x OR + Quantity

Normal unit Packet $10.00    
e.g. Cigarettes Desc. Factor / Price Type Quantity Indicator  
Alternate unit 1. Single 1.05 20.00  
Alternate unit 2. Carton .95 10.00 M

A Packet of cigarettes containing 20 cigarettes is $10.00
A single cigarette is loaded by 5% Sum: 10.00*1.05/20 = $0.525
A Carton containing 10 Packets is loaded by 5% Sum: 10.00*.95*10 = $95.00

Normal unit Pipe 3 Metre lengths $40.00  
e.g. Pipe Desc Factor / Price Type Quantity Indicator
Alternate Unit 1 1 Metre 1.250 3.000

3 metre length of Pipe is $40.00
A metre of Pipe is loaded by 25% Sum: 40.0*1.25/3 = $16.67

When invoicing, the "Quantity" is dependent on the "Of Code" - Select 0, 1, or 2
The unit descriptions are displayed, but you may want to change the general description.

SCALTB

These invoice lines show:
1st line selling 1 x normal unit
2nd line selling 1 x alternate unit
3rd line selling 3 x alternate unit
(note the difference between lines 1 and 3 due to the loading factor).

SCALTC

8SCX06-- TOOL KITS

See general information on Toolkits.

Discount Level Product Category
Replaced By / from Product Code Salesman Code
Sales Code Short Description
Invalid Alt. Items Sales Analysis Level
Tax Code Price Prompts
Products missing Descriptions Target Factor
Recalculate Average Costs Change Bin 1 code - Change Bin codes
Category 2 and 3 Status Code
Mark-up Codes Text Flags
Date Main Supplier

Talk to us about these or any other specific requirements and the following notes.

8SCL04S Product Re-coding.
8SCL05AC - Averge Cost: Re-calculate Average Cost from Purchase records - Option to update "Aged" cost
8SCL05AL - Amalgamate Aliases: Add the Stock DEMAND from an Alias to its "Master". Re-code the SCT records to the MASTER code
8SCL05FR - Identify "problem" items for stocktake. Report and set the "Fixup-Rate" for items with a high ratio of stock adjustments. Assign each product a "behaviour" level (scm-fixup-rate): How many Qty Adjustment plus Stocktake Variance records are present per 100 Purchase records.
8SCL05H1 - Reports on active items with no Stocktake transaction since a specified date.
8SCL05OH - On Hand: Re-calculate On Hand from SCT/SCP. Takes On Hand from the first transaction after the "start" date and re-calculates On Hand based on all the subsequent transactions. Option to update only if "Z" found.
8SCL05OS - Old Stock: Calculate the Aged Qty and cost for items where current "on hand" includes "old" purchases.
8SCL05ST - As for OH, but takes the SCXI On Hand as the opening Stock figure - For re-calculating "on hand" stock from an "old" SCX and a current SCT. Option to use Category range.

8SCX08 DELETE PRODUCT RECORDS

As with all tool kits this is a very powerful program: BACK UP first. Use it to delete records on the following files (with their Maintenance programs):
SCM (Products - 8SCL09C2),
SCX (Branch Stock - 8SCL12C2, Supplier Products - 8SCL23C1, Extra Text - 8SCL09C2) and
SCT (Transaction - 8SCL19C1),
NOT Special Prices, Suppliers Orders or Invoices (Sales) etc.
Select ranges of Product Codes, Categories and SCM Status codes (probably "Z" in this case).
Select Branches, SCX Status Code, SCX Record types (Branch, Supp. Product and / or Text or all - and one, several or all Transaction Types.
Y to Delete from: SCM: SCX: SCT: Cancel SCM only (doesn't delete SCX/SCT recs) or Delete.

SCX08


This e.g will delete all records within the range with a "Z" status.

Enter Y to run or N to ESC - a record is displayed on screen.
    NOTES
  1. SCX records with Stock will NOT be deleted - they must be zeroed first.
  2. To delete SCM records you must also delete ALL the corresponding SCX and SCT records.
  3. SCX and SCT records can be deleted independently.
  4. SCT record deletion is based on SCX

8SCL80 CLEAR STOCK TRANSACTIONS

For a variety of reasons your Stock Files can become inaccurate and certain transaction fields may need to be cleared and re-calculated with other programs. N.B. Discuss with us FIRST. Back up FIRST. These programs can be scheduled to run overnight.

SCL80A

On Hand, Customer Order, Issues, Returns,
Received, Purchase Order, Requisition, Shipped,
Sales, Purchases (Sales/Purchases Qtys / Values MTD, YTD and date),
Demand, Adjustments, Opening, Stocktake (date), Old Stock (some systems only)
NOT applicable: Allocated, C/O fwd., New Receipts, S/O fwd.

8SCP08C- AGED STOCK - WRITEDOWNS

For writing down old stock. A report is printed.

Accept or change Valuation date.
and "Current" Period (e.g. 12 months before the valuation date)

SCP08

Defaults can be set in controls - accept or change.

SCP08A

To include / exclude various details
and either print or Export to the designated csv file.

SCP08B


8SCL06 ARCHIVE STOCK TRANSACTIONS

Archive old transactions periodically to keep your files from getting too big. This saves backup time and disk space. You may want to do this every month or so depending on the size of your files and how often you look up past transactions. You have the choice of deleting the records or archiving them. Your archiving procedure should be set-up to name your newest archive file "ccSCT01" where "cc" is your company code, check with us first.

SCL06

Make your selections, "Y" and Enter.
Esc when finished - results are displayed. The files then need to be rebuilt.

8SCL18C1 WORK FILE MAINTENANCE

Accept file name eg. ccSCWC2 (where "cc" is your company name, and "WC2" is the current work file belonging to "C2" logon). Or change to a different work file eg. ccSCWC4 OR change to ccSCS which is the Supplier Orders Costing File. These are temporary files which are deleted once the transactions are updated.

8SCL19C1 TRANSACTION FILE MAINTENANCE

Allows changes to the Transaction file records. N.B. these programs should only be used to change dates or spelling etc. See notes on Maintenance.

8SCL28C2 SCREEN 1 - LAYOUTREPORT MAINTENANCE
Also see general information on adding and changing reports. Most of these fields can be changed when reports are run.
8SCL28C2 SCREEN 2 - SUBJECTREPORT MAINTENANCE
Is mainly associated with SCM or Product Master File: static information describing product/item.

Key in or pluck the Subject No.
You may use your own descriptions. Select ONLY the subjects required;
only those subjects will then appear when a report is run using this format.
Product - see further selections below.
Category - see further selections below.
Branch:
Supplier
Sales Code
Status "Group" status e.g. from ST to space. See more below.
Bin See more below.
Category 2
Category 3
Disc Code / S/A Level
Short Description
PLU no.
Label Codes
Buying groups:

Up to 3 "subjects" can be used for sorting stock reports e.g. Product by Category by Status.
Although Branch MUST be included it can be set to hierarchy 4 so that it will not "sort" by.
Other subjects can be set to hierarchy zero so that they can be used for selection criteria but not for sorting (hierarchy) purposes.

SCL28A

Up to 3 "subjects" can be used for sorting stock reports e.g. Product by Category by Status.
Although Branch MUST be included it can be set to hierarchy 4 so that it will not "sort" by.
Other subjects can be set to hierarchy zero so that they can be used for selection criteria but not for sorting (hierarchy) purposes.

8SCL28C2 SCREEN 3 - CONDITIONSREPORT MAINTENANCE
Is mainly associated with SCX or Stock File - Branch W/house info describing how many, where, how much.
Key in the Subject No. or use the arrows and Enter to select.
Key in your own description ONLY for the subjects required for this report.
Only these subjects will appear when a report is run using this format.

SCL28B

SCL28C

SCL28D

Key in the "conditions" e.g. D and V that will most frequently be used for this report.
These fields are variable: i.e. you have the opportunity of changing them when running the report.

  1. Summary / Details, Quantities / Values (3 fields).
    1. Summary: gives totals only
      Details: lists each Product
    2. Quantities
      Values
      Space or Both Quantities and Values
    3. Detail line Number to include (for 8SCP02C1 and 8SCP02F5 only).
Line 1: Description:
Product Code     Cat. c2   c3   S/A  Supp.   St. Description
Line 2: Codes:
             Short Desc. Units           Cl Dsc Tx Sl          PLU    Alt Unit/Price/Qty,    Labels
Line 3: Prices, Costs:
  COSTS:   Std.   Last    Avg.  Use PRICES: 1    2     3    4    5   Sp   Per    Date   Outer M/up
Line 4: Alternates:
             Alternate 1     Alternate 2     Replaces        Replaced by
Line 5: Misc:
   Disc. Breaks:  Method/Basis, .... Qty/Factor (3).... Frgt %,  Weight, Volume,   L   x  W   x   H

  1. Transaction Date Range, Transaction Types (3 fields)
    1. From Date
    2. To Date
    3. Transaction Types:

      Key Transaction Type Key Transaction Type
      space No transactions (default) * All transactions
      B Customer Order O Supplier Order
      C Credit P Purchase
      D Demand (lost sale) Q Quantity Adjustment
      I Production Issue S Sale
      M Transfer (inter-branch) V Stocktake Adjustment
      N Production 1:1 transfer Z Replace On-hand with entered qty.

    4. Ageing code (only for Special Ageing).
      e.g. 01/04/1998 31/03/1999 P S (all Purchases and Sales within this period)

  2. Above / Below a given Gross Profit / Margin (3 fields)

      Field Key Description
      i. A Above G.P.
      B or space Below G.P. (default)
      H Higher Mark up
      L Lower Mark up
      ii. value G.P. / Mark up % (value)
      iii. P GP / Mark up based on Price / Cost figures
      S or space GP / Mark up based on Sales data

      e.g. B 25 P (below 25% G.P. based on sell / cost price)

  3. Inactive / Price Change / G.P. range / Stocktake etc. (3 fields)
    1. Selection

      Key Description
      B Items changed / added within period.
      C Prices changed in period.
      F Factor range: Stock-turn x GP%
      G GP range
      O Old: no sale in period
      P Performance range: Factor (Stock-turn x GP%) by years' supply
      i.e. how well items perform compared to amount of stock carried.
      S No Stocktake in period
      T stock-Turn range: Value-a to Value-b


    2. Selection (e.g. Price will display) changed in last e.g. 6 (Months) or: Days, Weeks, Years. Negate above .e. NOT changed within the (e.g. 6 months) period.
    3. From (and if relevant, To) Factor OR Number (e.g. date or number of months)
    4. N - turns selector off.

      e.g. T, 1, 4 (turn over between 1 and 4 times a year)
      e.g. F, 0, .8 (GP. / annum 0 - 80% - low performer, poor return on investment)
      e.g. F, 1, 2.0 (GP. / annum 100 - 200% - high performer)

  4. Price and Cost to use (6 fields)

      Field Key Description
      i. (a) Price Code 1 - 9 from stock file
      ii. (b) Cost Code 1 - 9 from stock file
      iii. <
      >
      0
      (a) is less than (b)
      (a) is more than (b)
      (a) or (b) is zero
      iv. B only items which have Bottom-line set
      v. C
      O
      ~
      Current
      Old
      or Both values
      vi. Number Stockholding cost factor
      e.g. add 2.5% for cost of stockholding


  5. Qty / value-based selections - 1 (Basis of Selection 7) (5 fields)

    Applied to a quantity based on the setting of the "based-on" indicator.

    1. Subject 1 - Condition Applied to:

      Key Description Key Description
      H on-Hand (default) O re-Order to maximum - recent usage
      A Available P only up to re-order Point
      even when max. stock present
      C Customer order Q re-order - usage-based Quantity
      under / over stocked
      D 12mth Demand R Re-order level
      E rEceived S Supplier order
      F Free U dUe
      I Issued X maXimum stock
      M Month demand Y Ytd demand
          1-8 Price / cost codes


    2. Condition Comparitor (If):

      Key Description
      N or space Not equal to (default)
      A all items on SCX (i.e. have a Transaction)
      * all items on SCM, includes non-stock items
      = Equal to
      < Less than
      > Greater than
      - Less than or Equal to
      + Greater than or Equal to
      R In range (using Values below)
      X Outside range (using Values below)


    3. Same set as field (i).
    4. Value to compare against OR
    5. A range; i.e. if this field is used, field 4 becomes the "From" value and this field the "To" value.

      Examples of Selector 6: In the following a "~" represents a space in that particular field.

      Key Description
      H, >,~ Select if On Hand is greater than 0 (default).
      ~, A,~ All products on SCX.
      ~, * ,~ All items on SCM (includes non-stock items)
      A, =, 0 Zero Available stock
      H, < 0 On-hand is negative
      H, >, 5 more than 5 On-hand
      1, <, 6 Sell Price is less than Cost Price
      F, =, ~ 5.0, 50.0 Free Stock between 5 and 50
      P, >, A Re-order Point (even if Max. Stock present)
      is more than available.
      A, =, ~, 10, 20 Available stock between 10 and 20
      S, =, ~, 5, 20 Supplier Order is between 5 and 20
      A, <, R Available is less than Re-order level
      H,+, 0 On hand is equal to or more than zero


  6. Qty / value-based selections - 2 (5 fields)
    As for set 6 above - applied only if set 6 conditions met.

  7. Short-term Usage - Re-order controls 1 (5 fields)

      Field Key Description
      i. No. of month's "recent" usage
      ii. No. Weighting factor for recent usage - Forecast
      Weight Factor default 0
      iii. No. Max months' stock to be held
      Defaults to product's max
      iv. Y to include Month to Date
      v. Y
      0
      to update SCX re-order level
      only if currently zero


  8. Long-term Usage - Re-order controls 2 (5 fields)

      Field Key Description
      i. No. of month's "long-term" usage
      ii. No. Divisor for required stock level
      iii. W Divisor represents Weeks' usage
      iv P Print only items to be re-ordered

      R

      Print items to re-order OR already ordered.
      v. A Available
      F Free (default)


  9. Price Book Code, Customer Price variables (8 fields)
    Print items with no price / re-order qty, stock etc.

      Field Key Description
      i. No. Price No
      ii. No. Discount Code
      iii. Cust. Code for Personalised list / export
      iv. No

      markup rate

      v. Code Price book code - optional
      vi. P Print Alternate Units
      O

      Only alternate units

      vii. R Round Alternate Units
      viii. ~ Space to print all
      P Print priced items only
      Y Print priced and un-priced items
      Z Print un-priced items only

  10. Report Code (1 field)
    1. Up to 4 Report code(s)

    Top of this page.

8SCL28C1 SCREEN 1TRANSACTION REPORT MAINTENANCE
See Report Maintenance for general information on adding and changing reports.
8SCL28C1 SCREEN 2TRANSACTION REPORT MAINTENANCE
In the Subject column, key in ONLY the subjects required;
only these subjects will then appear when a report is run using this format.

SCL28C1


Reference -
Trans. Type - to sort by Transaction Type
Trans. Branch
8SCL28C1 SCREEN 3TRANSACTION REPORT MAINTENANCE
Key in the conditions (e.g. D for Detail) that will most frequently be used for this report.
These fields are variable, i.e. you have the opportunity of changing them when running the report.
  1. Prompt: e.g. Detail
    Summary or Details
    Update dates: 01/04/2006 to 31/03/2007

  2. Prompt: e.g. Purchases
    Up to 10 Trans. types: e.g. P

  3. Prompt e.g. Sell
8SCL29C0 1. STOCK SYSTEMCONTROLS

GENERAL. MAINTENANCE PROCESSING. PURCHASES: (8SCL01C2)
8SCL29C0 3. PRODUCT CATEGORIES    SCL29C0CONTROLS
A record for each Category code required.
8SCL29C0 4. SALES CODESCONTROLS
Also see Sales Analysis controls.

8SCL29C0 5. STOCK LOCATIONSCONTROLS
Also see Invoicing Controls

8SCL29C0 6. STATUS CODESCONTROLS
A record for each Status

8SCL29C0 7. TRANSACTION TYPESCONTROLS
A record for each Transaction Type

8SCL29C0 8. PRICE PROMPTSCONTROLS

8SCL29C0 9. CATEGORY 2 (SUB-GROUPS)CONTROLS
A record for each Category 2 required.
See Product Category for more.
8SCL29C0 10. CATEGORY 3 (SUB-GROUPS)CONTROLS
A record for each Category 3 required.
See Product Category for more.
8SCL29C0 11. MARKUP FORMULAECONTROLS
Generate Price # from price # adjust by $ factor Round to
5 8 .00 1.1600 0
4 5 .00 1.0600 0
3 4 .00 1.0600 0
1 8 .00 1.4500 0
0 0 .00 0.0000 0
0 0 .00 0.0000 0

Price #: Selling prices 1 to 5 OR 99: a Set price
Product costs: (SCM) 6: Avg 7: Latest 8: Std
Stock costs: (SCX) 16: Avg 17: Latest 18: Aged 19: Rebated
"Adjust by" is added to the "using" price before the factor is applied
"Factor": For 12.5% increase enter 1.125, decrease = .875
"using price 99" will set price to "adjust by" - use 0 to clear.

8SCL29C0 12. PRICE BOOK HEADERSCONTROLS
8SCL29C0 13. WRITEDOWN CONTROLSCONTROLS
Defaults for stock writedowns 8SCP08C2 and ?8SCP25
8SCL29C0 14. IMPORT TEMPLATESCONTROLS
Import Templates for Cognosco. SCIT
Used to reformat the layout of a supplier's stock list sent to you as data (.xls or .csv) e.g. a Price List, so that you can translate his data for importing into Cogito.
8SCL29C0 17. CUSTOMER CATELOGUECONTROLS

8SCL29C0 18. ARCHIVING CONTROLSCONTROLS
Two records - an empty branch record and a blank Archive record.
8SCL29C0 19. BAR CODESSCONTROLS
8SCL29C0 20. SALES KITSCONTROLS
8SCL29C0 21. SIZE RANGE CODESCONTROLS