1 Topic by Joe2 (edited by Joe2 06/21/2023 01:03:50 pm)

  • Joe2
  • New member
  • Offline
  • From: Singapore
  • Registered: 12/20/2016
  • Posts: 6

Topic: Inventory valuation report error for locations after stock transfer

Hi,

Regarding the Inventory valuation report,
Sum of each location value is not equal with All location value, after location transfers.

Transferred item cost are calculated with new location cost, instead of old location cost.

For example,
I get 2 locations ( L1 and L2 ) and one product A.
There is 1 qty in L1 with cost $1 ( L1 total value is $1)
There are 2 qty in L2 with cost $2 ( L2 total value is $4)
Total cost value for All location is $5. ( it is correct before undergoing a transfer )

After doing a transfer of 1 qty from L2 to L1, the result showing as followed,
2 qty in L1 with cost $1 ( L1 total value is $2)
1 qty in L2 with cost $2 ( L2 total value is $2)
so, sum of each location value is $4, which is not correct.
If I select all location, the result is showing $5, which is correct.

So, We get problem to get inventory valuation by each location after stock transfer.

Please advise.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,163

Re: Inventory valuation report error for locations after stock transfer

Since the product costs are different across locations, make them appear as 2 different items with specific costs. That way, transfers will show up as at appropriate costs across locations.

apmuthu's Website

  • Joe2
  • New member
  • Offline
  • From: Singapore
  • Registered: 12/20/2016
  • Posts: 6

Re: Inventory valuation report error for locations after stock transfer

Yeah, there must be specific cost value for each location, but the specific cost is not correct for each location currently.
So, we can only use the report of all location value as correct figure,
Value of each location is not correct and sum of them are not equal to all location report figure.

  • From: Nigeria, Ilorin
  • Registered: 09/20/2022
  • Posts: 15

Re: Inventory valuation report error for locations after stock transfer

I currently have the same error with V2.4.16.
Inventory valuation of some items in other location is 0.00 while in "NO location filter" it appears with the correct value or, more than the average unit value.