I'm getting an error when uploading the payment fi...
# generall
Luis
12/07/2023, 8:21 PMI'm getting an error when uploading the payment file to the bank. It says File Creation Date is Future Dated. But I can't see the file creation date/time stamp in the template. The template is the standard CPA-005.
s
Sam-I-Am
12/07/2023, 8:39 PMLook for the fields:
pfa.custrecord_2663_file_creation_timestamp
Sam-I-Am
12/07/2023, 8:40 PMand pfa.custrecord_2663_process_date
l
Luis
12/07/2023, 8:44 PMThanks. Is there also a timestamp in the template? It looks like the file creation date is converted to yyDDD. Not sure how it knew the time itself. The file was generated by a user from Australia for a bank in Canada. So it's future dated in Canada but not sure where the time is in the template or file
s
Sam-I-Am
12/07/2023, 8:45 PMpfa.custrecord_2663_file_creation_timestamp
Sam-I-Am
12/07/2023, 8:46 PM Copy code
A${setPadding(recordCount,"left","0",9)}${setLength(cbank.custpage_eft_custrecord_2663_issuer_num,10)}${setPadding(newSeqId,"left","0",4)}${setPadding(pfa.custrecord_2663_file_creation_timestamp?string("yyDDD"),"left","0",6)}${setPadding(cbank.custpage_eft_custrecord_2663_processor_code,"left","0",5)}${setLength("",20)}CAD${setLength("",1406)}Sam-I-Am
12/07/2023, 8:47 PMLOL international dateline in action!!!!
l
Luis
12/07/2023, 9:13 PMThanks. I'm not so techy, so I only understood yyDDD in for the timestamp. Where is the time there?
y
yagyakumarnag
12/08/2023, 4:45 AMHi Luis,
We need to check your actual EFT template then only It can be figured out.
l
Luis
12/10/2023, 8:05 AMIt's the standard CPA-005. Anyway, it looks like it does not log the actual time stamp in the template. Only the date portion.
j
Jon Kears
12/10/2023, 10:44 PMI'd assume it's timezones. Aus is consistently 14-16 (17?) hours ahead. yyDDD is the day in year, so runs from 0-365. You're probably ahead of when you want to post it
8 Views