Different Unit Cost and Price each location

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 6 Replies | 1 Follower

Female
64 Posts
605 Points
Joined: 2011-8-19
Last Online:
2013-5-22 8:13
Location: Cebu, Philippines
Bhing posted on 2012-10-1 9:09

Hi NAV Expert

Is it possible to have different unit cost and price assigned for item per location?

Also, Is there any disadvantage if I enable the functionality of Change Log Set up with selected tables to record (i.e insertion, modification & deletion)?

Please advice.

 

 

Thanks and best Regards,

Bhing

All Replies

Male
2,350 Posts
34,180 Points
Joined: 2006-4-10
Last Online:
2013-6-19 15:45
Location: Pune India
Moderator
Amol replied on 2012-10-1 10:34

Yes you can have different price for every location

I foresee there is no disadvantage in activating change log setup for tables but try to activate the change log for selected fields in tables rather than entire field list because it is unnecessary increase your DB size.

As well as periodically delete the change log entries this will keep you DB size in control.

 

-Amol

http://dynamicsuser.net/blogs/amol

Don't forget to  the post(s) that solved your problem

Female
64 Posts
605 Points
Joined: 2011-8-19
Last Online:
2013-5-22 8:13
Location: Cebu, Philippines
Bhing replied on 2012-10-1 11:04

Hi Amol

What functionality should I used to activate different unit cost & price per location?

Thanks and best Regards,

Bhing

Male
2,350 Posts
34,180 Points
Joined: 2006-4-10
Last Online:
2013-6-19 15:45
Location: Pune India
Moderator
Amol replied on 2012-10-1 11:14

Default system doesn't maintain default locationwise price

1) Define Customer price group and attached the price to those group

2) You need to customize if you want to maintain the price location wise for every customer.

-Amol

http://dynamicsuser.net/blogs/amol

Don't forget to  the post(s) that solved your problem

Male
299 Posts
4,595 Points
Joined: 2007-6-29
Last Online:
2013-6-19 17:21
Location: Budapest
faludigabor replied on 2012-10-1 13:32

Hi,

 

if you are using average cost  then NAV can maintain UC per location by standard functionality. 

 

Look for financial management\inventory\setup\inventory setup 

Average Cost calc type  : Item & Location & Variant

 

Change log : Like Amol says no major downside's - just space increase -> performance implications  long term.  IF you clean up then no issue. 

 

G.

(available for freelance/contract)

www.fits.hu

Navision blog :

www.fits.hu/navblog 

 

Female
64 Posts
605 Points
Joined: 2011-8-19
Last Online:
2013-5-22 8:13
Location: Cebu, Philippines
Bhing replied on 2012-10-2 12:15

Hi,

If I used FIFO as costing method, is it I can still used or maintain different unit cost & price per location?

 

Thanks and best Regards,

Bhing

Male
299 Posts
4,595 Points
Joined: 2007-6-29
Last Online:
2013-6-19 17:21
Location: Budapest
faludigabor replied on 2012-10-2 14:03

Nope , not out of the standard system.

 

g.

(available for freelance/contract)

www.fits.hu

Navision blog :

www.fits.hu/navblog 

 

Page 1 of 1 (7 items) | Get this RSS feed | Bookmark and Share