Link Custom Transaction field to Custom Fixed Asset Management field
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