on 05-13-2011 10:39 AM
Hello Gurus,
recently we made client copy.
After that we are unable to create FICO documents.
If we create document only in IF it is created, but when we assign cost center or order it shows that doc.nr is created and number assigned but its not.
Also the CO number doens get updated, whereas FI counts +1 on posting.
We are getting also these errors:
"SAPSQL_ARRAY_INSERT_DUPREC" "CX_SY_OPEN_SQL_DB"
"SAPLGLIU" or "LGLIUF11"
"INS_ZSGBDGA"
Searched the whole internet
Created and assigned Logical system, then made a converted logical system names, then changed number ranges for Controlling are and FI documents but still nothing
Is there some place in CO which needs to be maintained?
Or what should i do?
best regards
Laurynas Prikockis
Helpful answer. Found problem by my self
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
check your CO number ranges (T-code KANK).
The "DUPREC" in the error message means "Duplicate records" so when you try to post a CO-document the current number from the number range interval used is lower than the number of the last CO-document already posted (see table COBK). And you cannot post 2 documents in one CO-area with the same document number.
So
Make an MS Excel back up of NRIV RK_BELEG,
check for each number range the highest COBK entry,
delete the number range buffer (SM56, explanation to buffering see SAPNET note 62077)
and set your "current number" in KANK to the level of the highest COBK entry.
The next CO document you try to post should be posted with the highest COBK entry +1 and the number range buffer is "refilled".
Best regards, Christian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
ive done the same, but also found that some Consultantat back in 2005 made some changes and in the report
LGLIUF11 included some additional table ZSGBDGA which numbers are driving me crazy.
FORM INS_ZSGBDGA "#EC CALLED
TABLES P_T_TABLE
USING P_RECORD TYPE ANY
P_RENUMBER_OBJ TYPE BOOLE_D. "#EC NEEDED
DATA: T_ZSGBDGA LIKE ZSGBDGA OCCURS 0 WITH HEADER LINE.
CLEAR T_ZSGBDGA . REFRESH T_ZSGBDGA .
T_ZSGBDGA[] = P_T_TABLE[].
IF P_T_TABLE[] IS INITIAL.
APPEND P_RECORD TO T_ZSGBDGA .
ENDIF.
IF NOT P_RENUMBER_OBJ IS INITIAL.
SORT T_ZSGBDGA .
CALL FUNCTION 'G_ADJUST_RECORD'
EXPORTING
TABELLENNAME = 'ZSGBDGA '
RENUMBER_OBJ = 'X'
TABLES
TABELLE = T_ZSGBDGA .
ENDIF.
GET TIME.
T_ZSGBDGA-CPUDT = SY-DATUM.
T_ZSGBDGA-CPUTM = SY-UZEIT.
MODIFY T_ZSGBDGA TRANSPORTING CPUDT CPUTM
WHERE RCLNT = SY-MANDT OR RCLNT NE SY-MANDT.
INSERT ZSGBDGA FROM TABLE T_ZSGBDGA .
IF SY-SUBRC NE 0.
MESSAGE X201 WITH 'ZSGBDGA '.
ENDIF.
ENDFORM.
Im trying to find the place where the number range is stored.
Any idea how it can be done?
Regards
Laurynas
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.