I have an ms sql database that contains and invoice header table and an invoice line item table; this is a one to many relationship. Normally, in SQL we would create a join statement to merge the datasets. In the case of integration with Netsuite, I am attempting to push the header record with all associated line items to the invoice object. Currently, when I do this, it is creating a new record for each line item rather than grouping them appropriately. I'm trying to use lookups and other methods to handle this children/line-items with no luck. Can anyone assist me with this issue?
Please sign in to leave a comment.