Hi,
We need to create GL transaction import scenario using single line.
The debit and credit lines need to represent in one line.
Attached the screen shot as a reference.
Regards
Nethupul
Hi,
We need to create GL transaction import scenario using single line.
The debit and credit lines need to represent in one line.
Attached the screen shot as a reference.
Regards
Nethupul
Hi
Error seems to be pointing to your Batch number column. What is the value you are supplying for Batch number? Is Batch number set to auto number or manual sequence number?
Regards,
Hi
This is also one of the reasons to get this issue. Please verify.
Hi,
Consider Batch number as automatic. Then how could I correct this ?
Regards
Nethupul
Hi
Even if the Batch number is set to automatic, on your source data, add a column for batch number and use any number or alpha numeric reference number to identify the batch.
On import, it does use an auto generated number.
Regards,
Yes,
Better provide the unique numbers for the Reference Numbers.
Since you have used the DATE value, hence getting the Input String is not in Correct Format Error.
HI,
I have attached the import file. As you mentioned batch no we can leave as blank and then system will consider system number sequence?
And could you check my excel file ?
Regards
Nethupul
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.