Anyone know how to associate vendor bills with cli...
# generala
Alex Long
12/06/2021, 10:49 PMAnyone know how to associate vendor bills with client invoices through the REST/SOAP api records?
b
battk
12/06/2021, 11:53 PMreframe your question using the native netsuite names of transactions
battk
12/06/2021, 11:53 PMpurchase order is the normal transaction before a vendor bill, and a vendor payment is the normal one after
battk
12/06/2021, 11:54 PMhonestly neither sounds like a client invoice
a
Alex Long
12/07/2021, 2:59 PMIf you review the Endpoints in the API browsers - Invoices and Vendor Bills are distinct endpoints. I really only have familiarity with API side. When I pull from the "PurchaseOrder" endpoint - there is no data.
Alex Long
12/07/2021, 3:00 PMMy goal is to create a P/L for each invoice line. Associate all the Invoices with their respective Vendor Bills and do a basic aggregation and subtraction.
b
battk
12/07/2021, 3:09 PMinvoices are linked to the sales line of transaction
battk
12/07/2021, 3:09 PMso sales order to invoice to customer payment
battk
12/07/2021, 3:09 PMvendor bills are linked to the purchases line
battk
12/07/2021, 3:09 PMpurchase order to vendor bill to vendor payment
a
Alex Long
12/07/2021, 4:12 PMSo if I wanted to know which Vendor Bills are associated with a specific Invoice - what is the key?
Invoice A was 500 for Project A
Vendor Bill 1,2, 3 each were 100 for Invoice A on Project A - I don't want just to associate to the project, I want to associate to the Invoice
b
battk
12/07/2021, 4:37 PMthere is none
battk
12/07/2021, 4:38 PMnatively netsuite does not track which individual item is sold unless you are using things like serialized items
a
Alex Long
12/08/2021, 2:03 PMso we are a marketing firm. I know it's possible to associate our vendor bills with the client invoices because we have a custom report that does so. It provides us a P and L on each invoice based on the associated vendor bills.
Alex Long
12/08/2021, 2:03 PMI don't know how to do it using the API endpoints available
b
battk
12/08/2021, 7:09 PMyou can use customization to associate invoices with bills, but you would need to understand how that association is done
battk
12/08/2021, 7:10 PMthen replicate that via api
3 Views