Table that stores monthly "beginning qty"

Question

Hi guys, 
 Would you please lend me your hand in finding the table that stores beginning qty (and also value) for inventory? Basically, i'm trying to replicate the "5.History" tab in Inventory Inquiry. I've looked into IM_PeriodPostingHistory, IM_ItemWhseHistoryByPeriod, and coming up empty. 
 The IM_PeriodPostingHistory has the beginning qty for inventory only on period 01, which might be due to accounting practice. Where does the History tab get the numbers from?? The near-instant speed tells me it's not calculating, o r do we actually have to back-calculate the quantities?? 
 Ken

Kevin M · Answer

For the main query, use the outer join to create your table structure, just to get the item / year / period (or item / whse / year / period) list, then do sub-queries of the summary table (i.e. column = a select statement), making the join stuff easier. 
 This strategy might not be as fast to run, but it is much easier to write.

Sage 100

Table that stores monthly "beginning qty"

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING