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

Hi there, does anyone know how I can get those transactions for which the         generateaccruals is set to true on the transaction lines?

I believe that's an item field, not on the transaction

<@U29QCJQF3> Yes, that true, it's on the item. But here's the thing wile it's set on false on the item at some PO's it's still set to true. Therefore I assume this must be stored elsewhere at the transactionline level

so when I would make a join to the item I get the current value from the item and not what's current at transaction line level from the PO

Is that because the item level setting was changed at some point? Or is there an option to override on transaction level that I'm unaware of?

You could join to the item receipt and check for a GL impact. If there are no accruals the IR would be non-posting

We want to prevent an GL impact and therefore we need those PO's for which an IR has not been performed yet.

Could you compare dates to that of the item setting change?

So what would you suggest with this exactly?

Check system notes to see when the item was changed and use that to filter the creation dates of PO's to determine if they will generate accruals or not