Skip to content
+1-888-319-3663

COMMUNITY FORUM

GL Transaction Integration

Shraddha asked 4 years ago
We are using a .csv file to run the GL Integration with the amount format as 
 
000249833,0000000000001,20170401,101-200-1011,000074993,Lse #2024410,000000697.84,2024410,LoanBkAdj
000249833,0000000000002,20170401,101-200-1000,000074993,Lse #2024410,000000697.84-,2024410,LoanBkAdj
We are able to have the amount converted to debit using the below script but the credit script doesn’t seem to work. Can you please suggest what can be done?
DEBIT
if not  fn.RIGHT(_F7,1) = “-“ then
return fn.VALUE(_F7)
else return 0
 
end if
 
‘CREDIT
 
if fn.RIGHT(_F7,1) = “-“ then
return fn.VALUE(fn.REPLACE(_F7,“-“,“”))
else return 0
 
end if
 
Answers
Ethan Sorenson Staff answered 4 years ago
Shraddha,
We have a help article that provides .NET scripts to make these conversions.
How to separate Debits and Credit when the source file has only 1 column

If you would like to submit an answer or comment, please sign in to the eOne portal.