FrontAccounting forum — Batching Invoice against Sales Delivery

Re: Batching Invoice against Sales Delivery

null@example.com (apmuthu) — Fri, 24 Apr 2015 00:53:02 +0000

The selections in one screen are the ones which get processed. Selections in the second screen must be done separately. You can try to increase the number of entries on each screen as stated in this thread, if you want all in one go.

Re: Batching Invoice against Sales Delivery

null@example.com (sakooon) — Wed, 15 Apr 2015 06:32:49 +0000

If I select the full screen (10 items) and then go to the next screen to continue selecting, when I process the invoice, only the last screen selection is processed...???

__________________________
http://solitairewithbuddies.com/

Re: Batching Invoice against Sales Delivery

null@example.com (dls) — Wed, 04 Mar 2015 12:02:27 +0000

I most certainly did. - very easy - Thank you

Re: Batching Invoice against Sales Delivery

null@example.com (apmuthu) — Wed, 04 Mar 2015 08:46:12 +0000

I hope you used the last method instead of hacking the code.

Re: Batching Invoice against Sales Delivery

null@example.com (dls) — Tue, 03 Mar 2015 22:37:09 +0000

Thanks - that works.

Re: Batching Invoice against Sales Delivery

null@example.com (apmuthu) — Tue, 03 Mar 2015 19:21:11 +0000

@joe: maybe we need to remember the ticks of the previous page in the session variables before going to the next page.

Try to increase the number of items to say 20 or more. Try changing line 207 in sales/inquiry/sales_deliveries_view.php:

$table =& new_db_pager('deliveries_tbl', $sql, $cols);

by hardcoding it to

$table =& new_db_pager('deliveries_tbl', $sql, $cols,,20);

The function new_db_pager() is defined in includes\db_pager.inc at line 482 with the following prototype:

function &new_db_pager($name, $sql, $coldef, $table = null, $key = null, $page_len = 0)  {

If the default $page_len is left as zero (0), then the #_users.query_size field's value (default 10) is taken.

It can also be set in Setup => Display Setup (Preferences) => Query page size:

Re: Batching Invoice against Sales Delivery

null@example.com (dls) — Tue, 03 Mar 2015 17:40:42 +0000

Thanks for the reply apmuthu

I've tried that, but the Search Not Invoiced Deliveries screen only gives 10 items at a time. I can select all of those and batch those, limiting me to 10 items.

If I select the full screen (10 items) and then go to the next screen to continue selecting, when I process the invoice, only the last screen selection is processed.

Is there any way of selecting and batching more? Or am I missing something?

Re: Batching Invoice against Sales Delivery

null@example.com (apmuthu) — Tue, 03 Mar 2015 13:52:01 +0000

Create a batch Invoice. Refer the Wiki.

A batch invoice, a single invoice created from multiple work orders/deliveries, can be processed if all items have been sent to the same location. Click the check-box beside each delivery and click the Batch button at the top of the column to make such an invoice.

Batching Invoice against Sales Delivery

null@example.com (dls) — Mon, 02 Mar 2015 17:29:19 +0000

Is there any way of batching more than one screen (10 sales Delivery) into an invoice? Every time I select the items and go onto the next screen the first selection is lost.

Thanks