HELP! I NEED CUSTOM REPORT: TENDER TYPE Totals by DEPARTMENT

Sorry, but you can't do that. When someone buys two items each from a different department, but pays with Cash and Check, HOW do you allocate the two tenders to the two departments? The tender amounts/types are not allocated to each item on the transaction (or those departments assigned to the items), but rather is allocated to the entire transaction itself. It's impossible to break that down any further into smaller details (Depart., Category, Item, Supplier, et). Sorry to burst your bubble.

Actually, Jason, they are.

Right now I am assembly this information via 2 reports. A canned report "Detailed Sales Report" will give you transaction # for each 'item'.

The tender summary by date report (custom) also includes Transaction #. So with a little excel work I can show

By Tender Type, Cash, Debit Card ect, each Item purchased and what department that item is in.

Do a subtotals and you have it.

I'm just looking for a way to combine the two reports.

David

begin 666 Custom - Tender Summary by Date.qrp M+R\M+2T@4F5P;W)T(%-U;6UA

I think you are talking about a split payment.

Larry and Joe split a bottle wine and a cheese plate. They each pay for

Some one else please look into this. Again, I am doing this now but by using 1 standard report and a custom "Tender Summary" report. See my other post with the attachment for the Tender Summary report.

I think Jason is correct about split transactions but the sale of EACH ITEM and its METHOD of TENDER of is recorded in the database. If just yet to see a report that pulls both at the same time.

David

David: Say on one sale, a $10 item a and a $20 item B, and they pay with $25 check and $5 cash, what would the report look like???

Or, are you wanting to just make the assumption that there are never split tenders and build the report that way?

Peter AmericanRetailsupply.com

"David Parrish" wrote:

David,

That info is NOT in the database. What you are probably seeing is selling the one item per sale and the tender is saved for that sale, not the item. Jason is correct.

I don't follow this statement below:

Each item is recorded, yes, but the tender is associated with the invoice, not the item... . yes/no? which table are you refering to? P.S. if you are using Gift Certificates you are guaranteed to have split tenders. Peter

If just yet to see

Refer to the attachment in one of my last posts. Run the report to see "TENDER TYPE"

EXAMPLE

Customer A buys 1 bottle of Merlot and 1 Bottle of Chardonnay. He pays with a VISA. For this transaction a TRANSACTION # is generated and stored in the dbase. It may be under another table like item movement or something but the 1 bottle of Merlot and the 1 bottle of Chardonnay are each identified as being sold under TRANSACTION Number: "####".

I admit, I don't know the affects of this when there is a split transaction. I do so few split transactions I don't consider it as being that much of an influence on the accuracy of the report. Even so I would consider a less than 1% margin of error to be acceptable for my purposes.

AGAIN, run the custom report I have attached to this thread (must be using OE or another reader) then run the Standard Detailed Sales Report for the same period and include transaction numbers. You will be able to identify each ITEM sold by Transaction Number - cross reference with custom tender report - and each item/amount will be identified by transaction number and subsequently by TENDER TYPE.

Again, I've been doing this for a while and it is possible and accurate.

So with out being rude, will you guys actually look at the reports an the data and stop telling me how impossible it its.

I do undertand that the code language that these reports are written in MAY NOT be capable of generating the data in form I need because while it is a very logical process it is a complex one and the code may not have the 'vocabulary' or syntax to do that level of comparison and extrapilation.

Thanks in advance.

OK, OK, OK

I understand the confusion now.

I kept saying ITEM, as the SUBJ suggestion I am talking about DEPARTMENT. I found a split transaction. I am not going down the ITEM level really. I am simply looking at DEPARTMENT.

I found a transaction that was split between a Gift Cert and a VISA. Looking at the TENDER REPORT there are two items(term used loosely) I should say 'records' returned with the same trans #. One of the 10.15 and the other for $8.10. But the actual ITEM of merchandise sold was a single bottle of wine for 18.25. BUT my reporting is still accurate.

The report I want will show that for the DEPARTMENT of 'WINE RETAIL' I will have 2 sales: 1 for 10.15 for the tender type of Gift Cert and 1 for 8.10 using Tender Type VISA Credit Card.

Whalla! Eurika and other terms of excitement.

So I sincerely appologize for unintentionally misleading this group/forum. Please run the report I previously attached and see of yourselves.

Then perhaps we can find a way to combine the two.

Again, thanks for patience and understanding.

David

David,

You _still_ can't get there from here! Again, the department is tied to the _item_ sold.

Buy a bottle of $50 wine and a $10 corkscrew, I'm assuming that they are in different departments.

Pay for it $30 in cash + check of $30.

Look at your reports.

How was the corkscrew department paid for, cash or check?

Jeff - run the report attached. Also please contact me via my direct email david.parrish@vino100-lakeway DOT com

or call me on my cell 512.557.5215 And we talk abou this. This way I can share data with you and 'show' you what I mean.

regards,

David

begin 666 Custom - Tender Summary by Date.qrp M+R\M+2T@4F5P;W)T(%-U;6UA

David,

I did before sending the first email and deleted my findings to shorten the message.

It shows exactly what I described.

You are NOT getting the correct information out of your Custom report + the Detailed Sales report.

_You_ need do exactly what I described in my last email. Humor me

OK,

YOU ARE CORRECT :-D

I did a test transaction on my Register.

I guess I have never had a transaction that was split up like that it was always 'even' so my reports work out.

I would think that the report could still be done however.

So I'm stuck marrying these items together in MS Excel - argh

the whole reason I need this is for accurate data entry into Quickbooks by dept/tender so it balances against the deposits made into the bank account which are by....you guessed it TENDER TYPE, MC/VISA, AMEX, CASH, CHECK ect..

dp

David,

If you are using QuickBooks, setup RMS to talk to it and then assign QB's GL accounts to let RMS where to post to. After setup, it will post to whatever GL account you tell it to.

If you have access to CustomerSource, click here for a step by step on the setup;

If you are going to use Excel why not give this add-in a try?

David, We are in need of the same report you are requesting, did you have any luck locating one, if so let me know where please?

Such a report is not possible because of the database table structures to allow for split tendering.

Say you have a receipt with 2 line items - 1 bottle of Gin from the Liquor Dept for $12.95 and 1 bottle of Wine from the Wine Dept for 6.95. Total

Say this sale is tendered with any 2 tenders, $10 and $9.90 - credit card and cash, or Gift Card and a credit card, etc.

Which dept did the $10 credit card tender go to?

Rick Brown DataBasics