Validation while Posting Journal Entries

[former_member225135]

Dear Experts,

I have requirement from client wherein the Journal entry (for consolidation) should not be posted if the supporting is not attached (either in journal template or in document section).

Please let me know if any of you have came across the same requirement and any solution/work around you have

System Details:

SAPK-81008INCPMBPC

SAPK-74014INSAPUI

Regards,

Rahul

[astonebraker]

Change the users to be only allowed to park journal entries. After parking, add the supporting documentation as an attachment to the journal entry under Services for Objects. Then have a separate user review the parked entries to be sure supporting documentation is attached, then post. You are not able to add attachments until the journal entry is created either through parking or posting.

[former_member186338]

Sorry, but are you talking about BPC journals??? "parking"? "Services for Objects"??

[Former Member]

Hi Rahul,

Have a look at the below note, it gives an idea that journal validation can be applied to UJ_VALIDATION using a BADI.

2340984 - Detailed journal validation error message is not displayed

Also this note for a parameter which says UJ_VALIDATION is applied to journals while saving.

2163780 - UJ_VALIDATION is always triggered when saving journal.

Also in help...a BADI is given for adding or calculating any entirs while saving a journal.....but dont know whether it can used to have a validation in it.

http://help.sap.com/saphelp_bopacnw101/helpdata/en/34/d10429fd55426e9b6bfae6ec393fc2/content.htm?fra...

Regards,

JP

[former_member186338]

Sorry JP,

Looks like you didn't read the question... The topic author is asking not about validating records sent by journal but to have the document uploaded in the system "related" to this journal. Please don't answer just to answer something.

[Former Member]

Sorry Sir....But please don't pre assume that I am answering it just for the heck of it without reading! Sorry. I have answered above solution just to tell him that BADI can used through UJ_VALIDATION!!!! I read yours and Rahul's conversation! Yes their is no link for the documents uploaded in the system to cross check against the journal ID!

But one thing can be done is...in Journal template in the comments section, ask the user to enter the documents name which will be uploaded as a supporting document for it. Then using the UJ_VALIDATION BADI, check the comment name from this table UJJ_TMPL_ADITMS and cross verfiy it from UJFS whether such document exists or not.

I have not tested it....but its a thought! Looks like it should work through ABAP.(seems logical). I may be wrong also. Just an idea.

Regards,

JP

[former_member186338]

"name which will be uploaded as a supporting document for it" - bad idea!

- user can enter any name 🙂 it's not the way how to perform checks...

- if you upload document the file name is not unique...

[Former Member]

- user can enter any name 🙂 it's not the way how to perform checks... - Yes! there will be some discrepancies in it.... 🙂 can be expected! But if the user wants this requirement badly...then will have to train them in doing so!

- if you upload document the file name is not unique... - where? in UJFS?

[former_member186338]

Sorry, but it's not a question of user training... Users are able to always enter the same name of some saved document and the test will be happy! This is absolutely not the right way of doing any test!!!!

not unique - it depends where and how the document is saved.

The only way to achieve the requirements is to create new interface where journal posting is combined with document upload (plus some integrity relation between document id and journal id)

[former_member225135]

The logic behind this is the user want to have some supporting working for each journal posted. The same working can be referred in future to understand the logic of final output.

In absence of any working, the user should not be allowed to post entry

[former_member186338]

You don't understand me!

Uploaded document has no relation with the journal that is posted in the next step! While posting journal you are not able to check if you have uploaded document related to this particular journal in the system! And you can't combine document upload and journal posting in the same interface without rewriting BPC 🙂

[former_member225135]

I know the logic of BPC. I have explained the same thing to my client and they are not ready to listen to this. 😞

I Just wanted to know whether there are any other options to meet the client requirement which I am not not aware.

As you have said that this is not possible, I have to fight with client to make them understand this

Regards,

Rahul

[former_member186338]

You can propose the client to change BPC code and write new journal interface 🙂 For $$$$$$$ 🙂

[former_member225135]

But can we do it through Badi ?

I have workaround where I can create BPF and ask user to upload document first before going to next step of journal entry. But my only concerns is when user will not go through BPF, then such validation can't be kept in place

Regards,

Rahul

[former_member186338]

But how do you want to link uploaded document with the journal entry??? Logically impossible!

[former_member186338]

Sorry, but no way! Journal entry is not linked to any document etc...