Jump to content
Sign in to follow this  
moj6054

Calculate Item on Report

Recommended Posts

Hi, I have a problem with report, I have three table(product,invoice,invoicelineitem) and want to know for each item how many I sold(qty)

for example:

Invoice:

Invoice:1 Item A qty::5

Item B qty::6

Invoice::2 Item A qty::7

Item B qty::6

I want see in report:

Item A qty::12

Item B qty::12

Stuff.zip

Share this post


Link to post
Share on other sites

Produce your reports from the Linetems table. A report sorted and summarized by invoice will look like your first example; a report sorted and summarized by item will look like the second one.

Share this post


Link to post
Share on other sites

I am afraid that's something you'll need to work out on your own. So far, I don't see that you have a reporting layout with the necessary sub-summary parts, nor a script to produce the report.

Share this post


Link to post
Share on other sites

If you look again at Comment's InvoiceReports.fp7, you will find a layout named Report. This has sub-summary parts like what was explained. Not a single layout in your last file has a report layout or sub-summary in it at all.

I have modified your file and added a Report layout. When you create a new layout, FM walks you through 'report' and adding sub-summary parts - it even shows you the resulting report (to the right) as you design it, inserting sub-summary parts as you specify. You need to understand how this works.

Look at your report layout in layout mode. It clearly shows the sub-summary parts. You can work with them by selecting Layouts > Part Setup.

StuffMOD.zip

Share this post


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

Sign in to follow this  

×

Important Information

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