it
Forum Replies Created
-
It sounds like you have a pretty process. However, I am struggling a little bit in the “expensive parts” section. Do you allow all of your mechanics to walk into the stores room and get what they need, trusting that they will following procedure?
In short, do you have a stores clerk? This would help streamline the process through centralized control.
Basically, this is what I would see happening (I have used this process in a few repair stations)
1. Mechanic has traveler, list of parts required are printed on it (or not). No reservations are made. Traveler must have the WO barcode, Task barcode on it. If I am not mistaken, there is a way to have this be one barcode – ie the work order number and task number is a single scan.
2. Mechanic needs part, walks to the stores area. He/She has the traveler in hand. Also has his badge with barcode on it.
3. Tells the stores clerk the part needed. Stores clerk looks it up in the system to find the location.
4. Stores clerk pulls the part. Selects the option to issue part to work order.
5. Stores clerk scans the work order/task (see comment above) and gets prompted to scan the part.
6. If the part is not already assigned to the task, it prompts to add part to the task. Answer yes.
7. Then it will prompt for QTY (I think that is the order of the prompts)
8. Then if it is not reserved, it will reserve the stock line and then prompt to issue the stock line.
9. If you answer yes, it issues it to the job.
NOTE: Somewhere in those steps it also asks you to scan the badge of the person you are issuing the part to if you have that switch turned in your system settings.
So, the point I am making is that I guess I don’t understand why the need to know quantities is there. The mechanic should only have to worry about what they want, the system will manage the rest. If there is nothing to issue, then a procurement should be initiated for the item. You could build in automation to alter procurement of this need.
There is a presentation I did a while back on barcoding which covers every single feature of all barcoding capabilities – and screen shots. It is available on this website. I receomend you take a look at it.
Hope this helps.
-
We do not use this. We use our own reports, and we have a customized, fully automated PO/RO approval system. Each transaction is analyzed at the time it is approved. Vendor performance, warranty returns for Vendor, PN and serial number, delivery times, etc.
So, our process moves the analysis of the vendors (both PO and RO) to front the process allowing us to be proactive, instead of reactive.
-
Anthony, we have something similar too. However, our receiving process is as follows.
1. Open box, inspect paperwork, parts, etc.
2. Create receiving inspect transaction
3. Enter waybill, dims, weight, etc. (we have screen scripter module)
4. If RO/PO was not approved, clerk is blocked from creating RI transaction. I have build a fully automated PO/RO approval system using screen scriptor.
5. If 4 is true – they fill out a NCR form called a check tag. They could also enter an unknown receipt. We are working on this process.
6. Process receipt, scan paperwork, photograph part.
7. Print QA document. QA document is customized to pull notes from any attached order. It also has sign off for each item for the WH clerk, and the QA inspector. It also has a series of blocks that get highlighted for a variety of “alerts”
8. Receipt is finalized, passed to QA.
9. If QA rejects it, stock line is correct, new labeled printed.
10. If part is damaged, turned over to procurement, vendor return is processed.
-
You are correct in your thinking. Be aware that you may have challenges if you have dealing with mutli stock reservations.
I always to the qty_ship field whenever dealing with invoices.
For credit memos you can use two instances of the invc_detail talble. the tables would look like this
stock.stm_auto_key = stock_reservations.stm_auto_key and
stock_reservations.sod_auto_key=so_detail.sod_auto_key and
so_detail.sod_auto_key=invc_detail.ind_auto_key and
invc_detail_2.ind_credited=invc_detail.ind_auto_key
This is not excact, but should point you in the right direction. Additionally, this assumes all credits have stock lines and that they are linked through the so_detail table which in reality they are.
This is one way to do it. The other way is just as you have already stated.
If you post your query we might be able to help solve the problem better.
-
Thanks to Stephen Sullivan for this one!!
Oracle, Quantum version 10.1.10
Symptom: When Quantum is launched on the local workstation two instances of command prompt occur in the background (in Windows Task Manager, under processes you will see a row for cmd.exe twice for every occurrence of Quantum being launched). These sessions do not close automatically, even when Quantum closes. As the user continues closing and opening Quantum throughout the week these sessions build up, and eventually greatly impact overall system performance, until the sessions are manually killed in Window Task Manager (or the PC is restarted).
Cause: A pause was mistakenly left in two batch files that run when Quantum is run on the workstations: reg_dotnet.bat and reg_QcProject.bat. This pause prevents the silent command line session that is opened in the background upon launching Quantum from closing.
Fix: Browse to the Quantum shared folder on the server. Locate the two batch files. Edit each batch file (right click, then select Edit). The file should open in text editor (notepad). Remove the word “pauseâ€. Close the file, saving it as you close it. This will update the last modified date on each file. Since the file is listed in versioncheck.dat, when users launch Quantum next the system will detect that the last modified date changed and will pull over the updated batch files to the workstation.
This is fixed in 10.2.
-
Thanks – we noticed multiple cmd.exe instances running on several machines. All of which are having hanging issues.
I am very interested to learn the results of your investigation.
-
I have forwarded your comments to Todd Lewis and Jocelyn Scott as additional emphasis on this topic.
-
Morten – you can have custom programming done for the barcode to show this. However, I think your issue (no pun intended) resides in your process and documentation.
In order to make a recommendation on changes, I would need to understand the following
1. What paperwork does your mechanic have in hand when the demand for the consumables is raised?
2. What does your barcode label on the part look like?
3. What is the setup of your stores room, or area where the mechanic is drawing the consumables from?
4. What happens when the mechanic doesn’t use all of the product they have issued to the job?
-
I have noticed this as well, but I cannot say if I have an issue with them hanging out there.
I know in this version they had to rework some of the messaging and other things and it may be a result of that. The v10 platform is a new code set in Delphi so there could be other things happening upon startup that the new platform needs. I would suggest contacting Nicola to see what he says.
-
More specifically, your statement needs to look like this (US Format)
update stock set tag_date = To_Date(’01/01/2013′,’mm/dd/yyyy’) where pnm_auto_key = 376464 and receiver_number = ‘P240241-10-2’
-
Your client installation needs to be on a dedicated drive for each user. That has to be done through a batch file and component control can provide that. What it does is a map Q drive unique to each user and all of your dlls in your terminal server are registered to the Q drive however on the back end the Q drive is mapped to their individual unique installation for each client. In addition to that you do have to have the d.e.p settings set for the executeables in quantum. I recommend you talk with Pietto at component control.
-
You probably dont have your client installation setup correctly. Each terminal server user must have their own client install. CC has batch files that will help manage this automatically.
-
Brittany,
Please refer to my two lectures from a few years ago on physical inventory and managing stock shortages.
They are found here http://quegroup.camp7.org/Default.aspx?pageId=1501844
-
Jerry – got it. I understand now. I believe the system does not allow it based on the message your provided.
I dont think we have ever had to post anything to the future. I would imagine this would cause reporting issues.
I am sorry, but I cannot offer any more suggestions at this point.
-
You can also force the sub querries to return a single result by encasing the selected field in () preceeded with the “max” function.
This, however, would return only the maximun value if multiple values were found.
select inh.invc_number “INVC #”, inh.invoice_date “INVC DATE”,ind.item_number “ITEM #”,cmp.company_name “CUSTOMER”,
(select max(stk.serial_number)
from stock stk, stock_reservations str, so_detail sod
where
ind.sod_auto_key=sod.sod_auto_key and
str.sod_auto_key=sod.sod_auto_key and
str.stm_auto_key=stk.stm_auto_key) “STK SN”,
(select pcc.condition_code
from part_condition_codes pcc, stock stk, stock_reservations str, so_detail sod
where
ind.sod_auto_key=sod.sod_auto_key and
str.sod_auto_key=sod.sod_auto_key and
str.stm_auto_key=stk.stm_auto_key and
stk.pcc_auto_key=pcc.pcc_auto_key) “STK CD”,
(select max(poh.po_number)
from stock stk, stock_reservations str, so_detail sod, po_detail pod, po_header poh
where
ind.sod_auto_key=sod.sod_auto_key and
str.sod_auto_key=sod.sod_auto_key and
str.stm_auto_key=stk.stm_auto_key and
stk.pod_auto_key=pod.pod_auto_key and
pod.poh_auto_key=poh.poh_auto_key) “STK PO NUMBER”
from invc_detail ind, invc_header inh, companies cmp
where
inh.invoice_date >= To_Date(’01-01-2013′,’mm-dd-yyyy’) and
ind.inh_auto_key=inh.inh_auto_key and
inh.cmp_auto_key=cmp.cmp_auto_key
To see if a sub querry is the culprit for your multiple returned results, you can (as mentioned above) remove one of the sub querries at a time.
Like this one..
(select max(stk.serial_number)
from stock stk, stock_reservations str, so_detail sod
where
ind.sod_auto_key=sod.sod_auto_key and
str.sod_auto_key=sod.sod_auto_key and
str.stm_auto_key=stk.stm_auto_key) “STK SN”,
Just remember to not have a commo on the last value, before the FROM
-
Anne, this means that one of the sub querries is returning more than one result. Likely because you have multiple PO’s related to a single SO item, or multiple stock reservations somewhere.
To troubleshoot it, just remove one sub querry at a time. The sub querries are encased in ()
-
Jerry, if you are getting that error, then you are missing some dates. The Batch header and the detail both need to be changed.
If you verify that both header and detail transaction dates are changed to the same date range the period you are trying to post to are correct, you might need to contact CC. Is it possibly that the period dates assigned to the GL period were entered with the incorrect dates?
-
Jerry,
When you are attempting to post into these periods, have you made that period your current period, and have you changed your transaction dates in the batch to fall within that period?
-
No worries Dave. Many of the staff at CC are knowledgable, but not everyone can know everything.
Hopefully you are attending this years QUE Group Conference in July!
-
Matt, I think you would be well served to attend this year’s QUE Group conference. Nick will be giving a lecture on StarShip, plus you will be able to collaborate with other users face to face and see what solutions they have developed. Your’s sound very interesting and I think you could offer advice to others as well.
-
Dave, the price lines were not mean to be a replacement for or syncornize with the list pricing in the parts master.
The list price in the parts master was meant to the MFG List price, much like Avref pricing whereas the price lines are supposed to be a tool to document single or teared pricing for both customer and vendor.
We use price lines, but I have modified the screens slightly to accomodate our models. Our price lines are used to record price base lines for about 6 types of transcations by condition. For example, exchange new condition or exchange oh condition.
The price lines can be pulled into transactions by entering the price line number in the price field for an item. This will paste in the price line values.
You could also look at the Parts Catalog feature, which does have relationships to the list price field, I believe.
-
Pedro, Thanks for the follow up. It sounds to me like the issue is that the printer you specify in your barcode label print settings is not overriding the system default printer.
I will send this to the CC Board Member for you.
As a side note, it may be easier to change your default printer to your barcode printer, allowing your barcode labels to print directly to the printer, while the other documents are previewed and you then select which printer to route to. At this point it is six of one and half a dozen of the other I suppose.
-
Sue thanks for the details. I will forward this to our CC Board Member for follow up.
-
Nic – I am unaware of anyone doing this type of integration. I can tell you, however, that if that worked with our bank system it would be a great help as well.
The only issues i would see is that it would have to have the following constraints
1. It would have to lock the sales order down after the card is processed so pricing and product could not be changed
2. It would have to bypass any balance or credit limit checks (regardless of terms settings) as the order is paid.
Just a thought..
I am interestd to hear more about this if you pursure it.
-
Nick,
Credit card transactions can be handled in a few ways.
1. You can process the credit card through the invoice POS feature, which acts similar to an FBO type over the counter transaction. When this was introduced, the balance field was intoroduced to the printed invoice and the invoice screen, along with payment amount.
2. You can process the transaction like a normal cash receipt as well. Applying the credit card information during cash receipt process.
If you could offer a bit more detail on what the challenge is that would help us help you 🙂
-
Sue please provide the details of what you see when attempting to delete.
This could be related to a new security setting, it could be related to data issues, it could be related to a bug in the software, it could be related to user error because of new features, or it could be related to a new system setting.
So, please provide the specific error text and the keystrokes or other relivant details of the transction.
Thanks
-
Sue – I think the issue is probably related to the desktop default printer, or your barcode label print settings. We are on that version and have had no issues.
There are two barcode labels in QC, although they look the same they are actually two different documents.
For the one that gets printed upon receiving, you can access it by going to the PO drop down menu, then click Forms and Reports. From there select the Barcode Receiving Label.
This will bring up the print settings that label. Once you have this up, click the EDIT button. You have some choice here now. In the print to option, you can chose to send to Printer – which will send it directly to the printer you have specified in the Printer Option on this screen. If you have nothing specified in the printer option AND you have it set to destination printer then it will just go to the default printer that you have speficied in your computers print settings.
If you choose Preview option (which is what I recommend) then you will see a preview of the barcode label first. This will require the user to then click the Print button. From there the print dialog box would pop up with the printer specified in the Printer option on your print settings above, or your default printer. The preview option is useful if you have a regular laser print set on your computer along with your barcode printer. You can only have one default printer. Usually it is the laser printer. Previewing the label first will allow you to direct the label to whatever printer you want.
So, this is how you can change your print options for the barcode label that prints at the time of the receiving.
For the barcode label that prints from stock, you can access that from the Inventory Drop Down menu, then forms and reports and then Barcode PN Label.
-
In case you are refering to the PO number for which the item was purchased under, and not the customer’s PO number, here is a SQL Query that you can use to get you started
select inh.invc_number “INVC #”, inh.invoice_date “INVC DATE”,ind.item_number “ITEM #”,cmp.company_name “CUSTOMER”,
(select stk.serial_number
from stock stk, stock_reservations str, so_detail sod
where
ind.sod_auto_key=sod.sod_auto_key and
str.sod_auto_key=sod.sod_auto_key and
str.stm_auto_key=stk.stm_auto_key) “STK SN”,
(select pcc.condition_code
from part_condition_codes pcc, stock stk, stock_reservations str, so_detail sod
where
ind.sod_auto_key=sod.sod_auto_key and
str.sod_auto_key=sod.sod_auto_key and
str.stm_auto_key=stk.stm_auto_key and
stk.pcc_auto_key=pcc.pcc_auto_key) “STK CD”,
(select poh.po_number
from stock stk, stock_reservations str, so_detail sod, po_detail pod, po_header poh
where
ind.sod_auto_key=sod.sod_auto_key and
str.sod_auto_key=sod.sod_auto_key and
str.stm_auto_key=stk.stm_auto_key and
stk.pod_auto_key=pod.pod_auto_key and
pod.poh_auto_key=poh.poh_auto_key) “STK PO NUMBER”
from invc_detail ind, invc_header inh, companies cmp
where
inh.invoice_date >= To_Date(’01-01-2013′,’mm-dd-yyyy’) and
ind.inh_auto_key=inh.inh_auto_key and
inh.cmp_auto_key=cmp.cmp_auto_key
This assumes you are using the sales order moudle to sell your parts, and not the RMI module, or just directly through the invoice
You should be able to copy and paste this SQL into your Interactive SQL tool and run it to see how it returns the results.
Hope that helps.
-
James, not sure if you know this or not, but the imaging system uses the IE browser by default. So, whatever IE can interript, and how IE would behave using it through the standard GUI is how imaging would reactact.
That being said, you may be able to get creative with XML files, or scripts to open
what you need by putting the file attachement as the link itself. For example, an HTML file with a redirect header tag would prevent the user from having to click a link.
Just a thought.
-
Ryan,
That is pretty much the only way I can think of to handle it. The only suggestion I have is to create an SO to that vendor, link your RO to it and sell the part to them for the amount. Then do an ar to ap transfer if necessary. THat will provide for a cleaner transaction trail.
-
Ryan, Does the core credit result in a part being shipped to you at some point, or is the credit money?
I assume the core credit referes to a future purchase on exchange?
How you are currently handling this, even if it is a manual process.
-
Nick,
Yes, there is a function for that. For warnings only, your code would look like this
procedure FormShow(Sender: TObject);
begin
end;
procedure BtnOKClick(Sender: TObject);
begin
begin
if (form.dataset.fieldbyname(‘TMC_AUTO_KEY’).AsInteger=’8′)
then
showmessage(‘ CUSTOMER TERMS NEED VERIFICATION. ^ UPDATE THE SALES ORDER HEADER AND THE COMPANY MASTER RECORD’);
END;
END;
-
There is no company level warnings for the receiving inspection module.
However, you could put warnings against those company records for PO and RO activities that warn the users to insert specifcally worded statements into the RECEVING INSTRUCTIONS field.
Receiving instrustions are available for exchanges, purchase orders and repair orders and are visible to the user upon receipt.
Another tactic could be to embedd pop up messages in the documents that get printed when receiving and have them pop up for specific companies. To avoid coding multiple company names, you could use a UDF check box in the company record and change the UDF lable to “Receive Warning”. Then, in your documents any time that check box is “True” throw the pop up message upon printing of the document.
-
James – I dont think that is possible as the notes in Contact Mgmt are Blob fields which do not recongize HTLM tags.
You could use document imaging perhaps.
-
Billy, yes that is the way to handle. We have used the Drop Ship flag in the PO to initiate a crystal report (within 15 minutes of it being approved) which notifys our billing department, and our QA department.
They the QA team will contact the vendor to obtian the paperwork and they actually do the recieving. This is to ensure proper paperwork. It is essentially a routine inspection without physically looking at the part.
Once the receipt is done, the procurement team is notified and they print a packing slip which gets routed to our billing team. The billing team then creates the invoice directly from the sales order.
The reason they create the invoice is to ensure additional charges are applied where applicable.
With reference to the PO being approved, we do not use the built in PR module. We have created our our internal approval system for PO and RO transactions using the Screen Designer module and Crystal Reports (which are automated with Visual Cut)
-
Thanks Nic – We have never used that feature, which is probably why I didnt know it was there. Appreciate the explaination.
-
Nic – can you ellaborate on the “C1” reference? I am unfamilary with any area that automatically posts any type of invoices.
-
Yes, we are on the 10 in our live environement.
There was some very good performance improvements. There is also some bugs
in stock issue, and dealing with consignment/lot core cancelations and rma’s.
-
Bill,
You hit the nail on the head. That is a big issue with integration. Have looked at StarShip? CC created that integration after Guy Richie visited my site and saw what I did with Harvey Software.
That being said, our integration is still better than the Star Ship I think. Harvey is a low cost, powerful and flexiable system. We purchase one license and paid a contractor to build the bridge for us for about 4,500 and that was nearly 7 years ago. Its been rock solid since.
To solve the address problem, we built it into the bridge where we parse each field, working backwards to seperate the field elements then put them into the proper fields in Harvey.
Having a bridge to a single shipping software that allows for multipel carriers is a huge advantage because then you only deal with one bridge to maintain, and you have to train only on one interface, instead of each carriers software.
Our bridge grabs data from QC Shipping module based on Shipping Order number. It brings over all address, COD, hazmat, ship methods and account numbers.
It checks order amounts, payment terms and company warnings for potential blocks.
After processing order, it displays shipping status to select, then stores this in a temp table.
Shipment can be deleted and changed any time during the day with no impact to QC data.
At the end of the day, all shipping details including price and cost of freigth, who packed it, number of boxes, dims, wietght, etc. are posted back to QC shipping order and the status selected at the time of shipping is applied – which then creates the invoice and prints any associated docs.
The one thing that StarShip does do that mine does not is ship HazMat. Ours needs a third party app to ship hazmat, so those are processed through UPS.
Otherwise we can also add carriers and build our own back end integration to those carriers if we want.
I believe Nic Chambers uses StarShip quite sucessfully, so he may be able to tell you more about that option.
-
Dave – is it possible the invoices were printed upon core receipt, then when accounting was processing invoiced in the “Print/Post” invoices function off of the invoice mdoule, they selected all invoices to post? It wouldnt have alterted them if the invoices were already printed.
Also, if you open the invoice and go to the global menu, look at the Browse Audit Trail. This will tell you the user, date and time that each process step was done in the invoice. That being create, print and post.
That assumes you have Track Changes turned on system wide.
-
Dave, the easiest thing to do is just a query in the Interactive SQL tool like this..
select
pr.pri_auto_key,
pn.pn,
pc.condition_code,
pr.price_line,
pr.discount,
pr.list_price,
pr.price_type,
pr.remarks,
pr.qty_multiple,
pr.unit_cost,
pr.mfg_discount_code,
pr.mfg_deposit,
mfg.mfg_code,
pr.converted,
ds.discount_code,
pr.foreign_list_price,
cur.currency_code,
pr.exchange_rate,
pr.avref_flag,
pr.override_discount,
pr.sdf_pri_001,
pr.sdf_pri_002,
pr.sdf_pri_003,
pr.sdf_pri_004,
pr.sdf_pri_005,
pr.sdf_pri_006,
pr.sdf_pri_007,
pr.sdf_pri_008,
pr.sdf_pri_009,
pr.sdf_pri_010,
pr.wo_exch_lp,
pr.wo_foreign_exch_lp,
ur.user_name,
pr.change_timestamp,
pr.foreign_unit_price,
pr.sell_price_method,
pr.disc_pre_price,
pr.mult_pre_price,
pr.overwrite_sp,
pr.overwrite_lp
from
prices pr,parts_master pn,part_condition_codes pc,manufacturer mfg,discount_codes ds,currency cur,sys_users ur
where
pr.pnm_auto_key=pn.pnm_auto_key and
pr.pcc_auto_key=pc.pcc_auto_key and
pr.mfg_auto_key=mfg.mfg_auto_key and
pr.dsc_auto_key=ds.dsc_auto_key and
pr.cur_auto_key=cur.cur_auto_key and
pr.sysur_auto_key= ur.sysur_auto_key
Then, in interactive SQL you can click the Save icon and it will dump the results into a CSV file. Not all of the fields are included in this query as I dont know what version you are running.
Once you have your data stored, you can delete the records in the table by running this SQL statement
delete * from prices
Test this in your test database first. The delete statement will likely take a long time if you have a lot of records, and will slow your system down.
-
To the best of my knowledge, the only thing that can post an invoice when receiving a credit memo is the user. When they receive the core, it will prompt to create the credit memo. If yes is selected, it automatically shows the print. Once printed, it prompts to post.
Make sure your receiving clerks do not have access to post an invoice.
Also, if you are using the reciving inspection module, you can normalize and streamline your receiving so that your users are seeing pretty much the same thing for each receipt.
The only exception is RMA’s which cannot be receiving through the recieving module.
-
We do not currently use the warranty module, but would should like to be able to use for warranty purposes.
We use to process warranty transactions with the sales exchange function (see my lecture on “Creative Exchanges”) but now that our lot and consignment inventory has increased substantially, we are switching to using the RMA functionality exclusively. We are incorporating an automated approval system using screen scriptor, much like our PO and RO approvals.
When it comes to warranty proccessing, the key points to consider are
1. The effects on the lot module
2. The effects on consignments
3. The effects on sales person commission
4. The effects on Revenue and COGS reconition
5. The effects on customer statements
6. The effects on Awaiting Core
7. The effects on stock cost assignment
8. The processes for bill backs
After a full investigation and review we opted to stay with the RMA functionality.
-
Also – we will be creating a forum for the purchase order module soon. Thanks for pointing that out.
-
We do not use the cost+ method in purchase management. Unless something has changed recently that I am not aware or, there is no real functionality behind the exchange method settings in the PO.
So, this is how we handle PO exchanges that are borkered – not specific to your question, but it might help you flow through your process.
•1. Create SO for flat rate exchange
•2. Create PO linked to SO for exchange
•a. On the PO add a charge code for the exchange repair charges.
•3. Receive exchange item on the PO
•a. This will automatically reserve item to the SO
•b. Do NOT receive the repair charge on the PO yet
•4. Ship item to the customer on the SO
•5. Customer sends Core back on SO
•a. Receive core on the SO
•6. Link core stock line from the SO to the PO core return
•a. Ship core back to the vendor
•7. Vendor gets core repaired.
•8. Vendor sends us a bill for the repair charge.
Option 1: Core repair charge is higher than what was billed to the customer
•A. Delete the charge on the PO
•B. Add a Part Number on the PO called Repair Charge with the cost of the repairs
•C. Re-Open original SO and Add a Part Number on the SO called Repair Charge
•D. Link SO item and PO item
•E. Receive the Part Number called Repair Charge on the PO
•F. This will reserve the item to the SO
•G. Invoice the part number called Repair Charge to the customer
Option 2: Core repair charge is lower or equal to what was billed to the customer
•A. Leave the charge code called Repair Charge on the PO
•B. Enter the amount of the repair charges
•C. Receive the repair charge
•D. Accounting changes the GL batch and points the charge amount to COGS, so that is is AP Suspense and COGS
•E. Accounting adds an adjustment charge to the Invoice with the difference in cost and a zero price amount.
•a. This is NOT the actual repair charge amount, but the difference between the original cost and the repair charge
Amount so as to bring the total invoice cost to the amount of the original item purchased + the core repair charges.
-
Sorry for the lack of clarity in my other post. I assume you would not be unreserving the unit. I am a bit puzzled by the external to internal not working. An extern WO is by its charateristics a customer owned unit. It must be a bug.
We have work order but are not actively using it. We have setup two additional databases for both of our repair stations and are re-implementing those. So, I cannot say if it works in our current verion – but Im sure I will find out soon enough.
The closed update field is present in many of the QC tables. The developers built this in for tech support reason. It allows you (in most cases where the field is present) to bypass the stored procedures and contraints so that you change the table values without getting the contraint errors.
…. little insider trick.
… if you want to know how to default your password on your machine, I can tell you how to do that too. In a work order environment where you have a kiosk machine shared by many users (contractors in some cases) you could set up a Windows machine to automaticallly log into your network bypassing the network logon, then automatically launch QC (and even default hte DB in a multi DB setup) which defaults the QC password requiring the user only press OK to log on.
-
Nic is absolutely correct. I forgot to mention that part. You could also do a qty split on your stock lines creating new stock lines with qty 1 each. Then, you may still need to update the serial number fields through sql.
Either way, always remember to re-label your parts if they are on your shelf. See my white paper on “What Requires A Part To Be Re-Labeled” which is available in one of the previous conference downloads area.
-
Ryan – other than looking at the Analysis took in the inventory module for each part indivudally, you will probably have to create a crystal report, or excel query to do this.
Kenin Otto (Advance QC) is capable of creating this for you at a reasonable price.
-
Larry, I doubt voiding your PO would allow you to change the status of the PN.
The issue is that the serialized flag is looking for serial numbers in your active AND historical stock lines.
An easy fix is to run an SQL statement like this
update stock set closed_update=’T’, serial_number=’NSN’ where pnm_auto_key= [input the part master auto key here] and serial_number=”
This will insert the text “NSN’ into the serial number field for all of your stock lines that are attached to the specific part number, regardless of their active state. It will ignor any stock lines that already have a serial number. Once this is done, you can turn on the serialized flag for the part number. Then, edit your stock lines one at a time to input the correct serial number. Going forward, a serial number will be require for this part upon receipt.
Hope that helps.