Tuesday, October 16, 2018

Custom Field Value that Sources Item Weight is Different from the Item Weight Value in the Inventory Record

User creates a custom transaction line field that source the Item Weight from the Item record but the value showing is different.

Item Weight: 2.57 lb per Bundle
Stock Units: Bundle
Purchase Units: Each
Sale Units: Each

1. Navigate to Customization > Lists, Records, & Fields > Transaction Line Fields > New
2. Type: Decimal Number
3. Unmark the Store Value checkbox
4. Applies to tab > select Sale
5. Sourcing and Filtering tab > Source List: Item > Source From: Item Weight
6. Save

User creates a Sales Order and the Item weight that shows up in the custom field is equal to 0.4283333

The rationale is because of the unit of measure.

1. Lists > Accounting > Units of Measure > New
2. Enter a Type Name
3. Fill out the table:

 

NAME

PLURAL NAME

ABBREVIATION

PLURAL ABBREVIATION

CONVERSION RATE (/base)

BASE UNIT

Each

Each

each

each

1

Yes

IP

Bundle

Bundle

IP's

6

 

2.57/6=0.4283333

No comments:

Post a Comment