Integrated Business Solutions - Vision Point Enhancements

Home < Vision Point < Kit Inventory Items

Printable Page

Download Page

Kit Inventory Items

Back to index

Description

Documentation

Technical

Description:

If the programs are previously unmodified and the same versions, these new programs may just be copied over. As with all modifications, it is recommended that the ACCPAC versions be checked to assure they are the same. Programs that have been modified are distributed in the same manner as described in the ACCPAC Installation Guide. Programs beginning with "TO", "T0", and "P0" should be treated the same as "SYS" files in ACCPAC, and should be located in the same directory as "SYSDATA.DBF". If there are any databases on the distribution disk that begin with "TO" they should also be located in the system directory. Please refer to the installation instructions. The TOINST program will normally rename and locate programs as required, but some files may need to be moved depending on the individual system configuration.

Program and Form Changes:

The following programs and forms have either been changed or added:

TYPE	FILE NAME	DESCRIPTION
FORMS
	ARINVD.*	Inventory File Listing (Descrp)
	ARINVT.*	Inventory File Listing (Item)
	ICKIRU.*	Component Information
	ICKITD.*	Kit Descriptions
	ICKITM.*	Kit Master Structure
	ICSUBC.*	Kit Sub Components
	ICSUBS.*	Kit Sub Components
MENUS
	ARMAIN.MPR	AR Main Menu
	SOMAIN.MPR	Sales Main Menu
PROGRAMS
	ARCREA.PRG	Set Up File Variables and Delete/Check Data Files
	ARMENU.PRG	Main Menu
	ARPOSD.PRG	Enter Invoice Detail
	ARPOSE.PRG	Revise Current Invoice/Credit Memo
	ARPOST.PRG	Create Invoice
	ARPSTM.PRG	Print Invoice & Credit Memo
	ARPSTMD.PRG	Create/Delete/Check Data Files From Data Dictionary
	BAUPDATE.PRG	Update program for BA
	ICFXPBR.PRG	Foxpro Specific browse window (tobrowe for Foxbase)
	ICKIADD.PRG	Add new kits
	ICKIAL.PRG	Update allocated information on kit building
	ICKICHG.PRG	Change Kit Information during entry
	ICKIMNT.PRG	Kit Maintenance (Main Program)
	ICKIRCC.PRG	Cost Comparison Report
	ICKIRCR.PRG	Component Requirements
	ICKIRQU.PRG	Request for Quote
	ICKIRU.PRG	Update Kits
	ICKISRN.PRG	Kit Screen for Input
	ICKITA.PRG	Assemble Kits
	ICKITBLD.PRG	Build the Kits that have already been setup
	ICKITD.PRG	Detailed Kit Information
	ICKITFND.PRG	Find the Kit by number (search routine)
	ICKITLM.PRG	List Kits
	ICKITP.PRG	Print the Components in a kit
	ICKITS.PRG	Update Kit Information
	ICKITSHP.PRG	Ship Kit Items
	ICKITSU.PRG	Kits
	ICKITU.PRG	Kit Update
	ICKIVU.PRG	View Kit Detail
	ICKIVW.PRG	View Kit breakdown during transaction
	SMCREA.PRG	System Manager Creation Program
	SMDTBL.PRG	System Manager Key Fields Update
	SMKPMN.PRG	Program to set up the keys for processing
	SMKPOC.PRG	Processes the key changes
	SOCREA.PRG	Set Up Files Varibles and Create/Delete/Check Data Files
	SOMAND.PRG	Edit SO Detail Lines
	SOMANT.PRG	Edit SO Detail
	SOMENU.PRG	Main Menu
	SOPOSD.PRG	Enter SO Detail
	SOPOSE.PRG	Revise Current SO
	SOPOST.PRG	Create Sales Order
	SOPSTM.PRG	Sales Order Header Printing
	SOPSTMD.PRG	Print detail of sales orders
	SOSHPE.PRG	Enter Shipment Detail
	SOSHPP.PRG	Shipment processing with kits
	SYSBCAL.PRG	Recalculate File Balances
	SYSISRN.PRG	Inventory Maintenance Screen
	T0CHKL.PRG	Check kit items for inclusion on form
	T0LSTL.PRG	List Line item detailed breakdown
	T0SWCLR.PRG	Switch Color Function
	TOBOX.PRG	Draws a Box on the Screen
	TOCRE1.PRG	Create Databases for a module
	TOCREA.PRG	Create/Delete/Check Data Files From Data Dictionary
	TODBCK.PRG	Build/Update Fields for Database Files
	TOFLOC.PRG	Locate Directory Placement of Files
	TOFPOP.PRG	Picking list that pops up
	TOHEAD.PRG	Screen Heading
	TOINST.PRG	Install Dictionary
	TOLIST.PRG	List and Select Based on Data Dictionary
	TOMNB9.PRG	Custom Bar Menu
	TOMNU9.PRG	Custom Popup Menu
	TOSMKP.PRG	Sets up the key field databases with dictionaries
	TOTGPK.PRG	Tag Selection

Database Changes

ARKITMnn.DBF

Kit Configuration

Tags:

KITITEM Key: kititem

