| Summary: | SPV APPROVAL ERROR | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS AP | Reporter: | joginder singh <joginder.singh> |
| Component: | IMIS AP FORMS AND REPORTS | Assignee: | Mahender <mahender.singh> |
| Status: | RESOLVED USER TO VERIFY | ||
| Severity: | normal | CC: | sharad.sharma |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | PC | ||
| OS: | Windows | ||
| Database: | Module ID: | ||
|
Comment 1
Mahender
2021-07-26 11:31:04 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 |