Inventory Item Maintenance

Maintaining a list of items used in calculating cost of sales.  Each item definition is comprised of a unique number, a description, a count unit description, a cost per count unit, a key item flag and a variance on/off flag.
PLU Assignment Maintenance

Maintaining a list of PLUs assigned to each inventory item.  Each inventory item will have a list of PLUs assigned to it and a quantity to use each time it is sold.
Purchases

Maintaining a list of unposted purchases.  Each purchase will consist of an inventory item and a quantity recieved.

Purchases will be posted upon user action to a YYMMDD.PRC file of the user’s choice.  These counts can be modified at any time by entering new counts and reposting to the incorrect day.
Transfers

Maintaining a list of unposted transfers.  Each transfer will consist of an inventory item and a quantity recieved.

Transfers will be posted upon user action to a YYMMDD.TNF file of the user’s choice.  These counts can be modified at any time by entering new counts and reposting to the incorrect day.
Waste Counts

Maintaining a list of unposted waste counts.  Each waste count will consist of an inventory item and a quantity wasted.

Waste counts will be posted upon user action to a YYMMDD.WST file of the user’s choice.  These counts can be modified at any time by entering new counts and reposting to the incorrect day.
Ending Counts

Enter ending counts for all items currently defined in item database.

Ending counts will be posted upon user action to a YYMMDD.CNT file of the user’s choice.  These counts can be modified at any time by entering new counts and reposting to the incorrect day.
File Formats

Name: LOCATION.DAT
Purpose: Storage of defined locations.
Location: INVDATA subdirectory of application
Type: Binary
Size: 1600
Record size: 16
      Description    STRING * 16

Name: INVITEMS.DAT
Purpose: Storage of defined inventory items information.
Location: INVDATA subdirectory of application
Type: Binary
Size: Variable dependent on number of records
Record size: 64
     
Number 2 bytes INTEGER 1 –  2
Description 16 bytes STRING 3 – 18
Count Unit 12 bytes STRING 19 – 30
Location 2 bytes INTEGER 31 – 32
Cost 4 bytes LONG 33 – 36
Purchase Count 4 bytes LONG 37 – 40
Waste Count 4 bytes LONG 41 – 44
Ending Count 4 bytes LONG 45 – 48
Transfer Count 4 bytes LONG 49 – 52
Key Item Flag 1 byte  BYTE 53
Theoretical Flag 1 byte  BYTE 54
UsedFlag 2 bytes INTEGER 55 – 56
Extra1 4 bytes LONG 57 – 60
Extra2 4 bytes LONG 61 – 64

NOTE: UsedFlag will indicate if item has been used for a purchase or a count.  If UsedFlag is > 0 and the user tries to delete the item FF_INV will warn that the deletion of that item will ruin any historical reports.

Key Item Flag will be used for masking the lists of inventory items used when entering counts.  Also will be used for reporting on key items only.

Theoretical Flag will indicate whether theoretical usage will be computed for the item.

Name: YYMMDD.CNT
Purpose: Permanent storage of ending counts
Location: INV subdirectory of application
Type: Binary
Size: Variable dependent on number of records
Record size: 6
        Item Number            INTEGER
        Count                  LONG

Name: YYMMDD.PRC
Purpose: Permanent storage of purchases
Location : INV subdirectory of application
Type: Binary
Size: Variable dependent on number of records
Record size: 6
        Item Number            INTEGER
        Count                  LONG

Name: YYMMDD.TNF
Purpose: Permanent storage of purchases
Location : INV subdirectory of application
Type: Binary
Size: Variable dependent on number of records
Record size: 6
        Item Number            INTEGER
        Count                  LONG

Name: YYMMDD.WST
Purpose: Permanent storage of waste counts
Location : INV subdirectory of application
Type: Binary
Size: Variable dependent on number of records
Record size: 6
        Item Number            INTEGER
        Count                  LONG

Name: #####.RCP  (where ##### is the number of an Inventory Item)
Location: INVRECIPE subdirectory of application
Purpose: storage of PLU assignments and corresponding usage quantities
Size: variable dependent on number of records
Type: Binary
Record size: 6
Record fields:
        Item Number    – 2 bytes (INTEGER)
        Quantity        – 4 bytes (LONG)
Revisions

06/17/96  Beta Version 1!02

  1. Fixed bug related to inventory numbers.  Was storing internally as an SHORT integer, this means that an inventory item number can never be greater that 32,767.  Fixed by shrinking the number field on the dialog EDITITEM to 4 digits rather than allowing 5 digits.  This approach was taken rather than changing the number to a LONG integer, because of the ease.
  2. Added display of version on bottom of screen.
  3. Renamed the program Q.S.R. Inventory

06/18/96  Beta Version 1!03

  1. Added more on-line help.
  2. Added HASP copy protection. (Program #10)

07/23/96  Version 1.04

  1. Take item cost to 4 decimal places instead of 2
  2. Add dollar totals of other categories to report along with Variance $

08/25/96  Version 2.00

  1. Version 5 compatible.  Pull down menus, new report viewer, etc….

08/27/96  Version 2.01

  1. Fixed bug related to running transfers and waste reports.  Was only running a purchases report.
  2. Enhanced memory usage by finding more places to erase arrays and only dim when necessary.
  3. Added % figures to variance reports.

12/09/98  Version 6.01

  1. Y2K compliant.

01/05/2000 Version 6.02

  1. Cleaned up some remaining Y2K bugs

02/09/2000 Version 6.03