reporting - Store operation Register Journal

Apr 07, 2006 7 Replies

I would like to see a report that journals ever action in POS. the journal that view each reciept in the ledger type report.



Filtering it by the printer so you don't have to look at duplicate reciepts.



Important filters: Batch, Register, Tender type.



Drill downs: Customer, Transaction



Come on everyone, I can't be the only one that thinks this would help make the software more useful. I is so ackward chasing all the reports


---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.



formatting link
cd28a1-a4c3-464d-a29c-5dfc36d23206&dg=microsoft.public.pos


Hi John, we have two reports that make it much easier to find and review reciepts than the Journal Viewer. One is a summary that shows just one line per receipt, with drill downs for customer, item and transaction. The other shows each detail line on the receipt with the same drill downs. Both allow filtering by date, batch, register, cashier and customer. The detail report also filters by item.

Send me an e-mail if you are interested.

Ken Kosnik Computer Analytics Corporation kkosnik at cacorp dot com

"John M" wrote:

formatting link
cd28a1-a4c3-464d-a29c-5dfc36d23206&dg=microsoft.public.pos

Ken,

I am interested. Are they the report customized by RMS by chance.

John

"Ken K." wrote:

formatting link
cd28a1-a4c3-464d-a29c-5dfc36d23206&dg=microsoft.public.pos

Hi John,

I have attached the two reports: Summary and Detail. The Detail report can also be run as a drill-down from the Summary.

Let me know if they solve your problem.

No, they are not "customized by RMS". We developed them in-house.

Ken

formatting link
cd28a1-a4c3-464d-a29c-5dfc36d23206&dg=microsoft.public.pos

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

Great report, very helpful. Is there a way to add the customers phone number and email address to this report? Thanks, Butch

formatting link
cd28a1-a4c3-464d-a29c-5dfc36d23206&dg=microsoft.public.pos>

Butch,

You know that you can click on the account number and it will take you into the customer's record, right?

I do know that. I was hoping to export the information. I appreciate your input and prior help. Thanks Butch

formatting link
cd28a1-a4c3-464d-a29c-5dfc36d23206&dg=microsoft.public.pos> >

Butch,

If Ken hasn't already responded yet, add the following to the bottom whichever report you wanted the info on;

Begin Column FieldName = "Customer.PhoneNumber" DrillDownFieldName = "" DrillDownReportName = "" Title = "Phone #" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1365 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Customer.EmailAddress" DrillDownFieldName = "" DrillDownReportName = "" Title = "Email Address" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1110 GroupMethod = groupmethodNone ColFormat = "" End Column

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required