Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Use Transaction Fields on Item Search w/out Dropping Items w/out a Transaction.
I have an item search I'm working on. I'd like to be able to look at the # of items currently on hand vs. the # of items sold over a certain period of time in the past.
I'm using a formula to display the # sold, using Case When Trans Type = INV or Cash Sale then qty sold else 0. This way I get results even if I have an item which has never had a sale.
The problem arises, when I want to limit my search to invoices and cash sales in a certain time period. If I put a filter in for transaction date, then any item which does not have a transaction in that time period gets dropped off the results. Other than programming a date into my formula, is there any way around this?
0