Skip to main content
Answer

Monthly Sales Report

  • November 1, 2021
  • 2 replies
  • 588 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).

2 replies

  • Freshman III
  • 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
  • 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?