How can I view transactions in a batch by scrolling with the up and down arrow keys.

(0) Share

Report

Posted on by Community Member Microsoft Employee

How can I view transactions in a batch by scrolling with the up and down arrow keys. right now, I can only see one transaction by using the journal lookup feature.

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I view transactions in a batch by scrolling with the up and down arrow keys.

scroll from one tx to the other using page up and page down keys. if there are multiple pages on a tx, use ctrl arrow key right, ctrl arrow key left to move within pages. hope this helps
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I view transactions in a batch by scrolling with the up and down arrow keys.

Right now you can do that. But it can be added to the Detailed Sales report.

You would need to add the batch number column to the report.

Add the following to your Detailed Sales Report.

Begin Column

FieldName = "[Transaction].BatchNumber"

DrillDownFieldName = "[Transaction].BatchNumber"

DrillDownReportName = ""

Title = "Batch"

VBDataType = vbLong

Formula = ""

ColHidden = False

ColNotDisplayable = False

FilterDisabled = False

ColWidth = 1245

GroupMethod = groupmethodNone

ColFormat = ""

End Column

Then you can filter by batch number and also group by batch number on the Detail Sales Report.

I suggest you save the new report named as "Custom - Detailed Sales by Batch.qrp"