AR Import Question 1

[iwells]

Hi,

I've googled this error and check this forum, but I'm not finding much on this ...

I have a multi-invoice import file and each invoice has multiple lines, but I'm getting the error:

Description: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Source: 10:39:49 - 1063.800a0bb9.506.225

Here's a sample of the two tabs for the import that I populated (the other 3 tabs exist but are ignored ... Excel 2000 worksheets for the format):

INVOCIES

CNTBTCH CNTITEM IDCUST IDINVC INVCDESC DATEINVC DATEDUE DATEBUS SWMANTX AMTTAX1 AMTTAX2 AMTTAX3 AMTTAX4 AMTTAX5
1 123 3A 3A 11/30/2012 11/30/2012 11/30/2012 1 22983907 0 0 0 2
123 4A 4A 11/30/2012 11/30/2012 11/30/2012 1 18272723 0 0 0 3
124 5A 5A 11/30/2012 11/30/2012 11/30/2012 1 0 0 0 0 0

INVOICE DETAIL

CNTBTCH CNTITEM CNTLINE AMTEXTN IDACCTREV AMTTAX1 AMTTAX2 AMTTAX3 AMTTAX4 AMTTAX5
1 20 95766098 1 15322576 0 0 0 0
1 40 6617265 1 1058760 0 0 0 0
1 60 18324734 1 2931958 0 0 0 0
1 80 22941331 1 3670613 0 0 0 0
2 20 71770695 1 11483312 0 0 0 0
2 40 945324 1 151252 0 0 0 0
2 60 21287960 1 3406074 0 0 0 0
2 80 20200529 1 3232085 0 0 0 0
3 20 6720596 1 0 0 0 0 0
3 40 872606 1 0 0 0 0 0
3 60 908965 1 0 0 0 0 0

If I leave the item/line numbers out the import attempts to add all the invoice details together and gives an error that the sum of the detail taxes (41,256,630) isn't equal to the first line item tax (22,983,907).

Am I missing a field to form the direct relationship between header and detail lines? Clearly I am, but per the documentation and my testing I'm overlooking it after 14 days off for Christmas.

Accpac 5.5/5.6

 

[ettienne]

That error normally means you have mixed data types in an Excel column, in other words you have numbers and text in one column. Each column in Excel must either contain all text or all numbers, not a mix of text and numbers.
For example, if you have A123 in row 1 and 123 in row 2 then you have mixed text and numbers. You need to convert the number to text in Excel, enter the number as '123 or use the =TEXT() function to convert numbers to text.

Also looking at your file layout (which is almost impossible to read as is) something does not make sense.
Do you have anything in the CNTBTCH field? This can be 0 but you must have something in there, use the same value for all lines.
CNTITEM in the header must match CNTITEM in the detail - that seems to be wrong as well.
CNTLINE in the detail can be 0, this is auto assigned when you import.

 

[ettienne]

On second thoughts...
Fix your CNTBTCH, CNTITEM and CNTLINE fields and the errors should be fixed.

 

[iwells]

Sorry for the formatting, it didn't copy as I expected and I didn't preview the post ... it was the CNTBTCH ... I didn't give it a 0 value as I had been informed to leave this blank. Work now, thanks!

 

[ettienne]

You can never leave required fields blank, whoever told you that knows not what he speaks of.