Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
printablefalse

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',
If (Assigned_to_Opportunity__c != null, 'Assigned',
If ( Dealer_Account__c != null, 'Dealer Stock',
If (Quantity__c = 1, 'Yakta', 'Error'))))

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 Fields

Field Name

Comments

Entry No. (auto number)

Serial No.

Master Detailed

Document Type

Shipment
Receipt
Transfer
Adjustment
Consumption
Output
Dealer Stock
Assigned
Returned

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 No. only if

...

:

  • It is not assigned

    , or if it

  • 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, and

  • Quantity = 1.

A Serial No. header cannot be deleted if:

  • Any of the fields below are

    not blank

    populated:

    • Sold to Opportunity

    • Sold to Opportunity Product

    • Dealer Account

    • Sold to User AccountOr

  • 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

  • Must turn on

    Enable 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

    :

    • 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 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 Fields

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?

...

  • Dealers must fill out Case and Warranty Ticket Lines to get paid receive payment for under-warranty work.

    • For not under-warranty work, Warranty Ticket Lines are optional for not under-warranty work

    • Vendor Payment lookup, Purchase Credit Memo lookup on Case

  • 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

    • Under Warranty Product Amount > 0, to create a Purchase Credit Memo , to credit against the Purchase Invoice