Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV70500
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Inventory Report Options Group Display Name: Inventory Report Options
Physical Name: IV70500
Technical Name: IV_Options_ROPT
Group Technical Name: Inventory Report Options
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | PRTBYSIT ![]() | Print by Site | Integer | GB | 0 |
2 | PRNTOPTN ![]() | Print Option | Integer | GB | 0 |
3 | STTGNDSC ![]() | Start Generic Description | String | STR10 | 10 |
4 | ENGENDSC ![]() | End Generic Description | String | STR10 | 10 |
5 | ENUSRCAT_1 ![]() | End User Category[1] | String | STR10 | 10 |
6 | ENUSRCAT ![]() | End User Category | STR10 | String | 10 |
7 | ENUSRCAT_2 ![]() | End User Category[2] | String | STR10 | 10 |
8 | ENUSRCAT_3 ![]() | End User Category[3] | String | STR10 | 10 |
9 | ENUSRCAT_4 ![]() | End User Category[4] | String | STR10 | 10 |
10 | ENUSRCAT_5 ![]() | End User Category[5] | String | STR10 | 10 |
11 | ENUSRCAT_6 ![]() | End User Category[6] | String | STR10 | 10 |
12 | KITSRTBY ![]() | Kit Sort By | Integer | GB | 0 |
13 | STRTUCAT_1 ![]() | Start User Category[1] | String | STR10 | 10 |
14 | STRTUCAT ![]() | Start User Category | STR10 | String | 10 |
15 | STRTUCAT_2 ![]() | Start User Category[2] | String | STR10 | 10 |
16 | STRTUCAT_3 ![]() | Start User Category[3] | String | STR10 | 10 |
17 | STRTUCAT_4 ![]() | Start User Category[4] | String | STR10 | 10 |
18 | STRTUCAT_5 ![]() | Start User Category[5] | String | STR10 | 10 |
19 | STRTUCAT_6 ![]() | Start User Category[6] | String | STR10 | 10 |
20 | STTITNUM ![]() | Start Item Number | String | STR30_Item_Number | 30 |
21 | ENITMNBR ![]() | End Item Number | String | STR30_Item_Number | 30 |
22 | PRVDRINF ![]() | Print Vendor Information | Integer | GB | 0 |
23 | PRTDSCNT ![]() | Print Discontinued | Boolean | CB_Discontinued | 0 |
24 | FINRPTNM ![]() | Financial Report Name | String | STR30 | 30 |
25 | PRNTNOTS ![]() | Print Notes | Boolean | CB_Print_Notes | 0 |
26 | PRNTTYPE ![]() | Print Type | Integer | GB | 0 |
27 | ASKECHTM ![]() | Ask Each Time | Boolean | CB_Ask_Each_Time | 0 |
28 | INCLGNDS ![]() | Include Legends | Boolean | CB_Include_Legends | 0 |
29 | PRNTOFIL ![]() | Print to File | Boolean | CB_Print_to_File | 0 |
30 | PRTOPRTR ![]() | Print to Printer | Boolean | CB_Print_to_Printer | 0 |
31 | PRTOSCRN ![]() | Print to Screen | Boolean | CB_Print_to_Screen | 0 |
32 | IFFILXST ![]() | If File Existing | Integer | GB | 0 |
33 | FILEXPNM ![]() | File Export Name | String | STR255 | 255 |
34 | EXPTTYPE ![]() | Export Type | Integer | INT | 0 |
35 | RPTGRIND ![]() | Report Group Index | Integer | INT | 0 |
36 | STTCLASS ![]() | Start Class | String | STR10_Item_Class_Code | 10 |
37 | ENDCLASS ![]() | End Class | String | STR10_Item_Class_Code | 10 |
38 | STTSCHED ![]() | Start Schedule | String | STR10_Schedule | 10 |
39 | ENSCHDUL ![]() | End Schedule | String | STR10_Schedule | 10 |
40 | STTLOCCD ![]() | Start Location Code | String | STR10_Location_Code | 10 |
41 | ENLOCNCD ![]() | End Location Code | String | STR10_Location_Code | 10 |
42 | STTLOTTY ![]() | Start Lot Type | String | STR10_Lot_Type | 10 |
43 | ENLOTTYP ![]() | End Lot Type | String | STR10_Lot_Type | 10 |
44 | STRTNGDT ![]() | Starting Date | Date | DT | 8 |
45 | ENDINGDT ![]() | Ending Date | Date | DT | 8 |
46 | ENDTKNDT ![]() | End Token Date | Integer | DDL_End_Dates | 0 |
47 | STTOKNDT ![]() | Start Token Date | Integer | DDL_Start_Dates | 0 |
48 | STRCTNUM ![]() | Start Receipt Number | String | STR20_Document_Number | 20 |
49 | ENRCTNBR ![]() | End Receipt Number | String | STR20_Document_Number | 20 |
50 | RTPACHIN ![]() | Report Palette Choice Index | Integer | INT | 0 |
51 | RTGRSBIN ![]() | Report Group Sub Index | Currency | DLR14 | 14 |
52 | SORTBY ![]() | Sort By | Integer | DDL_Sort_By | 0 |
53 | PRTSRLOT ![]() | Print Serial Lot | Boolean | CB_Print_Serial_Lot | 0 |
54 | INZROQTY ![]() | Include Zero QTY | Boolean | CB_Include_Zero_QTY | 0 |
55 | PRTITQTY ![]() | Print Item Quantities | Boolean | CB_Print_Item_QTYS | 0 |
56 | STTBINUM ![]() | Start Bin Number | String | STR20 | 20 |
57 | ENBINNBR ![]() | End Bin Number | String | STR20 | 20 |
58 | STDOCNUM ![]() | Start Document Number | String | STR20 | 20 |
59 | ENDOCNUM ![]() | End Document Number | String | STR20 | 20 |
60 | STDOCTYP ![]() | Start Document Type | Integer | INT1 | 1 |
61 | ENDOCTYP ![]() | End Document Type | Integer | INT1 | 1 |
62 | STTMODUL ![]() | Start Module | String | STR3 | 3 |
63 | ENDMODUL ![]() | End Module | String | STR3 | 3 |
64 | STRXSRC ![]() | Start TRX Source | String | STR13 | 13 |
65 | ENTRXSRC ![]() | End TRX Source | String | STR13 | 13 |
66 | STBCHSRC ![]() | Start Batch Source | String | STR15 | 15 |
67 | ENBCHSRC ![]() | End Batch Source | String | STR15 | 15 |
68 | STBCHNUM ![]() | Start Batch Number | String | STR15_LBAU | 15 |
69 | ENDBNMBR ![]() | End Batch Number | String | STR15_LBAU | 15 |
70 | STVNDRID ![]() | Start Vendor ID | String | STR15_LBU | 15 |
71 | ENDVNDID ![]() | End Vendor ID | String | STR15_LBU | 15 |
72 | INQTYREQ ![]() | Include QTY Requisitioned | Boolean | CB_QTY_Requisitioned | 0 |
73 | INZRORLV ![]() | Include Zero Reorder Level | Boolean | CB_Zero_Reorder | 0 |
74 | CALSGQTY ![]() | Calc Suggested QTYS | Integer | GB | 0 |
75 | RCPTOPTS ![]() | Receipt Options | Integer | DDL_Print_Option | 0 |
76 | VENDROPT ![]() | Vendor Options | Integer | DDL_Vendor_Option | 0 |
77 | SEGSRTBY ![]() | Segment Sort By | Integer | INT1 | 1 |
78 | STTACNUM_1 ![]() | Start Account Number:Account_Segment_Pool1 | String | Account_Segment_Pool1 | 6 |
79 | STTACNUM_2 ![]() | Start Account Number:Account_Segment_Pool2 | String | Account_Segment_Pool2 | 6 |
80 | STTACNUM_3 ![]() | Start Account Number:Account_Segment_Pool3 | String | Account_Segment_Pool3 | 6 |
81 | STTACNUM ![]() | Start Account Number | Account_Number | Composite | 80 |
82 | STTACNUM_4 ![]() | Start Account Number:Account_Segment_Pool4 | String | Account_Segment_Pool4 | 6 |
83 | STTACNUM_5 ![]() | Start Account Number:Account_Segment_Pool5 | String | Account_Segment_Pool5 | 6 |
84 | STTACNUM_6 ![]() | Start Account Number:Account_Segment_Pool6 | String | Account_Segment_Pool6 | 6 |
85 | STTACNUM_7 ![]() | Start Account Number:Account_Segment_Pool7 | String | Account_Segment_Pool7 | 6 |
86 | STTACNUM_8 ![]() | Start Account Number:Account_Segment_Pool8 | String | Account_Segment_Pool8 | 6 |
87 | STTACNUM_9 ![]() | Start Account Number:Account_Segment_Pool9 | String | Account_Segment_Pool9 | 6 |
88 | STTACNUM_10 ![]() | Start Account Number:Account_Segment_Pool10 | String | Account_Segment_Pool10 | 6 |
89 | EACCNBR_1 ![]() | End Account Number:Account_Segment_Pool1 | String | Account_Segment_Pool1 | 6 |
90 | EACCNBR_2 ![]() | End Account Number:Account_Segment_Pool2 | String | Account_Segment_Pool2 | 6 |
91 | EACCNBR_3 ![]() | End Account Number:Account_Segment_Pool3 | String | Account_Segment_Pool3 | 6 |
92 | EACCNBR_4 ![]() | End Account Number:Account_Segment_Pool4 | String | Account_Segment_Pool4 | 6 |
93 | EACCNBR ![]() | End Account Number | Account_Number | Composite | 80 |
94 | EACCNBR_5 ![]() | End Account Number:Account_Segment_Pool5 | String | Account_Segment_Pool5 | 6 |
95 | EACCNBR_6 ![]() | End Account Number:Account_Segment_Pool6 | String | Account_Segment_Pool6 | 6 |
96 | EACCNBR_7 ![]() | End Account Number:Account_Segment_Pool7 | String | Account_Segment_Pool7 | 6 |
97 | EACCNBR_8 ![]() | End Account Number:Account_Segment_Pool8 | String | Account_Segment_Pool8 | 6 |
98 | EACCNBR_9 ![]() | End Account Number:Account_Segment_Pool9 | String | Account_Segment_Pool9 | 6 |
99 | EACCNBR_10 ![]() | End Account Number:Account_Segment_Pool10 | String | Account_Segment_Pool10 | 6 |
100 | SEGMNTRG ![]() | Using Segment Range | Integer | INT | 0 |
101 | Start_PriceLevel ![]() | Start PriceLevel | String | STR10_PriceLevel | 10 |
102 | End_PriceLevel ![]() | End PriceLevel | String | STR10_PriceLevel | 10 |
103 | Start_QTY_Type ![]() | Start QTY Type | Integer | DDL_QTY_Type | 0 |
104 | End_QTY_Type ![]() | End QTY Type | Integer | DDL_QTY_Type | 0 |
105 | Start_Component_Item_Num ![]() | Start Component Item Number | String | STR30_Item_Number | 30 |
106 | End_Component_Item_Numbe ![]() | End Component Item Number | String | STR30_Item_Number | 30 |
107 | BM_Assembly_Journal ![]() | BM Assembly Journal | Boolean | CB_BM_Assembly_Journal | 0 |
108 | BM_Distribution_Detail ![]() | BM Distribution Detail | Boolean | CB_BM_Distribution_Detail | 0 |
109 | BM_Bill_Status_Active ![]() | BM Bill Status Active | Boolean | BM Bill Status Active | 0 |
110 | BM_Bill_Status_Pending ![]() | BM Bill Status Pending | Boolean | BM Bill Status Pending | 0 |
111 | BM_Bill_Status_Obsolete ![]() | BM Bill Status Obsolete | Boolean | BM Bill Status Obsolete | 0 |
112 | BM_Comp_Status_Active ![]() | BM Comp Status Active | Boolean | BM Comp Status Active | 0 |
113 | BM_Comp_Status_Pending ![]() | BM Comp Status Pending | Boolean | BM Comp Status Pending | 0 |
114 | BM_Comp_Status_Obsolete ![]() | BM Comp Status Obsolete | Boolean | BM Comp Status Obsolete | 0 |
115 | BM_Comp_Type_Misc_Charge ![]() | BM Comp Type Misc Charges | Boolean | BM Comp Type Misc Charges | 0 |
116 | BM_Comp_Type_Services ![]() | BM Comp Type Services | Boolean | BM Comp Type Services | 0 |
117 | BM_Comp_Type_Flat_Fee ![]() | BM Comp Type Flat Fee | Boolean | BM Comp Type Flat Fee | 0 |
118 | BM_Print_Notes_Bill ![]() | BM Print Notes Bill | Boolean | BM Print Notes Bill | 0 |
119 | BM_Print_Notes_Comp ![]() | BM Print Notes Comp | Boolean | BM Print Notes Comp | 0 |
120 | BM_Print_Cost_Options ![]() | BM Print Cost Options | Integer | GB | 0 |
121 | Max_Levels ![]() | Max Levels | Integer | DDL_Max_Levels | 0 |
122 | DATE1 ![]() | Date | Date | DT6 | 6 |
123 | BMTRXSTATNOTREL ![]() | BM Trx Status Not Released | Boolean | CB_BM_Trx_Status_Not_Released | 0 |
124 | BMTRXSTATREL ![]() | BM Trx Status Released | Boolean | CB_BM_Trx_Status_Released | 0 |
125 | OPTIONS ![]() | Options | Integer | DDL | 0 |
126 | Start_TRX_ID ![]() | Start TRX ID | String | STR17_TRX_ID | 17 |
127 | End_TRX_ID ![]() | End TRX ID | String | STR17_TRX_ID | 17 |
128 | Starting_TRX_Date ![]() | Starting TRX Date | Date | DT_Date | 6 |
129 | Ending_TRX_Date ![]() | Ending TRX Date | Date | DT_Date | 6 |
130 | STRTSRLT ![]() | Start Serial/Lot Number | String | STR20 | 20 |
131 | ENDSERLT ![]() | End Serial/Lot Number | String | STR20 | 20 |
132 | StartPriceGroup ![]() | Start Price Group | String | STR10_LBAU | 10 |
133 | EndPriceGroup ![]() | End Price Group | String | STR10_LBAU | 10 |
134 | STCURRID ![]() | Start Currency ID | String | STR15_Currency_ID | 15 |
135 | ENDCURID ![]() | End Currency ID | String | STR15_Currency_ID | 15 |
136 | STRTABCCD ![]() | Start ABC Code | Integer | DDL_ABC_Code | 0 |
137 | ENDABCCD ![]() | End ABC Code | Integer | DDL_ABC_Code | 0 |
138 | STRTSTCKCNTID ![]() | Start Stock Count ID | String | STR15_LBAU | 15 |
139 | ENDSTCKCNTID ![]() | End Stock Count ID | String | STR15_LBAU | 15 |
140 | Start_Landed_Cost_ID ![]() | Start Landed Cost ID | String | STR15_LBAU | 15 |
141 | End_Landed_Cost_ID ![]() | End Landed Cost ID | String | STR15_LBAU | 15 |
142 | Start_LandedCostGroupID ![]() | Start Landed Cost Group ID | String | STR15_LBAU | 15 |
143 | End_LandedCostGroupID ![]() | End Landed Cost Group ID | String | STR15_LBAU | 15 |
144 | ASOFDATE ![]() | As Of Date | Date | DATE | 6 |
145 | INZRQTYI ![]() | Include Zero Qty Items | Boolean | CB_IncludeZeroQtyItems | 0 |
146 | STARTBIN ![]() | Start Bin | String | STR15_Bin | 15 |
147 | ENDBIN ![]() | End Bin | String | STR15_Bin | 15 |
148 | LNGSTRTDESC ![]() | Long Start Description | String | STR100 | 100 |
149 | LNGENDDESC ![]() | Long End Description | String | STR100 | 100 |
150 | USEGLPOSTINGDATE ![]() | Use GL Posting Date | Boolean | CB_Use_GL_Posting_Date | 0 |
151 | INNGVQTY ![]() | Include Negative QTY | Boolean | CB_Include_Negative_QTY | 0 |
152 | COSTAVGPERIODIC ![]() | Cost For Periodic Average Items | Integer | DDL_CostItems | 0 |
153 | PRTINACT ![]() | Print Inactive | Boolean | CB_Inactive_Items | 0 |