This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Why are is `transactionline.inventoryaffecting = 'F'` for item fulfillment lines?

If I recall correctly, the mega-query our team developed to meet this need included both `isinventoryaffecting = 'T'` and `transaction.type IN ('ItemRcpt', 'ItemShip')`

same reason fulfillments are represented with multiple lines in searches

multiple different accounts are affected for each item line

only one of the transaction lines is actually inventory affecting

I don't know what's going on but for me there are certain item fulfillments all the lines are false.

Yes. Lot numbered inventory items to be specific.

are they actually inventory affecting? Or are they simply picked

They should be. When I do my query to get the inventory it's off be the amount we transfered.

<@U5TF1GQ20> if you had to write a query to get the inventory would it look different?

<https://netsuiteprofessionals.slack.com/archives/C01FBBZ8PQC/p1636869308080800|https://netsuiteprofessionals.slack.com/archives/C01FBBZ8PQC/p1636869308080800>

and i wouldn't attempt historical inventory

I need it in suiteql to use the odbc connector. I'm under the impression that netsuite internally uses a transaction related search under the hood. Am I wrong?

it could be, but we dont know the details of the sql used

That's unfortunate.

I need to get it into excel. I'm gonna have to generate an oauth1 signature in vba. Lord help me.