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
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