Name	TYPE	WID	DEC	DESCRIPTION
ASSEMBLER	C	10	0	Department or Employee Responsible for Assembly
BUILD	C	1	0	Build Kits during a sales order or invoice (Y/N)
COMPLETE	C	1	0	Complete Kits Only (or allow variance)
DESLN1	C	35	0	Description Line 1
DESLN2	C	35	0	Description line 2
DESLN3	C	35	0	Description Line 3
DESLN4	C	35	0	Description Line 4
DESLN5	C	35	0	Description Line 5
DESLN6	C	35	0	Description Line 6
DETPRICE	C	1	0	Use the Individual Component Prices
ECONQTY	N	10	2	Economic Quantity to produce in a batch
KITITEM	C	15	0	Item number for the Kit
KITTIME	N	9	2	Time to Assemble One Kit
LISTTYPE	C	1	0	List on Invoice and Orders (Items/Descrip)
PRICTYPE	C	1	0	Price update from components during building
TOTALTM	N	9	2	Time to buy and Assemble (including components)
WIPQTY	N	10	2	Quantity in active work orders

ARKITRnn.DBF

Kit Transaction Detail File

Tags:

ITEM Key: item+kitno

KITNO Key: kitno+component

Name	TYPE	WID	DEC	DESCRIPTION
COMPONENT	C	3	0	Order of listing item in kit
DATERQD	D	8	0	Date required
INVNO	C	8	0	Invoice Number
ITEM	C	15	0	Item Number of component
KITDATE	C	8	0	Date Created
KITDESC	C	35	0	Item Description as part of the kit
KITDISC	N	7	3	Discount as part of the Kit
KITITEM	C	15	0	Kit Item Number
KITNO	C	8	0	Unique number for the order
KITQTY	N	9	0	Kit Quantity sold
OPTIONAL	C	1	0	Item Optional or Mandatory
PRICECOMP	N	12	2	Price of Component as shown on Invoices/Orders
QTY	N	10	2	Quantity included in the order (per kit)
SONO	C	8	0	Sales Order Number
USAGE	C	1	0	Use price for this component

ARKITSnn.DBF

Kit Component Items

Tags:

COMPONENT Key: kititem+component+item

ITEM Key: item+kititem

KITITEM Key: kititem+item

Name	TYPE	WID	DEC	DESCRIPTION
COMPONENT	C	3	0	Order of listing within Kit
ITEM	C	15	0	Item Number
KITDESC	C	35	0	Item Description as part of the kit
KITDISC	N	7	3	Discount as part of the Kit
KITITEM	C	15	0	Item number of the Kit
OPTIONAL	C	1	0	Item Optional or Mandatory
PRICECOMP	N	12	3	Price of Component (temporary information replacedby inventory file during invoicing)
QTY	N	12	3	Quantity of this item included in the kit
USAGE	C	1	0	Use price for this component

ARTRANnn.DBF

Invoice Transaction File

Tags:

Name	TYPE	WID	DEC	DESCRIPTION
KITNO	C	8	0	Kit Number (if applicable)
LINENO	N	4	0	Line Number on the Invoice
PRINTLN	C	1	0	Print Line on Invoice
PRINTPR	C	1	0	Print Price on Invoice

ARYTRNnn.DBF

Year-to-Date Invoice Transaction File

Tags:

Name	TYPE	WID	DEC	DESCRIPTION
KITNO	C	8	0	Kit Number (if applicable)
LINENO	N	4	0	Line Number on the Invoice
PRINTLN	C	1	0	Print Line on Invoice
PRINTPR	C	1	0	Print Price on Invoice

SOTRANnn.DBF

Sales Order Transaction File

Tags:

Name	TYPE	WID	DEC	DESCRIPTION
KITNO	C	8	0	Kit Number (if applicable)
LINENO	N	4	0	Line Number on the Sales Order
PRINTLN	C	1	0	Print Line on Invoice and Sales Order
PRINTPR	C	1	0	Print Price on Invoice and Sales Order

SOYTRNnn.DBF

Year-to-Date Transaction File

Tags:

Name	TYPE	WID	DEC	DESCRIPTION
KITNO	C	8	0	Kit Number (if applicable)
LINENO	N	4	0	Line Number on the Sales Order
PRINTLN	C	1	0	Print Line on Invoice and Sales Order
PRINTPR	C	1	0	Print Price on Invoice and Sales Order

SYSPIKnn.DBF

Browse Assistance Database

Tags:

SEQNO Key: tablid + tagnm + STR(seqno)

TABLID Key: tablid + tagnm + fieldname

Name	TYPE	WID	DEC	DESCRIPTION
FHEADING	C	20	0	Browse field heading
FIELDNAME	C	10	0	Field name to display
PICCLS	C	30	0	Picture Clause for the numeric fields
SEQNO	N	3	0	Sequence number to display browse
TABLID	C	8	0	Database name for the browser
TAGNM	C	8	0	Tag name for the order the file is displayed in
WFONT	C	10	0	Windows Font
WIDTH	N	3	0	Width of field display for Character Fields
WSTYLE	C	10	0	Windows Style for the list

SYSTOMnn.DBF

Extension Menu Selections for Vision Point

Tags:

MODULE Key: module + prgid

SEQ Key: module + STR(seq,3,0) + prgid

Name	TYPE	WID	DEC	DESCRIPTION
COND	L	1	0
MENUID	C	1	0
MODULE	C	2	0
PRGAR	C	40	0
PRGID	C	8	0
REPBOTT	N	5	0
REPDISP	C	1	0
SEQ	N	3	0
TITLE	C	30	0

top