Hi BPC experts,
As the title implies, I used DM package "Restore Journals" but it does not load everything from the uploaded flat file. I have solved my previous issue in this post by implementing sap notes : https://answers.sap.com/questions/346150/bpc-101-export-and-import-journals-not-working-pro.html?childToView=350311#comment-350311
Below is the flat file (in JRN format and opened from a TXT format) :
APPSET_ID,APPL_ID,JRN_TMPL_ID,JRN_ID,DESCRIPTION,USERC,DATEMODIFIED,USERP,DATEPOSTED,STATUS,IDJ_AUTO_REV,POSTED,IDJ_OLD,IDJ_GROUP,AUTO_REVERSED,BALANCED,REOPEN,EDITABLE,VARIABLET,ENTITY,AUDIT_TRAIL,CURRENCY,SCOPE,TIME,VERSION,ACCOUNT,FLOW,INTERCO,ROW_NUM,DEBIT,CREDIT,REMARK
SAP_IFRS,Consolidation,000001,0000000001,Import nr 1,TRUONG,,,,S,-1,,-1,-1,,,,,,AE02,INPUT,LC,S_NONE,2016.12,ACTUAL,E500070,F15,I_NONE,00000001,22223.0000000,,
SAP_IFRS,Consolidation,000001,0000000001,Import nr 1,TRUONG,,,,S,-1,,-1,-1,,,,,,AE02,INPUT,LC,S_NONE,2016.12,ACTUAL,E500091,F01,I_NONE,00000002,,22223.0000000,
SAP_IFRS,Consolidation,000001,0000000002,%COPYTO #1%Import nr 1,,,,0 ,S,-1,,-1,-1,,,,,,AE02,FS_ADJ,LC,S_NONE,2016.12,ACTUAL,P726010,F20,I_NONE,00000001,2221.0000000,,
SAP_IFRS,Consolidation,000001,0000000002,%COPYTO #1%Import nr 1,,,,0 ,S,-1,,-1,-1,,,,,,AE02,FS_ADJ,LC,S_NONE,2016.12,ACTUAL,P729000,F30,I_NONE,00000002,,2221.0000000,
SAP_IFRS,Consolidation,000001,0000000003,Import test,TRUONG,,,,S,-1,,-1,-1,,,,,,LU02,FS_ADJ,LC,S_NONE,2016.12,ACTUAL,P804000,F20,I_NONE,00000001,2222.0000000,,
SAP_IFRS,Consolidation,000001,0000000003,Import test,TRUONG,,,,S,-1,,-1,-1,,,,,,LU02,FS_ADJ,LC,S_NONE,2016.12,ACTUAL,P801000,F30,I_NONE,00000002,,2222.0000000,
SAP_IFRS,Consolidation,000001,0000000003,Import test,TRUONG,,,0 ,S,-1,,-1,-1,,,,,,LU02,FS_ADJ,LC,S_NONE,2016.12,ACTUAL,L001050,F20,I_NONE,00000001,2222.0000000,,
SAP_IFRS,Consolidation,000001,0000000003,Import test,TRUONG,,,0 ,S,-1,,-1,-1,,,,,,LU02,FS_ADJ,LC,S_NONE,2016.12,ACTUAL,L001060,F30,I_NONE,00000002,,2222.0000000,
SAP_IFRS,Consolidation,000001,0000000004,Import test,TRUONG,,,,S,-1,,-1,-1,,,,,,AE02,INPUT,LC,S_NONE,2016.12,ACTUAL,A101000,F80,I_NONE,00000001,33.9000000,,
SAP_IFRS,Consolidation,000001,0000000004,Import test,TRUONG,,,,S,-1,,-1,-1,,,,,,AE02,INPUT,LC,S_NONE,2016.12,ACTUAL,A000100,F30,I_NONE,00000002,,33.9000000,
SAP_IFRS,Consolidation,000001,0000000005,XXX,TRUONG,,,0 ,S,-1,,-1,-1,,,,,,AE02,FS_ADJ,LC,S_NONE,2016.12,ACTUAL,E900100,F20,I_NONE,00000001,5.0000000,,
SAP_IFRS,Consolidation,000001,0000000005,XXX,TRUONG,,,0 ,S,-1,,-1,-1,,,,,,AE02,FS_ADJ,LC,S_NONE,2016.12,ACTUAL,P900000,F30,I_NONE,00000002,,5.0000000,
There are several issues :
1) It is supposed to generate 5 journals ID (see JRN_ID). However, it only creates one (and therefore merges all the journals in one).
2) It only reads several lines, not all of them. To be more accurate, it records account P801000, L001060, E900100 and P900000 from the flat file. I do not see any kind of logic about why the system would specifically choose those lines.
3) P801000 and L001060 are entries for LU02 entity while the 2 others for AE02 entity. ENTITY Dimension is set as Header dimension in one unique journal template but BPC does not make the difference and still puts them both in one journal (even if JRN_ID separates them).
4) I also tried to create 2 journals from the web client > export journal package > clear journal table package > upload exported journals > Restore journals. The system only creates one journal ID and only reads several lines.
I cannot upgrade the system unfortunately but if someone has met this kind of issue, please share your solution.
Thank you in advance.
Dat
Add comment