|
Posted by Danny on May 21, 2007, 10:31 am
Please log in for more thread options Todd
Thanks - didn't think of using Shift+F6 ( good idea).
Anyway to launch some sql queries from within RMS POS- via a HTML page or
maybe qsrules?
Danny
> Good morning Danny,
>
> Thank you for posting your offline question.
>
> You are not able to run a Zreport or Xreport while in Offline mode.
>
> If Graphs (Shift+F6) will not show you enough information about your sales
> then you would need to run SQL scripts as you have documented.
>
> You can download a table/column schema from the following site; but here
> is
> a listing of what the transaction tables you listed are used for:
> https://mbs.microsoft.com/downloads/customer/Microsoft_Dynamics_RMS_20_DB_Sc
> hema.zip
>
> Transaction - This table holds the transaction information.
>
> TransactionEntry - This table shows the items that are in the
> transactions.
>
> TransactionHold - This table shows a listing of transactions that are on
> hold.
>
> TransactionHoldEntry - This table shows the items that are in the
> transactions that are on hold.
>
>
> Please let me know if this answers your questions.
>
> Todd Berger
> Microsoft Online Support Engineer
>
> Get Secure! - www.microsoft.com/security
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --------------------
> Subject: Off-line zreport simulation
> Date: Wed, 16 May 2007 10:40:59 -0300
>
> Hi Folks
>
> Once in a while, we do trade shows and use the off-line mode. I would like
> to have the ability to simulate z-report - in order to know how well I did
> at the show. I would be interested in knowing what other people are
> doing...
>
>
> Not sure which of the transaction tables to use... Transaction,
> TransactionEntry , TransactionHold, TransactionHoldEntry
>
>
> I did a few tsql report scripts - this is what I have so far -
> - listing of stuff sold..
> SELECT [Transaction].Time, [Transaction].TransactionNumber,
> item.ItemLookUpCode,
> TransactionEntry.Price, TransactionEntry.Quantity,
> Item.Description
> FROM TransactionEntry
> INNER JOIN [Transaction] ON TransactionEntry.TransactionNumber =
> [Transaction].TransactionNumber
> INNER JOIN Customer ON [Transaction].CustomerID=Customer.ID
> LEFT JOIN Item ON TransactionEntry.ItemID = Item.ID
>
>
> list of total sales
> SELECT [Transaction].TransactionNumber, [Transaction].Time,
> [Transaction].Total, [Transaction].SalesTax, [Customer].FirstName
> FROM [Transaction]
> INNER JOIN Customer ON [Transaction].CustomerID=Customer.ID
>
>
> This appears to work but not user friendly for some of my staff. Could I
> do
> this with qsrules or VB?
>
> I know that once reconnected a z-report can be done but sometimes we are
> at
> a trade shows for three days...
>
>
> Danny
>
>
>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap