Is it possible to update intercompany journal entry lines via csv import?
G B
03/09/2021, 4:35 AM
I’m looking to tag vendors on the line level of intercompany journal entries but can’t seem to figure out how to update the lines versus the csv import adding additional lines
G B
03/09/2021, 5:46 AM
The solution i’ve come up with so far is to select “Overwrite Sublists” in the csv import settings, and then reimport the exact same journal entry lines with a name include (so netsuite is deleting the lines then reimporting vs just updating the lines)
n
Netsuite Tragic
03/09/2021, 6:55 AM
when you do the export include LineId. Use this in your update to specify the exact line. You only need your changed fields, you don't need to re-import the entire line.
p
PNJ
03/09/2021, 7:22 AM
Be careful with overwrite sublists and journals. It can remove any applied amounts
👍 1
PNJ
03/09/2021, 7:23 AM
I always prefer to do a correction JE rather than updating
g
G B
03/09/2021, 12:50 PM
Thanks everyone! @Netsuite Tragic, I can export line ID for intercompany JEs, but unfortunately, there is no where to map Line ID for the csv import of intercompany JEs (vs regular JE which you can map to line ID’s)