Print Invoice Bug

@Joe
Thanks for your reply but please try the following

in Customer Reports select print invoices,
then in From select SI 305 abbas and in To select SI 305 abbas

now you can print and the report would generate and the Value is 3,000.00 USD

now try to change the currency filter , lets say try to select EUR - Euro

Trying to print now would generate a white PDF report.

so the currency selector isn't of use in report 107??
i mean if we cant use it why is it there??

an easy fix to the problem would be by adding the ability save the report in excel format so we can manually add the prices in the desired currency.

Right now this report is missing the Destination selector where we can output the report in excel format, would you please consider adding it?

is there any workaround to print invoices in a non default customer's currency??
like a new report based on 107 but with the desired currency hard-coded into it .. would it work??

Try to use the attached rep107 and provide feedback.
This method has the ability make the report quicker on currency filter doing it in the sql itself.

@joe: see if it is fit to be committed into the core.

Well, if you feel this is a bug, then we will have to rewrite almost all the documents. I don't understand why, because you use no resources if you do not print the white page. We have had this behaviour from the very beginning of FA.

BTW. the Customer filter also gives a blank page if the customer is not there.

Please tell me if we should rewrite.

/Joe

Even if just 1 invoice is chosen and no currency filter is in place - all currencies will be allowed - there is no change in the code / sql for this choice of no currency.

@joe: should the file be committed?

There is no major change to this file. Just a currency filter in the where statement and an extra table join for it and that too only when the currency is chosen.

The customer filter remains so even in my code but does that determine the currency as well? Anyone using the filters, be it customer and / or currency will know what to expect of the results of the output subset. The changes in the code here will not affect any other report as it is localised only.

Yes, it is not a big deal. We can leave it as is and the code here can be used at will by those who need it - maybe I will put it in my FA24Mods.....

@Alaa, if I really understand your need, your biggest problem is the exchange rate on the date of invoice (if it's not stored for some other invoice).
An easy work arround would be if you change the function of the "Comments:" param in your changed report and manually input the exchange rate there. Of course some code changes are needed too.
Than you can make it work relatively well (it will not folow the rate changes of the selected period, if there are some). In fact the manual input can be used only for blank dates.
It will not be stored, just used to print or e-mail what you need.
I guess it is an issue of headquartes with other currency???

Better still, populate the exchange rate for the currency desired into the exchange rates table for every day in the year.

Is there a weblink / service / CSV available for middle rates for each day - archives of exchange rates - so that when a date range for a currency pair is requested, it can provide rates to populate the FA exchange rates table directly for that entire period. Also for rare significant rate changes, can the last populated rate not be taken instead?