Dynamics Community Forum Thread Details

SOP History w/ some missing categories

I recently was able to query the SOP302-303 and match with SOP 101-102 records to almost complete a report that until now was being done in a manual process.

However the only problem is that some of the records are blank, they have zeros for price. The last month I had records for is Feb. 2009. For one thing, how does that happen? What is the mechanism needed to set History records to be a little more up to date ?

It is possible that Feb. is in history for some of the categories and not the others. In this case, I am reporting on a large group of nursing home facilities for P&L so we need to see all the products that were used by each facility.

It was suggested to me that I Query the data to see if there are any food orders within history and current for that period. It is possible that those sales were not posted to history and are only current. I can query the actual data and see what's there. (or in GP zoom down to the food orders and get sales numbers for the months I am looking for and then query to see which table those sales numbers are), but I don't know the tables needed.

I am not sure which tables that means, the SOP101 and 102? Please note that I don't have a full access to the system but just to the tables as I am on the reporting end. I will need to shore up my knowledge of GP if this engagement continues, God willing.

Quick Links

Leaderboard