Can we maintain the average cost for a group of Items
Hello,
Product Version 12.1.3
we are manufacturer of yarn and cotton is our raw material. for same raw material we have opened three item codes as
1- Item Code + Running Season + Cheapest Region
2- Item Code + Odd Season + Different Region
3- Item Code + Odd Season + Odd region
we use mix of these three items due to some moisture and other attributes. this is our business requirement to track this mix.
however our financial requirement is to average out the average rate of inventory across three items making a group .
can you please advise suitable solution / work around
Thanks
Sudhir