Bug 6805 - SPV APPROVAL ERROR
Summary: SPV APPROVAL ERROR
Status: RESOLVED USER TO VERIFY
Alias: None
Product: IMIS AP
Classification: 01.IMIS
Component: IMIS AP FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: PC Windows
: Normal normal
Assignee: Mahender
URL:
Depends on:
Blocks:
 
Reported: 2021-07-26 10:21 IST by joginder singh
Modified: 2021-07-26 11:31 IST (History)
1 user (show)

See Also:
Database:
Module ID:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Comment 1 Mahender 2021-07-26 11:31:04 IST 
please active below account code then check

 GL Account Code not valid for this company :3A - 202250124
Description joginder singh 2021-07-26 10:21:05 IST 
Hi,

Good Morning,

There is error while approve the SPV in company 3A NATURAL BEVERAGES (A unit of Himachal Plywoods Private Limited).

UPDATE VW_STORE_PURCHASE_BILLS SET STORE_PURCHASE_BILLS_RECID=:1,COMPANY_CODE=:2,COST_CENTRE=:3,FOREX_RATE=:4,STATUS=:5,CREATED_BY=:6,CREATED_ON=:7,LAST_UPD_BY=:8,LAST_UPD_ON=:9,VOUCHER_TYPE=:10,VOUCHER_SERIES=:11,VOUCHER_NUMBER=:12,ENTRY_NUMBER=:13,VOUCHER_DATE=:14,SUPPLIER_CODE=:15,FOREX_CODE=:16,BILL_AMOUNT=:17,NARRATION=:18 WHERE ROWID=:19  


ORA-20003: GL Account Code not valid for this company :3A - 202250124
ORA-06512: at "IMIS.GL_POSTING_DTL_TPC", line 194
ORA-06512: at "IMIS.GL_POSTING_DTL_TRG", line 58
ORA-04088: error during execution of trigger 'IMIS.GL_POSTING_DTL_TRG'
ORA-06512: at "IMIS.PKG_AP", line 16393
ORA-06512: at "IMIS.SPV_TRG", line 190
ORA-04088: error during execution of trigger 'IMIS.SPV_TRG'


Kindly do the needful.

Thanks

Joginder singh