| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Serial No. Management
Serial No. Fields
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) | ||
Assigned 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 Fields
Field Name | Comments | ||
|---|---|---|---|
Entry No. (auto number) | |||
Serial No. | Master Detailed | ||
Entry Type | Manufactured, Dealer Stock, Sold, Returned, AssignedDocument 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 with = Manufactured.
Copy Document Type to Entry Type
Insert a Serial No. header if it does not exist
yet. We should never allow duplication.
Item Ledger Entry, Shipment ILE, populate Serial No. Ledger Entry with = Dealer Stock
Add Serial No. field to Opportunity
When adding Serial No. to Opportunity, populate Serial No. Ledger Entry with = Assigned
Opportunity
If Record Type = End User, and if Status = Closed Won, populate Serial No. Ledger Entry with = Sold
Return????
How to return? Return Sales Order????
Warranty
...
When unposting WS, delete the Serial No. only if:
It is not assigned
If the Serial No. is not sold or an error occurs
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
Quantity = 1.
A Serial No. header cannot be deleted if:
Any of the fields below are populated:
Sold to Opportunity
Sold to Opportunity Product
Dealer Account
Sold to User Account
The 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
Enable field tracking for all fields on:
Serial No. table
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 Fields (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 Type Family = InventoryParts | |
Under Warranty Labor Amount | Roll-up summary with Under Warranty = true, and Product Type Family = Labor | |
Out of Warranty Amount | Roll-up summary with Under Warranty = false | |
Vendor Payment (lookup) | ||
Purchase Credit Memo (Lookup) |
Warranty Lines Fields
Field Name | ||||
|---|---|---|---|---|
Case No. (master-detail) | ||||
Product | part means inventory | 2 hours, + parts (Part/Labor (lookup to Product))Parts when Product Family = Parts Labor when Product Family = Labor | ||
Quantity | ||||
Unit Price | ||||
Line Amount (formula) | what formula? | Under Warranty | checkbox? |
Processes
Dealers must fill out Case and Warranty Tickets to get paid Ticket Lines to receive payment for under-warranty work.
Optional for For not under-warranty work, Warranty Ticket Lines are optional
Vendor Payment lookupSales , Purchase Credit Memo lookup
on Case
For Cases, turn on the approval process to approve, if the 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
Parts Under Warranty Product Amount > 0, to create Sales a Purchase Credit Memo , to credit against APthe Purchase Invoice