web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Pallet Quantity and Bo...
Microsoft Dynamics AX (Archived)

Pallet Quantity and Box/Layer Quantity for an Item

(0) ShareShare
ReportReport
Posted on by richierich79 300

I am trying to understand the relationship between and Item and it's Pallet Quantity and it's Box/Layer Quantity.

Are these 121 with and Item, or 121 with a Customer\Item?

Looking to extract this data for an item from the database layer, but Im having trouble finding which tables Pallet Quantity and Box\Layer quantity are in?

*This post is locked for comments

I have the same question (0)
  • richierich79 Profile Picture
    richierich79 300 on at

    Perfect, thank you.

    I can see how this relates an Item to x number of pallets.

    I assume there's not a direct db relationship between pallets and customers.

    I am really looking at this from the context of pricing point of view and whether this impacts the price of an item. When a price of an item is calculated for a customer would a price for an item be differ dependant on the number of pallets for an item.  I know InventDim is a column on PriceDiscTable but I don't know if it's used this way?

  • richierich79 Profile Picture
    richierich79 300 on at

    That makes sense, thank you.

    Is box quanitiy in the same tables, or are they stored differently?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans