Hello,in the VOUCHER_APPROVAL view I have 5 rows. When executing select * from VOUCHER_APPROVAL query, I wait 5 minutes for the result. very long.. What could be the reason? Only on a production base.
slowly retrieving data from the view VOUCHER_APPROVAL
This topic has been closed for comments
Most probably you have a lot of approved vouchers in view VOUCHER? Probably some voucher types are set as “Store original” so that records are not removed from VOUCHER_TAB when you update to General Ledger?
Since you give no company, year or period in your query the database needs to go thru all records in table VOUCHER_TAB to get your 5 records.
Try adding a condition on COMPANY and ACCOUNTING_YEAR to see if that makes any difference.
Change YourCompany in the example below to your company.
SELECT *
FROM voucher_approval
WHERE company = 'YourCompany'
AND accounting_year = 2021
Where is parametr Store original?
It is defined here on the Voucher Type:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.