Here is a CLOSE transaction as it looks after being loaded into Excel
Code: Select all
BEGIN CLOSE TRANSACTION # 872 1/27/2011 13:43
TX1A 8.750% 0.38
TX2A 2.000% 0.12
TOTAL TAX A 0.5
TX1B 2.500% 0.11
TX2B 1.250% 0.08
TOTAL TAX B 0.19
UNIT TAX 0.5
TOTAL TAX 1.19
CASH SALE: 2 10.27
CHECK SALE: 0 0
CREDIT SALE: 0 0
DEBIT SALE: 0 0
GIFT CARD SALE: 0 0
SALE: 0 0
CASH RETURN: 0 0
CHECK RETURN: 0 0
CREDIT RETURN: 0 0
DEBIT RETURN: 0 0
GIFT CARD RETURN: 0 0
RTRN: 0 0
NET SALES: 0 10.27
TOTAL TAX: 0 1.19
GROSS SALES: 0 11.46
TIPS: 0 0
CASH BACK: 0 0
SUB REG CASH: 0 11.46
CASH DROPS/PULLS: 0 0
+ CASH FUND: 0 125
CASH IN REG: 0 136.46
CHECKS IN REG: 0 0
CREDIT IN REG: 0 0
DEBIT IN REG: 0 0
/REG: 0 0
TOTAL PAYOUTS: 0 0
TOTAL DISCOUNTS: 0 0
TOTAL REDUCTIONS: 0 0
TOTAL COUPONS: 0 0
TOTAL VOIDS: 0 0
TOTAL GIFT CARDS: 0 0
SALES TRANSACTIONS: 2
RETURN TRANSACTIONS: 0
PAYOUT TRANSACTIONS: 0
NO SALE TRANSACTIONS: 0
GIFT CARD TRANSACTIONS: 0
TRANSACTION TOTAL : 2
Code: Select all
BEGIN SALE TRANSACTION # 871 1/27/2011 13:43
1. DALE
STOCK NUMBER DESCRIPTION TAX RATE PIECES UNIT PRICE PRICE
60004 COLOR KEY TWO SIDED 2 1 2.99 2.99
60008 RUBBER GRIP DOMESTIC KEY 1 1 4.29 4.29
2
SUB TOTAL 7.28
TAX1A at 8.75% 0.38
TAX2A at 2% 0.06
TAX1B at 2.5% 0.11
TAX2B at 1.25% 0.04
SALES TAX 0.44
PROVINCIAL 0.15
UNIT TAX 0.5
TOTAL 8.37
CASH TENDERED 8.37
I am also looking for input on how folks want to choose which files to convert starting from the last recorded transaction.
1. All transactions in the file?
2. Only today's transactions?
3. Enter a transaction number and go back to that?
4. Enter a date and go back to that?
5. Enter a date and only convert that date.
6. Enter a transaction number and only convert that transaction?
7. Mutiple options from above?
Would you want to be able to launch this program from the POS.EXE program using the [F4] option?
I am on vacation for the next 3 days so if I hear back from you I can work on the program then to finish it.
Here is the download link http://www.dhpos.com/R2C.EXE You will have to download it to the same folder that holds you other DHPOS program files and run it from there.
Dale