Since the anniversary update of MS Win10 there seems to be serious problems with PDF printing.

At least mine is displaying on the screen, but when I print the document it over print the line items with just black lines that nothing is displayed.

Found a temporary work around. When Print, select advanced on the printer menu and select print pdf as an image. Then it prints without the think black horizontal lines.

I am using 2.3.25 and it seems to open the pdf. It the PC you are using does not have Acrobat installed it will not open. Once Acrobat is installed, then it opens, but popups needs to be activated.

152

(13 replies, posted in Reporting)

In the config file there is also an option on line 74:

/* Do not print zero lines amount of 0.00 in Sales Documents if service item. 1 = do not */
    $no_zero_lines_amount = 1;

When you install, click on top and select "Activated for..." Select it and put tick mark in the box for the Cash flow

154

(10 replies, posted in Reporting)

Thanks

155

(18 replies, posted in Items and Inventory)

On the inventory planning report some stock items indicate that zero for the months 1,2,3,4 5 and 3*M and indicates 20 for QOH; 3 for CustOrd; 0 Supp Ord, 0 Sugg Ord.

There were however transactions for months 1,2,3,4,5 and there should be an amount for 3*m. Why would it not display these transactions on some stock items?

It makes it very difficult to plan stock this way. When the Inventory Item Movement report and inquiry is drawn, it indicates that there were movements for the specific stock item for the same periods.

Suggestions would be appreciated. Unfortunately I am not able to add attachments.

Regards

Wynand

156

(10 replies, posted in Reporting)

Not sure what you are talking about.

157

(10 replies, posted in Reporting)

That is true, it is a document send to the customer.

If you do not select the the show allocated, it will display the outstanding invoices. When the show allocated is selected to yes, it will give the history for the entire period that the client is with the company. In some cases this could be many pages long.

If it was possible to select the period begin and end date, then it will have an opening balance if there was any outstanding invoices and at the end a closing balance. This is normally done monthly. 

I now draw draw a Customer Balances report and print it to Excel, after which I copy it into a word document to create a statement with a begin and end date.

158

(10 replies, posted in Reporting)

It seems that even though you set fiscal year to current, it will display on the statement all the open fiscal years information and not just the current fiscal year when you select show allocated.

Hi

Is it possible to add a start and end date on the Customer Statement under reports.

If you select the show Allocated, it prints all the transactions that the client ever had with you, instead of allocations for a specific period.

It also displays the info on the day that you draw the report.

One can do the begin and end dates with the Customer balances.

Regards

160

(4 replies, posted in Modules Add-on's)

I also had the same issue. At the end I went through every single customer to add their respective branches. The info is there, it is just not linking after the import, but when you open the customer and click on add/edit branch, it automatically recreate the branch for the customer. With multiple branches it is a bit more of a challenge.

Hi

I created a Barter Bank account under the section "Control accounts" in my Balance Sheet, and would do transactions through bank deposit and Bank payments on this Barter Bank account through the Banking and GL Tab..

You would use your normal GL accounts for income (or you can create a different income account) and expenses for example (motor repairs).

At the end of the month

162

(1 replies, posted in Wish List)

I found what seem to an abandoned POS project on SourceForge.

Maybe one can ingrate this into FA. This is one thing that is still needed in FA.

https://sourceforge.net/projects/phpwpos/?source=recommended


Any comments?

163

(16 replies, posted in Reporting)

Thanks.

Was also thinking in the line of dotproject or openproject.

Will have a look at your suggestion.

Regards

164

(16 replies, posted in Reporting)

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

165

(13 replies, posted in Reporting)

Thanks. Have done something similar but have setup a service item linked to the discount given account  in the ledger.

I though there might a a tick mark or display zeros or something that might be easier, but you idea works great as well.

Regards

166

(13 replies, posted in Reporting)

Thanks for the effort.

Seems there is no easy way around this.

167

(13 replies, posted in Reporting)

apmuthu wrote:

rep107.php (Print Invoice) does not show the rate and discounts

Thanks

Agree, but what should I change in the rep107 to show the item cost and the 100% discount on the invoice with 0 toal for the line item?

168

(16 replies, posted in Reporting)

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

169

(13 replies, posted in Reporting)

I do that, but when you print the invoice (Pdf) file, on the report, it does not display the amount nor the discount

170

(13 replies, posted in Reporting)

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

171

(16 replies, posted in Reporting)

Is there a way that I can send you copy of the report with the data?

At the bottom of the reports where it reads: "Total Balance" it is the total balance for all the dimensions relating to that on customer, instead of the Total for that one selected dimension only.

172

(16 replies, posted in Reporting)

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

173

(16 replies, posted in Reporting)

HI

It would also be great if we could save the statement as Excel.

174

(16 replies, posted in Reporting)

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

175

(5 replies, posted in Reporting)

Agree with you.