BIC Stock Valuation report for sage evolution

Hello

I am building a BIC report for sage evolution that picks the quantity as per the date selected on the parameter window.Currently when I pick a date prior to date the report shows me the stock quantity as at now(This is based on the costtrackingID and date stamp generated) but I want the report to show me the correct quantity as at the date selected on the parameter.

▶ Reply to This

Replies to This Discussion

Permalink Reply by Prasad Thutta on February 12, 2018 at 1:51pm

Have you been successful generating this kind of report in the past?

Thanks

Prasad

▶ Reply

Permalink Reply by Kimaru Austin on February 13, 2018 at 8:36am

Hi Joseh, nitumie copy of the report I see if I can make adjustments for you, somehting tells me if we create a strored procedure that creates a temp table that takes the selected date, this is possible.