looking for a voids and returns report

Jan 13, 2008 2 Replies

Rate this thread:

cheese plus 18 years ago

how can i create a report for voided transactions and returns?

i want to look at this each week or month (historically) not daily via the x and z reports

thanks

Vote

convoluted 18 years ago

Hi Cheese

A return or void could be tracked by filtering the detailed sales report for qty sold less than zero (negative quantities); paste the following verbiage on your detailed sales report Begin Column FieldName = "ReturnType" DrillDownFieldName = "" DrillDownReportName = "" Title = "Return Type" VBDataType = vbString Formula = "CASE [Transaction].RecallType WHEN 1 THEN 'Recalled for Return' WHEN 3 THEN 'Void' WHEN 0 THEN (CASE WHEN TransactionEntry.Quantity <

0 THEN 'Manual Return' ELSE 'N/A' END) END" ColHidden = False ColNotDisplayable = False FilterDisabled = True ColWidth = 2280 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

The column will show you if the negative qty was because of a manual return, a recall for return or a void. H> how can i create a report for voided transactions and returns?

Vote

Jen Losch 18 years ago

Hi there,

Retail Analytics from Professional Advantage will enable you to have access to that information. Basically, anything that is captured in RMS you will be able to report on.

If you would like to take a closer look at the product, we have a short movie available at

formatting link

Please let me know if you have any questions.

Thanks,

Jen Bridgeford snipped-for-privacy@profad.com

701 235 2363 ext 248

"cheese plus" wrote:

Vote

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required