They are temporary tables populated when printing/previewing reports - check out this post: sagecity.na.sage.com/.../37357.aspx

Thanks, That answered one of my question ,why are those "..Wrk" tables there..

1. Preview desired report.

2. Locate data and time stamped works table.

3. Rename original works table for restoration later.

4. Remove data and time stamp from works table.

5. User Crystal designer to open report and edit.

6. When you refresh data will appear.

7. When finished delete works table with data and rename original empty works table back to original name.

Posted by BigLouie

..

Now, i need to find the way from where i can retrieve info for Valuation report by Period.

If anyone had get into this, pls let me know..

A little known secret is that the Valuation by Period report is not accurate, close but not accurate.  You have two options. Use the IM_PeriodPostingHistory  table or the  IM_ItemTransactionHistory table and build a report based on either table to get what you need.