Rep_Stock View
Reference No: 24839 C4AE3544A3
(V 02.00.14-00)
Details
In CR2 you can generate a custom report using Rep_Stock View, which will display the Stock status information for Parts. The detailed list of the fields present in the view along with their description are given in the Table 1.0.
Table 1.0 Report Fields
Field Name | Description |
BRANCH | Site ID |
MANUFACTURERID | Manufacturer ID |
MANUFACTURERNAME | Manufacturer Name |
PARTNUMBER | Part SKU |
PARTDESCRIPTION | Part Description |
LISTPRICE | List Price |
COST | Replacement Cost |
BINNUMBER | Bin Number |
ONHANDQTY | Stock on Hand |
ONORDERQTY | Quantity on Order |
LASTSOLDDATE | Last Sold Date |
PACKAGEQTY | Package Quantity |
SETQTY | Set Quantity |
MINIMUMQTY | Minimum Quantity |
MAXIMUMQTY | Maximum Quantity |
STOCKSTATUS | Stock Part/Non Stock Part/Temp Stock Part |
AVERAGECOST | Average Cost |
NONRETURNABLE | Non Returnable |
DATEADDED | Date Added |
BRANCHID | Branch ID |
lastreceivedate | The date when stock was received last time. |