Hi @Nagah.khaled,

what is the number format of your excel ?

eg : 0.00 or 0.000xx

Best Regards

Shehan

i checked the number format and checked the uploaded data in the interface table

the voucher is balanced as a total number ,

but when we calculate by LOAD_GROUP_ITEM , it is not balanced.

solution

update the Load Group Item filed to to one value and recheck the loaded data.

system will accept the voucher and create it.

Load Group Item (depending on the external voucher basic data) is intended to create a voucher per group.  These must balance within the group. 

Example

+100 Group A

-100 Group A

+200 Group B

-200 Group B

This works.  IFS will create two vouchers.

This will not as it does not balance within the group.

+100 Group A

+100 Group B 

-200 Group B. 

Best regards, 

Thomas

update the Load Group Item filed to to one value and recheck the loaded data.

system will accept the voucher and create it.

Yep, as described, if all records have the same load group item only 1 voucher will be created.  That’s the intent of load group item.   

But if you need different vouchers from the same file, then you would have different groups and the data must balance within a group.