After CO month end -- Need to solve quickly

Dear all,

We have a scenario in sales order costing with sale order is cost object with valuated stock

Major issue is after running month end in CO, client is checking a Z-report which is developed for cost of sales

In this report client is checking profit and loss statement for the month of JAN 2012 which should show net profit of SAR 2 million instead of current net loss of SAR 4 million for the sales of SAR 9 million.

The major problam lies with inventry change in account whic is showing negative balance of SAR 7 million in the profit and loss account.

When I checked WIP in KKAO system is showing WIP(cumulative is zero) and WIP ( period ) is showing negative balance..

For the some of the orders I am still able see the amount with negative sign in the WIP ( period ) column of the report after order status as delivered..

In the Z-report system is showing change in inventry account amount as (7 millions)..

WIP calculation is at actual cost

Scenario:

Client create sales order only for make order no stock..

Production order are created with reference to sale order..

For each production there will multiple production orders in a single header production order

Some times client is issuing materials at header order directly instead of each order level..

some times issuing only material with no actual activies and taking GR from order then it flows to header order..

Please provide your valueble inputs as it is very urgent for the client..

Thanks,

Janki