it
Forum Replies Created
-
I believe the syntax is like this
FormatDateTime(‘dd/mm/yyyy’, myDate));
-
Great!
-
Michael, this sounds like what I have for our Oracle system.
I will be giving a presentation on this, and would like to mention you as a resource for the firebird element.
May I throw your name out there?
-
Jessica – can you please email me a screen shot of one of you problematic transactions so that I can better understand the issue?
I’ve checked with out payables department and they do not entirely understand the issue you are having either.
If there is an order related to it, such as PO/RO, etc. provide information on that too.
-
Ryan, there are two option I believe.
1. Create a sales order to the vendor for the same item, same amount non stock and invoice it out. Then, you can do an AP to AR transfer to wash the transactions out.
2. Create a new line item on the PO, same PN non stock but put a negative quantity in. Receive it – post the vendor invoice then you can do an AP to AP to wash the transactions out.
Make sure you test in your Test DB first.
-
Wesley this can be done with Crystal Reports and then automating those reports using Visual Cut or other automation tool.
-
Tony – we have never had the Oracle support. CC has always helped us with any issues we have had. Really, the elements of Oracle that are used by Quantum, and us is really pretty limited.
I have yet to use anyone but CC. Pretty hard to beat Konstantin’s knowledge and availability.
-
The only way to accomplish this is to use the DIA Tool. I don’t know if they have pre-written import scripts for stock reservations. I doubt it.
However, if you have the barcode unit, you can use the very first option called SO VAL which is SO Validate.
This function allows you to scan the BC on the part, add it to the SO and Reserve while you are picking the part. Of course, you would have to have some sort of list of stock lines with their locations to work from. We find it works beautifully for large orders. We are currently building two of them as I type this using the Wireless BC units.
-
Dave – that is a new setting in your system settings.
-
Cory, we used that feature in our shop many years ago and it worked pretty good.
However, that was many version ago on both QC and MS Project.
-
Spencer – I believe Eric Chez or John Boyce might be a good source of information. I know they do a lot of work outside the system.
-
Sue, I think it might be best to engage Component Control for a refresher demo first. I would go the route of sales and not technical support or training. Although you use the AC maintenance module, you could ask sales to do a refresher demo to see if you can truly deploy the module, or if you need to cancel the SMA and licensing for the module since you don’t use it swap it for a different module.
I am not trying to get around them charging for training, but this is really what you need – essentially you need to be “re-sold” the module, right?
Just a thought.
-
Spencer – you could use document imaging to attach the file to an RFQ or the company record.
-
Ken, yes that would be easier. Having worked with Quantum since the very first lines of code were written, and before that the Quick Quote system, I can tell you that in my experience, it is not a frequent thing to change the sales order company after the sales order has been created, line items added and potentially stock reserved.
Most companies want a record of the customer canceling the order, and if it is a common thing, then perhaps the root cause should be investigated and addressed through a process analysis and re-definement so that it is avoided in future transactions. Addressing why a mistake or cancelation is made, in my opinion, is better business practice then introducing ways to hide mistakes or lose the record of the cancelation.
Just my two cents.
-
Ken – you have two options.
1. If you want to keep record of the sale the customer made, and then canceld (if that is the case) then you can manually close your sales order (making sure you do not have stock reservations) and then COPY the sales order.
To copy the sales order, click the Browse SO Header option from the drop down menu, search for the sales order so that it comes up on your browse, then click the COPY button at the bottom of the browse grid. This will provide an opportunity to specify the customer and then replicate all of the line items on the sales order.
2. You can manually change the pointer in the SO_Header table to from the old customer to the new customer using the Interactive SQL tool.
By pressing CTRL+F10 you will be given a field value view window which shows you all field values. The field you want to change would be the CMP_AUTO_KEY
So, open your sales order, edit the header and press CTRL+F10 – write down the SOH_AUTO_KEY number. This is the unique identifier for that Sales Order header.
Then, open the company record that you want to change it to. Edit the company. Press CTRL+F10 and write down the CMP_AUTO_KEY number. This is the unique identifier for that company record.
Next, open your interactive SQL statement. Type in
update so_header set CMP_AUTO_KEY=[your company auto key here] where SOH_AUTO_KEY=[your sale order auto key here]
click the yellow lightening bolt. If you are confident the statement is correct, click the green check box.
Remember, never… ever forget the WHERE statement. If you do, it could change ALL of your sales orders.
-
Ken – yes you can certainly do that. You have to look at the cost to benefit ratio. There is real cost associated to processing transactions inefficiently. Take this example
If you can save yourself 10 seconds on every transaction you do in QC and you do 10 transaction per day, that works out to be ..
10 seconds * 10 transactions = 100 seconds
100 seconds / 60 = 1.66 minutes per day (not much)
1.66 minutes * 5 days a week = 8.33 minutes per week
8.33 minutes per week * 52 weeks per year = 260 minutes per year
260 minutes per year / 60 = 4.33 hours per year saved (over half of a work day)
Now, if you actually figure out the amount of time you would spend creating
this bogus line item, printing your document, then deleting the line item and
re-adding it as an exchange (if that is my understanding) and figure out
how many you do a year I think might be quite surprised how many hours
you will spend doing that. It probably could pay for the Forms Designer Module.
Just a little food for thought 🙂
-
Well, you could create your own document set in Crystal Reports and use Datalink viewer to run them.
Or, you could use the clause system or line item notes to elaborate on the default wording.
That is pretty much your options as far as I know.
-
Ken – you need to modify your documents in the forms designer module to accommodate the different languages.
The only different between the exchange and the loan function in QC is that the loan function forces the same PN/SN upon core receipt.
I did a lecture at the conference a few years back called creative exchanges. It talks to the exact situation you are speaking of.
It is available in the Members only section under presentations
-
Sue, the aircraft configurations is used for managing fleet maintenance, and events. It is a fairly complex functionality. We use it on a limited based for tracking the westwind fleet configurations as the OEM rep, but don’t use for launching actual maintenance events.
The idea behind it is that you can build out your aircraft configurations for each aircraft in your fleet, then record flight hours against it. From there you can run reports on when maintenance due. The system will automatically cycle the landings, cycles, flight hours, etc. all based on how you have set up your aircraft structure and how each element of the structure is “incremented” towards a maintenance event, like a A, B or C check.
You can launch non-routine events as well and link it all to the AC Maint Module, which works nicely. There is a steep learning curve.
as for the publications module, this is used to track publication revisions. Although it a handy tool, it is not extremely robust. Many airlines and other fleet based companies are moving more towards solutions like that offered by JetPubs (right down the street from us)
Hope that helps.
-
Here is the status according Nicola Hanna at Component Control
Just a quick update regarding this item. We have heard a lot from our customers regarding the bank reconciliation screen and this forced us to research new components that would allow us to collapse the screen as we were able to in the past. We were successful in finding the solution, and it has been corrected in our development environment. Version 10.3 will have this feature returned to the system.
-
Thanks for the compliment Ken. I’ve been using Component Control products since 1998 when I started at Component Control back in the Quick Quote days. I worked there for seven years, and left there in 2004 as the VP of Quantum Product. Funny to think I interviewed (and maybe made the hiring decision – can’t remember) Pietro, Frank, Joanne, Jason, and possibly a few others that have been there a while. Patsy interviewed me along with Mike and Connie – the founders of Component Control – a long time ago when I first started there.
So.. I’ve been around the block a few times. Hope to see you at the conference.
-
Yes – this would be nice. But, you could use the custom menus to create a shortcut to the document images icon to at least make it a single click for access.
-
There are a lot of variables here.
The first question is – is he uploading the listing, using the ILS Extract to update of letting it happen automatically with their monitoring tool?
The ILS extract allows you to exclude reserved parts.
I do not see any fields or filters to exclude the reserved items. This could be accomplished through either an event manager script (do they have that) where the script removes the stock market flag if an item is reserved – or they could have a customized upload.
I think there is more to this then meets the eye. Are you both on the same version?
-
Ken,
There is no search capability in the forums. We use a web service called Wild Apricot and have submitted this request several times. We hope to have that capability in the future.
There is no job posting forum here, but we are constantly expanding the services. Job forums is something we are currently looking into, but with a partnership approach with placement services.
-
Ken – There is now a new forum called New Member Introductions
Thank you for the feedback.
-
Ken – We do not have that, but its not a bad idea. We can certainly add it.
Most participants here have met each other at some point along the way, so I guess we didn’t really think about it. Hopefully we can meet you at the conference!
Take a look around the forums and see if you scrape up some useful stuff. We are always looking for more suggestions.
-
I will request an update on the issue.
-
Ken – welcome to forum!
I would like to see this as well. There is actually a item number field in the BOM table and I suspect it wouldn’t be too hard to implement that. I undertand your frustration, we have the same challenge.
I will forward the request onto CC again and see what comes of it. If you are attending the coference this year, we bring it up there too
-
Sorry – the answer is in this forum
http://quegroup.camp7.org/Default.aspx?pageId=580507&mode=MessageList&eid=1259455
-
Matt – there is a fix in version ten for the performance issues. Refer the administration forum for details.
No issues with Avref here.
-
Thanks for the help everyone. Worked like a charm!!
-
Nick – this is great. I use a crystal report to extract the ILS files, and this can automated with Visual Cut. The beauty of this approach is that I can create a batch file that calls visual cut and the FTP push after VC runs. That batch file is what is scheduled.
So, in short, I can fully automated my ILS uploads now with your batch file examples.
If anyone wants a copy of the crystal report, I will be happy to send it along.
-
Nick will you share samples of your batch files to auto upload the file via FTP?
-
The portal has been a key element to our contract programs. I will be giving a lecture on this at the conference and touch on that portion of the portal.
-
As a side note, we prefer to use the XREF table to record higher and lower assembly items. This allows us to find parts when searching in the parts master records. The assembly matrix is not looked at when searching parts.
This is relative to parts sales and not work order related functionality, however.
-
The assembly matrix is found through the part master global menu Assembly Matrix option. From there you can add your list of part numbers (higher or lower assembly).
Once there is data in this table, an icon will appear in the button bar next to the part that looks like an aircraft.
To the best of my knowledge, this table functions only as a reference outside of any shop control type functions.
-
We have been using the portal for over a year now. The setup was very easy. It has been very reliable and works well.
The only complaint I have is the limited style sheets available to customize the screen layouts. Im not speaking of the data fields, and labels for the data fields. That is very extensive. I am speaking of the actual HTML Style sheets.
That being said, the ability to customize what the user sees on an individual basis is huge. We can give one user access to data that another user in the same company does not get. I love that part.
The only thing I wish I could get is a full on shopping cart that is integrated with the EDI system. That would be the icing on the cake.
We have a demo video for purposes of training our customers on the web portal. You can view it on our website at http://www.worthingtonav.com click on My Portal then click the Business Portal Introduction Video link.
http://www.worthingtonav.com/uploadedFiles/Mainsite/MyPortal/web_portal.html
As for static IP’s, that is must. You need that in order to operate securely. Port forwarding will work, but if you host your own website, it can get a bit messy. Also, you will need a security certificate installed on the server.
Hope that helps.
-
Thanks John! I read quite a bit about the TDBComboBox giving people issues.
I will try your approach as well.
I ordered about 4 books on sql, data analysis and Delphi to get my library back up to speed.
-
Thanks Cameron, I will give it go.
Hope you are able to make the conference! Keep me posted.
-
Ok – My coding is pretty rusty, and I could use some help on this. I have been able to get the TDBComboBox object to show the list of system users as my previous code shows.
However, I am unable to select a value from the drop down, and I do not really know how to then take that selection and post it to the DB. I have looked at list objects vs. combo box objects and get no different results.
Can some please assist by posting code that would allow to save the select value to a UDF field in the On Button Click section?
-
Sorry – there should be a
q.Free;
Before the last end;
-
For the benefit of other users, I decided to post the full set of code for this drop down box.
Thanks for the help on this, it is much appreciated.
This code is in the Form show section, creates a ComboBox (drop down box) and fill the selection with the user name from the sysuser table. This code is written relative to the shipping order header, where the parent object is not the form, but the first tab sheet.
procedure FormShow(Sender: TObject);
var
q: TOracleDataset;
cmb: TDBcombobox;
begin
cmb :=TDBcombobox.Create(Form);
cmb.Parent := Form.TabSheet1;
cmb.DataField := Form.Dataset.Fieldbyname(‘SDF_SMH_001’).AsString;
cmb.dataSource := Form.DataSource;
cmb.Top := 222; {Play with position}
cmb.Left := 386; {Play with position}
cmb.width :=228; {Play with position}
cmb.height :=21; {Play with position}
q := TOracleDataset.Create(nil);
q.SetSession := Form.OCSession;
q.Sql.text :=’select user_name from sys_users order by 1′ ;
q.Open;
q.First;
while not q.eof do
begin
cmb.items.add(q.FieldByName(‘user_name’).asString);
q.Next;
end;
end;
-
when QC is launched, the quantum.exe file checks the versions.dat file as you said. if it needs to copy files down, it does. Then it launches the reg.exe and registers all DLLs. I am not confident that the versions.dat file is the only thing that initiates the update process though. Not sure, but the datetime stamps of the dlls alone may also be an initiator.
Have you tried just changing the versions.dat file to read only so it never gets updated?
-
We were in the same boat. The majority of our issues related to string conversions though. Some of our custom documents needed correction too.
What I did to speed it up was export the code and my screen XML and then use notepad to do a find and replace. Then, copied the screen code and button click code back into the system.
-
Andrew – This is great! I have posted similar code for the current user portion, but have struggled with poplulating the list values.
This is exactly what I needed! Thank you!
-
You know what I always say..
Define the Process and Train!
-
Cameron, several examples have been posted to the forums for screen script code.
It may be in the system admin or the forms designer area or even this forum, I cannot recall where I posted it.
I am at a bit of an impasse myself. I need to find a say to grab users and populate a selection option with them. I can get the users, but I don’t know how to then populate a drop down list.
Not sure if this is what you are trying to do, but if you have suggestions on this, that would be great.
My samples do show ways to grab the user name, etc.
-
I think security is handled through user log in. It is on the user of the computer to ensure they are logged in. If they move away from the computer, they should be hitting F8 to log out, requiring the next person to log in.
We modified our barcode labels to include the user name of the person who received the part. Additionally, our warehouse clerks have stamps issued by QA. They are different looking than QA but are controlled the same way. This is what is used to stamp off the inbound QA document, and also the pick tickets on the way out. Our guys are required to stamp the pick tickets for who picked it, who inspected it, who packed it and who shipped it.
The barcode label also has a box on it for the QA person to stamp off on the inbound side.
In addition to this, on the outbound side, we barcode the shipment statuses (shipping order). So, when the part is picked, the clerk scans the shipping order, and a barcode called picked. The same for inspected, the same for packed, and again after the tracking number has been assigned, they scan one called ready for pickup.
This generates automated notices to the originator of the order, updates our website for the customer, and provides a time trail for analysis, history, etc.
I know this is a bit off track, but may stimulate ideas.
I presume this is what you mean by security.
-
Certainly.