Has anyone ever seen and resolved the following er...
# csvimportsp
Paul Giese
12/22/2021, 5:23 PMHas anyone ever seen and resolved the following error
Each line must have a non-null value. Zero is permitted.r
RJMNS
12/22/2021, 6:06 PMSounds like your file has an issue. I'm guessing there's an "extra" line at the end of your file that was blanked out. I'd delete (not Clear Contents) all blank rows and all blank columns, save and then try again.
k
KevinJ of Kansas
12/22/2021, 7:16 PMalso - make sure that you don't have values in both the debit and credit column in the same line
KevinJ of Kansas
12/22/2021, 7:16 PM(zero counts as a value)
p
Paul Giese
12/23/2021, 1:07 PM@RJMNS - I did a CTRL+END check to ensure there are no extra blank rows
Paul Giese
12/23/2021, 1:09 PM@KevinJ of Kansas - I removed the zeros from the debit and credit columns too
Paul Giese
12/23/2021, 1:10 PMHere is a screenshot. Everything that can be set to Internal ID is.
Paul Giese
12/23/2021, 1:26 PMI successfully loaded a different advanced IC journal that wasn't impacting the intercompany AR or AP account. I'm wondering if that has something to do with the issue. Or, if there is some field that I need to include/exclude.
k
KevinJ of Kansas
12/23/2021, 10:17 PMOh. I'd just do this one in the user interface until I figured out the combination of factors that worked - I'd expect it's because you are touching AR and AP and not defining elimination on all of them as well as vendors/customers
24 Views