Hi All,
I have the unique requirement from customer that they would like to have the average cost to be calculated for some location to be on individual location level but for some other locations, they would like the average cost to be calculated using group of locations.
Example
They have
Location A
Location B
Location C
If the sales is from the Location A system to calculate avg. cost on Location level A.
But if the sales is from Location B or Location C, system to calculate the average cost using location B and C both.
So, for ITEM X,
Purchase Location A (Qty = 1) $10
Purchase Location A (Qty = 1) $20
Purchase Location B (Qty = 1) $20
Purchase Location C (Qty = 1) $30
Purchase Location C (Qty = 1) $40
What they want,
Sales Location A (Qty = 1) $15
Sales Location B (Qty = 1) $30
but NAV ,assuming I have set the costing on item / variant / location level, will give following results,
Sales Location A (Qty = 1) $15
Sales Location B (Qty = 1) $20
I planning to change the program to handle this by modifying cost adjustment routine so that while calculating the average cost to look for one location / multiple location based on setup maintained on individual Location.
Before I do that , I would like to have opinion from you all, has someone case across this requirement before? Is there any other way to handle this rather than changing the program?
Please suggest.
Thanks.
0
Comments
Use Bins instead to track inventory in those GroupLocation.
If you do the mod, we are talking of 100's of hours of development and huge number of objects modified and increased risk of the project and upgradability.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I totally agree with you that change will be huge and that's why want to have second opinion / workaround.
Do we any other solution rather than using BINS (customer doesn't have anything do with the warehousing), so will be difficult to push for the BIN solution.
Thanks.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I understand using BINs could be one option, but do we have any other way to address this?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n