I need to add custom fields to the File record. Seems like NetSuite does not allow this. What we have is vendor bills with attachments on the File tab. We sync this to an external app and that may sometimes fail, hence I wanted a checkbox on the File record itself to track success or failure of the sync.
I could create a custom record with fields - File Internal ID, Vendor bill Internal ID, External app internal ID that tracks all this but then i dont think there is an event i suitescript I can use to trigger when a file is attached in view or edit mode on a vendor bill (i would need this to write to my custom record).
Any ideas on how we could do this?