Bug 430 - GRN
Summary: GRN
Status: RESOLVED FIXED
Alias: None
Product: IMIS PURCHASE
Classification: 01.IMIS
Component: IMIS PURCHASE FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: PC Windows
: Normal critical
Assignee: Mahender
URL:
Depends on:
Blocks:
 
Reported: 2019-07-30 13:22 IST by Arindam Ghosh
Modified: 2019-07-30 14:34 IST (History)
1 user (show)

See Also:
Database: DS
Module ID: GRN not approved

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 2019-07-30 14:34:42 IST 
this account code "100920021" not define for this company  contact to account department
Description Arindam Ghosh 2019-07-30 13:22:24 IST 
GRN not approved in unit 66

UPDATE GOODS_RECEIVED_NOTES SET GRN_RECID=:1,COMPANY=:2,STATUS=:3,CREATED_ON=:4,PROJECT=:5,GRN_TYPE=:6,GRN_SERIES=:7,GRN_NO=:8,ENTRY_NO=:9,GRN_DATE=:10,STORE_ID=:11,SUPPLIER_CODE=:12,SPLR_DELIVERY_ORDER_NO=:13,SPLR_DELIVERY_ORDER_DATE=:14,GRN_CURRENCY=:15,CREATED_BY=:16,LAST_UPD_ON=:17,LAST_UPD_BY=:18,REMARKS=:19 WHERE ROWID=:20  



ORA-20003: GL Account Code not valid for this company contact to account code 100920021
ORA-06512: at "IMIS.GL_POSTING_DTL_TPC", line 193
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_PR", line 2134
ORA-06512: at "IMIS.PKG_PR", line 4708
ORA-06512: at "IMIS.TRG_GOODS_RECEIVED_NOTES", line 178
ORA-04088: error during execution of trigger 'IMIS.TRG_GOODS_RECEIVED_NOTES'