Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Contributor
PEBA
Posts: 18
Registered: 03-25-2009
0

Importing AR invoice

I do not write many VI imports but have created a few AR invoice imports with no issues but I have never imported multiple detail lines so I'm not sure what step I am missing on this.

 

We are on version 4.3.  I am importing AR invoices and having a problem with importing more than one line of detail into the detail record.   I am using the Next function for the invoice number.  Everything works well except the 2nd line of detail is overwriting the first so I only get one line in my invoice detail instead of two. 

 

My excel file contains the header and both detail records in the same line.:

 

Div#  Customer #   Item Code1  Quantity1   Amount1   Item Code2  Quantity2  Amount2

 

Thanks!

Pam Wilson
Super Contributor
Posts: 1,462
Registered: 11-03-2008
0

Re: Importing AR invoice

Each item needs to be on a separate row in your spreadsheet.

Contributor
PEBA
Posts: 18
Registered: 03-25-2009
0

Re: Importing AR invoice

Not what I wanted to hear but thanks so much for the info!

Pam Wilson