Skip to main content

Notifications

Announcements

No record found.

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,647 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,443 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,443 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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans