Hi @Devon_Godfrey as if by magic or your presence in this thread the script is now working without any changes by me, perhaps AT had a wobble that has been fixed?

I had this working perfectly but yesterday the autonumber stopped being created. There are some posts about AT problems with Automations at the moment, anyone else experiencing this?

I would have liked to not have to create the additional field but at the moment that seems to be the way for me to do it. The Table you shared has given me some new ideas, thanks

Elias_Gomez_Sainz1h Afaik, you can’t create a Lookup on Suppliers table to get ONLY the unpaid Invoices. How have you done that? To show only the unpaid I created a new column “Unpaid Invoices” in the Invoice Table which uses a formula to see if th...

Thanks again Also, in the same way, you could create a new View in Suppliers table, seeing only those with pending Invoices (but in the Invoices linked record field you will see ALL the invoices related to that Supplier). The only problem with this...