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.
Larry and Joe split a bottle wine and a cheese plate. They each pay for
50%. One pays with cash the other with an AMEX. I can see how this would cause problems but I don't think RMS has a way to truly take one item from inventory and split it anyway.
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.
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.
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
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.
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.
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..
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;
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.