Adding Customer to Journal Entry upload

[Former Member]

Hello,

We were told we could expand the basic journal entry template beyond what is standard. When i manually type in an entry i click assign profitability segment and i have the option to select a customer. I would like to add that option to my excel upload. How do I do this.

Thanks,

Aundrea

[Sandeep_Kumar · Accepted solution]

You can get more details here: https://help.sap.com/viewer/6b39bd1d0e5e4099a5b65d835c29c696/1805.500/en-US/d9fb8c4f76ef4277bad9b836...

[Sandeep_Kumar · Accepted solution]

you need to create a custom logic for new field first and enable this for "Post General Journal Entries". Once the coding block is published, you can see the field in template. Hope this helps.

[Former Member · Accepted solution]

Hello,

this link does not address adding columns in Excel it addresses adding and changing fields in the tiles. Is there a way to add the column in Excel.

[NarendraChandel]

Hi Sandeep, other experts,

We have added a custom field in Coding block its of type Code list and the same field is available when we doen the template in "Upload Journal General Entries" app but when we add value to this custom field and upload it gives error

Sorry, a technical error occurred. Please try again later.Show Log and nothing is shown in the log.

but when I try to debug the app using F12 it show error with odata service FAC_GL_DOCUMENT_POST_SRV/FilesContentForUpload with status 403 and no further information.

Has anyone faced this issue and how this can be resolved

[former_member94298]

You don't need to do any extensibility to add the 'customer' field that you get in the profitability segment window to the journal template/ PROF_KNDNR is the field you need.

[rb2020]

Could the same thing be done to add a vendor to a journal? I find it can be very difficult to actually analyze the P&L on an expense basis, given many many vendor expenses are recorded or adjust by either accruals, or recurring journal entries for amounts that are prepaid and posted to the income statement over one or two years.

[Ana_Moreira]

You have all the fields available in the template in Help Portal

https://help.sap.com/viewer/0fa84c9d9c634132b7c4abb9ffdd8f06/1908.500/en-US/41f88d19c3b64b1db1c2aa80...

[Former Member]

Unfortunately none of the names of the templates are clear like that. They all look like this:

/CFG/FORM_CFGSOL_CONFIGNOTES

CH_VAT_DCL_V0

CH_VAT_DCL_V0_PRINT_OUT

E2EIE_IC_FORM_CHANGELOG_PDF

E2EIE_IC_FORM_CONFIG_NOTES

FDP_SRF

FDP_SRF_PDF

FIMY_GST_03

FIN_FO_PAYM_LIST

FIWTKR_BUSINESS_INCOME_CC

FIWTKR_BUSINESS_INCOME_SUPPL

[Sandeep_Kumar]

this relates to maintain form templates and not upload Journal entries.

[Former Member]

tile: maintain file templates

pre-delivered templates

[Sandeep_Kumar]

Not sure from where you are getting these files.Can you paste a screen-shot of the app here?

[Former Member]

I want to edit the "standard" journal entry upload template. I found the tile to do this but i need to know what the official name of the template. None of the files whose description shows journal matches the "standard" template.

[Sandeep_Kumar]

You can donwload the standard template using app "Upload General Journal Entries" and the file name should be "JournalEntry_Template"

[Former Member]

Thanks, do you know what role can do this. and the steps. or is that the link you sent. the link mentions adaptation mode. I can not find that. Any and all clarification would be great

[Sandeep_Kumar]

Check role "EXTENSIBILITY" and app to create coding block is "Custom Fields and Logic"