Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ruth Entwistle]

#NAV2017?

We do not use manufacturing or warehousing but would like to add the pallet information into NAV in a place that one could see this information while inputting an order. 
We already use ALT UOM for lbs and cases.  We have both these units of measure on the sales lines already.  

Where would you add the pallet information TI/HI so that a salesperson could easily access this information (driven by item card) while entering a sales order or looking at an item card? 

Thanks all! 

——————————
Ruth Entwistle
Customs Broker/Vendor Relations
Heron Point Seafood
Newmarket NH
——————————

[David Wiser]

If you are using an “Alt UOM” you probably have an add-on, so this answer may or may not help.  I have normally seen the dimensions of the pallet on the item Unit of Measure page.  If you set up a UOM for pallet, you can add the Height, Length, and Width of the pallet to the UOM.  If your add-on solution includes pallet functionality, there may be a table within the add-on to capture it.

——————————
David Wiser
Project Manager
Tigunia
Seattle WA
——————————
——————————————-

[Ronald McVicar]

Good reply David.
So does this mean you can have a item like a role of film with maybe 1,800 inches (UOM #1 to a role (UOM #2) and a Pallet which might have eight (8) roles (UOM #3) to a pallet?  They I suspect then you can consume by either Inches, roles or pallet, too?
???

——————————
Ronald McVicar, IT Software Mgr
NSP (Quality Meats)
nspproteins.com
——————————
——————————————-

[Lewis Rosenberg]

I agree with Dave’s answer.  Another option is to use Extended Text if you want the information to show up on an order line, but it will require extra steps.  You can enter the pallet information as Item Extended Text on the Item Card.  Then when entering sales orders, use the Line menu drop-down, select Functions and Insert Ext. Text.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
————————————————————————
BCUG/NAVUG All-Star
BCUG/NAVUG Board of Advisors, Chairperson
BCUG/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————

NAVUG/BCUG Summit (navugsummit.com)
Orlando, FL – October 15-18, 2019

Come hear me speak:
GET50 – All About NAV/BC Security
Friday, October 18, 2019
9:45 AM – 10:45 AM
——————————
——————————————-

[David Wiser]

Yes, you can have all those UOM in the table.  But, they would all relate to the Base UOM.  So, if INCH was the base UOM, you would set up ROLL as 1800 INCH and also PALLET as 14400 INCH (assuming 8 rolls to a pallet).  The system will then allow you to transaction in any of the three units of measure.  Under this scenario, some might be tempted to use ROLL as the base UOM and then set up INCH as 1/1800 of a ROLL.  I would recommend against that as its usually best to have the lowest level as the base.

——————————
David Wiser
Project Manager
Tigunia
Seattle WA
——————————
——————————————-

[Adam Jones]

Hi Ruth,

What we have done is to set up new fields on the item table, then use a factbox to look at this data in the sales order.

As this is also on the item card, we don’t have to be entering a sales order to view the info.  We don’t however use ALT UOM’s so I can’t tell you how this would handle them.

Many thanks.

——————————
Adam Jones
Celebration Paper & Plastics Ltd
Burton upon Trent
United Kingdom
——————————
——————————————-

[Joseph Flynn]

I’ve always worked in a multi location environment and add TI HI to the SKU table/card. Often times there is a need to have different pallet sizes in different locations.?

——————————
Joseph Flynn
Sr. Dynamics NAV Developer
Gold Star Foods INC
Ontario CA
——————————
——————————————-