It didn't show any info in report.

No wonder, why it show up on list...........:< Thank you very much.

Still trying it. Try to use Manufacturing Task Scheduler, but it said it require enable "Manufacturing Routing and Work Center", but I can't find it in the Setup. Is this extra function?

Yes, I used this method, but we also need the min/max char(range) of each field. Is any records has it?

I think I have some logic problem here. :> In this search report sort by internal ID to produce the # 1,2,3,...... Now I want to add sort the date after 1st sort. (11/3, 11/4)

Same result, no change for some reason.

I tried it, it didn't change.

Hi, Another question about sorting pop up. Is it possible to add another sort in formula? I try the Sort by internal ID, then by Ship Date, it doesn't work. I think it's because of the formula. Thank you very much.

Yes, if possible. I just use it to highlight the SO. Now we used it in two methods. One is email, and one is PDF. Both will show Overdue on screen and PDF.

One extra question. The overdue show on the report, and I use it for the highlighting function. Is there a way to hide the number on that report(not print out the colume)?.

Ouch, solved. Thank you very much.

Looks like I miss something somewhere. I don't have that field.

Yes, but my result fields didn't have Customer : Days overdue field in that list. Did I miss something in setup?

Sorry, I think I didn't make it clear. The search report is a Daily Sales Order report. I wish to pull and include the customer days overdue record on the list.

Thank you for the answer,. But we need it show in SO search report. Because we need to know if this SO ok to ship out when the customer has bad record.

Yes, looks like that's the problem. Is any way to make it pull the number from invoice/customer? Because we want the worker look at that info. If overdue stop shipping.

Yes, this method works. Thank you very much.

I use this search report to do the highlight note to warring the person.

Hi all, A little more question. We use Formula (Numeric) to do the rownum, but when we try to switch to sorting by SO#, the row number will change with the row position. Is there a way to let the row number don't change with SO# sorting, display 1 to xx in order?

Hi, Sorry for the late update. We use highlight function to archive this request. Thank you very much.

Yes, it works. Thank you very much.

Thank you very much. It works, but there is another problem. Our report want to show each order amount, if I leave it blank, amount wont show up on preview/report. If I select sum, it show, but there is a total amount in the total count line. Is there a way to hide the total amount? Also is it possible to add row…

Just found the problem. It's Transaction Form role permission cause that. ? Thank you very much.

Here is the SO I made, order 2, 1 marked shipped. Fulfilled record, marked shipped for 1. here is the picking ticket, try to show already shipped or fulfilled number after quantity. I was used ${item.quantityfulfilled}, and I think it show the number to be fulfilled.

I think I am need to rephrase my question. :> We have an SO. Some items shipped. Now we want to print picking sheet again, and it show the order qty, also the shipped qty. Which field id I should call for the shipped qty?

Hi, I am checking my coworker accounts, their still show default arrangement. Did I miss somewhere?

I did it. But do they need to press customize view button or it publishing to everyone automatically?

Yes, it works. Thank you very much. But another question. It seems work on me now. How to publishing this modified search to my coworker account?

Well, I tried this field, but it show $0 on every orders. :>

I just got it. It's tranid?starts_with("SO") But this also remind me an old question. In Transactions Form, we made a custom Transfer Order form. But somehow in that form, the Linked Forms->Picking Ticket, only show 2 of our 6 picking ticket forms. All forms are active, but it only show two for selection. Any idea about…