- This topic has 0 replies, 1 voice, and was last updated 19 years ago by
.
-
Posts
-
KFC Sales Plugin
KFCSales 6.02Last edited: December 15, 2003 08:09 AM
The KFC Sales plugin is a custom plugin written explicitly for American Retail Systems, but is available for download to dealers if they want to use it as is. It is a multipart report with sales by group, cash reconciliation, paidouts, promo, allowance, and group by ordertype sections. Accounting formulas used are those of American Retail Systems and do not necessarily conform to other reports written by Touch Menus.
[color=red:32zlf576][u:32zlf576][b:32zlf576]
Download KFC Sales Plugin[/b:32zlf576][/u:32zlf576][/color:32zlf576]Installation
Place the following files in the Plugins directory:
* KFCSales.EXE – the program executable
* KFCSales.PID – the program definition fileSample
*** KFC Sales Report ***
Report Printed on: Mon, Dec 20, 1999 3:04pm
Report For: Fri, Nov 27, 1998
> Fri, Nov 27, 1998*** SALES SECTION ***
Group Net Sales
1 2) Pizza 5909.552 2) Pasta 532.24
3 2) Salad 984.02
4 2) Dessert 49.38
5 1) Soft Drinks 1022.92
6 2) Juice 193.97
7 1) Beer 213.16
8 1) Oth. Alcohol 34.09
9 2) Oth. Grocery 26.95
10 1) Tea + Coffee 213.56
Tax 1 Sales 1483.73Tax 2 Sales 7696.11
Subtotal Net Sales 9179.84
Sales 1 Tax 325.74Sales 2 Tax 538.73
Total Tax 864.47
Rounding Error 0.00
Total Receipts: 10044.31(-) Non-Cash Receipts: 0.00
(
Cash Receipts: 10044.31(-) Paid Outs: 0.00
(
Theoretical Deposit: 10044.31
Actual Deposit 0.00Cash Over/Short -10044.31
*** NON-CASH RECEIPTS SECTION ***
Media Amount
Total Non-Cash Receipts 0.00*** PAID OUT SECTION ***
Paid Out Amount
Total Paid Out 0.00*** SALES BY ORDER TYPE SECTION ***
Group Name Here Takeout Drive Totals
2) Pizza 2197.06 3235.21 477.28 5909.552) Pasta 0.00 512.44 19.80 532.24
2) Salad 64.50 908.96 10.56 984.02
2) Dessert 0.00 49.38 0.00 49.38
1) Soft Drinks 513.64 500.34 8.94 1022.92
2) Juice 0.00 178.85 15.12 193.97
1) Beer 19.36 193.80 0.00 213.16
1) Oth. Alcohol 0.00 34.09 0.00 34.09
2) Oth. Grocery 0.00 26.95 0.00 26.95
1) Tea + Coffee 23.10 190.46 0.00 213.56
Here Takeout Drive Totals
ToTals 2817.66 5830.48 531.70 9179.84TRANSactions 396 197 28 621
*** PROMO SECTION ***
Promo Amount
1 2) Pizza 2.452 2) Pasta 0.50
3 2) Salad 0.74
4 2) Dessert 0.33
5 1) Soft Drinks 1.01
6 2) Juice 0.25
9 2) Oth. Grocery 0.09
Total Promo 5.37*** ALLOWANCE SECTION ***
Allowance Amount
Total Allowance 0.00*** SUMMARY SECTION ***
Net Sales w/o VAT 9179.84
(+) Promo w/o VAT 5.37
(+) Allowance w/o VAT 0.00
(
Gross Sales 9185.21KFCSales Version 6.02
Technical
The Product Mix plugin reads Media.Dat for the media names, Groups.Dat for the group names, and General.Dat for tax settings. Report options existing as of 6.57 are respected. All items are assumed to use included tax, irregardless of the tax settings at the time the item was rung. The plugin goes through a series of steps to read and calculate the data.
1. A posting routine looks for Cash.Prn and posts the information to the appropriate journal file. See Cash.Prn File Format for details.
2. The journal file is read check by check. If a Deposit posting is found, the Deposit total is incremented. If a Paid Out total is found, a line is added to the Paid Out listing section.
3. As each check is read, the following calculations occur:
* Total receipts are incremented by the Check Amount.
* Media totals except for Cash Tendered are incremented for posting in the Non-Cash Media section.
* Group totals are incremented, including tax.
* If the check has any coupons (group 97), the coupon total is redistributed to groups 0-96 in ratio to the item sales for each group on that check. For example, if a check had 15.00 of items including 5.00 of group 1 items, then a 3.00 coupon would cause group 1 to be incremented by 1.00 (3.00 * 5.00/15.00). The redistributed amounts are also reported in the promo section.
* If the check has any promos (group 98), the promo total is redistributed to groups 0-96 using the same formula as for coupons. The redistributed amounts are also reported in the promo section.
* If the check has any allowances (group 99), the allowance total is redistributed to groups 0-96 using the same formula as for coupons. The redistributed amounts are also reported in the allowances section.
* For groups 0-96, included tax is backed out. The tax rate is determined by the first character of the group name, not by the tax flags for that item in the journal.
* Promo and allowance totals now have tax backed out of them using the same rules as for regular items.
* These modified totals for the check are now rounded to the nearest penny and posted to the running totals for the report. Rounding by check is more accurate than rounding by item. However, rounding cannot occur at a level higher than check level, or the different sections would not necessarily balance.
4. Some final totals are calculated as the report is built. Subtotal Net Sales is the sum of Net Sales for all groups.
5. Total Tax is the sum of all the taxes collected.
6. Since Total Receipts is the sum of the actual check amounts, it is possible for rounding errors to prevent Subtotal Net Sales + Total Tax to exactly match it. For this reason, a line called Rounding Error is inserted which reports this discrepancy.
7. Cash Receipts = Total Receipts – Non-Cash Receipts.
8. Theoretical Deposit = Cash Receipts – Paid Outs.
9. Cash Over/Short = Actual Deposit – Theoretical Deposit.
10. The Non-Cash Receipts, Paid Out, Promo, and Allowance Section report the totals as generated in step 3 above.
11. The Sales by Order Type is capable of reporting 4 Order Types per section and will make more sections if needed. The right column of the last section will contain totals.
12. The Totals headings in the Sales by Order Type section intentionally have extra characters in upper case. This allows third party software to identify these lines to assist in exporting data.
13. The report finishes with the Summary section which calculates Gross Sales, which is the sum of Net Sales, Total Promo, and Total Allowance.Cash.Prn File Format
The Prn file is created by the Touchnet application using printer output redirected to a file. It can contain 5 different types of data as defined by the Kind= line.
* Kind=1 Actual Cash In Till
* Kind=2 Register Fund
* Kind=3 Deposit
* Kind=4 Cash Drop
* Kind=5 Paid Out – This kind will also include an additional line containing the description.Sample
Date = 991011
Time = 1003
Employee = 1
Kind = 5
Description = CusRef
Amount = 5.00
Date = 991011Time = 1037
Employee = 0
Kind = 3
Amount = 500.00
Date = 991011Time = 1037
Employee = 1
Kind = 5
Description = Produce Man
Amount = 45.00
Date = 991011Time = 1037
Employee = 1
Kind = 4
Amount = 60.00
Posted to Journal* Code 5000
o Amount – 4 bytes
o Employee Number – 4 bytes
o Kind – 2 bytes
o Time – 2 bytes
* Code 5003
o Description – 10 bytesRevisions
12/15/99 Version 6.02 rw
1. Initial Release.
- You must be logged in to reply to this topic.