Open Forum

RE: NAV 2017
We use dimensions to track expenses and Assembly Orders created for a specific Job.  Sometimes invoices are posted without the correct dimension.  Sometimes Assembly Orders are created for stock and then pulled off the shelf and need to be assigned to a specific job dimension.  Is there anyway to change the dimension code for an invoice, assembly order, or any other document once it is posted in NAV other than reversing and recreating with the correct dimension codes?

Thank you,

------------------------------
Traci Albosta
Comitt Well Solutions LLC
Katy TX
------------------------------

Traci

Unfortunately, you will have to have your VAR/Partner write a customization to change the dimension values on posted document(s). After NAV 2009 (6.0), the dimension set id was introduced and swapping a dimension value on the table level went away. Your VAR/Partner will have to write a customization to identify if the new dimension set id already exist. If it doesn't, it must request a new set id from NAV and apply it to the transaction (posted document, ledger entries & GL entries). Not a rare request at all.

Reach out to them, Good Luck!

------------------------------
Alfredo Zelaya
Sr. Systems Analyst
Megadyne Americas LLC
Fairfield NJ
------------------------------

Original Message:
Sent: Aug 12, 2019 10:41 AM
From: Traci Albosta
Subject: Changing Dimensions after posting

RE: NAV 2017
We use dimensions to track expenses and Assembly Orders created for a specific Job.  Sometimes invoices are posted without the correct dimension.  Sometimes Assembly Orders are created for stock and then pulled off the shelf and need to be assigned to a specific job dimension.  Is there anyway to change the dimension code for an invoice, assembly order, or any other document once it is posted in NAV other than reversing and recreating with the correct dimension codes?

Thank you,

------------------------------
Traci Albosta
Comitt Well Solutions LLC
Katy TX
------------------------------

You may want to consider this add-on product. I have installed this for clients and found it to work well to meet their needs. My last install was on NAV 2016 but it is available up to 2018.
https://www.dynamicsnavaddons.com/dimension-management/

------------------------------
Cynthia Priebe MCP, DCP
Senior Analyst and Project Manager
Liberty Grove Software
------------------------------

Original Message:
Sent: Aug 12, 2019 11:10 AM
From: Alfredo Zelaya
Subject: Changing Dimensions after posting

Traci

Unfortunately, you will have to have your VAR/Partner write a customization to change the dimension values on posted document(s). After NAV 2009 (6.0), the dimension set id was introduced and swapping a dimension value on the table level went away. Your VAR/Partner will have to write a customization to identify if the new dimension set id already exist. If it doesn't, it must request a new set id from NAV and apply it to the transaction (posted document, ledger entries & GL entries). Not a rare request at all.

Reach out to them, Good Luck!

------------------------------
Alfredo Zelaya
Sr. Systems Analyst
Megadyne Americas LLC
Fairfield NJ

Original Message:
Sent: Aug 12, 2019 10:41 AM
From: Traci Albosta
Subject: Changing Dimensions after posting

RE: NAV 2017
We use dimensions to track expenses and Assembly Orders created for a specific Job.  Sometimes invoices are posted without the correct dimension.  Sometimes Assembly Orders are created for stock and then pulled off the shelf and need to be assigned to a specific job dimension.  Is there anyway to change the dimension code for an invoice, assembly order, or any other document once it is posted in NAV other than reversing and recreating with the correct dimension codes?

Thank you,

------------------------------
Traci Albosta
Comitt Well Solutions LLC
Katy TX
------------------------------

I agree with Cathy as I was going to suggest same.   I have worked with some people from Dynamicsnavaddons and they are good.

------------------------------
David Cameron
Microsoft Financial Consultant
Templer Group
ANCASTER ON
------------------------------

Original Message:
Sent: Aug 12, 2019 11:14 AM
From: Cynthia Priebe MCP, DCP
Subject: Changing Dimensions after posting

