Good effort. I am looking forward to see your more presenatations. Could you please make presentation for mass allocation rule which is very important topic in GL?
Thanks Muhammad. I am planning to put the complete set of training videos so that anyone interested to learn Fusion can learn from the comfort of their home.
Can anyone pls. help as I am facing the issue, when I click "sample Data.xlsm" message appeared "Cannot start the source application for this project". Pls. update. thanks
I am having problem with validating. It is coming up with this message. "worksheet for segment 'Account' does not exist. Press 'Add Segment Sheets' button." I have done this several times, i meant clicking Add Segment Sheets' button but it does not correct it
I get the following error in my log file during RI: "You cannot save this address because at least one of the address elements is invalid." Anyone know how to resolve this? I have checked my address values and everything looks good.
@@vikashandaqviksoftoraclefusion hey there Vikas. I figured the problem out and it works for me now. Thanks for getting back. I didn't think anyone would answer me. Means a lot. God bless you and thanks for your amazing knowledge.
Good video. However, there are a few mistakes in the video, one of which is a critical mistake, and I would like to make sure that viewers do not make the same mistakes. The first mistake is that you assigned the segment label "Intercompany segment" to the Intercompany segment that you defined. This is a critical mistake that is well documented in the GL Implementation Guide. By assigning this label, the system will re-use the Company segment Value Set in the Intercompany segment. This will create issues later in terms of intercompany functionality, specifically intercompany transaction processing, reporting and reconciliation, apart from creating issues if you use segment value security. Hence you should not assign the Intercompany segment label on the spreadsheet. To avoid this critical mistake, you should add a tab for the Intercompany segment on the RI spreadsheet through the Add Segment Sheets button, and add the same values as the company segment, and add a "0000" None value. This will create a separate value set for the Intercompany segment. Before you upload the second ZIP file you should go to the Chart of Accounts structure and update the Intercompany segment label. After that you re-deploy the flexfield, and then proceed to upload the second ZIP file. This is well documented in the GL Implementation guide and is also the leading practice for using the RI spreadsheet. The second mistake is that you put the name as "QS Ledger" on the RI spreadsheet. Actually it should be the Chart of Accounts name and not the Ledger name. The system assigns the Ledger name by suffixing the country code to the COA name. The "Name" in the first tab should be your COA name and you should avoid using the word "Ledger" in it. The third mistake is that you put the Canadian province in the State column of the RI spreadsheet. You should put it in the Province column. Hope this helps.
Thanks for taking time to provide the feedback. 1. issues mentioned you are valid and I had shared the same in my video also. I should have added removing the segment label. 2. QS Ledger is my COA name. It was for the demo purpose. 3. Ok. Thanks again.
When you add a new sheet, the system automatically creates that for intercompany and during upload automatically assigns the segment qualifier for that. You do not need to specifically do that and redeploy the flexfield.
thank you for this wonderful explanation
Good effort. I am looking forward to see your more presenatations. Could you please make presentation for mass allocation rule which is very important topic in GL?
Mega like for your simply explained. Thanks a lot for your efforts
Thanks for your appreciation.
Thanks Vikas a perfect presentation.
Thanks Vikas. In fresh instance by doing this will it create one enterprise or we need to manually create enterprise & then do this?
Liked and added to my videos. simply well explained.
Thanks Muhammad. I am planning to put the complete set of training videos so that anyone interested to learn Fusion can learn from the comfort of their home.
Great effort. will wait for the next upload.
Can anyone pls. help as I am facing the issue, when I click "sample Data.xlsm" message appeared "Cannot start the source application for this project". Pls. update. thanks
I am having problem with validating. It is coming up with this message. "worksheet for segment 'Account' does not exist. Press 'Add Segment Sheets' button." I have done this several times, i meant clicking Add Segment Sheets' button but it does not correct it
Can you please email me your rapid file?
I get the following error in my log file during RI: "You cannot save this address because at least one of the address elements is invalid."
Anyone know how to resolve this? I have checked my address values and everything looks good.
Can you please email me your rapid file?
@@vikashandaqviksoftoraclefusion hey there Vikas. I figured the problem out and it works for me now. Thanks for getting back. I didn't think anyone would answer me. Means a lot. God bless you and thanks for your amazing knowledge.
Need free instance for training if available,
Dear Ebrahim, Unfortunately, as of now there is no free instance available.
Good video. However, there are a few mistakes in the video, one of which is a critical mistake, and I would like to make sure that viewers do not make the same mistakes.
The first mistake is that you assigned the segment label "Intercompany segment" to the Intercompany segment that you defined. This is a critical mistake that is well documented in the GL Implementation Guide. By assigning this label, the system will re-use the Company segment Value Set in the Intercompany segment. This will create issues later in terms of intercompany functionality, specifically intercompany transaction processing, reporting and reconciliation, apart from creating issues if you use segment value security. Hence you should not assign the Intercompany segment label on the spreadsheet.
To avoid this critical mistake, you should add a tab for the Intercompany segment on the RI spreadsheet through the Add Segment Sheets button, and add the same values as the company segment, and add a "0000" None value. This will create a separate value set for the Intercompany segment. Before you upload the second ZIP file you should go to the Chart of Accounts structure and update the Intercompany segment label. After that you re-deploy the flexfield, and then proceed to upload the second ZIP file. This is well documented in the GL Implementation guide and is also the leading practice for using the RI spreadsheet.
The second mistake is that you put the name as "QS Ledger" on the RI spreadsheet. Actually it should be the Chart of Accounts name and not the Ledger name. The system assigns the Ledger name by suffixing the country code to the COA name. The "Name" in the first tab should be your COA name and you should avoid using the word "Ledger" in it.
The third mistake is that you put the Canadian province in the State column of the RI spreadsheet. You should put it in the Province column. Hope this helps.
Thanks for taking time to provide the feedback.
1. issues mentioned you are valid and I had shared the same in my video also. I should have added removing the segment label.
2. QS Ledger is my COA name. It was for the demo purpose.
3. Ok.
Thanks again.
When you add a new sheet, the system automatically creates that for intercompany and during upload automatically assigns the segment qualifier for that. You do not need to specifically do that and redeploy the flexfield.