Print a large number of invoices at once

Issue solved. Thank you!

Thank you for your suggestions.

I have one more question -

I have invoices denominated in 2 currencies - USD (base currency) and EUR. How can I print only all EUR denominated invoices in a particular month?

I used the 'Print Invoices' function under the 'Customer' class of 'Customer and Sales Report'
I tried using the Currency Filter but the results will give me both USD and EUR invoices.

The reason I need to print only EUR invoices is because I want to add a comment line only on EUR invoices. Appreciate your help. Thank you.

This filter does not seem to work. Does this 'Currency' correspond to 'Customer's Currency' field under 'Add and Manage Customers' function? What should I change to make this filter kick in? Thank you.

@joe: The following info will be useful in getting Sales Groups into all pertinent reports:

functions in includes/ui/ui_lists.inc:

sales_groups_list($name, $selected_id=null, $special_option=false)
    used in function sales_groups_list_cells
sales_groups_list_cells($label, $name, $selected_id=null, $special_option=false)
    used in sales_groups_list_row
sales_groups_list_row($label, $name, $selected_id=null, $special_option=false)
    used in sales/manage/customer_branches.php (data entry and updation)
    used in sales/manage/recurrent_invoices.php (selection for recurrent invoice generation)

functions in sales/includes/db/sales_groups_db.inc:

The following 5 functions are used only once in sales/manage/sales_groups.php
add_sales_group($description)
update_sales_group($selected_id, $description)
delete_sales_group($selected_id)
get_sales_groups($show_inactive)
get_sales_group($selected_id)

get_sales_group_name($group_no)
    used in sales/manage/recurrent_invoices.php
    used in sales/create_recurrent_invoices.php

I just looked deeper into the code in rep107 and it seems that currency is actually not considered in the filters
Those 'if' functions only cover invoices, debtor_no and email (I hope I am reading the code directly...)
Can this be fixed so to include currency filter? Many thanks.

            if (!exists_customer_trans(ST_SALESINVOICE, $i))
                continue;
........
            if($customer && $myrow['debtor_no'] != $customer) {
                continue;
            }
.......

            if ($email == 1)

@joe: Whilst incorporating the Currency filter in the appropriate report request forms, plesse try to include Sales Group filter as well. The latter will help manage exceptions easily with the help of temporary groups.

In FA 2.4, we can allow customer branches be part of multiple Sales Groups and possibly include a fallback Sales Group in the Customer record (debtor_master) as well.

The currency filter didn't work for most documents, so these have been fixed and the 2.3 HG repo has been updated.

The fixed Invoice Document kan be downloaded here.

/Joe

All reports affected by the currency filter commit other than rep108.php get their results from other functions. In FA 2.4, we can consider filtering them in the WHERE clause in the source function's SQL tself.

In rep108.php, the sql is executed inline and can hence be filtered in the WHERE clause itself instead of in the php loop after the fact. The patch below achieves it:

--- reporting/rep108.php    Fri Feb 13 20:23:10 2015
+++ reporting/rep108.php    Fri Feb 13 20:19:18 2015
@@ -86,18 +86,17 @@
    if ($orientation == 'L')
         recalculate_cols($cols);
  
-    $sql = "SELECT debtor_no, name AS DebtorName, address, tax_id, curr_code, curdate() AS tran_date FROM ".TB_PREF."debtors_master";
+    $sql = "SELECT debtor_no, name AS DebtorName, address, tax_id, curr_code, curdate() AS tran_date FROM ".TB_PREF."debtors_master WHERE 1 ";
     if ($customer != ALL_TEXT)
-        $sql .= " WHERE debtor_no = ".db_escape($customer);
-    else
+        $sql .= " AND debtor_no = ".db_escape($customer);
+    if ($currency != ALL_TEXT)
+        $sql .= " AND curr_code = ".db_escape($currency);
+
         $sql .= " ORDER by name";
     $result = db_query($sql, "The customers could not be retrieved");
 
     while ($myrow=db_fetch($result))
     {
-        if ($currency != ALL_TEXT && $myrow['curr_code'] != $currency) {
-            continue;
-        }    
         $date = date('Y-m-d');
 
         $myrow['order_'] = "";

Strange thing happened.

With the new rep107.php file, the function under 'Customer and Sales Reports' --> 'Print Invoices' works well.
However, if I go to 'Sales' --> 'Customer Transaction Inquiry' and then print individual invoice there, I get blank page.

I replaced with the old rep107.php file and then printing in 'Customer Transaction Inquiry' returns normal.

With the new rep113.php file, printing credit note in  'Customer Transaction Inquiry' has no issue.

A new update of the file rep107.php has been done. please make a reload of the file from HG repository.

/Joe