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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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