Serial No. Management
Serial No.
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 | |
No. of Ledger Entries | Serial No. cannot be deleted if No. of Ledger Entries > 0 | |
Status | If (Sold_Date__c != null, 'Sold', | |
Quantity | Rollup Summary | |
Dealer Account (lookup) | ||
End User Account (lookup) | ||
Sold to Opportunity (lookup) | ||
Sold to Opportunity Product (lookup) | ||
Manufacture Date | ||
Sold Date | formula | |
Warranty Expiration Date | formula | plus 5 years???? or 2000 hours??? |
Serial No. Ledger Entry
Field Name | Comments | |
|---|---|---|
Entry No. (auto number) | ||
Serial No. | Master Detailed | |
Document Type | Shipment | |
Posting Date | Reserve a SN against an opportunity | |
Opportunity | lookup | |
Item Ledger Entry (lookup) | ||
Description |
Processes
When inserting Item Ledger Entries if Serial No. is not blank.
Insert Serial No. Ledger Entry.
Copy Document Type to Entry Type
Insert a Serial No. header if it does not exist. We should never allow duplication.
When unposting WS, delete the serial number only if it is not assigned, or if it is not sold, or error
Serial No. Assignment table is blank for this serial number
3 fields below are blank
Sold to Opportunity
Sold to Opportunity Product
Sold to End User Account
If ILE’s Document Type = Shipment, insert another SN ILE with Entry Type = Dealer Stock, and Quantity = 1.
Serial No. header cannot be deleted if:
Any of the fields below are not blank:
Sold to Opportunity
Sold to Opportunity Product
Dealer Account
Sold to User Account
Or Serial No. assignment table is not blank
These four fields should be READ only for regular users.
Sold to Opportunity
Sold to Opportunity Product
Dealer Account
Sold to End User Account
Field Tracking
Must turn on field tracking for all fields on Serial No. table, and Serial No. Entry table.
When posting returns
Error if the following 3 fields are not blank or Serial No. Assignment is not blank.
Sold to Opportunity
Sold to Opportunity Product
Sold to End User Account
When posting returns, blank out Dealer Account.
Add one more Serial No. Ledger Entry, for the return.
Case Management
Case (used for Warranty Ticket) one case per serial number
Field Name | ||
|---|---|---|
Warranty Status | In Review, Approved, Paid | Paid = can be A/P check or credit memo against AP |
Serial No. (lookup) | ||
Product (lookup) | ||
Item (lookup) | ||
Under Warranty | Need a formula field??? | |
Under Warranty Amount | Roll-up summary with Under Warranty = true | |
Under Warranty Product Amount | Roll-up summary with Under Warranty = true, and Product Family = Parts | |
Under Warranty Labor Amount | Roll-up summary with Under Warranty = true, and Product Family = Labor | |
Out of Warranty Amount | Roll-up summary with Under Warranty = false | |
Vendor Payment (lookup) | ||
Purchase Credit Memo (Lookup) |
Warranty Lines
Field Name | ||
|---|---|---|
Case No. (master-detail) | ||
Product | Parts when Product Family = Parts Labor when Product Family = Labor | |
Quantity | ||
Unit Price | ||
Line Amount (formula) | what formula? |
Processes
Dealers must fill out Case and Warranty Ticket Lines to get paid for under-warranty work.
Warranty Ticket Lines are optional for not under-warranty work
Vendor Payment lookup, Purchase Credit Memo lookup on Case
Case - turn on the approval process to approve, if Under Warranty Amount > 0
Once approved, create two workflows to call the apex code
Under Warranty Labor Amount > 0, to create a Vendor Payment to pay via ACH
Under Warranty Product Amount > 0, to create Purchase Credit Memo, to credit against Purchase Invoice