• From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Topic: Inventory Sales Report

Sales of service items don't appear in the Inventory Sales Report (ISR)
This means that if I run the ISR it does not balance to the GL Sales in the Profit and Loss.
It would be better if the ISR included sale of service items so that it balances to the P&L.

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

Re: Inventory Sales Report

If you wish to track inventory of Services, then create a Service Item of Inventory Type (and not Service Type) and put in a huge value of stock so that it does not run out... A separate stock category if you want.....

apmuthu's Website

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Inventory Sales Report

Hi Apmuthu
you can't do that as the "inventory item" will be included in your balance sheet as stock which will reflect a huge incorrect value of stock that does not exist which would be very bad if you're using Front for accounting not just invoicing.

Front can't report the sale of services like in the Inventory Sales Report....

Category  Description                     Customer   Qty    Sales       Cost     Contribution
Service     Programming                   ABC Ltd     3     15 000       -            15 000
Service     Server Management         XYZ Ltd     1       2 000       -              2 000

It would be really helpful if it could.
Maybe there is someone out there who can add this report?

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

Re: Inventory Sales Report

@MarkAndrew: You're right, the stock throws the balance sheet off. The report must have a flag to include service items as well.

@joe: any closure?

apmuthu's Website

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

Re: Inventory Sales Report

I will have a look ito this.

Joe

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

Re: Inventory Sales Report

@Mark,

Can't you just use the report 'Item Sales Summary Report' for this purpose?

/Joe

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Inventory Sales Report

It doesn't show customer and product. Only inventory sales report does.

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

Re: Inventory Sales Report

Ok, I guess it could be done. Give me some time.

Joe

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

Re: Inventory Sales Report

This has been implemented in release 2.3.24. Git repository updated. Two files can be downloaded here

/reporting/reports_main.php and
/reporting/rep304.php .

Replace the files on your server.

/Joe

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

Re: Inventory Sales Report

@joe: Thanks for a quick one.
Wiki-ed the updated screenshot for Rep304 and attached herein.

Post's attachments

ISR.png 31.5 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Inventory Sales Report

wow! thanks.

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Inventory Sales Report

can this new report be in next update to Front?

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Inventory Sales Report

can this new report be in next update to Front?

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

Re: Inventory Sales Report

If you mean report 304, that we just fixed, then the answer is yes. This report is automatically included in the next release.

Joe

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

Re: Inventory Sales Report

The snapshot in the repo can be used directly without having to wait for a new release.

apmuthu's Website