Question:
I’m working on automating invoice creation in Tadabase.
In TABLE 1, I have multiple records where different Manufacturers (Manufacturer 1 & Manufacturer 2) are assigned to the same Sales Rep. Currently, when I generate invoices in TABLE 2 (Invoice Table), it creates separate invoices for each manufacturer, even though they share the same Sales Rep.
How can I automate the process so that only one invoice is created per Sales Rep, even if multiple manufacturers are assigned to them in TABLE 1?
Would appreciate any guidance on how to structure this automation efficiently. Thanks!