AP Invoice 2

[Zak2009]

Hi All,

Am creating an excel CSV template to be used to import invoice details in AP.

When the invoice has one detail it imports okay but when it has more than one detail it gives the following error.

"Description: Invalid input. The document total amount does not match payment schedule amount. Correct payment amounts in the schedule." I have tried to adjust almost all the figures that show the amounts but to no success,which field has the "payment schedule amount"

Kindly assist

Thanks

 

[ettienne]

Leave the payment schedule lines blank, this will be calculated when you import.

 

[Zak2009]

Thanks,

How do you achieve this exactly

 

[Jay Converse]

Leave that rectype off the file, i.e., only have rectypes 1 and 2.

 

[ettienne]

You still need to include the rectype 3 headings, just leave the records out.

 

[Jay Converse]

Oops, yes, that's what I meant.

 

[Zak2009]

Thanks,

Am still getting the same error.

 

[Jay Converse]

Then you didn't do what we said.

 

[ettienne]

You're doing it wrong...

 

[Zak2009]

This is how the field have been specified,

RECTYPE CNTBTCH CNTITEM IDVEND IDINVC INVCDESC DATEINVC AMTTAX1 AMTGROSTOT AMTINVCTOT AMTDUE
RECTYPE CNTBTCH CNTITEM CNTLINE TEXTDESC IDGLACCT AMTTOTTAX AMTDISTNET AMTDIST AMTGLDIST
RECTYPE CNTBTCH CNTITEM CNTPAYM DATEDUE AMTDUE AMTDUEHC
1 517 2935 CCBRO005 20970 Brookside Dairy Ltd 20100709 1073.1 13380 13380 13380
2 517 2935 20 Brookside Dairy Ltd 40000 0 5600 5600 5600
2 517 2935 30 Brookside Dairy Ltd 40000 1073.1 6706.9 6706.9 6706.9
3 517 2935 1 20100808 13380 13380

 

[Jay Converse]

Remove the last line.

 

[Zak2009]

Thanks so much it has worked.