Hi All,
Would it be possible to know the connection between General Ledger and vouchers or voucher rows, please?
I’m looking for any common columns or fields.
I really appreciate your valuable comments.
Thank you in Advance. 😊
Solved
Connection between General Ledger and vouchers
+15Best answer by Adam Bereda
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.
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
+15Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.