I have a line item table which has connections to the “manufacturer” table, and that manufacturer table has an assigned “contact person” table. I want to make an invoice and combined all line items to order from each contact based on whom they belong to using automation task, the regular scenario is that I have 100 orders from different manufacturer, and I want to combined all line items per manufacturer, when order comes, then I can send the invoice pdf after the automation combine orders from the same manufacturer (source of the item)
Remember: each order contains 100 items, and not from the same source, it has multiple location, but the customer orders from us directly and we get it from different manufacturers, how can we make that possible? We don’t like to get any third-party that’s why we have tadabase for this… Please help.