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

Hello, can someone help me make a saved search that will return all item fulfillments with no GL Impact?

<@UJ8HZPBKR> Set your criteria, maybe you only want item fullfillment from Sales Order or Item fullfillment from Transfer Order

<@UJ8HZPBKR> Yes. Posting means whether it posted to the GL or not. True for it did post, false for it did not. Item Fulfillments are considered a transaction.

So I tried that and it doesn't work. the results aren't accurate at all <@UN3JFQH17> <@UD8EEAZC3>

Aren't accurate how? You get a mix of IFs that are posted and not posted?

If I sort it by Any, I get results, if I set Posting to No I don't get any results

Im looking for all IF's that have no GL impact

Are you sure you have IFs with no GL impact? When I use the posting, I get very few.

I'll let someone else jump in here. From my understanding, to see if something has made an entry to the general ledger, you use _Posting_.

Yeah I'm sure. I have found records that would indicate as such

Can you send screen shot of the GL impact on one of these IFs? Please redact sensitive information.

So <@UJ8HZPBKR> needs a way to get the Ifs with zero transactions under the GL Impact. Not just IFs with a GL impact of No.

"I am looking for IF's where there is NO GL Entries
so that sublist is blank"

I believe there is an article in suiteanswers with this same scenario but am just on mobile so can’t link it sorry