AP - AR Accounting Supplier Invoice did not create accounting document after posting

SOLVED

I posted two supplier Invoices and observed it does not create a journal. I checked the accounting task and the journal on hold shows two. I check recurring tasks for the active time and it's okay. I deactivated the accounting task. Restarted batch server and activate accounting task. Even click on update but still the same. I saw an article that says I should setup a P&L account on the chart of account and on the accounting code for the company did that but still the same. It is a new database
Replicating Error: Created another supplier invoice.

Below is the batch server log for this task.

#<AdxVL>@(#)%I% Batch query log ACCBATCH1
<0001 01-10-21 00:01:24 (Application server time) @X3.TRT/ADS_TOOL$adx(158) Error 76 : SQL Server Error [Microsoft][SQL Server Native Client 11.0][SQL Server]The SELECT permission was denied on the object 'TABLAN', database 'x3data', schema 'APPLC'. (10001)
<0001 01-10-21 00:01:24 (Application server time) @X3.TRT/ADS_TOOL$adx(158) Error 76 : SQL Server Error [Microsoft][SQL Server Native Client 11.0][SQL Server]The SELECT permission was denied on the object 'TABLAN', database 'x3data', schema 'APPLC'. (10001)
<0001 01-10-21 00:01:24 (Application server time) @X3.TRT/ASYRREQPEND_RSTD$adx(179) Error 76 : SQL Server Error [Microsoft][SQL Server Native Client 11.0][SQL Server]The SELECT permission was denied on the object 'AUTILIS', database 'x3data', schema 'APPLC'. (10001).
Note: There are two different servers, one for application and the other for SQL database.
 oN VERSION 12