HQ Reports - Adding 'Drill Down' to a column

TT,

Try;

DrillDownFieldName = "[Order].ID"

In the Order # column section.

No luck.

Here's my dilemma: When an item not in my database is Special Ordered, I have the sales reps enter a non-inventory ILC 'SO-DEPARTMENT' where the actual department is used. The actual make/model are entered into the item description and the correct price is also entered.

All of my special orders are work orders with a reference of 'SO'. I have a Special Orders - Open report for Store Ops that lists all open work orders with a reference of 'SO'. Here at HQ (also a store), we run the report, note the orders with 'SO-dept' ILCs, find hard copies, create new items, edit the work orders, issue POs, etc. When the item is received, the report will show that everything is available to fill the order and the customer is contacted to arrange delivery. On this report, the SO-dept items do not show the transaction-specific description, just the 'Special Order - Department' description from the Item properties.

Here comes store #2... (and #3 & #4). My HQ folks can't just walk over to the order spindle and gather hard copies. I am uploading Journals to HQ. What I am hoping for is the ability to drill down on the Order Number and have the Journal open to a copy of the actual receipt.

Now that I think about it, if I could get the transaction-specific description on the report, that would be even better.

Ideas?

Tom

"Jeff" wrote:

TT,

I could have sworn it worked. Sorry ;-(

Before I sent it, as a quick and dirty test, I modified the stock HQ Work Order (Detail) report with that change and I thought it pointed me to the correct receipt.

I'll play some more.