You may want to consider this add-on product. I have installed this for clients and found it to work well to meet their needs. My last install was on NAV 2016 but it is available up to 2018.
https://www.dynamicsnavaddons.com/dimension-management/

------------------------------
Cynthia Priebe MCP, DCP
Senior Analyst and Project Manager
Liberty Grove Software

Original Message:
Sent: Aug 12, 2019 11:10 AM
From: Alfredo Zelaya
Subject: Changing Dimensions after posting

Traci

Unfortunately, you will have to have your VAR/Partner write a customization to change the dimension values on posted document(s). After NAV 2009 (6.0), the dimension set id was introduced and swapping a dimension value on the table level went away. Your VAR/Partner will have to write a customization to identify if the new dimension set id already exist. If it doesn't, it must request a new set id from NAV and apply it to the transaction (posted document, ledger entries & GL entries). Not a rare request at all.

Reach out to them, Good Luck!

------------------------------
Alfredo Zelaya
Sr. Systems Analyst
Megadyne Americas LLC
Fairfield NJ

Original Message:
Sent: Aug 12, 2019 10:41 AM
From: Traci Albosta
Subject: Changing Dimensions after posting

RE: NAV 2017
We use dimensions to track expenses and Assembly Orders created for a specific Job.  Sometimes invoices are posted without the correct dimension.  Sometimes Assembly Orders are created for stock and then pulled off the shelf and need to be assigned to a specific job dimension.  Is there anyway to change the dimension code for an invoice, assembly order, or any other document once it is posted in NAV other than reversing and recreating with the correct dimension codes?

Thank you,

------------------------------
Traci Albosta
Comitt Well Solutions LLC
Katy TX
------------------------------

Thank you very much for the information.  I will look into the add-on.

Traci

------------------------------
Traci Albosta
Comitt Well Solutions LLC
Katy TX
------------------------------

Original Message:
Sent: Aug 12, 2019 02:31 PM
From: David Cameron
Subject: Changing Dimensions after posting

I agree with Cathy as I was going to suggest same.   I have worked with some people from Dynamicsnavaddons and they are good.

------------------------------
David Cameron
Microsoft Financial Consultant
Templer Group
ANCASTER ON

Original Message:
Sent: Aug 12, 2019 11:14 AM
From: Cynthia Priebe MCP, DCP
Subject: Changing Dimensions after posting

You may want to consider this add-on product. I have installed this for clients and found it to work well to meet their needs. My last install was on NAV 2016 but it is available up to 2018.
https://www.dynamicsnavaddons.com/dimension-management/

------------------------------
Cynthia Priebe MCP, DCP
Senior Analyst and Project Manager
Liberty Grove Software

Original Message:
Sent: Aug 12, 2019 11:10 AM
From: Alfredo Zelaya
Subject: Changing Dimensions after posting

Traci

Unfortunately, you will have to have your VAR/Partner write a customization to change the dimension values on posted document(s). After NAV 2009 (6.0), the dimension set id was introduced and swapping a dimension value on the table level went away. Your VAR/Partner will have to write a customization to identify if the new dimension set id already exist. If it doesn't, it must request a new set id from NAV and apply it to the transaction (posted document, ledger entries & GL entries). Not a rare request at all.

Reach out to them, Good Luck!

------------------------------
Alfredo Zelaya
Sr. Systems Analyst
Megadyne Americas LLC
Fairfield NJ

Original Message:
Sent: Aug 12, 2019 10:41 AM
From: Traci Albosta
Subject: Changing Dimensions after posting

RE: NAV 2017
We use dimensions to track expenses and Assembly Orders created for a specific Job.  Sometimes invoices are posted without the correct dimension.  Sometimes Assembly Orders are created for stock and then pulled off the shelf and need to be assigned to a specific job dimension.  Is there anyway to change the dimension code for an invoice, assembly order, or any other document once it is posted in NAV other than reversing and recreating with the correct dimension codes?

Thank you,

------------------------------
Traci Albosta
Comitt Well Solutions LLC
Katy TX
------------------------------