Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

how to record pieces, pallets, boxes on inventory transaction

Posted on by 624

when i receive inventory i need to record how many pieces, how many boxes, and how many pallets it came in. The problem is that the conversion between pieces, boxes, pallets is variable, every transaction it can be different so i cant use the units of measure to accomplish this. For example - on one transaction i can have 100 pieces in 2 boxes, next time it can be 100 pieces on 5 boxes etc. Does someone know the best way to do this?

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 on at
    RE: how to record pieces, pallets, boxes on inventory transaction

    thanks Zhu! I didnt know those fields were there - adding something similar should work

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,378 Super User 2024 Season 2 on at
    RE: how to record pieces, pallets, boxes on inventory transaction

    Hi, I think you can add new fields, or directly use the fields below, and fill in the quantity you need when order entry.

    pastedimage1686196416353v2.png

    Hope this can give you some hints.

    Thanks.

    ZHU

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 on at
    RE: how to record pieces, pallets, boxes on inventory transaction

    any ideas or suggestions of how the customization would work?

  • Jun Wang Profile Picture
    Jun Wang 7,437 Super User 2024 Season 2 on at
    RE: how to record pieces, pallets, boxes on inventory transaction

    you may consider do a customization, there is not out of box for it.

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 on at
    RE: how to record pieces, pallets, boxes on inventory transaction

    thanks - but that doesnt really answer my question.

    Every transaction i need to record 3 units of measure - are there any examples how this can be accomplished, other than saying there is no best way to do it?

  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,437 Super User 2024 Season 2 on at
    RE: how to record pieces, pallets, boxes on inventory transaction

    there is no best way. in location is not directed, system always use base uom to record transaction on item ledger even user specified different uom on the line.

    if the location is directed, system will not use base uom and will use alternative uom instead

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans