<![CDATA[FrontAccounting forum — Edit Invoice using posted Wiki]]> https://frontaccounting.com/punbb/viewtopic.php?id=10735 Sun, 16 Aug 2026 00:30:37 +0000 PunBB <![CDATA[Edit Invoice using posted Wiki]]> https://frontaccounting.com/punbb/viewtopic.php?pid=43878#p43878 I tried to to change an existing Invoice using the procedure posted in the Wiki and the results created parts of the new Invoice with redundant invoice numbers instead of creating unique new numbers.  I could not find out why.  This is the first time I've tried to change an invoice with this level of software (2.4.19 Default Theme, Church Chart of Accounts). I'm listing all the changes in the DB when I changed one invoice.  If any one can help me or even verify that I should see different results and why, then I'll know I did something wrong.

Edit Invoice using posted Wiki
Results posted below.

0_audit_trail
('32595', '30', '6472', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'),                    (Original)
('32596', '13', '6473', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'),                    (Original)
('32597', '10', '6473', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'),                    (Original)
*********************************************************************************************
('32595', '30', '6472', '1', '2026-08-15 19:30:10', NULL, '8', '2026-04-26', NULL),                    (Changed)
('32596', '13', '6473', '1', '2026-08-15 19:28:04', NULL, '8', '2026-04-26', NULL),                    (Changed)
('32597', '10', '6473', '1', '2026-08-15 19:28:04', NULL, '8', '2026-04-26', NULL),                    (Changed)
*********************************************************************************************
('34130', '13', '6473', '1', '2026-08-15 19:28:04', 'Voided.', '8', '2026-04-26', '0'),                (New Addition)
('34131', '10', '6473', '1', '2026-08-15 19:28:04', 'Voided.\nedit', '8', '2026-08-15', '0'),        (New Addition)
('34132', '30', '6472', '1', '2026-08-15 19:30:10', 'Updated.', '8', '2026-04-26', '0'),            (New Addition)
('34133', '13', '6772', '1', '2026-08-15 19:31:27', NULL, '8', '2026-04-26', '0'),                    (New Addition)
('34134', '10', '6771', '1', '2026-08-15 19:32:22', NULL, '8', '2026-04-26', '0'),                    (New Addition)
('34135', '12', '6769', '1', '2026-08-15 19:32:22', NULL, '8', '2026-04-26', '0');                    (New Addition)


0_bank_trans
('12920', '12', '6473', '4', 'CP260325', '2026-04-26', '165', '0', '0', '2', '217', NULL),        (Original)
**************************************************************************************
('13543', '12', '6769', '4', 'CP260621', '2026-04-26', '165', '0', '0', '2', '217', NULL);        (New Addition)


0_comments
('13', '6473', '2026-04-26', '260426 PayPal $4.93'),                    (Original)
('10', '6473', '2026-04-26', '260426 PayPal $4.93'),                    (Original)
('12', '6473', '2026-04-26', 'POS_VBC #6473'),                            (Original)
**************************************************************************************
('13', '6772', '2026-04-26', '260426 PayPal $4.93'),                    (New Addition)
('10', '6771', '2026-04-26', '260426 PayPal $4.93'),                    (New Addition)
('12', '6769', '2026-04-26', 'POS_VBC #6771');                            (New Addition)


0_cust_allocations
('6485', '217', '165', '2026-04-26', '6473', '12', '6473', '10'),        (Deleted)
**************************************************************************************
('6781', '217', '165', '2026-04-26', '6769', '12', '6771', '10');        (New Addition)


0_debtor_trans
('6473', '10', '0', '217', '214', '2026-04-26', '2026-04-26', 'Dn260325', '3', '6472', '165', '0', '0', '0', '0', '165', '0', '1', '1', '7', '0', '4', '0'), (Original)
***************************************************************************************
('6473', '10', '2', '217', '214', '2026-04-26', '2026-04-26', 'Dn260325', '3', '6472', '0', '0', '0', '0', '0', '0', '0', '1', '1', '7', '0', '4', '0'),     (Changed)
***************************************************************************************
('6771', '10', '0', '217', '214', '2026-04-26', '2026-04-26', 'Dn260623', '3', '6472', '165', '0', '0', '0', '0', '165', '0', '1', '1', '7', '0', '4', '0'), (New Addition)
***************************************************************************************
('6769', '12', '0', '217', '214', '2026-04-26', '0000-00-00', 'CP260621', '0', '0', '165', '0', '0', '0', '0', '165', '0', '1', '0', '0', '0', NULL, '0'),     (New Addition)
***************************************************************************************
('6772', '13', '1', '217', '214', '2026-04-26', '2026-04-26', 'DN260001', '3', '6472', '165', '0', '0', '0', '0', '0', '0', '1', '1', '7', '0', '4', '0');     (New Addition)


0_debtor_trans_details
('16227', '6473', '13', '101', 'Donation - Tithe', '165', '0', '1', '0', '0', '1', '8112'),        (Original)
('16228', '6473', '10', '101', 'Donation - Tithe', '165', '0', '1', '0', '0', '0', '16227'),
***************************************************************************************
('16227', '6473', '13', '101', 'Donation - Tithe', '0', '0', '0', '0', '0', '1', '0'),            (Changed)
('16228', '6473', '10', '101', 'Donation - Tithe', '0', '0', '0', '0', '0', '0', '0'),
***************************************************************************************
('17075', '6772', '13', '101', 'Donation - Tithe', '140', '0', '1', '0', '0', '1', '8112'),        (New Addition)
('17076', '6772', '13', '104', 'Donation - Building', '25', '0', '1', '0', '0', '1', '8536'),
('17077', '6771', '10', '101', 'Donation - Tithe', '140', '0', '1', '0', '0', '0', '17075'),
('17078', '6771', '10', '104', 'Donation - Building', '25', '0', '1', '0', '0', '0', '17076');


0_gl_trans
('40813', '10', '6473', '2026-04-26', '4011', '', '-165', '7', '1', NULL, NULL),        (Original)
('40814', '10', '6473', '2026-04-26', '1200', '', '165', '7', '0', '2', '217'),
***************************************************************************************
('40813', '10', '6473', '2026-04-26', '4011', '', '0', '7', '1', NULL, NULL),            (Changed)
('40814', '10', '6473', '2026-04-26', '1200', '', '0', '7', '0', '2', '217'),
***************************************************************************************
('42822', '10', '6771', '2026-04-26', '4011', '', '-140', '7', '1', NULL, NULL),        (New Addition)
('42823', '10', '6771', '2026-04-26', '4011', '', '-25', '7', '4', NULL, NULL),
('42824', '10', '6771', '2026-04-26', '1200', '', '165', '7', '0', '2', '217'),
('42825', '12', '6769', '2026-04-26', '1003', '', '165', '7', '0', NULL, NULL),
('42826', '12', '6769', '2026-04-26', '1200', '', '-165', '7', '0', '2', '217');


0_refs
('6771', '10', 'Dn260623'),
**************************************************************************************
('6768', '12', 'CP260620'),            (Original)
('6769', '12', 'CP260621'),            (New Addition)
('6772', '13', 'DN260001'),            (New Addition)
('1', '20', 'SI19001'),                (Original)
**************************************************************************************
('6402', '30', 'SO260002'),            (Original)
('6472', '30', 'SO260003'),            (New Addition)
('6530', '30', 'SO260003'),            (Original)
('18', '40', '101'),                (Original)


0_sales_order_details
('8112', '6472', '30', '101', 'Donation - Tithe', '1', '165', '1', '0', '0'),    (Original)
**************************************************************************************
('8112', '6472', '30', '101', 'Donation - Tithe', '1', '140', '1', '0', '0'),    (Changed)
**************************************************************************************
('8536', '6472', '30', '104', 'Donation - Building', '1', '25', '1', '0', '0');        (New Addition)


0_sales_orders
('6472', '30', '1', '0', '217', '214', 'auto', '', '260426 PayPal $4.93', '2026-04-26', '3', '1', '1313 Garbage Can Lane\r\nBoredom, XZ 12345', '', NULL, 'John Doe', '0', 'DEF', '2026-04-26', '4', '165', '0', '0'),    (Original)
***************************************************************************************
('6472', '30', '3', '0', '217', '214', 'SO260003', '', '260426 PayPal $4.93', '2026-04-26', '3', '1', '3520 Leith Street\r\nBoredom, XZ 12345', '', NULL, 'John Doe', '0', 'DEF', '2026-04-26', '4', '165', '0', '0'),    (Changed)


0_stock_moves
('8112', '6473', '101', '13', 'DEF', '2026-04-26', '165', 'auto', '-1', '0'),        (Deleted)
***************************************************************************************
('8536', '6772', '101', '13', 'DEF', '2026-04-26', '140', 'DN260001', '-1', '0'),    (New Addition)
('8537', '6772', '104', '13', 'DEF', '2026-04-26', '25', 'DN260001', '-1', '0');    (New Addition)


0_trans_tax_details
('12950', '13', '6473', '2026-04-26', '0', '0', '1', '0', '165', '0', 'auto', NULL),        (Original)
('12951', '10', '6473', '2026-04-26', '0', '0', '1', '0', '165', '0', 'Dn260325', '0'),        (Original)
***************************************************************************************
('12950', '13', '6473', '2026-04-26', '0', '0', '1', '0', '0', '0', 'auto', NULL),            (Changed)
('12951', '10', '6473', '2026-04-26', '0', '0', '1', '0', '0', '0', 'Dn260325', '0'),        (Changed)
***************************************************************************************
('13542', '13', '6772', '2026-04-26', '0', '0', '1', '0', '165', '0', 'DN260001', NULL),    (New Addition)
('13543', '10', '6771', '2026-04-26', '0', '0', '1', '0', '165', '0', 'Dn260623', '0');        (New Addition)


0_voided
('10', '6473', '2026-08-15', 'edit'),    (New Addition)
**************************************************************************************
('13', '6473', '2026-04-26', ''),        (New Addition)

]]> Sun, 16 Aug 2026 00:30:37 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=43878#p43878