Hi,

Voucher rows are connected to voucher header using unique index key with columns company, accounting year, voucher type and voucher no .

Best Regards,

Pawel

Hi @Pawel Dworzynski , Thank you so much for your response.

Do you have any idea how the General ledger and vouchers are connected together.

I’m looking for a connection between Gen_Led_Voucher_Tab and voucher_tab tables.

They are connected with the same columns but only for voucher types which have Store original ticked. Other vouchers are deleted from voucher_tab when updated to GL.

Voucher_tab is hold table (voucher in Accounting Rules) while gen_led_voucher_tab is General Ledger table, populated by GL Update routine. One is source for the other, but records in these two are not connected. 

For some voucher types with “Store original” flag set, original voucher data is not removed from voucher_tab, but just hidden by setting “Updated” field to Yes, these vouchers can be found in both these tables.

Thank you so much @Adam Bereda