Finance | Project Operations, Human Resources, ...

How to get a WIP report that reconciles to the TB for our auditors

(0) Share

Report

Posted on by fergarb

Our auditors want a breakdown of WIP projects/production orders as of period end (31 December) showing the total cost in that particular project, that totals and is equal to the WIP trial balance code as of period end for their testing. How do I generate such a report?

I have the same question (1)

All responses (3)

Answers (0)

Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi fergarb

There are total 3 types of Positive WIP and 1 Negative WIP that you need to reconcile with GL.

Following can be found from Report and you can easily reconcile with GL if you are using separate GL:

1. Material in progress - Production Control > Inquiry & Report > WIP Report > Material in progress (This is Positive WIP - Accumulation)

2. Indirect costs in process - Production Control > Inquiry & Report > WIP Report > Indirect costs in process (This is Positive WIP - Accumulation)

3. Work in Progress - Production Control > Inquiry & Report > WIP Report > work in process (Labor hours) (This is Positive WIP - Accumulation)

Last one in Finish Goods "Reported as Finish" > we do not have any specific report available in system. I normally take from production posting inquiry form with filter on Journal as "Report as Finished" and in advance filter Production Order having status = !Finished. This is negative WIP, as this is normally deducted from GL.

If you are not using separate ledger in that case, add all this data and try to reconcile with your GL, it will give you proper required data.

Let us know if this helps.

Thanks,

Was this reply helpful? Yes No
fergarb 5 on at

Like (0)

Report

Hi Gaurangkumar, thank you for the detailed guide above. I have followed it through to the final step, I am struggling with the final step in adding the advanced filter to only show non finished orders as the when adding the filter field, none of the available fields have Status as an option

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi fergarb

You need to go to advance filter and require join the Production order table to apply this filter.

Please let me know if this helps.

Thanks,

Was this reply helpful? Yes No