we are trying to load voucher from excel sheet
as total the balances are equaled but on the LOAD_GROUP_ITEM level
the voucher is not balanced.
system created 2 LOAD_GROUP_ITEM M & M1
advise please
Best answer by Nagah.khaled
View original
This topic has been closed for comments
Userlevel 4
+7
Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.