Jump to content
Sign in to follow this  
gregorj

Daily Transaction Report

Recommended Posts

This one has me scratching my head.

I'm working on a touch screen, point of sale retail solution for a golf course.

I need to generate a report at the end of a period of sales that summarizes the various "products" sold.

There are 37 products, each with a PRODUCT NO.,

PRICE, QTY and DESCRIPTION. These are sub-divided into 8 logical groupings.

On any given day there could be from 0 to over 50 units sold for each product number.

The printed report summarizes the number of units sold as follows:

NO. DESCRIPTION QTY PRICE

Registration

001 Resident 2 90.00

002 Senior 0 0.00

003 Student 1 30.00

** SubTotal ** 3 120.00

Greens Fees

101 Resident 9 Hole 12 168.00

102 Senior 9 Hole 9 90.00

... (others)

**SubTotal ** 96 1321.00

Gas Carts

301 18 Hole Gas Cart 13 362.00

302 9 Hole Gas Cart 9 142.00

**SubTotal ** 22 504.00

( 5 other catagories, each with a catagory sub-total)

Finally a Gross Total which is the sum of all sub-totals in units and dollars.

***TOTAL*** 168 2470.00

I imagine a script would start with sorting on the part no. field and the break field would be the catagory in which those specific no.s were placed. A subsummary report ?? I can't seem to get a handle on how to nail this one down.

Help please.

Share this post


Link to post
Share on other sites

Your products should also have a Category field, which is one of the eight groupings (Registration, Green Fees, etc)

The report would have sub-summary fields for Category, ten Product No i that order. Sort by Category, Product No in that order.

Should work, nothing too hard about your situation. Just got to get the data structure right.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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