...
Field Name | Comments | |
---|---|---|
Serial No. (Name field) must be unique | Text | |
Product (lookup) | ||
Item (lookup) | ||
Engine Serial No. | Text | |
Hydrogear Left Serial No. | Text | |
Hydrogear Right Serial No. | Text | |
Serial No. Status | Assigned,In Stock,Sold, Returned, formula???? | |
Quantity | Rollup Summary | |
Dealer Account (lookup) | ||
End User Account | formula | |
Opportunity (lookup) | ||
Manufacture Date | Rollup Summary | |
Sold Date | formula | |
Warranty Expiration Date | formula | plus 5 years???? |
Serial No. Ledger Entry
Field Name | Comments | |
---|---|---|
Entry No. (auto number) | ||
Serial No. | Master Detailed | |
Entry Type | Manufactured, Dealer Stock, Sold, Returned, Assigned | |
Posting Date | Reserve a SN against an opportunity | |
Opportunity | lookup | |
Description |
...