COGS and Change in Inventory Reporting

Dear All,

Client want to Cross Verify the Cost of Goods Sold (COGS) during the Month with change in inventory during the month in the system, how can we do that.

Example

In F.01

If we enter 1 to 5 period in Reporting periods

And we enter 1 to 4 period in Comparison periods

We will get the difference between the 4 and 5th period in difference column

So the material GL account will show the difference in difference column that will be equal to change in inventory during the month.

Now they want to cross verify this amount with COGS.

Regards,

Shayam