Invoice Line Gross Profit

Hello,

Our company needs to be able to answer the following question: “How much profit did we make on each line that we billed today.”  I’m trying to create a saved search that will show me the following at a line level for all of the invoices on a given day:

  • Invoice #
  • Customer
  • Item
  • Quantity Invoiced
  • COGS (actual lot cost, not an estimate)
  • Amount Charged to Customer
  • Gross Profit $
  • Gross Profit %

I’ve contacted NetSuite support, and they tell me that this is apparently not do-able at the line level.  I’m not sure where to go with this one… help!

Rookie Asked on May 23, 2021 in Accounting.
Add Comment
1 Answer(s)

Hi, frank33210

 

If you look under the GL Impact located in Item Fullfilment, est.cost should be the same as COGS, if do you can use it in saved search instead.

 

Let me know if  I need it to build for you,

Regards,

Rookie Answered on May 26, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor