Skip to main content

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 @NAthukorala47 

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 @NAthukorala47  In addition to VKumar comment, also please check the value that you are passing to Batch Nbr = Date and the same value you are passing to Transaction Date.

 

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

 

 


@NAthukorala47  Provide some text value like “AR12345” instead DATE value and verify.


Hi @NAthukorala47 

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, @NAthukorala47  Even if you provide some static number on the imports while creating the document system will consider the Auto-Generated Value.

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 @NAthukorala47 were you able to find a solution? Thank you!


Reply