BP validation for reconciliation account in S4HANA

[former_member658995]

Dear Experts,

Could you please advise how to handle validation for reconciliation account in BP [S4HANA].

Requirement is to validate and display error message if not exist based on

1) Correct Reconciliation tagged to External BP and Interco BP.

2) Trading Partner field must be tagged in the Interco BP.

Thanks,

Sanjeev.

[VeselinaPeykova]

As a starting point, I think that you need to figure out how to distinguish the inter-company BP from the rest of the BPs.

It seems that you are a developer, in which case I would recommend that you talk to the functional consultant for clarifying the requirement.

[former_member658995]

If initial then we need to display error message.

Please advise

[former_member658995]

Hi Veselina Peykova,

Thanks for your reply seems need to handle either BADI or BDT , but need advise and below are the rquirement details:

1) Employee Vendor should not be subjected to Vendor Confirmation Process as Vendor Master Team does not have any control over the employee data as it is managed and maintained by the HR Team. Hence Employee Vendor Master should be excluded from the Vendor Confirmation Process.

2)1.Correct Reconciliation Accounts should be tagged to the correct accounts group

a.Interco Business Partner should tagged as followed:

i.Vendor Accounts: 223***

ii.Customer Accounts: 123***

b.External Business Partner/Individual Business Partner should be tagged as followed:

i.Vendor Accounts: 221***

ii.Customer Accounts: 121***

2.Interco Business Partner should be tagged with a trading partner

Thanks in advance.

Sanjeev

[VeselinaPeykova]

Probably my initial comment was not very clear.

What I actually meant was that depending on how these business partners are configured in your system, some of the tasks (trading partner mandatory for inter-company business partners) will not require development effort - for example, if you use different BP types or if you have separate account groups (if you have implemented note 2516606 - BP_CVI: Taking into account the FI-specific field modification of customer and vendor in t...).

For checking whether specific values for reconciliation account are suitable for a specific kid of BP - here you will need to write custom logic, because you cannot restrict it only via configuration - in standard you could enter any account as long as it is set as a reconciliation account for the corresponding account type.

This was the reason why I suggested a discussion with the functional consultant before you start with development.

[former_member658995]

Thanks for your reply @Veselina Peykova,

I'd discussed with functional owner and confirmed its based on BP grouping, will distinguish the inter-company BP from the rest of the BPs.

Mentioned note, is not how to validate field in BP so please advise if there is any way to display validation message.

Thanks,

sanjeev

[VeselinaPeykova]

You need custom validation message only for the reconciliation account, for the trading partner field you do not need one (at least it does not seem so from your explanation). For the trading partner - once you set it to mandatory, it has to be maintained, it is just a matter of configuration to set it mandatory for the criterion that you need. The note that I mentioned is aimed at functional consultants, so that we do not create unnecessary work for developers 🙂

I cannot advise you on how it is best to develop the custom message for the correctness of reconciliation account, I am not a developer, sorry.

In the projects where I worked, selecting the right reconciliation account was never a real issue requiring custom logic, our business users picked it based on account description and it was easy to validate the templates for initial upload.

[former_member658995]

Thanks , I am able to manage and implemented BDT with custom Function module for CVIV30. CVIC30 & FS1147 --> Trading Partner Number.

Able to do validation for all 3 fields for customer and vendor , Trading Partner.

Thank you.

Sanjeev