Solved

Connection between General Ledger and vouchers

M
Rank
Badge +14

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. 😊

 

icon

Best answer by Adam Bereda 7 July 2022, 16:29

View original

5 replies

P
Rank

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

 

M
Rank
Badge +14

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.

 

P
Rank

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.

 

A
Rank
Userlevel 7
Badge +16

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.

Regards, Adam
M
Rank
Badge +14

Thank you so much @Adam Bereda 

Reply


Terms & ConditionsCookie settings