[trimblee]

I'm setting up and testing a vendor bill import, and getting this error:

Transaction is not in balance! 273771.41,273771.4

I'm not setting the amount at the header level, only at the line. From the error, it looks like it's only off by $0.01. Is there some sort of rounding error happening?

The expense file has 19 lines, some with up to 6 sig figs. Is NetSuite rounding the line amounts vs the total that posts to AP differently?

Anyone seen this before?

Thank you.
This is a cached copy. Click here to see the original post.

[trimblee]

RE: Vendor Bill Import – Transaction not in balance

I trimmed all my decimals to two places and the upload worked. This seems like a bug though, I'm going to file a case.

[skhanna]

Hi

I am trying to do the same import but the issue I have is that the first line amount value is replacing the amount on all the following lines. Any ideas why? Also its not showing the customer/job name on the line items.

Please help.

Thanks

SK

[trimblee]

RE: Vendor Bill Import – Transaction not in balance

Are you using two files, one for header data, one for expense? If you aren't, that's probably the cause of the amount issue, if you are, I'm not sure. Can you post a few example lines?

For the Customer/job: Are you setting "Billable" to True? If you aren't I think NetSuite won't write whatever data you've mapped in the Customer:job field.

[Author]

Posts