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: 95

▶ 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 Excel Question for a Combined report

Excel Question for a Combined report
2 Add In: ExtendFormulaeToUsedRows

Add In: ExtendFormulaeToUsedRows
3 Access Denied on Function

Access Denied on Function
4 Sage X3 Intelligence Reporting : An unexpected error occurred. Error Number : [3704]. Description : [Operation is not allowed when the object is closed.]. Source : [ADODB.Recordset]

Sage X3 Intelligence Reporting : An unexpected error occurred. Error Number : [3704]. Description : [Operation is not allowed when the object is closed.]. Source : [ADODB.Recordset]
5 Drill Down Add-In

Drill Down Add-In

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service