How do I update an entire column with a value?
Summary
update field entry in visual BuilderContent
Hello all!,
I have an integration in PaaS that is reading documents that contain refund amounts The refund amounts are broken up by each item that invoice contains.
so a file containing refunds for processing would look like:
Invoice number, Name, Item, item value, total, other stuff,...
1234, john smith, item1, someNum1, anotherNum,... ,
1234, john smith, item2, someNum2,anotherNum,.. ,
.
.
.
6541, Jane Doe, item1, someNum1, anotherNum,... ,
6541, Jane Doe, item2, someNum2,anotherNum,.. ,
.
This integration will be scheduled to run as needed so each refund document will change run to run
What is being asked of me: process invoices for refund only if the total of of the item values equals to the total listed amount and output a file of invoices where the total does and doesn't match the sum of all the item amounts.