Jump to content

How to calculate Customer sales total from invoices without using "ExecuteSQL"?


Recommended Posts

I created a demo file. My question is how to create customer sales total without using ExecuteSQL. Go to the report and click customer report. And you would see my sql statement. Is there a way to do the same thing not using sql? If I export it to iPhone ExecuteSQL may not work....Thanks.

 

KC

Customer Sales Report.fmp12

Link to post
Share on other sites

Use a layout of the Invoices table. Find the invoices in the date range you want, with the payment status you want. Sort them by customer. Place a summary field totaling the invoice amount in a sub-summary by customer part. If you want to see only customer sub-totals, delete the body part of the report layout.

There is no need for a Report table (unless you need to track reports made or submitted).

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.