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.

Views: 62

▶ Reply to This

Replies to This Discussion

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

Hi

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

Thanks

Prasad

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. 

RSS

This Weeks Top Content 

1 Roll-up in PJC

Roll-up in PJC
2 New Intelligence Report error

New Intelligence Report error
3 Report Designer Add-in 1.2.0 always goes back to inactive after closed Excel

Report Designer Add-in 1.2.0 always goes back to inactive after closed Excel
4 Report Designer Menu not Showing

Report Designer Menu not Showing
5 New user missing Standard reports, options and filters

New user missing Standard reports, options and filters

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service