08-04-2009 8:33 PM
Hi I have a BDc program which has 3 records in that file i.e header , detail , trailer. the text file will be sending to update the data every week. In the Detail record there are some fields where i need to do the calculations and make sure the totals are in the trailer are correct or not. for example in Check count against Total number of Detail records received on file, If not matched issue warning message Like that there is one more calculation i.e Check total against Total dollars received on file, If not matched, issue a warning message.
Edited by: Rob Burbank on Aug 4, 2009 3:37 PM
08-04-2009 8:39 PM
08-04-2009 8:41 PM
HI Rob,
My question would be how to do the calculation that total no.of records from detail is equal to trailer record count and total no. of dollar amount from detail record is equal to the trailer record if not i should show message. i need a code or psuedocode how to do it.
for example
detail record
1 2.00
2 3.00
3 3.00
4 2.00
5 1.00
Trailer record
5 $11:00
Edited by: Srinivas Bandaru on Aug 4, 2009 9:44 PM
Edited by: Srinivas Bandaru on Aug 4, 2009 9:47 PM
08-04-2009 8:58 PM
You have asked the same question in another post, so I will lock this to avoid confusion.
Rob