Search options (Page 8 of 12)

Some clients work on projects and their clients whom they do the project for wants the outstanding amounts on the invoices per project.

I thought that if you setup the project as a branch of the client that it might work, but you can not draw reports for the branch, only for the main company.

I also thought that you could setup each project with that client as a separate client, but then it becomes a nightmare to keep track of the cost items for that project.

Seems to be a hornet's nest like you say.

I am thinking of using an open source project management software for the tracking and costing of the project and then monthly bring in the total cost before invoicing from FA.

Regards

Thanks for the effort.

Seems there is no easy way around this.

Thanks, I assumed that it is the case, but would not have an idea where to begin to call this new function. in Rep108.pdf.

Your new.zip change works great accept for the Total Balance.

Is there a way that one could have a sub balance for the dimension and then the total balance below?

Would that be the same if one would use dimensions to filter in Customer Balances report Report101.pdf

Hi

I use a service item for Example ABC; total = 1 ; Price = 30; Discount = 10%; Result = 0

On the invoice only ABC is printed and the rest is blank. Nothing is shown in that line on the invoice. I need the line to show the above information.

regards

Apmuthu

The reports is providing the data require as per your zip file above.

When a dimension is selected for the report for that customer, it lists the correct entries in each line.

The Total at the bottom of the Statement report is the Total for all the dimensions for that customer, not just the total for specific Dimension selected.

I do not know if the above would fix the issue? It seems to the same as the info in the attached zip folder above.

regards

Wynand

Hi

Let me start by thanking you for your input.

Have replaced the files. The report does give the info required, but there are two issues that I can pick up:

1. The dimension Name is not displayed anywhere on the Statement
2. The dimension total is the same as the total outstanding for all the dimensions on that particular client and not just for the invoices outstanding for the specific dimension.

For example:

Dimension A and Dimension B is linked to the same customer. Drawing a reports then on the customer with no dimension selected gives you the answer for the total outstanding for A+B.

when selecting Dimension A, the Invoices and amounts listed in the detail matches the dimension, but the total for the Statement is still A+B instead of the total only for A

Hopes this makes sense, but it gives a great platform to work from.

Regards

Hi

I think that the statement report where invoices and payments are listed could work if you can search for a specific dimension attached to that Customer.  The customer balances report can also work.

Thanks. Will the js files recreate itself then again?

Hi Apmuthu, have tried that, to no avail. I will try in PHP5.3 and see what happens.