Pietro
Forum Replies Created
-
You can change the sort in the package for the data pipeline but it will be overridden during an upgrade
-
Dan. Did you try to use the variable to select the ar contact.
- INVC_CONTACT
-
Hi Brandon. Is this for the main component on repair ?
-
Right click on the date field and format it the way you want.
-
Stock.stm_auto_key =stock_reservations.stm_auto_key and so_detail.sod_auto_key=Stock_reservarions.sod_auto_key and so_detail.soh_auto_key =so_header.soh_auto_key
-
Hi Terri. This is all about setup. Once done it’s a great tool. Also using the received payment event to close the past due contact once paid. Thx pietro
-
Hi Dan try to make another shipping event the same as the other but flag with airwaybill to T. Then it will send only when there is an airway bill.
-
I think There is a setting in crystal to uncheck for all uppercase. I’ll check and let you know
-
I found a guy who sells refurbished units for half price. New battery and a handle.
-
Hello all. You can configure the RF client as a server install and configure the tnsnames to point to an accessible IP address. It’s not that heavy to it works pretty well. Thx pietro
-
Abigail there is a presentation last year from que group that shows you how to use the custom sql event
-
Henrik have you tried to save the printer in the document? I’ll try rthis our toda to see if it works. Thx pietro
-
Henrik. Did you define the printer in the emgr event?
-
You can change the check to show the attention field on the company header?
-
bDT? BCS?
-
Tony. Add the Rolodex user group in the envent manager screen. Then you can flag your users to these groups and set emgr to send to them. It will allow as many as you like. Let me know if you need help. Thx pietro
-
Pat. If you load the style it’s the same. I would try to create another style and run agai
-
Your will need to add address1,address2,address3 fields etc.
-
Hi Courtney. I have two scanners left and three base stations.
-
Jeff is the Worth RF Scanner LT701 x 1 with B551 Base Station still for sale for $300
-
Terri. The trick to the portal is making the flow what is easiest for your customers. Follow the flow and see where you find it difficult or confusing and have it changed. Sometimes too much information is overwhelming and makes the navigation difficult. Thx pietro
-
Dave isn’t there 8140s in the shipping module?
-
You will need to trunc the date to remove the time. That is why you are getting to data.
-
Duane , did you setup the filter and connect the drill down?
-
On the newer dashboard you can set the columns format field to C and it will use the windows currency format
-
Andre. Use not in or <> for not equal to
-
You can try to delete her component control registry key. Hkey_current_usersoftwarecomponentcontrol.com
-
Krista I’ll look around.
I have made many of them. Each is a bit proprietary though.
Thanks
Pietro
-
Leo. I have one that shows quotes to orders by sales person and the ratio and percentages
-
Andre. Try prefixing the STM.serial_number on your select. I’ll look at it closer when I land
-
Everyone. Is correct. Ideally you will want to have a shipping status event that will send to the person in the SHipping order header when status is set to shipped and one for the posted invoice which can be directed to persons assigned to that company in the Rolodex.
-
Tony shading is on the first report tab. There are lines that say the shape name and shading
-
Jason. I think it’s in the call_list. I think I have one already written where you can add a user and it shows what they have.
-
Hey bil
You need to connect WO operation to stock reservation table on woo and then stock by stm
-
Tony I like the smaller room presentations. It is like a round table and a presentation mix. They are small enough for questions yet the presenter can disseminate quite a bit of information. Having 10-15 of these a day would encourage variety and interest.
-
Jim this is the correct table. have a look in sql and see if there is anything there. It has been a common issue that the SM number is not imported into the table so it does not know where to import the data.
-
Tyler Have you moved the base station to another machine? This way we can isolate the issue.
-
Johann Sveinsson wrote:Hi there,
I’ve been asked to try and produce a list of open WO which tracks how long each WO spent under every type of description available from the WO_STATUS table, basically, to be able to measure and improve overview of all open WO, and locate our ‘bottlenecks’.
I’ve had a look at the audit_trail table and I can’t make much sense of it, would the status description changes be stored there and how would I extract/link the necessary data from that table?
FYI I’m actually operating on SQL developer and not CR, but this subforum seems to contain most SQL related questions.
Thanks in advance,
Edit: http://www.quegroup.camp7.org/f_crystal/3092576 has helped me understand the Audit_trail table contents, so I’m looking at SOURCE_TABLE ‘WOO’ and SOURCE_AK key that is tied to WOO_AUTO_KEY, but now I’m a bit stumped on as to how I should proceed to pull this info out.
Johann have you tried to look at the WO_STATUS_HISTORY table. This can give you the time that a WO stayed in a particular status.