We're trying to update some journal record lines E...
# csvimports
m
We're trying to update some journal record lines Entity (Name) fields via CSV Import but on this particular subset of journals the field is readonly and it doesn't seem like we can overwrite it, has anyone experienced this / know how to work around it? We edit/saved the journals to unapply everything but no luck.
l
Does it contain an AP or AR line? Is it linked to another transaction with AP or AP line as well under Related Records subtab? Or does the status say Approved for Payments or something like that? If so, I am not if there's another way but if the period is still open, I mark the journal as unapproved which will break the link the Journal and that other transaction, edit the Journal, save and approve it. Then, link it back to that other transaction if I have to.
m
Thanks for the response. Hopefully this answers your questions: • I think the journal was approved but we edit/saved it to unapprove and unlink from any associated records (so it's in Pending Approval status) • They are AR lines but the Related Records tab is empty
we are worried there are related records under the hood that aren't connected to the journal anymore (as evidenced by nothing in the Related Records tab) but are still somehow restricting us from editing
I tried loading the journal via suitescript 2.0 and the
links
sublist is empty also
l
So it's already in pending approval status but the field is still not editable? That does not sound like a standard behavior of NS. You may need to check if there are workflows or scripts.
m
Correct. It was previously approved but is now in Pending Approval status. I tried turning off workflows but I think you're right about the script I just found fingers crossed
The script is a
VALIDATE LINE FUNCTION
one that adds an error if the entity is missing but i don't know why that would make the field readonly in general. I disabled it but the record is still uneditable (via csv upload/UI)
r
Accounting period is closed?
m
thanks for the follow up! No, opened all accounting periods (working in sandbox for now). Still never figured it out, we have ACS on the case now but no luck either. Only solution we've figured out is doing a full replace on the sublist which hopefully will work