Anyway to pull a search of Item fulfillment that n...
# generali
iSuite
10/21/2019, 5:20 PMAnyway to pull a search of Item fulfillment that needs to be billed? I'm not seeing anything in the fulfillment that I could pull into my criteria for a search
b
battk
10/21/2019, 5:24 PMadd a filter on the created from : status column
battk
10/21/2019, 5:24 PMyou probably want sales orders that are pending billing
i
iSuite
10/21/2019, 5:26 PMYeah I've got sales orders pending billing, but I want to be able to bill partially fulfilled orders as well with a ss workflow. The problem is I have to do it with Item Fulfillments it seems because if I have it bill a Pending Billing/Partially fulfilled order it bills the whole order
b
battk
10/21/2019, 5:30 PMif you use the join, you can search the sales order is was created from
battk
10/21/2019, 5:30 PMfrom the item fulfillment search
i
iSuite
10/21/2019, 5:34 PMYeah so if I do an item fulfillment transaction search and set the criteria to Created From: Status = 'Partially Fulfilled/Pending Billing' it won't just pull the item fulfillment pending billing, it will pull all fulfillment's linked to that order even they have already been billed.
b
battk
10/21/2019, 5:54 PMim not sure that netsuite actually tracks fulfillments in that way. fulfillments are linked to sales orders and sales orders are linked to its billing transaction
battk
10/21/2019, 5:54 PMi dont think there is a direct relation from fulfillments to the billing transaction
i
iSuite
10/21/2019, 6:10 PMYeah exactly. So that's my problem.