How to get Weight from Sales Tab of OITM Table

[former_member535256]

Hello,

When I look at the Weight in the Sales Tab in the Master Item, I see the weight like 1.5lb. But when I run a query, I see only number 1.5. How to I get the unit of weight from that field?

Thank you

[former_member532218 · Accepted solution]

Hi.

Use SWght1Unit field. Refer to OWGT for the corresponding Unit Name.

Regards,
Arlene

[former_member535256]

Thank you very much. That what I needed