News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Add a new quantity fie...

Microsoft Dynamics AX (Archived)

Add a new quantity field to InventSum table

(0) Share

Report

Report

Posted on by bernardqin

559

Hi experts,

I want to add a new quantity field to InventSum table, and want it has the same behavior as field Qty. Can anyone give me some snapshot?

Below is my requirement:

Items are measured as "Metre" for inventory unit, but for customer users, "Roll" is common unit for business. However, the unit conversion cannot be defined between those, I try to add new fields "QtyRoll" to related tables, like InventJournalTrans, PurchLine, SalesLine, ProdJournalRoute, and also InventTrans, InventSum. But I am not sure how to implement it.

Besides, any other solution is also appreciated.

Thanks in advance.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

André Arnaud de Cal... 291,711 Super User 2024 Season 2 on at

Like (0)

Report

RE: Add a new quantity field to InventSum table

Hi Bernardqin,

Just adding a new field is not an issue, but adding business logic to maintain this field correctly would be cumbersome, especially when there is no standard unit conversion possible.

Have you considered using catch weight functionality? Then you can record two units of measure for each transaction.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans