Skip to main content
Question

Need to create a GL transactions Import scenario with one line


NAthukorala47
Jr Varsity III
Forum|alt.badge.img

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

 

 

8 replies

Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • March 27, 2023

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,

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • March 27, 2023

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.

 

 


NAthukorala47
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 57 replies
  • March 27, 2023

Hi, 

Consider Batch number as automatic. Then how could I correct this ?

 

Regards

Nethupul

 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • March 27, 2023

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


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • March 27, 2023

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,

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • March 27, 2023

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.

 

 


NAthukorala47
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 57 replies
  • March 27, 2023

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2657 replies
  • May 17, 2023

Hi @NAthukorala47 were you able to find a solution? Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings