Jump to content

Value List as a Calculation


Gloria
 Share

This topic is 5708 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm very new to FM7 & need help with my Value List. I have set up an inventory DB, I add new product through a purchase invoice by way of a portal. I have "Product ID", "Product Description" , "Product Cost" and Sales Catagory fields. The Sales Catagory field is based on a Value List called Sales Catagory which includes "Grocery", "Pop", "Confection" etc entered as a Custom Value List. My problem is, I need to sort & find the Total Product Cost of all the "Grocery" product, the "Pop" product, the "Confection" product etc. I also need to print this calculated information. I don't know if I can do what I require or how to do it, any help would be greatly appreciated. Thankyou

Link to comment
Share on other sites

Is a subsummary report what you're looking for? With it you could group your line items by category, showing the costs of each category in subsummaries with a grand total at the end.

Link to comment
Share on other sites

I'm not sure. I enter my new product on the purchase invoice into a portal, what I want is to be able to see & print that same invoice except have the data summarized & totaled by sales catagory instead of the way it was originally entered. I thought I could just duplicate the original puchase invoice layout & then somehow have it sorted by the catagory, if I could find a way to get a total for the catagories, but this doesn't appear to be working. I also tried to set up a subsummary report but wasn't successful with that either. I'm sorry, I may not be making myself clear, the more I work on this project the more confused & frustrated I get. I was doing wonderfully until it came time to create the reports that I need to print, I can get the data in, I just can't get it out.

Link to comment
Share on other sites

Thankyou, Thankyou, Thankyou, that's exactly what I'm trying to do!! I'm going to go through the example step by step until I get it right. I have one more question in mind but I may be able to figure it out myself from your example. You have made my day Thankyou again

Link to comment
Share on other sites

This topic is 5708 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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