validation

[Former Member]

hello expert !

how to check if the row is uploaded with amount equal to zero or more 0 ?

the idea is to force users to upload even if the amount = 0.

thanks a lot

S.

[Former Member]

Hi Sonia,

AFAIR, it is solvable if:

1 - validation for each row

2 - use the function (do not have a system at hand - so by memory) CONDITION.

[Former Member]

hi expert !

i tried function CONDITION () but it does'nt work. The definition of the function tells that Only the characteristics of the following roles are checked:

• Group currency key
• Version
• Posting level
• Time characteristics ( fiscal year, period)
• Consolidation unit (for validating reported financial data and modified reported financial data)
• Consolidation group

Since i need to check the fs item ( if the the amount is empty ot not) i can't use CONDITION ().

is it possible to do this check ?

thanks a lot !

S

[Former Member]

CONDITION function DOES work, but for manual adjustments.

For validation of data during flexible upload I would recommend BAdI.

[Former Member]

Hi Sonia,

Please use the "Group by" option and include the FSI and other mandatory items like ORU as applicable.

This will ensure that, the condition is checked for each combination of data that is loaded for FSI and ORU.

Thanks

Premnath

[Former Member]

thanks for your help but it's not possible, it doesn't work.

[Former Member]

Hi Sonia

  Try VAL_YTD( fs_item ) = 0 or VAL_PER( fs_item ) = 0

Regards

A.Bharath

[former_member211095]

Hi Sonia,

If your upload data through document please follow Dan Sullivan instruction.

If data is uploaded through flexible upload method then create a validation method and assign it on Version combination.  This method is applicable for entire version and data.

Regards

Rajesh SVN

[Former Member]

yes data are uploaded through flexible upload.

i already create method and validation but the function is_initial( selection) doesn't work

any idea why it doesn't work?

thanks

[dan_sullivan]

Sonia,

If the upload is for documents, a validation may be defined and assigned to the document type in the document type configuration.

If not for documents (reported data posting level 00), then the task log will display the source and target records, but the standard logic will not, as far as I know, load zero records.

[Former Member]

hi Dan,

yes it for PL 00 i created an other question :

the steps are in UCWB:

I  added a new validation rule into the method.

insided the validation rule I created a selection condition wich it contains fs_item to be check and the posting level 00. Then the formula is : IS_INITIAL( condition)

then I created the error message.

When i executed the validation task it display green without error but the fs_item doesn't exist so the result must be error message.

thanks for your help