BCS: Validation TC balance check

[Former Member]

Hi all,

just bumped into a problem with the manual postings: Users are able to insert values in LC and TC.

For TC it is possible to give a balance for this posting unequal 0. That should not happen.

BCS doesn't check that. So we tried to create a validation rule for all posting balances in TC. Of course the system checks that for LC... It didn't work yet...

Has someone a hint or experience in this? Didn't find any in the forum yet.

Best Regards

[Former Member · Accepted solution]

Benjamin

if your client can live with TC = LC when you post a manual journal, then turn off TC as an input field, and ensure your FS Items have TC as a field in the Breakdown Cat's. TC will then mirror LC.

Regards

Marsy

[Former Member · Accepted solution]

Hi Marsy,

thank you for the reply. But I need TC! That is why I said "TC and LC".

Best Regards

[Former Member · Accepted solution]

Benjamin

just had a quick look at this and got this to work by;

create validation method, Documents, Data Rows are Totaled

create validation rule - TC_PER( TB ) = 0

where TB = all FS Items.

create error message.

Assign method to doc type.

Note the validation did not kick in until the "check" was executed on the document.

Regards

[Former Member · Accepted solution]

Hey Marsy,

thank you a lot, it works. Strange - I was absolutly sure I used that combination several times too...

Nevermind ; ) The customer considered not to use the rule anyway ....argh

Best Regards