Finance File upload problem

[former_member193063]

Hello Expert,

I am trying to load GL Accounts(Company Code) through File Upload.I  have created a Blank change request for service request Account of Company code(0G_SR_01) and the status of change request  without approve is Change to be Executed . While when I upload that take Entity Type Account(Company Code) . It shows There is no suitable  Change Request ...

Any help would be appreciated.

Thanks

Nikhilesh

[Former Member]

Hi Nikhlesh,

You are uploading account in company code, for this the change request type created should have entity type ACCOUNT and ACCCCDET. Then you can assign the processor to the change request steps.

After this you can create a open change request and first upload an ACCOUNT, then perform the upload of ACCCCDET(Account with company code data).

Regards,

Reema

[former_member206605]

If you are using edition, make sure that ACCCDET entity type along with ACCOUNT is added.

Kiran

[former_member206605]

Nikhil

One more point - in your screen shot - update mode - its overwrite and add records. Don't use that. Use overwrite and add attribute. If you use add records, all the recods will get deleted and then the fresh data will upload. With attribute delta will get added. Add attribute option is fast compare to add records.

One more suggestion - use USMD backend program instead of doing it from nwbc. USMD backend program is fast. Create a variant through nwbc. Save the variant and use it in backend program.

Kiran

[former_member206605]

Hello Nikhil

Seems problem with your CR type. Check what is the main entity for CR type - it has to be ACCCDET and not Account.

Kiran

[former_member193350]

Hello Nikhilesh,

According to my understanding, You can use the Upload functionality with blank CR type whose main entity as "ACCOUNT".

Try once with a CR type as "ACCOUNT" and let me know the result.

Regards

Prateek Agarwal

[former_member193063]

Hello Prateek,

Thanks for your respond , yes i am trying this CR type as "ACCOUNT" and its shows No Change Request Assign to you , while I have already define the steps for assign processor to change request steps number in other MDG workflow ....

Thanks

Nikhilesh

[former_member193350]

Hello Nikhilesh,

As you mentioned that you are created a new CR type whose main entity as "ACCOUNT" not "ACCCCDET" and you already defined the processors to the CR type.

Just cross check while creating a "Create change request" are you selecting the correct the CR type entity type as well as edition.

and check whether that CR is allocated to the required user only with whom you are trying to do "file upload".

It is wrking for me as above followed steps.

Let me know your findings.

Thanks!!

Regards

Prateek

[former_member193063]

Hello Prateek ,

Yes this time I create a blank change request 0G_SR_01 for "ACCOUNT" and take a Entity type "ACCOUNT" in file upload for same edition & also user is assign to who upload file , but No luck for me . It's again shows that There is no suitable  Change Request .

please let me know what i am missing ...

Thanks

Nikhilesh

[Former Member]

Hi Nikhilesh,

Approve the CR and then try assigning that for file upload.

[former_member206605]

Even if you approve the CR, if the entity type is ACCOUNT and if your CR has ACCCDET sysem will throw error.

1. Make sure that your CR type main entity type is ACCCCDET

2. Make sure not to select single object or object required - for CR

3. Select ACCCDET in attribute - file upload

4. Create a blank CR and then use upload.

If above settings are in place, then you will never get this error.

Kiran