This class will allow you to see the Lot Serial Number in the the LotSerial History File. It will show you the associated Item and Transaction Date and Type and the Reference Number. If the Lot Serial number was used in Sales Order Entry or Purchase Order Entry you can drill down to see the AR Invoice History Inquiry and the PO Receipt History Inquiry. There is also a Selection Grid associated with to Inquiry to find the Lot Serial Number. In reading the tables directly not using the business object to increase performance |
| LOCAL cDefaultTransWhere$="1=1" |
Default where clause containing current period |
| LOCAL cColumnSortText1$="{&G!GridSort1}" |
BT_ColumnSort bitmap when no selections have been made |
| LOCAL cColumnSortText2$="{&G!GridSort}" |
BT_ColumnSort bitmap when selections have been made |
| LOCAL viewLS_ITEM=1 |
[integer] Constant values for cViewType |
| LOCAL viewLS_ONLY=2 |
| FUNCTION LOCAL BT_ColumnSort() | ||||||
Button press logic for the Column Sort button | ||||||
| ||||||
| FUNCTION LOCAL BT_CustomerRecall() | ||||||
Button press logic for Lot Serial Customer Recall Report button | ||||||
| ||||||
| FUNCTION LOCAL BT_First() | ||||||
Button pressed to move to first record | ||||||
| ||||||
| FUNCTION LOCAL BT_Items() | ||||||
Items button pressed | ||||||
| ||||||
| FUNCTION LOCAL BT_Last() | ||||||
Button pressed to move to Last record | ||||||
| ||||||
| FUNCTION LOCAL BT_Lot_Serial_Search() | ||||||
When Lot Serial Search Button is pressed will bring up the Search Dialog. Will pass the Period Starting and Ending Date to the Dialog. Will create Whereclause used to filter the Lot Serial History file on OK. | ||||||
| ||||||
| FUNCTION LOCAL BT_Next() | ||||||
Button pressed to move to next record | ||||||
| ||||||
| FUNCTION LOCAL BT_OK() | ||||||
OK button pressed | ||||||
| ||||||
| FUNCTION LOCAL BT_Prev() | ||||||
Button pressed to move to previous record | ||||||
| ||||||
| FUNCTION LOCAL BT_SelectItem() | ||||||
Select button pressed on the Item List dialog | ||||||
| ||||||
| FUNCTION LOCAL BT_Switch() | ||||||
Switch view of inquiry | ||||||
| ||||||
| FUNCTION LOCAL BT_WhereUsed() | ||||||
Where Used Inquiry button pressed, only available if Type is BI | ||||||
| ||||||
| FUNCTION LOCAL BT_Zoom() | ||||||
Will bring up AR Invoice History or Receipt History Record if Type is SO or PO | ||||||
| ||||||
| FUNCTION LOCAL ChangeLB_ItemList() | ||||||
Item List listbox change logic | ||||||
| ||||||
| FUNCTION LOCAL ChangeLB_LotSerialTrans() | ||||||
Will check current record selected in Listbox if Type is SO or PO. If Type is SO or PO will call the BT_Zoom method to bring up Inquiries | ||||||
| ||||||
| FUNCTION LOCAL ChangeLB_LotSerialTrans1() | ||||||
Change logic for transaction list box when view 1 | ||||||
| ||||||
| FUNCTION LOCAL ChangeLB_LotSerialTrans2() | ||||||
Change logic for transaction list box when view 2 | ||||||
| ||||||
| FUNCTION LOCAL ChangeML_LotSerialNo() | ||||||
When Lot Serial field is changed it will re-populate the Listbox with Items that have the Serial Number associated with it. | ||||||
| ||||||
| FUNCTION LOCAL CheckInvHistory(key$) | ||||||
| FUNCTION LOCAL CheckInvHistory(key$, date$, dateFlag) | ||||||
Called from the ChangeLB_LotSerialTrans and OnFocusLB_LotSerialTrans methods when the Transaction Type is SO | ||||||
| ||||||
| ||||||
| FUNCTION LOCAL CheckPOHistory(key$) | ||||||
| FUNCTION LOCAL CheckPOHistory(key$, date$, dateFlag) | ||||||
Called from the ChangeLB_LotSerialTrans and OnFocusLB_LotSerialTrans methods When the Transactio Type is PO | ||||||
| ||||||
| ||||||
| FUNCTION LOCAL PERFORM GetItemDescription() | ||||||
Get Item Description | ||||||
| FUNCTION LOCAL LoadLBTransactions() | ||||||
Called from BT_Zoom and ChangdML_LotSerialNo method Will load the Listbox with selected Items | ||||||
| ||||||
| FUNCTION LOCAL OnExit() | ||||||
Logic to execute when exiting the dialog | ||||||
| ||||||
| FUNCTION LOCAL OnFocusLB_LotSerialTrans() | ||||||
Will check current record selected in Listbox if Type is SO or PO If Type is SO or PO will call the BT_Zoom method to bring up Inquiries | ||||||
| ||||||
| FUNCTION LOCAL OnFocusML_LotSerialNo() | ||||||
Will store current Lot/Serial number to cOrigLotSerialNo variable | ||||||
| ||||||
| FUNCTION LOCAL PostLoad() | ||||||
Logic to execute after the display of the dialog | ||||||
| ||||||
| FUNCTION LOCAL SortListBox(listboxCtl, columnSort$) | ||||||
Method SortListBox will apply the user selected column sorts to the list box | ||||||
| ||||||
| ||||||
| FUNCTION LOCAL TransHistDrillDown(key$, type$) | ||||||
Called from the BT_Zoom Decides which Inquiry to display the AR Invoice History or PO Receipt History Inquiry | ||||||
| ||||||
|
|
itmREGULAR$, itmSPECIAL$, itmCHARGE$, itmCOMMENT$, itmMISC$, valSTANDARD$, valAVERAGE$, valFIFO$, valLIFO$, valLOT$, valSERIAL$, typFINISHEDGOODS$, typRAWMATERIALS$, typDISCONTINUED$, typKIT$, proMAKE$, proBUY$, proSUBCONTRACT$, proMAKETOORDER$, proBUYTOORDER$, tierFIFO$, tierLIFO$, tierLOT$, tierSERIAL$, upceanTYPENONE$, upceanTYPEOTHER$ |
|
cAutoCompCellTypes$, cCentreCellTypes$, cEnterLikeTab$, cGridDefaultRowHeight, cLookupCellTypes$, cSearchDialogueCreated, cGridRowHeightPlus, cWdxGridLoadLimit, cExcelInstalled, cAllUsers$, cAllComps$, cAllWrks$, cOpenedNOMADSGridTable, cLocalGridVariablesSet, GridIOL$ |
|
InBrowse, ViewOnly |
|
GetCalendarEndingDate(), GetDefaultExtendedDescriptionKey$(), UPCEANCheckDigit(), UPCEANFetch(), UPCEANUpdate() |
|
ParseVendor() |
|
AddColumn(), ClassChangeGrid(), ClassInitializeGrid(), ClassOnFocusGrid(), ClearGrid(), DisableGrid(), DropColumn(), DropRow(), EnableGrid(), ExportToExcel(), FindColumnHeader(), FreezeColumn(), GetALEColumnInfo(), GetColumnAttributes(), GetGridIndex(), GetGridIOLIST$(), GotoCell(), GotoColumn(), GotoRow(), HideColumn(), InitializeRow(), InsertRow(), IsColumnHideAble(), IsColumnInGrid(), IsColumnMoveAble(), LoadGrid(), LoadRow(), LockGrid(), OnExitWithGrid(), ParseQuickString(), RefreshGridBindings(), RemoveGridFocus(), SaveGridSettings(), SaveRow(), SetColumnAttributes(), SetColumnAttributesHeadersMain(), SetColumnAttributesHeadersSec(), SetGridPresets(), SetupGrid(), ShowColumn(), ShowColumns(), ShowRow(), AddGroups(), AdjustNomadsInfo(), BT_RowDel(), BT_RowDown(), BT_RowIns(), BT_RowSearch(), BT_RowUp(), ChangeML_GotoLine(), ClearNomadsInfo(), CloneNomadsInfo(), CloseSearchWindow(), DoColumnChange(), DoSave(), PERFORM DoSearch(), FindNextCell(), FormatDate$(), FormatRow(), GetRowLockState(), GetWdwForCtl(), HasRowChanged(), IsColumnHidden(), IsCtlGrid(), OpenSearchWindow(), PERFORM PaintCell(), ParseIOList$(), ParseRowTag$(), PopulateGridBindings(), PutTick(), RemoveGridCustomization(), RemoveNomadsInfo(), ResetSecInitPropLists(), PERFORM ResolveFormatters(), ResolveGroups(), RestoreGridAutoComplete(), RestoreNomadsInfo(), ReturnToField(), SetButtonState(), SetButtonStateFirstRow(), SetButtonStateInsertRow(), SetButtonStateLastRow(), SetButtonStateNoRow(), SetButtonStateOtherRow(), SetColumnGroupState(), SetColumnState(), SetGridAutoComplete(), PERFORM SetGridHeaders(), PERFORM SetGridIOLISTS(), SetGridSecurity(), SetGridSize(), SetLocalGridVariables(), SetPopupStatus(), SetRowLockState(), SetRowState(), SetupNomadsInfo(), ShowSearchResult(), TestAutoCompleteObj() |
|
HasRights(), RefreshBindings(), SetDocDateWarnOff(), SetUIRecord(), SetVar(), AddSuppressedMsg(), BindVariables(), BT_Accept(), BT_AcceptClose(), BT_Cancel(), BT_CancelClose(), BT_Delete(), BT_First(), BT_Last(), BT_List(), BT_Listing(), BT_Next(), BT_Office(), BT_OKView(), BT_Prev(), BT_Print(), CheckMemo(), ClassPushMemoBtn(), ConfirmDelete(), ConfirmWrite(), DefaultChange(), DisplayErrorMsg(), DisplayMemoButton(), DisplayWriteError(), ExplodeIOL(), GetBusinessObject(), GetControlID(), GetFirstID(), HandleDocumentDateWarning(), HasMemos(), HidePopupMenu(), InitBusinessObject(), KeyChange(), LaunchMemo(), OnExit(), PostLoad(), QuickConfirmWrite(), PERFORM ResolveMemoParameters(), ReturnToCtlOrGrid(), PERFORM RtrnToCTLOrGrid(), SetBusinessObject(), SetFocusFailedID(), SetFocusFirstID(), SetFormDisplay(), SetFormState(), SetInitialRecord(), SetNumericVal(), SetStringVal() |
|