Getting an error message WS 123 while settlement of condition contract in S/4 HANA

[former_member336590]

Getting an error message WS 123 "A balance of USD 18,998.87- exists in document 0000000001" while settlement of condition contract in S/4 HANA

[former_member269211]

Dear Expert,

I have same issue as your one. Did you have solution to fix issue?

If you, please help to give me this.

Thanks,

Bình

[Former Member]

settlement1.jpgaccounting-settlement.jpg

[Former Member]

Hi

Please check the Tax Code Determination in your settlement process type. it should be 3-From Price Determination.

Regard

Venkata Sree

[former_member336590]

Hi Venkata

Thanks for your response. I am getting another error while settlement run after making change suggested by you.

Balancing field "Profit Center" in line item 002 not filled

Can you please help on why this might be happening? Also it will be great if you can share the control data for settlement pricing procedure.

Thanks

[Former Member]

Hi

Please check your split criteria in business volume profile determination. There should be split based on the PRCTR field also. Below is the standard PP control for settlement. if the error still occurs please share the error screen.

[former_member336590]

Hi Venkata

After adding the PRCTR field in the split criteria the profit center related error is gone. However, i am still getting the error around balance. Strangely, I do not get any error in "Check Run" but get the following error in "Live Run"

Also it will be great if you can help with the different condition types you have used.

We have used REBA and REBT as the accrual and the rebate condition in Condition contract.

Then we have setup the pricing procedure as below

REBA condition is determined in the source document (billing document) and is posted to accounting with the accrual key Z04.

Kindly let me know what wrong we might be doing and once again a big thanks to you for so far replying to my queries.

Thanks

[Former Member]

Hi Akhilesh,

This error due to the tax condition type in your settlement pricing procedure. you need to maintain the Handling of Missing Tax Code indicator as 2-No error in settlement process document type.

Can you let me which version of S4HANA your using. 1610 or 1709

[former_member336590]

Hi Venkata

Thanks for your help so far. We are using S/4 HANA 1610 version also the setting you highlighted above is already maintained.

Still the error persists. Does the pricing procedure looks ok to you?

Thanks

AK

[Former Member]

Hi Akhilesh,

Can you please re-check the TAX condition and condition record. The balancing issue is coming from the tax condition setting.

[former_member336590]

Hi Venkata

I checked the tax codes and there was indeed a master data problem with the same. This is resolved now. However, the balance error is still there. The amount that is shown is the actual rebate amount to be posted against condition type REBT.

Any pointers on why this might be happenning?

Also it will be great if you can share a sample accounting document of the actual invoice (with accrual posted in VF01) and the settlement document accounting document. This will help us in pin pointing the actual issue here

Thanks

AK

[Former Member]

Hi Akhilesh,

your settlement Gross Credit Memo Amount is not matching with Net Credit Memo Amount( Gross credit + Tax) . so the balance of USD 161.55 is showing. Below are the accounting posting for Settlement document.

[former_member336590]

Hi Venkata

In our case tax is ZERO and hence the gross and net are same. Thanks for providing the accounting document screenshots

Do let us know if you have any more pointers for us to look into.