Yes, why not. Just like the Inventory Items Movements inquiry, right?
But you will have to wait until release 2.2 for this I guess. Maybe it could be in 2.1.4 if this would be released before.

/Joe

Greetings, Joe.

Thanks for your prompt reply. Glad to hear that.

The customer balance rpt breakdown the data for invoice, outstanding amount & payment received from the customer and it's based on customer by customer.

As for the Item Balance rpt that I'm thinking of, it breakdown base on item instead of by customer and there will be no customer info in the item sales balance report. it show the invoice transaction, outstanding amount & payment received for the item.

The customer balance rpt was breakdown by customer but hopefully can have a new item sales balance report which can breakdown by the item name
[img]http://i.iimmgg.com/images/gr/2cef2a012019fbec962791e4ce075078.jpg[/img]

I'm trying to make the report but I can't do it as I'm still new in php & Mysql and the design of "debtor_trans" & "debtor_trans_details" is difficult for me to play around with them.
[img]http://i.iimmgg.com/images/gr/ba79f98b9eda7e56e02a68d296f57965.jpg[/img]

Really appreciate if you can make this report.

Thanks!!!

/Joe

Is it possible to have an Item Balance report?(just like the Customer Balance report)

Tanks for the info. I will give it a try.

Really appreciate your help.

God bless you!

Download the revision 1.5
and the file /reporting/reports_main.php:

Download the revision 1.11

Both files are belonging to CVS Main trunk (2.1.3)

/Joe

https://frontaccounting.cvs.sourceforge.net/viewvc/*checkout*/frontaccounting/frontaccount/reporting/rep304.php?revision=1.5

Is this is the link you referred to?
http://fa2.iron.from.pl/reporting/reports_main.php?Class=2&rep_id=304

I have problem to view the report, nothing appears after clicked the link. Not sure whether is because of my ISP connection issue or not.

/Joe

Thanks for the prompt reply. Have a nice holiday!

Regards,
kee

/Joe

Is there any way to print out the reports as below? or do FA have the following report pattern?

For example,

[Item A]
* Number of the QTY that ordered by customers
* Amount/payment that we have received for the item A

Thanks,