Skip to main content
Question

ADD LOCATION TO REPORT HISTORICAL INVENTORY VALUATION - IN617000

  • October 26, 2023
  • 1 reply
  • 93 views
Q
Freshman I

I am trying to add location and qty in location to Historical Inventory Valuation Report - IN617000, but I have some location that doesn’t select ‘ cost seperate’. So, I get trouble to show both because with such as location that no cost seperate - the field ‘costsiteid’ show the ‘siteid’ instead of ’locationid’. I get trouble in join 3 tables including: INitemsitehist ( Location & Qty), INitemcosthist (Beg. Cost, End. Cost) and INitemcosthistbyPeriod(LastActivitiesPeriod)

Case 2

 

Q

1 reply

V
Freshman I
  • viwe47
  • Freshman I
  • February 20, 2025

​@quetruong Did you come right with this report? I’m also faced with the same issue

Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved