Hi all,
I have this kind of table (with millions of Documents):
I need to fille the missing data in with vendors/customers/offseting GL account (where vendor/customer is not given).
For example:
If there is data about vendor (vendor ID) in one of the line items in a specific document, then it should be filled in all line items in the document. If there is data about customer in one of the line items of a specific document, all line items relevant to that document should be filled with customer ID. If there is no data about the vendor/customer, then it should take offset GL account.
I have already tried with peek function and if function, but it is quite complex to put all of these rules into one field.
Is there any smart way to do it? I appreciate the help
