Link Custom Transaction field to Custom Fixed Asset Management field

Written by
Carmela Batalla
Published on
October 24, 2023 at 5:32:42 AM PDT October 24, 2023 at 5:32:42 AM PDTth, October 24, 2023 at 5:32:42 AM PDT

Scenario

The customer would like to know how to link a custom transaction field to a custom Fixed Asset Management field.

Solution

1.Navigate toCustomization>List, Records, & Fields>Transaction Line Fields>Newto create the Custom Field(s) and apply it to the Transaction(s) (i.e Bill and Journal).

- Label (Name i.ePhysical Location)

    • Type: List/Record
    • List/Record: State
    • Store Value: T

> Applies to:

    • Purchase Item = T
    • Journal = T
    • Select all lines on the Custom Transactions

- ClickSave

- ClickApply to Forms(Select all the transaction forms this field would appear)

- Repeat the steps above and create another one for theZip

Important:Take note of theID(i.e custcol3)*Legend1

2.Navigate toCustomization>List, Records, & Fields>Record Types>FAM Asset Proposaltocreate Record Type on FAM Asset Proposal and FAM Asset

-New Field (Populate the ff:)

    • Label
    • ID
    • Type: List/Record
    • List/Record: State
    • Store Value: T

- ClickSave

Important:Take note of theID(i.e custrecord+ID Name)*Legend2

3. Navigate toCustomization>List, Records, & Fields>Record Types>FAM Asset

-New Field (Populate the ff:)

    • Label
    • ID
    • Type: List/Record
    • List/Record: State
    • Store Value: T

> Display

    • Subtab: General

- ClickSave

Important:Take note of theID(i.e custrecord+ID Name)*Legend3

We have all necessary field ID's created and ready, we will now proceed to link all records

4.Navigate toFixed Assets>Setup>Transaction Field Map>New Transaction Field Maptocreate the mapping

    • Source Transaction Field ID:*Legend1
    • Proposal Field ID:*Legend2
    • Asset Field ID:*Legend3
    • Transaction Field ID:*Legend1
    • Transaction Line Field =T

-ClickSave