I am confused on how to tackle this challenge and I was hoping to see if anyone had some advice on how they might handle this.
Description: I am putting together a solution for my sales people to enter their sales into an app that will calculate their commissions earned per sale. Ultimately the sales manager and the finance department will be able to run reports on this information to determine commissions earned. The first part of the program will be the layout where the sales person enters in information related to a particular sale. When the sales person opens this layout to enter information about the sale, they first choose the month and year that the sale occured. after choosing the year, a script will trigger to find all previous sales within that month and year and display the summary below in a scrollable window (I am hoping this can be a portal) The sales person enters information into the top part of the layout and when they click the "save" button the information is summarized on a line below. Each sale they enter will show up as a new line.
I have attached a pic of my layout with arrows that show which information I want to move to the summary area.
My issue is that I can not for the life of me figure out how to accomplish this moving of data to the summary area. If the information in the summary area was form a different table then I would use a portal but I can not see a way to use a portal to display information from the sale table that is setup for the layout.
I am using FM15 Pro Advanced
I have two tables:
Sales.Transaction - This table contains information that is specific to each transaction that a salesperson enters and contains fields like:
Customer.Name (we call if practice name because they are doctors)
CW (a.k.a. Service Ticket #)
Products - The products table contains information about the specific products with fields like:
Thank you in advance for taking the time to read this and assist if you can.