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.
How to Add $/Unit Column to Income Statement/Report
Does anyone know how to add a column to the Income Statement that shows the $/Unit for each line on the statement?
For example, if all of your sales are sold on a per pound (LB) basis, then management often wants to view reports (both income and expense) on a $/LB basis. For some companies this might be a per case, or a per item.
Suppose you want to show $/LB on the Income Statement. For a given period (like a month), you would divide all of the $ for each line by the total number of pounds sold that period to obtain $/LB for that line.
0