Skip to main content
Solved

Monthly Sales Report

  • November 1, 2021
  • 2 replies
  • 514 views

Forum|alt.badge.img

Is there a Monthly Sales Report by Ship to State?

 

Best answer by aborisova

Hi Nelson,

You may create a GI where you add the ARShippingAddress table as shown below. This way you will get the desired results: 

 

On the Results tab, select State field from the ARShippingAddress table; under grouping, group by State (optional).

View original
Did this topic help you find an answer to your question?

2 replies

  • Freshman III
  • 3 replies
  • Answer
  • November 1, 2021

Hi Nelson,

You may create a GI where you add the ARShippingAddress table as shown below. This way you will get the desired results: 

 

On the Results tab, select State field from the ARShippingAddress table; under grouping, group by State (optional).


  • Freshman I
  • 5 replies
  • September 6, 2024

I have attempted this GI and also need to display the state found on the billing address. Adding that has duplicated lines in the results. What can I do to resolve that?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings