• Registered: 07/02/2009
  • Posts: 12

Topic: Itemize & sales report?

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,

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Itemize & sales report?

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

  • Registered: 07/02/2009
  • Posts: 12

Re: Itemize & sales report?

Hi, Joe.

Thanks for the prompt reply. Have a nice holiday!

Regards,
kee

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Itemize & sales report?

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

/Joe

  • Registered: 07/02/2009
  • Posts: 12

Re: Itemize & sales report?

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.

  • Registered: 07/02/2009
  • Posts: 12

Re: Itemize & sales report?

or this is the file?

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Itemize & sales report?

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

  • Registered: 07/02/2009
  • Posts: 12

Re: Itemize & sales report?

Hi, Joe.

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

Really appreciate your help.

God bless you!

  • Registered: 07/02/2009
  • Posts: 12

Re: Itemize & sales report?

Hi, Joe.

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Itemize & sales report?

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

11 Reply by jourdan (edited by jourdan 07/16/2009 06:27:28 am)

  • Registered: 07/02/2009
  • Posts: 12

Re: Itemize & sales report?

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. smile

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. sad
[img]http://i.iimmgg.com/images/gr/ba79f98b9eda7e56e02a68d296f57965.jpg[/img]

Really appreciate if you can make this report.

Thanks!!!