Question

Shop Order WIP Report

  • 6 April 2021
  • 3 replies
  • 233 views

Userlevel 6
Badge +10

HI All,

 

Does any one has a Shop Order WIP that can be run to a given date?

The standard WIP report available in application can be run only for today’s status.

 

Thanks


This topic has been closed for comments

3 replies

Userlevel 3
Badge +6

Hi 

I normally create a report schedule so that it runs at midnight for each period end.  

If your periods do not end on calendar periods but say on a 4 4 5 basis, then schedule it to run weekly at end of week.  

 

Userlevel 4
Badge +7

Calculating the WIP status retrospectively should be difficult, so it makes sense why IFS standard is limited to running the report for current WIP. What you can do is as an extension to what Antbarrif has mentioned, schedule the report to archive a copy each day, and then have a custom procedure that will read the report’s archived data table and then write to a custom table from which you can run a custom report (i.e. a quick report).

Userlevel 6
Badge +10

Thanks for the suggestions.