UPDATE LOG OF CAFAMW-PSP ======================== 07 July 2006 Ver 3h.28 1. SALES ORDERS _proforma Invoice Print. Added in a new prompt "Add VAT to Carr. only" 2. QUIT: Added Auto-delete function for those duplicated unwanted records in the Stock file when doing a Daily FIle Maintenance 3. SHIPPING: Shipping & Shortage - Deletes the Parts issue line if Qty is Zero and was an "SH" item 4. STORES: Changed the Tariff code to be optionally unique to Grn or Serial, ie, not generic to the P/no. Controlled by Setting and parameter control, "C/Code Tariff unique to GRN" - set Y or N 5. STORES: Added NSN in Browse Button on Inventory Screen 6. PURCHASE ORDERS: Book in to Stock Re-Process Screen. Added prompt and connect to Stock Header Record Comment field 7. PURCHASE/SALES ORDERS: Book in to Stock, Open Sales Orders - Added new prompt to print Items that could have been delivered following the pop-up screen showing Sales Orders that are open (Form RO_SUMMW) 24 Apr 2006 Ver 3h.27 1. INVENTORY: Changed Stock Check process. If it is the only one set to "Y", then all the other prompts are curtailed, where only the Stock Check process is completed. In addition, acquires data for Rotable items 2. REPORTS : Added new report "Date Stock Checked" - reports by date range of items that have been stock checked - new report form RA_SCHKW added 3. REPORTS: Added new report "Both Alternates & Alias" - reports a combination of Alternate and Alisaes in one file. Form RA_ALTBW added 4. REPORTS: Added new report "All Progress Notes" - reports on all progress notes by date range and Supplier filter. New report form RO_OMEMW added 5. EDIT ISSUES: Added password control to block edits of Sales Ref no in Edit Part Issued. Password(12) now required 6. RFQ - Added prompts to Print Alt No. and Comments, same as Quotes - RQ_QUINW forms changed 7. 3h.27a: Corrected bug in Min Qty computation for Rotables 8. 3h.27b: Corrected bug in RFQ Alt P.no swop over 14 Apr 2006 Version 3h.26 - (AMNDPSP required) 1. PRINT REPORT: added Quote Originated by filter in "Respond by date" report 2. BATCH BOOK: Increase Cert_no to 14 Chars - various screens and reports changed 3. INVENTORY : Changed Price List year "YR" to 4 chars e.g. 0406=April'06 4. ALTERNATE: Added new column to show "INFORMATION" on the part. Controlled by new password line no 36 22 Feb 2006 Version 3h.25 1. Added a complete new section in Process a Sales Order to Auto-Pick a range of Sales Order. Checks for Qty Shortage, allows amendments, issues out the stokc and creates all docs ready fro Invoice. Prints a Picking List - RU_PCKDW 2. Changed Need to Buy List' to ONLY reports on Orders where Contract Review='Y' 28-Dec-05 (Version 3h.24) 1. Added in support for new Avref - does NSN numbers 22-Aug-05 (3h.23d) 1. Added prompt for "Depot" in Min Qty report 17-Aug-05(3h-23c) 1. Added Date Promised into P/Order Print. Sets to null when Order first made. Form changed to say "Contract date" and "Date Promsd" 01-Aug-05 (3h.23b) 1. Added code to acquire Min/Max from previous same depot if entered in "Receiving Depot" in Book into Stock 2 Added in support to prompt for different text clauses for Quotes, RFQ's and Sales Order Confirmations. Needs the letter "Q" in the FPGEPRP.release in Edit of Forms (Various tables) 3. Added new Setting & Parm items to "Prompt highest Issue number when doing a P/Order" 5. Added prompt for "Qty to Print "on Label and "No of Labels" 14-Jul-05 (3h.23a) 1. Beta-test feed back - fault in RFQ - "variable Paymt_trm not found" corrected 2. Added in new Report "Depot Sales". Report form RU_DEPOW added 23-June-05 (3h.23 - needs Amndpsp.exe) 1. Payment Terms - added in to program where Customer Payment Terms can be set individually by a code letter pre-definded in "Set Various Tables". Terms are prompted, Edited and printed on Quotes, Sales Orders and Invoice. Translates (if rules are set) to calculate and print on Invoices an actual payment due date for the Invoice 2. Added [DBF] Output for Min Qty Print Report 3. Increase PPQ to 5 Chars - Screens prompts changed as required. Internal programming altered to handle increase 4. Book in to stock - added prompt and entry for "Incoming Supplier GRN". Is printed out during print of Certs & labels. Report forms RP_BATCW.FRX, RP_BOOKW.FRX changed to support this new field 5. Transfer of stock to different depot now prints origin/destination Bin Locations (var: d_order/binloc) 31-May-05 (3h.22) 1. Added in Support for EURo prices in Inventory Control Screen. Button %Profit enhanced 2. Added logic to display "Sell core P/no" message in SO's and Quotes (same as when doing Invoices - is triggered if Core Support is turned on in Setting & Parameters) 3 Accept Return: Added Prompt to create /or not create an accompanying Sales Order : Added Option to print Q-Note - new form RX_QNOTW added : Added PO 4 line comment Box if PO applicable + PO message selection 4. Added Fusages.Comment into FSTKCRD to show in History. Form changed RA_CARDW. Needs 3h22.zip (contains new.FSTKCRD.DBF) 17-May-05 (3h.21)AMNDPSP.EXE needed 1. Added prompt for "ISSUE NUMBER" in load/Maintain Stock file screen 2. Added PO Acknowldeged date (internal and appears in DBF prints) 3. Added Browse Search for Supplier when chasing an overdue PO 4. Added support to print different forms as substitute for PO's, SO's, Invoices RFQ's, Quotes, Certs, Delivery Notes (useful for different languages) 18-APR-05 (3h-20) 1. Added new sub-menu to print by Demand order - form RU_DORDW issued 05-FEB-05 (3h.19b) 1. Added push button to either Zero out or Edit Fault Counter 15-JAN-05 (3h.19) 1. Added S&P switch to "Display Price Break Currency message" 2. Added Re-Print of Non-Conformance Report Report File RV_FAU2W 3. Added Print Reports on Faults on Supplier Report File RV_SUFAW 01-JAN-05 (3h.18) 1. Adding to Quote now displays last line 2. Added support in Browse to sort on Depot first (does a scatter/gather) 3. Depot Highlighted next to GRN 4. Also prompt for ISS no. duirng Rotable Book-into Stock 01-DEC-04 (3h.17) 1. Delivery Note D_ORDER now holds the old Bin Loc for print on Packing Note RU_DELVW 2. New setting & parm to handle special Barcode Label for Prism Doc Imaging (Adams Av) Print Sales Order, Invoice, Book-into-Stock 3. Added NSN prompt in P/no creation 4. Added Alt Pno in Open Sales Order print to DBF 5. Added new menu in Receipt History for O/S transfers uses RP_BATCW 10-Nov-04 (3h.16 AMNDPSP reqd) 1. Added ISS no. in Suggested Stock Alloc and Need to buy list RM_PARTW, RM_PRTLW, RM_CMPLW frx files changed FSALNED.DBF file altered 2. Added in trap for matching ISS no. in Process a Sales Order 31-Oct-04 (3h.15b AMNDPSP reqd) 1. Fix Min / Max Qty to each individual Depot 2. Add Listing for Sales and Purchase Order combined on one screen 3. Change of word from “Tariff” to “Customs Code" 4. Add prompt for "Issue Number" to each Part Number in all screens & prompts 5. Viewing all RFQs on Suppliers on one Part Number 6. Mask Out Buy price on Book-in to stock screen 7. Prevent duplication of Customers Purchase Order 8. Usage analysis Add prompt for Depot 9. Add in control for Purchase Order Last Amended date 10. Add in Quote validation period 11. Added Password control for Edit of Amended On date 12(c) Prompts a Continue Y/N to allow duplcation of Customers Purchase Orders (7-above) 03-Oct-04 (3h.14) 1. Added prompt price when adding a line in Re-scheduling Delivery 2. Added Print Button in interactive Ordering - RO_INTOW.FRX 15-Sep-04 (3h.13) 1. Added new Button in Edit Purchase Orders to Re-schedule Deliveries with option to create new Purchase Order line with split Qty's 2. Blocked issue of Parts if Bin Loc= "Q" for those Users using Fault Tracking system 3. Re-calculates Qty in Stock to treat items with Bin Loc="Q" as "Quarantine" again only for those Users where Fault Tracking System is turned on 01-Sep-04 (3h.12) 1. Total Valuation also prints Core value in stock and at repairs RA_VALNW 2. New CAFAM User can be profiled to have exact same rights as a previous User - easier in setting up Users 02-Aug-04 (3h.11) 1. Book in to Stock - now re-prompts for "Required For" so that Labels and GRN book shows this accordingly 05-Jul-04 (3h.10 Needs Amndpsp) 1. New program added to track supplier faults. Changes to supplier screen to display lines delivered and faults. Prompts in Goods Book-in to enter fault details against look-up table. Changes in Utilities Menu to support new data tables. (Triggered if BinLoc="Q") Fault number is auto-generated, prints-out fault report, and links to header screen to writ back new bin location 15 May 05 3h.09 1. Corrected fault in Rotable re-value process 13 May 04 3h.08 1. Changed Inventory Screen to show "New" rotables instead of "O/H". Looks for condition="NE" or "NS" 08 Apr 04 3h.07 (needs AMNDPSP) 1. Added Search on Sales Person in "Open Sales Order" report rm_custw.frx changed 2. Added link to allow different Ship-to address during Invoice Print. Drop down table to Cust name & address file 28-Mar-04 3h.06 1. Performance reports - Added Push buttons to search file on Invoiced or Contract date 11-Mar-04 3h.05 1. Return for Credit-tightened write to Sales Order file to prevent duplicates 2. Fixed "Con_qty" write during "Shipping & Shortage" and "Return for Credit" 3. Added Caution pop-up box in Auto-Picking Invoice Conversion to trap zero priced items 12-Dec-2003 3h.04 1. Added Custom Label print in Auto-Pick & Issue Menu to handle specialised labels (support for SpecTech connect to PICKMEWW.EXE) 2. Trapped and stop return more than Qty=99,999 (causes numeric o/flow) 3. Added new Push Button in Auto Pick to convert SHipped (picked items) direct to INvoice. (Optional connect-to PICKME2W.EXE) 27-Nov-2003 3h.03 (need AMNDPSP) 1. Added prompt for CONDition in Interactive Ordering 06-Nov-2003 3h.02 1. Complete new Section added in Purchase Orders - Interactive Ordering. Process to use Min Qty Report in Browse screen and create PO based on Usage 28-Oct-2003 3h.01 Amendments 1. Changed title "Approved" to "Contrlld" in Supplier Add/Edit screen 2. Re-located Alternate P/No Pop-up screen to make main screen fully visible 3. Added two push-buttons 'Show/Don't show Costs" in Parts sold by Customer report 4. Added two push-buttons 'Show/Don't show Supplier" in Open Sales Order report 5. Qty in Stock and on Order now displayed in Sales Order creation pop-up box 6. Removed default "APP/CT" in Book in to Stock Screen - now just blank 7. Added "Contract Date" prompt in Sales Order creation 8. Conversion of Quote to SO checks Credit Limit 9. Added drop-down screen to select items to print on "Re-Print" P/Orders Forms: run_reg0w.frx, ru_cus0w.frx 20-Oct-2003 (3h.00) Version Change 1. New Version released with password security to cover different levels of access 11-Aug-2003 3g.21 1.Chase Overdue now has selection for P/Order Type (PURC, REPR, EXCH etc) 2.Corrected GRN write for Rotables in "Shipping & Shortages" 3.Delivery Notes Issues now also connects to close Supplier Exchange items 22-Jul-2003 3g.20 (Major change - needs AMNDPSP.EXE)) 1. Concept of Depot introduced to handle stock at a different physical location - Prompts and tracks in inventory Control Screen incl History - Prompts to accept during Book-in to stock different location - New Section to transfer stock between Depots - Creates Delivery/Receipt History when transferring Stock between Depot - Login User on Depot is tagged to the Depot and generates own Header Address for outgoing Forms (e.g. Delivery notes, Invoices etc) - Blocks parts issues if Login User is not at the depot part is tagged to Forms- RA_CARDW, RR_OUTSW, RC_OUTSW, RP_BOOKW 2. Increase Cure date to 6 digits - supports YYYYMM entry. Modified look-up Table system to support six digits Ver 3g.19 not issued 30 Jun 2003 3g.18 1. Fixed Sales Order VAT Prompt if Country code was v"AT" 2. Quotes listings - added two-digit code selection in Print out 3. Sales Order open report - added filter prompt for one p/no 4. Batch Book print - added prompt to filter Supplier 30 Jun 2003 3g.17 1. Altered End Use Report to include qty in stk - new column added (RP_EUSEW.FRX) 12 Jun 2003 3g.16 1. Added new Browse Push Button on Inventory Control Screen to list one P/no 2. Changed "No Find" in Inventory Screen GRN/Sno to Browse Search within P/No 3. New Sub-menu added in Utilities to change Consum to Rotable & vice-versa 31 May 2003 3g.15 1. Placing Rotable Purchase Orders now displays last highest buy price for p/no 2. Added Contract Review column in "Need to Buy List" 3. Added Product Code Prompt to following Sales Order reports: "Need to Buy List" (RM_PARTW.FRX) "Sales Order Open" by Customer & Country (RM_CUSTW/RM_CNTRW.FRX) "S/Orders Open+Clsed" (RA_CUSTW.FRX) 4. Added Product Code Prompt to following Quotes/Inquiries report: "Sort by Cust/Supp" (RQ_CUSTW.FRX) 05-May-2003 3g.14 1. Added new Parameter "Always sell Rotables as Service Exchange Y/N" 2. Added Parameter "Round-off VAT" Y/N. (N)o will cut-off extra decimals 3. Added Long Description to display during Book-In to Stock 4. Added Memo Notes display (Progress) in Stock History display of PO's & SO's 03-Apr-03 3g.13 1. Tightened Decimal Place allocation (2 or 4) in Invoicing 2. Added Reminder to "sell" core P/No. Settings&Parms has new Question: "Support Core item & search with letter" set the Pre-Fix Part No Letter here or "N" fo No 3. Added Prompt for Country in Sales Order Open report. New file RM_CNTRW.FRX and FSALNED.DBF amended 4. Block Return & Credit if Minqty Flag is ON (same logic as Book-in to Stock) 5. RFQ defaults to blank Prices (was writing in Sell Prices) 6. Added prompt for CODE in Usage Analysis Report 02-Apr-03 3g.12 1. Inquiry Screen by Part Number - changed sort Order to Quote No descending 21-Mar-03 3g.11 1. Supplier address label corrected to print whats on screen 17-Mar-03 3g.10 (Ver change needs AMNDPSP.EXE or AMEMD.PRG) 1. Added pop-up to get 4 Comment Lines in PO's to print per item (RO_ORDRW.FRX changed) 2. P/No changed in ROTABLE Book-in to Stock now retains Old P/No in header for History 3. Stock Memo Notes can now be set individual to GRN/S-No via Settings & Parameters 16-Mar-03 3g.08 1. Added support in Auto-Picking to prioritise Conract Date 10-Mar-03 3g.07 1. Corrected bug in Buy price not printing for Dollar based items in Non-Moving Stck Rpt 13-Jan-2003 3g.06 1. Correced bug in "Issued By" not writing to Stock Header file during book-in to stock 21-Dec-2002 3g.05 1. Amended Stock Header to hold INQUIRD but not created as header (ra_creaw.frx) 2. Changed Part No search prompt to hold entered P/no if ESC was used in Browse table 3. Added Country Code 'look-up' in Print Reports-"Sales by Country Code" 4. Changed Reports-Inventory Control by Supplier for Consum Items in Stock (rc_suppw.frx) 08-Dec-2002 3g.04 1. Added Inventory Screen prompt/Edit for Customs Tariff 02-Nov-2002 3g.03 1. Corrected DBF file output for Items Away on repair report by Owner 13-OCT-2002 3g.02 1. PartBase Export file -added prompt to include Zero or non-zero Qtys' 2. Fixed duplication of PO line in stock header for same P/No on same POs' 3. Tightened Edit to Parts Issued QTY field to match Password permission 4. Print of Invoice/Certs etcs' - suppressed printing items where QTY=0 5. Return POs' now picks up the original PO prices 6. Added to "Auto-Pick/Issue Stock" Button to print 'List' of items issued 16-Aug-2002 3g.01 1. Tightened calc in Exch Rate for Batch Book Edit 2. Nulled Cert Date to re-prompt in "Write to batch Book" 3. Prompt for Add Tax Y/N matched to Country Code 4. Control file option to Auto-Pick against PPQ qty's added 5. Added prompt to also do Labels on already picked and Issued items 6. Added “Late 7 day” push button for Sales Orders matched to PO report 13 Jul 2002 *VERS* 3g.00 1. AMNDPSP for changes in Database Structure 2. Acquires and Browse history Date of PO in Batch book 3. Prompts & displays Cert "Issued By" 4. New field for "Repair Price" added in Rotable Stock Screen 5. Added Prompt for Tax Y/N in S/O's - triggers correct response during Invoicing 6. Added Proforma Inv. print out of a Quote 7. Control item to Make Return Q to be the outgoing Purchase Order No. 08 Jul 2002 *NEW* Vers 3f.17 1. Added the title "EXCH" on Invoices for Exch Sold Items RU_INVCW 2. Non-moving Stock now reports on each batch / Serial (instead of total) 01 Jul 2002 *NEW* Vers 3f.16 1. Added prompt for Condition in Part No. header creation 2. Added new Pushbuttons to filter Quotes for "Priced" and "Zero-Prices" 3. Added Flag system to tell "owner" of Quote that it was accessed by someone 4. Added Prompt to print Progress Notes in P.O. Memo Note print 5. Added Prompt for Customs Invoice during Repair PO print 05 Jun 2002 *NEW* Vers 3f.15 1 Added Push Button to print Labels in Stock Control Screen 05 Jun 2002 *NEW* Vers 3f.14 1. New Menu added to Auto-Pick & Issue Stock, print Picking Note 25 May 2002 +FIX+ Vers 3f.13 1. Corrected VAT calc for P&P during Invoice Prnt when no Accnts prg installed 2. Win Version of SLS Accounts Program released 06 May 2002 *NEW* Vers 3f.12 1. Added "MATL CERT" alongside JAA/FAA Forms - new form RU_MATLW added 2. Added Bin Loc search in Label Print AMNDSTRU to CAFAM/SLS files (Still 3f): FPURINV.THEIR_REF,C,12 24 Apr 2002 *FIX* Vers 3f.11 1. Corrected change P/No fault - missed out Sales Orders 12 Apr 2002 Continued ..Vers "3f.10" 1. Added Memo Notes in Quotations. Prompts during quote, separate menu to retrieve and print 2. Added Promopt for Memo Notes in S.O's with option to print FQOTMEM memo file added - need AMNDPSP 21 FEB 2002 to 13 MAR 2002: "NEW" Vers "3f.00" ACCOUNTS 1. Credit Limit Control now checks each Sale Line during procesessing of Invoice. Previosly only cheked at start of process and could allow sales to exceed Credit Limit FCUSTNA added field CRL_BAL ) needs AMNDPSP.EXE to update File Stru FSALORD added field CONTR_RVW ) FSALMEM changed field EXP_LIC ) 2. Export Licence now Prompted and printed thru' 3. Contract Review prompt & Control (added in Sales Order Edit) 4. Added bew Control Item - "Make File Ref mandatory" in Customer A/c 15 FEB 2002 *NEW* (a) P.O. Budget Spend Control 1. Added New Menu to list Budget spend/entry by "Date Due" of order 2. Reports on above with "Overspent" flag (b) Various 1. Option to print out P.O. Memo Notes 31 JAN 2002 STORES 1. Fixed bug in Printing Delv Note in PO 2. Added Control Item "Auto Pick Sell Price in SO's & Quotes" Y/N 28 JAN 2002 GENERAL Problem Intermittent "Illegal Op Error" during printing Correction 1. Changed way Printer is controlled. Previously also changed default setting. Now reverts back to Windows Print Setting