FrontAccounting forum — Itemize & sales report?

Re: Itemize & sales report?

null@example.com (jourdan) — Thu, 16 Jul 2009 01:41:36 +0000

joe wrote:

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!!!

Re: Itemize & sales report?

null@example.com (joe) — Wed, 15 Jul 2009 12:54:08 +0000

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

Re: Itemize & sales report?

null@example.com (jourdan) — Wed, 15 Jul 2009 11:04:06 +0000

Hi, Joe.

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

Re: Itemize & sales report?

null@example.com (jourdan) — Sun, 12 Jul 2009 14:00:38 +0000

Hi, Joe.

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

Really appreciate your help.

God bless you!

Re: Itemize & sales report?

null@example.com (joe) — Sun, 12 Jul 2009 13:55:49 +0000

This is the correct link:

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

Re: Itemize & sales report?

null@example.com (jourdan) — Sun, 12 Jul 2009 05:08:01 +0000

or this is the file?

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

Re: Itemize & sales report?

null@example.com (jourdan) — Sun, 12 Jul 2009 04:54:13 +0000

Hi, Joe.

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.

Re: Itemize & sales report?

null@example.com (joe) — Sat, 11 Jul 2009 09:22:14 +0000

Please try the new /reporting/rep304.php at the CVS Main Trunk.

/Joe

Re: Itemize & sales report?

null@example.com (jourdan) — Tue, 07 Jul 2009 15:15:05 +0000

Hi, Joe.

Thanks for the prompt reply. Have a nice holiday!

Regards,
kee

Re: Itemize & sales report?

null@example.com (joe) — Tue, 07 Jul 2009 14:51:08 +0000

I guess there is some report that reports the sales. It could eventually be changed to include a column with this info. I will have a look at it when returning from a holiday. Back on Friday.

/Joe

Itemize & sales report?

null@example.com (jourdan) — Tue, 07 Jul 2009 09:05:19 +0000

Hi,

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,