Thanks apmuthu
I understand now
1 06/06/2015 01:56:12 pm
Re: trans_no in 0_debtor_trans table (4 replies, posted in Items and Inventory)
2 06/04/2015 12:27:06 pm
Re: trans_no in 0_debtor_trans table (4 replies, posted in Items and Inventory)
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?
3 06/04/2015 07:42:29 am
Topic: trans_no in 0_debtor_trans table (4 replies, posted in Items and Inventory)
can someone explain to me what it is the trans_nr in the 0_debtor_trans , and where it comes from