Pietro
Forum Replies Created
-
The AR import will just bulk import AR lines. It is pretty straightforward. You can use the dia as well
-
Stream read issue happens when someone changes around the data fields in the data grids. Obviously quantum doesn’t like it. Deleting their users settings usually gets it back to work again. If you can see the culprit view right click and set to default. Thx p
-
Not sure people can hand windows search being disabled
-
Tino. Did you try to disable UAC
-
Tino what is the error I cannot See it
-
Jae have you disabled UAC. sometimes this is the culprit
-
jae are you running 64b or 32b outlook? also sometimes the trick is going into quantum user settings and changing default email client to outlook. if it already says that then take it out and save and try again. finicky
-
hello folks, if this is the only crystal report that is not working check the error tab. usually the report have unused parameters that fail the report in quantum. delete the unused parameters and try again
-
Hi Dave. If you already have quantum’s crm then we can use all other other modules to fill in the gaps. Event manager does Weil in this process
-
Nadim AAM actually makes oracle slowest. Manually giving it 40-60% is better. Separating the data into seperate dbfs really does the trick. It is a lengthy process of reassigning data to other dbfs and then back up and restoring to those dbfs. I have All the code somewhere. Also if you open ocdataversion and connect to the Db and select analyze schema. This helps. I have A list of what needs to be enabled and disabled in 11.12.19 oracle for best performance.
thx
p
-
Warren. Currently quantum by default only uses one dbf files for its data. Over time this becomes slower. Ideally separating the data into separate data files on different spindles makes a world of difference. Also granulation and depending on what version of oracle you on there are different optimizations. Email me and I’ll send you the scripts. Thx pietrorace@framici.com
-
People notice that after upgrades quantum gets slower. Seems par for the course. Like windows. You can run optimizations like granulation to improve it
-
Hi many or my clients use Chelsea Technologies. You can contact Meyer at meyer@chelsea-tech.com. Thx pietro
-
Mike you can use the audit trail as well if you know the time is was changed
-
hello anne-marie, so you basically want an invoice report by the ship to country on the shipping order? email me and i can find one pietrorace@framici.com
-
osman did you put the printer in the style? Sometimes if the printer share name is odd or has spaces quantum wont see it and therefore prints to your default printer. you can try to readd the printer with a simple name then reopen quantum and add the printer to the style and then try again.
thx
p
-
dont think you will be using some of the newest functionality. If you create a simple report does it load ok. I have been using 2016 for years without issue
-
Mike sometimes how the report was written doesnt translate the schema. if you take the report out and map to qctl and reimport does it work?
-
I think you are mixing apples and oranges. Do you want repair orders or work orders. They are separate beasts.
-
Hi does the pdf have data in it? Easy to use custom sql event and attaching crystal report. It becomes pdf as attachment.
-
Probably a pdf setting. All imaging Turns into PDFs in quantum
-
What are you looking to accomplish using. Stock audit ?
-
Hi Andrew. It is easier to create a new event. Any changes you make to the current queries will be erased during an upgrade.
-
Hi Alonda. I have One set left. $1k for both. I will Be in Atlanta next week. Let me know if you are interested. Thx pietro
-
Kyle try this
var
q : TOracleDataset;
begin
q := TOracleDataset.Create(nil);
q.SetSession;
q.Sql.text :=’select wtp.description from wo_task_type wtp, wo_task_master wtm ‘+
‘ where wtm.wtp_auto_key=wtp.wtp_auto_key and wtm.wtm_auto_key = ‘+ WO_TASK[‘WTM_AUTO_KEY’];
q.Open;
text:= q.fieldbyname[‘description’].asstring;
q.Free;
end;
-
Hi Tyler. So you have the install file?
-
Bill disable the enhanced security in preferences. This helps. Most people have changed to fox it or some other pdf viewer
-
Nadim I only bring this up because clients have asked me and CC for a solution. The images are not really encrypted Anyone with rights to that folder can open and pursue them. Seems there was bot much to gain.
thx
p
-
Remember coc auto key on the companies table is the warehouse address. Coc_office is the coc auto key for office address
-
Ryan. Have have searched high and low for a decent web company. So far Paul has the best setup with all the resources needed to make a integrated solution. Thx p
-
Wow 25K and remote hosting. I was Wondering why everyone was staying at their current version. Crazy. Well let the workarounds begin. I sure a solution will be posted soon. Thx
-
Kristen. Yes emgr can send out events using custom sql. We will be working in Arlington the first week of October. If you need help let me know. Thx pietro
-
I did think any used this invoice_email field. It was deprecated a long time ago. Better using the Rolodex parameters to flag invoice and AR recipients.
Invc_rec to send from event manager.thx
pietro
-
Hi Randy the email settings are in the server in the emgr/mail folder in SMTP properties I am In town if you need help
-
Hi Henrik. I made An install file a while ago that was silent and can get pushed out as part of policy. I may Need to remake it. Look up creating msi file and then bring over quantum.exe and qcsysmod. Bring in oui folder From client install. It has a silent install already. Let me now if you need help
thx
p
-
Did you make sure the data elements are in your template ? Also make sure you have a subject like it the event will not appear
-
Lisa you get this ok?
-
There are quite a few hyperlinks in quantum. We need to figure out where you want them and an easy way to manage them.
-
Brave 12.2.3 is cutting edge. Also issues with custom crystal reports
-
Have you tried to disable advanced security in adobe. Or better yet use Fox it
-
Cynthia. Connect the stock table to stock_ti table to wo_bom. Then you can get cost
-
The best way to use power BI is by creating views of the data you want to present. Uses the least number of licenses and fastest response.
-
There are literally thousands of bugs. Old and new. Not sure if there will ever be an entire list. They do post the fixes on the website though.
-
The WiFi guns have always been a problem. The RF guns are the best
-
Mike you should take the sql from the report and run it in sql developer or in quantum. Sql to work out the errors. Reports in quantum just show external exception error when the report query is bad.
-
Thx. We are making our way up the east coast. We are in Lauderdale now. Maybe we will stop by when we get that far. P
-
Alonda did you get that from Nadim. Let me know if you need to put it together. Thx pietro
-
John. Why are you using the status history table. This will give one record per change. If you go direct to po status it will show the status it is now.
-
Lee. Are you looking for wo Bom stock or WO main component ? Main component is connected to stock to stock reservations on stm auto key and then to wo operation on woo auto key
-
Tino send me your email and I’ll send you the directions Thx pietro