FrontAccounting forum — trans_no in 0_debtor_trans table

Re: trans_no in 0_debtor_trans table

null@example.com (jan12) — Sat, 06 Jun 2015 13:56:12 +0000

Thanks apmuthu

I understand now

Re: trans_no in 0_debtor_trans table

null@example.com (apmuthu) — Sat, 06 Jun 2015 01:59:51 +0000

To make sure that the new trans_nr is 1 more than the maximum of any previously allocated trans_nr which may or may not have been voided.

Re: trans_no in 0_debtor_trans table

null@example.com (jan12) — Thu, 04 Jun 2015 12:27:06 +0000

Thanks Joe

I see this happen, the trans_nr is now known to me

SELECT max(last_no) last_no FROM (
SELECT MAX(`trans_no`) as last_no FROM 0_debtor_trans WHERE `type`='13'
UNION SELECT MAX(`id`) as last_no FROM 0_voided WHERE `type`='13') a

But what is the purpose of the voided table?

Re: trans_no in 0_debtor_trans table

null@example.com (joe) — Thu, 04 Jun 2015 10:21:39 +0000

This is an internal number created when the records are done. Normally you would use the reference number when sending the invoices out.

Joe

trans_no in 0_debtor_trans table

null@example.com (jan12) — Thu, 04 Jun 2015 07:42:29 +0000

can someone explain to me what it is the trans_nr in the 0_debtor_trans , and where it comes from