I'm running into issues with creating an AR Cash Receipt Import using VI in version 5.1/2014. Does anyone happen to have a sample AR Cash Receipt VI job that they would be willing to share? Any help would be greatly appreciated. Thank you.
I'm running into issues with creating an AR Cash Receipt Import using VI in version 5.1/2014. Does anyone happen to have a sample AR Cash Receipt VI job that they would be willing to share? Any help would be greatly appreciated. Thank you.
You have to first import into AR_Batch to load the deposit Number, Bank Code, Date, Batch if you use batches, and the total cash deposit. Once done, you can import into the Cash Receipt table. I don't think you can do both in one import, or at least, I couldn't.
It this info helps, cool, if not I will post both my VI Jobs.
I agree with you on the need for two jobs here when batch entry is being used. I'm still having issues with importing into the Cash Receipt table. Would you be willing to post your jobs so that I may use them as a guide to see where I'm going wrong? Thanks so much!
This is my batch import:
"Import Job Definition" "Complete Coach Works (CCW)"
"Configuration Information"
"Job Name:" "AR_BATCH" "Table Name:" "AR_CashReceiptsDeposit" "Compiled Name:" "VIWI1S"
"Import File:" "c:\je\AR_Batch.txt"
"File Type:" "DELIMITED" "Delimiter:" "," "Import File On Host:" "N"
"Next Job Chain:" "AR_CASHREC"
"Data Elements" "Data" "Field"
"Seq No" "Column Name" "Type" "Type" "Oper" "Col" "Mask" "Default Value"
"0001" "DepositNo" "STR" "STD" "REPL" 1 "Start: 1 Len: 5" ""
"0002" "BankCode" "STR" "STD" "REPL" 2 "Start: 1 Len: 1" ""
"0003" "DepositDate" "STR" "DATE" "REPL" 3 "M/D/Y" ""
"0004" "BatchNo" "STR" "STD" "REPL" 4 "Start: 1 Len: 5" ""
"0005" "CashDepositAmt" "NUM" "STD" "ASSN" 5 "###,###,###.00-" "0"
"0006" "CreditDepositAmt" "NUM" "STD" "ASSN" 6 "###,###,###.00-" "0"
"0007" "CreditBalanceAmt" "NUM" "STD" "ASSN" 7 "###,###,###.00-" "0"
This is my Cash Receipt Import
"Configuration Information"
"Job Name:" "AR_CASHREC" "Table Name:" "AR_CashReceiptsHeader" "Compiled Name:" "VIWI1R"
"Import File:" "c:\je\AR_Magic.txt"
"File Type:" "DELIMITED" "Delimiter:" "," "Import File On Host:" "N"
"Next Job Chain:" ""
"Data Elements" "Data" "Field"
"Seq No" "Column Name" "Type" "Type" "Oper" "Col" "Mask" "Default Value"
"0001" "H.DepositNo" "STR" "STD" "REPL" 1 "Start: 1 Len: 5" ""
"0002" "H.ARDivisionNo" "STR" "STD" "REPL" 2 "00" ""
"0003" "H.CustomerNo" "STR" "STD" "REPL" 3 "Start: 1 Len: 20" ""
"0004" "H.DepositType" "STR" "STD" "ASSN" 4 "Start: 1 Len: 1" "C"
"0005" "H.CorporateTaxOverrd" "STR" "Y/N" "ASSN" 5 "Start: 1 Len: 1" "N"
"0006" "H.PostingAmt" "NUM" "STD" "ASSN" 6 "#,###,###,###.00-" "0"
"0007" "H.CheckNo" "STR" "STD" "REPL" 4 "Start: 1 Len: 10" ""
"0008" "L.LineType" "STR" "STD" "REPL" 5 "Start: 1 Len: 1" "I"
"0009" "L.InvoiceNo" "STR" "STD" "REPL" 6 "Start: 1 Len: 7" ""
"0010" "L.InvoiceType" "STR" "STD" "REPL" 7 "Start: 1 Len: 2" ""
"0011" "L.AccountKey" "STR" "STD" "REPL" 8 "Start: 1 Len: 9" ""
"0012" "L.AmountPosted" "NUM" "STD" "REPL" 9 "###,###,###.00-" ""
Sample Batch Data:
"0714","A","07/31/2014","MAGIC"
Cash Receipt Sample Data:
"0714","01","0CCW","0CCW","G","GL","","192000000",-3874.5,"TSI"
"0714","01","0CCW","0CCW","I","0010917","IN","",3874.5,"TSI"
Note that this is a zero cash receipt, the first line is a GL distribution, the second is an invoice.
Hope this helps.
ChaZ
This is a very old thread I know, but as the information is still valid and my question is so closely related I hated to start a new post. The sample VI scripts shown above assume a Deposit Number is included in the file to be imported. Since I didn't want to provide a deposit number I used "Next" in the import to AR_CashReceiptsDeposit. It works until I need that newly-assigned Deposit Number in the import to AR_CashReceiptsHeader... any way to get that information in to the second script? Or does everyone simply manually assign a Deposit Number in the data to be imported, or hard code a single Deposit Number to be used for each and every import?
Hello, did you figure this one out?
I did, thank you!
JC - Did you ever figure out how to do this? I'm struggling with this same issue now.
Yes. Where is your job failing? What errors are you getting?
Since I didn't want to provide a deposit number I used "Next" in the import to AR_CashReceiptsDeposit. It works until I need that newly-assigned Deposit Number in the import to AR_CashReceiptsHeader... any way to get that information in to the second script? Or does everyone simply manually assign a Deposit Number in the data to be imported, or hard code a single Deposit Number to be used for each and every import?
You ever figure this out? I have both jobs created just needing to pass the batch/deposit numbers from first to second.
Same. Any chance you've resolved this?
*Community Hub is the new name for Sage City