Thursday, January 10, 2019

Create a Field to Display the Posting Period of an Inventory Item

The user needs to enter the Posting Period when an Inventory Item is created. The user also needs the parent Posting Period to be displayed on the Inventory Item after the record has been saved. The user's goal can be achieved by following the steps below:

A. Create a custom Item field to show Posting Period
1. Navigate to Customization > Lists, Records, & Fields > Item Fields > New.
2. Enter a Label for the field.
3. Set the Type to List/Record.
4. Set the List/Record to Accounting Period.
5. Uncheck Store Value.
6. Click the Applies To tab and check Inventory Item.
7. Click Save.

B. Create a custom Item field to show the parent period of the Posting Period of an Item
1. Navigate to Customization > Lists, Records, & Fields > Item Fields > New.
2. Enter a Label for the field.
3. Set the Type to Free-form text.
4. Uncheck Store Value.
5. Click the Applies To tab and check Inventory Item.
6. Click Validation & Defaulting tab and mark Formula and enter {custitem6.parent} in the Default Value field.
7. Click Save.

NOTE:  Please take note that the custitem6 represents the field ID of the custom field created in A and will have to be manually filled up. The parent represents that the value should show the parent posting period chosen in field A. Both of these fields will be shown in the Custom tab of the Item record unless the user specifies another under the Display tab of the custom fields.

No comments:

Post a Comment