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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Returned Percentage
Ciao!
is there any way to calculate how many returns have come in using sales from the 3rd week (not Culmative)
For Example. Customer orders item A on 28th Nov 2011, then on the 12th he returns it saying it is faulty.
how do I calculate the formula to work out percentage from number of qty returned of Item A and dividing number of qty ordered from the 3rd Week?
I tried this formula :
Case when {account} = '1100 Sales' and ({today} - {trandate}) BETWEEN 0 AND 5 then decode({type}, 'Sales Order' , nvl({quantity},'0'),0) + decode({type}, 'Return Authorisation', nvl({quantity},'0'),0) else 0 end
0