Alternative Reconciliation Account for Customer

[SAPSupport]

Hello,

We need to set up the functionality Alternative Reconciliation Account in SD processes. We have been analyzing all the changes that need to be done and it seems that we'll be blocked in the point where we need to assign the account determination procedure with the billing type. Could you please let us know how to configure this functionality in SAP Cloud?

We're following this on-prem related 3rd party documentation: https://onlyordinarysapnotes.com/2013/08/26/alternative-reconciliation-account-for-customer/

Thank you!

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear Customer, 

With S/4HANA Cloud 2402.3, SAP released this functionality in the Cloud edition. Here you can find the documentation: SAP Help - Determination of G/L accounts for reconciliation and cash settlement 

The functionality is enabled via the Flexible Billing Document Posting configuration. It is the Usage Task DET_RECACC_CSHSET and further down in the document you will also see example implementation. (Set Account Determination Procedure for Reconciliation Accounts and Cash Settlement Accounts)

Please refer to 3487300 - Alternative Reconciliation Account Determination in SD - S/4HANA Cloud.

Best regards,

SAP Expert

[Domagoj · Accepted solution]

Hi. I have the same problem. I followed the instructions from the OSS note above, but didn't succeed. The note and the corresponding SAP help describe how to trigger the reconciliation account determination procedure, but it does not describe how to set this procedure, corresponding condition types or access sequences. When I tried to set an account through the app 'Automatic Account Determination' (ID 100297), and chose area, corresponding CoA and application VB (recoinciliation accounts), there are no condition tables to pick. Hence, I couldn't set an alternative account. How can the procedure, condition types and access sequences be maintained?

[MilicaVorkapic · Accepted solution]

Hi, I try enable functionality Set Account Determination procedure for reconciliation accounts and Cash Settlement Accounts. I added all customizing regarding instructions: Define Parameter Catalog for Flexible Billing Document Posting, Define Formulas for Flexible Billing Document Posting for DET_RECACC_CSHSET and Define Custom Routines for Flexible Billing Document Posting. After that I also filled in automatic account determination for VC application per SalesOrg/Order reason, but process doesn't work -I still have bookings on regular reconciliation account on F2 invoice. Could you please help me? Thank you in advance, Milica

[DoreenReichel]

Hi,

with release 2408 condition table 008 will be delivered for Area (Sales), Subarea (Sales Billing), Process (Assign G/L Accounts, Application (VB). It can be configured in SSCUI 100297 (Automatic Account Determination).

Regards,

Doreen

[MartinSpani]

hello  DoreenReichel , please, reconcilation account still goes to FI document according to customer master data, but not according to 100297 configuration... i need to set reconcilliation account according to sales org/ channel and we have filled configuration table 008, application VB. 

what could be a reason for incorrect behaviour of Automatic account determinantion of reconciliation accounts ?

thanks

Martin

[Domagoj]

Hi Martin, did you set the alternative account in the app 102631?

[MartinSpani]

hello Dorren, yes, it is configured also... but does 100297 interact really with 102631 ? as we have 100297 - from GL 311100 to GL 335100 but 102631 is GL 311100 to GL 335100 but also opposite way GL 335100 to GL 311100, it is becuase of manually FI postings.. can it be that way ?

[MartinSpani]

hello, it is working... flexible posting had to be defined