Here is a list of my most popular modifications I have created for SBT Vision Point series software over the years. I've used my dVERSION product to create and maintain these modifications (also known as parameters). For example, to modify ARREPT.PRG, I would create ARREPT.VER. This file might contain: IF\ .NOT. FIXED IF FILE(m0dbfdr + m0tmpf1 + ".dbf") ERASE (m0dbfdr + m0tmpf1 + ".dbf") ENDIF END\ IF\ FIXED ERASE (m0dbfdr + m0tmpf1 + ".dbf") END\ If translated by dVERSION without specifying the FIXED parameter, the resulting ARREPT.PRG would be identical to the original ARREPT.PRG. ---------------------------------------------------------------------------- ARMAND (AR) (DA 05/10/90) Created the ARMAND module that SBT forgot. The ability to edit invoice detail records. ---------------------------------------------------------------------------- CHGCOST (AR, SO) (Dennis Allen 04/14/89) Normally, when editing an inventory item, changing of the cost is only permitted on non-stock items. Cost for stock items is supposed to be changed at the time inventory receipts are made. This modification permits changing cost on an inventory screen, an invoice screen, or a sales order screen. ---------------------------------------------------------------------------- CI_HIST (AR, SO, SM) (Dennis Allen 01/18/94) This parameter adds two indices to AR/SO transaction files. When invoice or sales order details are entered, the most recent cost for that customer/item is displayed. These indices also allow customer inquiry of items and item inquiry of customers. ---------------------------------------------------------------------------- CUST_FOB (AR, SO) (Dennis Allen 08/01/90) This parameter adds a ship via and fob fields to the customer file. These fields are then used as defaults for sales order and invoices. ---------------------------------------------------------------------------- CUST_NAME (AR, SO, MA, PO, AP) (Dennis Allen 07/09/90) This parameter provides a lookup of the customer file by company name. ---------------------------------------------------------------------------- DESCRIP (AR, PO, SO) (Dennis Allen 05/02/89) This parameter provides a lookup of the inventory file by description. This parameter was modeled after the customer phone number index. ---------------------------------------------------------------------------- DESCRIP2 (AR, SO, PO) (Dennis Allen 09/26/90) This parameter modifies the inventory file to provide a second description field. This field will be used to produce invoices, sales orders and purchase orders. Note: Unlike the inventory description field, this second field is not stored or moved within transaction records. ---------------------------------------------------------------------------- FIXED These are bug fixes, or corrections of poor implementation, or selected Foxbase/FoxPro enhancements. A couple of examples: ?????? (DA 02/05/97) Replace GETENV() with f0GETENV(), which uses FOXPRO.INI file. To p0errors calls, add MESSAGE(1), SYS(16). ??PCLS (DA 08/22/94) Delete comments only when header doesn't exist in ??mast and ??ymst. ??POST (DA 08/09/94) Before prompting for a manual invoice number, this fix will look up the next unused number. Any invoice/sales order/purchase order number lookup of master file will also lookup history file. If user specifies blank number, allow user to cancel posting. SYSDFBR (DA 09/05/94) Added PRIVATE to memory variables. Added [Ctrl]-[J] to toggle on/off the JKEY incremental search. SYSFLAG (DA 01/05/93) Rebuild sysdatx.cdx. Prompt user to remove temp files. Add code to avoid sharing violations. SYSMULT (DA 10/29/88) p0errors Replace with improved procedure. For suspend, call p0extdb. Log errors to foxerr.dbf, similar to Pro Series. Quit to main menu. p0flockd, p0flockn, p0rlockd, p0rlockn Display wait window (SCHEME 7), test lock & loop or until user presses [esc]. Don't depend on m0color to perform a p0clrprn. f0opnfl Call p0dw4fix to repair record count. p0dsprp Customize SYSMENU to allow Find/Goto Line. Add CLOSE to window. Allow _WINDOWS to execute code. Add following procedures to sysmult.prg: f0getenv()- Retrieves environment variable from foxpro.ini p0dw4fix - Repair database record count p0eject - Perform a printer eject p0jkey - Allows JKEY enable/disable ---------------------------------------------------------------------------- FLMN (AP, AR, PO, SO, SM) (Dennis Allen 03/23/95) In SBT, passwords can be set to allow 'file maintenance'. When current password has file maintenance set to 'N', any attempt at file maintenance will prompt the user for another password. This parameter allows the user into file maintenance editors. Any attempt to add/edit/delete/recall records, however, will prompt the user for password. ---------------------------------------------------------------------------- GLSUB (GL) (Dennis Allen 04/11/89) This parameter adds a subtotal description field to the account type file. When this field is defined (not blank), a subtotal of all previous account types are printed on financial statements. When defined as 'RESET', the subtotals are reset (not printed). ---------------------------------------------------------------------------- GLSUB2 (GL) (Dennis Allen 01/27/92) Same as parameter GLSUB. Adds a second subtotal description field to the account type file. When this field is defined (not blank), a subtotal of all previous account types are printed on financial statements. When defined as 'RESET', the subtotals are reset (not printed). ---------------------------------------------------------------------------- ITEM_XREF (AR, PO, SO) (Dennis Allen 04/24/89) This parameter adds an item cross reference file. Similar to the suppliers file, the cross reference file allows the user to specify alternate item codes when searching for an item record. ---------------------------------------------------------------------------- ITEM_XREF2 (AR, SO, PO) (Dennis Allen 05/07/89) This parameter will store and display the item cross reference number for invoices, sales orders, and purchase orders. ITEM_XREF is required. ---------------------------------------------------------------------------- LEAVE_SHIP (SO) (Dennis Allen 05/12/90) If the user typically charges shipping on both original shipments and back order shipments, it is inconvenient to have to edit the order to add the special "SHIP" item back into the order. This feature causes the "SHIP" line item to hang around if the order is not completely shipped. Note: This parameter also allows a shipper to be copied into AR, even if the extended price is zero. ---------------------------------------------------------------------------- PATCH These are bug fixes, or corrections of poor implementation, or selected Foxbase/FoxPro enhancements. They are not under the FIXED parameter because each is still experimental. For example: ??MAND (DA 08/29/93) This patch adds a 'Move' command. The user can physically move any selected detail record. The destination must be BEFORE another selected record. ??POSD ??POSE ??MAND (DA 05/12/94) For AR/SO, place a negative amount in discount. Discount will be computed using specified unit price divided by original unit price. APACHK APCREA APPCH1 APPCHK AP_UP (DA 05/22/96) PO_UP SYSMULT SYSVADD SYSVDSP SYSVEND SYSVSRN A field called ref C(33) will be added and maintained in APVENDnn.DBF. Stubs can then print the variable mxpref. SYSLIST (DA, 08/01/90) This patch allows SYSLIST to accept wildcards. For example: ..NUTS.. will create: SET FILTER TO 'NUTS' $ m0field ..NUTS will create: SET FILTER TO 'NUTS' = RIGHT(m0field,4) NUTS.. is equivalent to the current SEEK method. SYSMULT (DA, 08/04/94) p0getch -- IF !EMPTY(f0GETENV('SYSLIST')), do syslist.prg. ---------------------------------------------------------------------------- SALES_COM (AR, SO) (Dennis Allen 10/18/88) This parameter adds a sales commission payable flag to the invoice and sales orders detail records. A sales commission report is generated from all transactions marked as payable. ---------------------------------------------------------------------------- SYSCOM (AR, PO, SO, SM) (Dennis Allen 06/12/93) This parameter allows the user an unlimited number of system comment lines. (non-laser only) ---------------------------------------------------------------------------- TRANS_MEMO (AR, SO) (Dennis Allen 05/11/94) This parameter will store and display a comment memo field for invoice and sales order details. Note: You can use a word processor instead of MODIFY FILE. ---------------------------------------------------------------------------- VEND_FOB (AP, PO) (Dennis Allen 08/01/90) This parameter adds a ship via and fob fields to the vendor file. These fields are then used as defaults for purchase orders. ---------------------------------------------------------------------------- VEND_NAME (AP, PO) (Dennis Allen 07/04/90) This parameter provides a lookup of the vendor file by company name. ---------------------------------------------------------------------------- VPARTNO (AR, SO, PO) (Dennis Allen 05/02/89) This parameter simply increases the length of the supplier part number to 25. If necessary, also increase length of xref field (ITEM_XREF) to 25.