Skip to main content
Answer

How to Deduct Applied Credit Memos on the Net Sales Field of Sales Profitability by Customer and Order?

  • August 14, 2023
  • 2 replies
  • 47 views

Forum|alt.badge.img

Hi everyone. 

 

Is there a way to deduct the applied credit memos of an invoice on the “Net Sales” field of Sales Profitability by Customer and Order? Thank you.

 

Best answer by Naveen Boga

@Novstat  The most effective approach to accomplish this is by utilizing a subreport.

By creating a straightforward subreport, you can efficiently compute the total amount of CREDIT MEMOs amount to each customer. Once you've retrieved this value, it can be subtracted from the overall Net Sales figure, yielding a precise representation of the financial data. 

 

Hope this helps!

 

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • August 14, 2023

@Novstat  The most effective approach to accomplish this is by utilizing a subreport.

By creating a straightforward subreport, you can efficiently compute the total amount of CREDIT MEMOs amount to each customer. Once you've retrieved this value, it can be subtracted from the overall Net Sales figure, yielding a precise representation of the financial data. 

 

Hope this helps!

 


Forum|alt.badge.img
  • Author
  • Varsity I
  • August 15, 2023

Thanks so much, @Naveen Boga. I’ll try your suggestion.