Release Notes Version 4.87 (December 10, 2007) Object Description frmAllocation_rpt Modify SOID and ItemID column properties; expand ItemID and LotNo field widths frmAltWC Add form-level security to form open event; add form load event frmAnnualExpense_rpt Change cmdCancel to cmdClose frmAnnualExpense_rpt Add optBasis option group; modify cmdView click event frmAPInvEdit subform Increase ItemNo and ItemDesc field widths frmAPInvLines subform Increase ItemNo and ItemDesc field widths frmAPInvLines subform Modify DefectQty LostFocus event to set focus to FreightCharge instead of InvSubTotal frmAPInvoice Add form-level security to form open event frmAPInvoice Change InvSubtotal and InvTotal Enabled = False; Locked = True frmAPInvoice Modify InvSubtotal control source expression frmAPInvoice Increase subform width; change InvSubTotal TabStop to No; increase shipping page field widths frmAPInvoiceEdit Add form-level security to form open event frmAPInvoiceEdit Change InvSubtotal and InvTotal Enabled = False frmAPInvoiceEdit Modify InvSubtotal control source expression frmAPInvoiceEdit Increase subform width frmBackflush Change scrap calculation in form open event frmBackOrders_rpt Remove Docmd.Close from cmdOK click event; change cmdCancel to cmdClose frmBillAudit Change cmdCancel to cmdClose frmBOL Add 'If Err.Number <> 3270 Then' to cmdSave click event error handler to avoid Access 2007 error msg frmBOL Expand subform widths; expand CustomerName field width frmBOL_rpt Change subform to listbox; modify throughout frmBOL_rpt subform Delete form frmBOLLines Modify OrderLineID and SerialNo column properties; expand OrderLineID, LotNo, and SerialNo field widths; decrease ItemDesc, LineNo, and UMCode field widths frmBOLLines_Quote Modify QuoteID and SerialNo column properties; expand QuoteID field width; decrease ItemDesc, LineNo, and UMCode field widths; increase quantity field width frmBOMAllocation subform Increase ItemNo width to 1.2 and Desc width to 2.667 frmBOMAllocation subform Remove recordsource; add recordsource to form open event frmBOMInvAllocate subform Increase LotNo and SerialNo to 1.2 frmBOMIssue subform Expand ItemNo, LotNo, and SerialNo field widths; remove WhseName field; decrease UMCode field width frmBOMIssue subform Change scrap calculation in IssueFlag afterupdate event frmBOMMaster Notes Expand ItemNo, ItemDesc, and Notes field widths frmBOMSub Expand ItemIDChild field width to 1.3764; increase column width to 1.2; increase list width to 4.2;expand ShortDesc field width to 2.5 frmBOMSub Add Scrap% afterupdate event to convert scrap rate; remove validation rule; modify validation text frmByProducts_Item subform Expand ByProductID field width to 1.3764; increase column width to 1.2; increase list width to 4.2 frmCalcBOMReqmts Expand ItemID field width to 1.3764; increase column width to 1.2; increase list width to 4.2 frmCCRecords Add form-level security to form open event frmCCRecords Change BegQty to Variant; add IsNumeric condition in cmdRecalc click event frmCCRecords Increase subform width frmCCRecords subform Modify ItemID column properties; expand ItemID and ShortDesc field widths; change DimID, LotNo, and SerialNo field widths to 1.3764 frmCCRecords subform Expand quantity field widths; move UMCode after CountQty; modify LocID column properties frmCOGS_PT Change cmdCancel to cmdClose frmCOGS_QB Change cmdCancel to cmdClose frmCompany Add form-level security to form open event; modify CompanyTab change event frmCompany Change Form reference to Object on System page frmCompany Add State Enter event to populate CountryID if null frmConsignment Add Level >=2 condition to form open event frmConsignment Expand subform width; shift summary fields to right frmConsignment subform Expand ItemNo, LotNo, and SerialNo field width frmContactEvents Expand FirstName, LastName fields; change Enabled to False; change BackStyle to Transparent frmContactInfo Add form-level security to form open event; modify field properties frmCopyConfig Modify EMID and CopyToID column properties; expand field widths; center command buttons frmCopyItem Expand ItemID field width; modify column properties; center command buttons frmCostedBOM Add form-level security to form open event frmCostedBOM Add optBasis group; reformat; modify cmdView click event frmCostedBOM Modify EMID column properties; expand EMID field width frmCostRollup Add new form; replace menu option using form instead of macro frmCreateNewParametric Modify ItemID column properties; expand field width; center command buttons frmCreateProdConfig Modify NewQuote and NewParent column properties; expand field widths; center command buttons frmCreateProdConfig Change GetMsg(203) to GetMsg(44) in cmdSave click event frmCreateRMA Expand subform width; expand CustName field width frmCreateRMAOrderLines subform Modify OrderLineID column properties; expand OrderLineID and quantity field widths; decrease UMCode field width frmCreateRMAQuoteLines subform Modify QuoteID column properties; expand QuoteID and quantity field widths; decrease UMCode field width frmCreateSerialNo Modify SOID and ItemID column properties; increase ItemID field width; decrease SerialNo field widths to 1.2; expand subform width frmCreateSerialNo subform Increase SerialNo field width to 1.2 frmCreateShipDocs Revise cmdRun click event to update tblBOLSelected for optDocument >=2 condition frmCustContacts subform Widen Address and State field widths to remove gaps frmCustContacts subform Expand FirstName, LastName, and Title field widths; resequence Email field frmCustDemand_rpt Remove Docmd.Close from cmdOK click event; change cmdCancel to cmdClose frmCustInvoiceReprint Change cmdCancel to cmdClose frmCustomers Add 'If Err.Number <> 3270 Then' to cmdSave click event error handler to avoid Access 2007 error msg frmCustomers Widen frmCustContacts subform and frmCustShipTo subform widths frmCustomers Add BillingState and StreetState Enter events to populate CountryID if null frmCustomers Expand frmCustContacts subform, frmCustPartxRef subform, and frmCustShipTo subform field widths expand page and form width frmCustomers Expand Address field widths; reformat address page frmCustomers Modify CustTabCtl OnChange event to disable copycmdStreetAddress if street address not populated frmCustomers_rpt Remove Docmd.Close from cmdOK click event; change cmdCancel to cmdClose frmCustOrderRelease Expand customer and item column widths; expand form width accordingly frmCustOrderRelease Expand ItemNo field; modify list column properties frmCustOrders Add 'If Err.Number <> 3270 Then' to cmdSave click event error handler to avoid Access 2007 error msg frmCustOrders Modify StatusID afterupdate event to delete linked shop orders if order cancelled frmCustOrders Add cmdLinkedOrders and click event frmCustOrders Revise SalesTaxPer and VATRate afterupdate events frmCustOrderSearch subform Expand CustomerName field width frmCustPartxRef subform Expand ItemID field width to 1.3764; increase column width to 1.2; increase list width to 4.2; expand ShortDesc field width to 2.667 frmCustShipmentsByItem Remove Docmd.Close from cmdOK click event; change cmdCancel to cmdClose frmCustShipmentsByItem Modify ItemID column properties; add optCust option group; reformat; modify cmdPrint click event frmCustShipTo subform Change Country row source to qryCountryLookup; modify State GotFocus event frmCustShipTo subform Add cmdCopyStreetAddress button to add customer street address; resize address, city and state field widths frmCycleCount Add form-level security to form open event frmCycleCountAccuracy_rpt Correct SQL syntax in cmdPrint click event frmCycleCountAccuracy_rpt Change cmdCancel to cmdClose frmCycleCountAdjustments_rpt Correct SQL syntax in cmdPrint click event frmCycleCountAdjustments_rpt Add optBasis option group; modify cmdPrint click event frmCycleCountProgram Change query update to recordset update in cmdUpdateTol click event to avoid update error when comma used for int'l numeric format frmCycleCountSchedule_rpt Remove Docmd.Close from cmdOK click event; change cmdCancel to cmdClose; change Popup property to No frmDimInv Expand ItemID field width to 1.3764; increase column width to 1.2; increase list width to 4.2 frmDimInvCost Add AvgCost field; modify form beforeupdate event frmDimInvCost Expand DimID field width to 1.3764; adjust cost field widths frmDropShipment Add new form frmECO Add form-level security to form open event frmECO Expand ItemID field width to 1.3764; increase column width to 1.2"; increase list width to 4.2 frmEventNotification Add form-level security to form open event frmFamilyMatrix Add form-level security to form open event frmFeatureSetup subform Add form afterinsert event frmForecast Change ItemID rowsource to qryItemLookup_Saleable; modify ToggleForm sub to reference qryItemLookup_Saleable frmForecast Add form-level security to form open event frmForecast Expand ItemID field width to 1.3764; increase column width to 1.2; increase list width to 4.2 frmFormSecurity Add ObjectDesc field to drop-down; add ObjectDesc shadow; add opType group; change Form label references to Object frmFormSecurity subform Modify ListLevel function frmImportData Add product class and product code import options frmImportData Modify cmdImport click event to inlcude product class and product code frmImportData Modify ClearAll sub; modify optItems afterupdate event frmImportData Add optPC and optWC import options frmImportQuote Add new form frmIndentedBOM Expand ItemID field width to 1.3764 frmInvActivity_rpt Add form-level security to form open event; change cmdCancel to cmdClose frmInvActivity_rpt Add optBasis group; reformat; modify cmdOK click event frmInvAdjCost_rpt Change ExtCost filter to AbsCost in cmdOK click event frmInvAdjCost_rpt Add form-level security to form open event; change cmdCancel to cmdClose frmInvAdjCost_rpt Add optBasis group; reformat; modify cmdOK click event frmInvByLocation Change ShortDesc field to Enabled False, Locked True frmInvByLocation Modify ItemID column properties; expand ItemID and ShortDesc field widths; increase DimID, LotNo, and SerialNo field widths to 1.3764; increase quantity field widths frmInventoryAging Add form-level security to form open event frmInventoryAging Modify ItemID column properties; expand ItemID field width frmInvGroup Change cmdCancel to cmdClose frmInvGroup Modify ItemID and SerialNo column properties; increase ItemID, LotNo, and Serial field widths to 1.3764; adjust other field widths frmInvLocOH_rpt Add new form; replace report menu option with new form frmInvoiceAudit Change cmdCancel to cmdClose frmInvTransactionHistory subform Modify recordsource in form open event to include BegDate and EndDate frmInvTransactionHistory subform Increase width of dtTimestamp, ItemNo, Desc, Quantity, LotNo, and SerialNo field widths frmInvTransactions Change Level = 3 to Level >= 2 in form open event; move UserID statement frmInvTransactions Change LotNo and SerialNo ListRows to 16; change SerialNo ListWidth to Auto, Column Widths to Null frmInvTransactions Modify LotNo GotFocus event frmInvTransactions Modify message lines 107, 108, and 109 frmInvTransactions Modify GetLocOH function and LotNo afterupdate event frmInvTransactions Add form variables; populate form variables at end of cmdSave click event frmInvTransactions Add cmdIssueSO button and click event frmInvTransactions Modify cmdSave click to include audit trail for shop order status and qtyrecvd updates frmInvTransactions Change GetMsg(110) to GetMsg(1180) in DimID afterupdate event frmInvTransactions Add SORecptCost variable to cmdSave click event frmInvTransactions Modify SOID column width properties; expand ItemID, LotNo, and SerialNo field widths to 1.3764; increase ItemID column width to 1.2; increase list width to 4.2 frmInvTransactions Modify column width settings in SOID and TrxType afterupdate events frmInvTransactions Remove InvOH function call for quote receipts from cmdSave click event frmInvTransfer subform Modify ItemID column properties; expand ItemID and ShortDesc field widths; change DimID, LotNo, and SerialNo field widths to 1.3764 frmInvTransfers Modify form open event to not allow subform deletions; modify form close event to prevent saves in read-only mode frmInvTransfers Increase subform width frmInvValuation_rpt Add form-level security to form open event; change cmdCancel to cmdClose; remove form close from cmdOK click event frmInvValuation_rpt Add optBasis group; reformat; modify cmdOK click event frmIssueSO Add new form  frmIssueSO subform Add new form  frmItemAvail Change cmdCancel to cmdClose frmItemAvail Expand ItemID field width to 1.3764; increase column width to 1.2; increase list width to 4.2 frmItemCost Add AvgCost field; modify form beforeupdate event frmItemCost Change Cycle property to current record frmItemMaster Add 'If Err.Number <> 3270 Then' to cmdSave click event error handler to avoid Access 2007 error msg frmItemMaster Add btnFile enabled for read-only access in form open event frmItemMaster Modify Phantom afterupdate event to remove purchased item restriction frmItemMaster Change Standard Cost label to Unit Cost frmItemMaster Revise frmItemCost subform width to 3.2" on main form and ToggleDimInv sub frmItemMaster Expand cboItemID and ItemNo field width to 1.3764; increase column width to 1.2; increase list width to 4.2 frmItemMaster Modify DimInvCost subform width in ToggleDimInv sub frmItemMaster_rpt Remove Docmd.Close from cmdOK click event; change cmdCancel to cmdClose frmItemOnOrder Change cmdCancel to cmdClose frmItemOnOrder Expand ItemID field width to 1.3764; increase column width to 1.2; increase list width to 4.2 frmItemSearch Increase ItemID field width and column properties; expand subform and ShortDesc width frmItemSearch subform Expand ItemNo width frmItemSearch_BOM Increase ItemID field width and column properties; expand subform and ShortDesc width frmItemSearch_BOM subform Expand ItemNo width frmItemSearch_Orders Increase ItemID field width and column properties; expand subform and ShortDesc width frmItemSearch_Orders subform Expand ItemNo width