FrontAccounting forum — Inventory Sales Report

Re: Inventory Sales Report

2015-04-29T20:08:28Z

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

Re: Inventory Sales Report

2015-04-29T19:27:35Z

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

Joe

Re: Inventory Sales Report

2015-04-29T18:42:33Z

can this new report be in next update to Front?

Re: Inventory Sales Report

2015-04-29T18:41:19Z

can this new report be in next update to Front?

Re: Inventory Sales Report

2015-04-14T03:46:21Z

wow! thanks.

Re: Inventory Sales Report

2015-04-12T11:27:30Z

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

Re: Inventory Sales Report

2015-04-11T07:27:01Z

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

Re: Inventory Sales Report

2015-04-11T06:08:10Z

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

Joe

Re: Inventory Sales Report

2015-04-10T18:18:50Z

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

Re: Inventory Sales Report

2015-04-10T06:02:34Z

@Mark,

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

/Joe

Re: Inventory Sales Report

2015-04-10T05:33:58Z

I will have a look ito this.

Joe

Re: Inventory Sales Report

2015-04-10T05:17:38Z

@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?

Re: Inventory Sales Report

2015-04-09T19:32:32Z

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?

Re: Inventory Sales Report

2015-04-07T11:40:45Z

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

Inventory Sales Report

2015-04-06T11:20:34Z

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.