Profit Loss and Custom Report give different Inventory Cost amount

1

Need help please, I’m trying to generate Inventory Cost report per customer with Custom Report. But the amount of Inventory Cost from the report is different from the amount of Inventory Cost in Profit Loss report.

Here is the Profit Loss statment, the Inventory Cost is the account in the red box

inventory-cost-cash-basis
inventory-cost-cash-basis1422×1128 223 KB

Here is the resolt of Inventory Cost of every transaction both from Profit Loss (by clicking the HARGA POKOK PENJUALAN account) and from Custom Report.

pl-vs-custom-report
pl-vs-custom-report1215×682 153 KB

The settings I use to generate the Inventory Cost from Custom Report

custom-report-settings
custom-report-settings681×851 36.8 KB

Is my approach is wrong? or it is a bug?

Thank you

2

Do not use old custom reports anymore. They are obsolete and going away. Old custom reports wouldn’t be able to give you inventory cost per customer anyway.

New custom reports can do this fairly easily:

image
image545×546 12.2 KB

This will give you inventory cost per customer / inventory item pair for the period.

You will need the latest version (20.6.49) for this.

1 Like
3

Thanks for quick response Lubos