Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to determine the REAL purchase price (per Each)
I'm trying to calculate "margin" with a formula, which I have defined as ({baseprice}-{cost})/{cost}.
This works great except when the purchase units are not the same as the stock units. I stock & sell everything by the "Each" but buy in units like "Case6", "Case12", etc.
While I can search for "purchase units" and display it, it displays a string like "Case6" or "Case12", and I do not get the unit conversion rate that would be necessary for me to do a meaningful margin calculation.
Am I missing something? Does Netsuite expose the "Unit Conversion Rate" anywhere so I can convert my purchase units to stock units?