• From: Nicaragua, Leon
  • Registered: 05/12/2012
  • Posts: 74

Topic: Sales report per article

After using FA only for cost recording during construction of our hotel, we have now entered into business and we have been using FA for a little more than a month as a complete EPR, and it works great. 
As it is a hotel, all our sales are services.  We have defined 6 different room types and ectra payment for additional persons (also defined as an article).  However, I have found no way to make a sales report per article, i.e. how many nights have we sold room type 1 etc. in a given period.  Have I missed something?  I can of course make a query in MySQL but it would have been nice to be able to do it directly in the program.

thorbjornw's Website

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

Re: Sales report per article

Please have a look in both the sales reports as well as items and inventory reports,

I guess there should be some you can use.

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Sales report per article

There is an Item Sales Summary Report in the addon extensions and a standard Customer wise sales summary report in the core.

Check the wiki - Reports and Analysis
https://frontaccounting.com/fawiki/index.php?n=Help.ReportsAndAnalysis

@Joe - please clean up the Wiki Sidebar and place Reports and Analysis on it as well.

apmuthu's Website

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

Re: Sales report per article

The help for reporting is context sensitive. Can this be better? Hoerver I will think about it.

Joe

  • From: Nicaragua, Leon
  • Registered: 05/12/2012
  • Posts: 74

Re: Sales report per article

I am quite sure there is no item sales report in FA as I have been around all the corners.  As the items are services, there is (of course) nothing in the inventory report.  I shall try out the suggested Item Sales Summary Report extension and report back.

thorbjornw's Website

  • From: Nicaragua, Leon
  • Registered: 05/12/2012
  • Posts: 74

Re: Sales report per article

I now installed the sales report extension and that was exactly what I was looking for.  Issue solved, thanks. smile

thorbjornw's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Sales report per article

@Joe: please consider including the (Item) Sales Summary Report extension as part of the core as it should really be there.

apmuthu's Website

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

Re: Sales report per article

Ok, I will.

/Joe

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

Re: Sales report per article

Fixed. HG repository updated.

/Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Sales report per article

Thanks Joe. You've named the report &Sales Summary Report, Detailed

It might have been better to be "Item &Sales Summary Report" to distinguish it from the Customer one.

apmuthu's Website

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

Re: Sales report per article

Done. You may now remove the custom report, Sales Summary Report, from the Item and Inventory Reports. This new report replaces this one.

/Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Sales report per article

Thanks Joe.

Updated the Wiki at:
https://frontaccounting.com/fawiki/index.php?n=Help.ItemSalesSummaryReport
and
https://frontaccounting.com/fawiki/index.php?n=Help.ReportsAndAnalysis

apmuthu's Website