it
Forum Replies Created
-
If you are on a newer version of QC, they changed the underlying document imaging functionality. This has caused all kinds of issues.
We have been working through them painfully and slowly. We found that users who have Adobe Acrobat DC installed on their machines cannot use imaging, even if you change the default for PDFs to Adobe reader and you change the defaults browser to IE Explorer.
We are running Windows 10, Adobe Reader DC, Adobe Acrobat DC – all the newest stuff.
If you do not have Adobe Acrobat installed, you can check the following
1. Make sure quantum.exe and qcsysmod.exe are in your list for data execution prevention – data execution prevention needs to be turned on.
2. If you are running windows 10, change your default browser to IE and no other. Edge will not work, firefox is problematic as is Chrome.
3. In your browser, make sure your adobe extensions are enabled and allowed.
If you are using Acrobat, like us, you will probably just have to wait until they fix it…
-
Ah I see. We do the same thing.
You will need to cut a Repair Order to yourself for the consigned part. Then, do an external work order to consignor.
Perform the work, virtually ship the part when the work is done. This will create the invoice for record.
Then, on the RO, receive the item into stock. This will create the payable.
You will need to decide how you want to handle the accounting side. And, this depends on how you are handling the billing of the repairs. There are many flavors of that.
-
Consigned product is not your own stock. There is no mechanism to show the usage of consigned parts as a sale within a work order bill of material.
Therefore, you must either
A. buy the product from your consignor so their commission check gets generated.
You would create an SO to yourself and a PO to your consignor. Ship the current part under consignment and bill it to yourself. Then, receive it in at the price you purchased it for. End result is the stock line is in your system as your stock with the purchase cost on it. Then you add it to the work order BOM.
Or
B. Sell the part to your Work Order customer so the commission check gets generated, then bring it into your work order BOM as customer owned stock.
-
The answer to your question depends on the technical abilities within your organization. One person might think creating a Crystal Report or writing an SQL statement is simple but another might not.
Your options are
1. Use the browse grids in QC to extract data into CSV files, then open them in excel and manipulate the data there.
2. Write SQL queries and execute them in Quantum’s Interactive SQL, then export those results into a CSV file. Open it in Excel and further manipulate the data.
3. Write SQL queries and same them in MS Query (.dqy file) format. This opens as a direct data connection to Quantum using MS Excel.
4. Use MS Excel data connection tools to connect to QC database, link tables and filter data.
5. Purchase Crystal Reports and write your own external reports
6. Purchase the Dashlet module and create dashboard queries (you need to know SQL for this to work, so you might as well save the money and do one of the options above)
There are many other 3rd party reporting tools that can connect to the QC database and create reports as well.
-
That is an only one I used as one point. The external table contained 3 fields, loc_auto_key, code and description.
Although it imports locations into the warehouse locations table vs. the locations table, it should be enough to get you started on what you need.
-
“WH_LOC_IMPORT”
PROCEDURE WH_LOC_IMPORT (P_IMP NUMBER)
IS
C DIA_RL_PKG.CURSOR_TYPE ;
V_START_LINE NUMBER := DIA_RL_PKG.get_start_line(p_imp) ;
I NUMBER := 0 ;
V_PWD VARCHAR2(100) := NULL;
SYSUR NUMBER ;
V_WLC NUMBER ;
V_LOC NUMBER ;
BEGIN
OPEN C FOR SELECT PWD, SYSUR_AUTO_KEY FROM SYS_USERS WHERE USER_NAME = ‘SYSDBA’ ;
FETCH C INTO V_PWD , SYSUR ; CLOSE C;
C := qc_sc_pkg.validate_password(‘SYSDBA’,V_PWD);
CLOSE C ;
/*
C := qc_sc_pkg.validate_password(‘SYSDBA’,V_PWD);
CLOSE C ;
*/
FOR R IN ( SELECT EXT.*
FROM EXT_WH_LOCS EXT
) LOOP
I := I +1 ;
IF (I >= V_START_LINE) THEN
V_LOC:=null;
OPEN C FOR SELECT LC.LOC_AUTO_KEY FROM LOCATION LC WHERE
LC.LOC_AUTO_KEY=R.LOC_AUTO_KEY;
FETCH C INTO V_LOC;
CLOSE C;
V_WLC := null ;
SELECT G_WLC_AUTO_KEY.NEXTVAL INTO V_WLC FROM dual ;
INSERT INTO WAREHOUSE_LOCATIONS (WLC_AUTO_KEY, WHS_AUTO_KEY, LOC_AUTO_KEY)
VALUES (V_WLC,’147′, V_LOC);
END IF;
END LOOP;
END ;
-
There are a few things will contribute to this.
1. Make sure your handheld units (if you have more than one) do not have the same host ID – you will get cross talk otherwise.
2. Make sure your hand held units recognize allow more than one base station so you have to make sure that your hand held is using the correct base station ID
3. If you are connecting your base station to the PC via serial port, make sure it is using com1 port.
4. If you are connecting your base station to your PC using a serial to USB adaptor (like I am ) make sure your drivers are installed and it is set up to use com1 port emulator.
5. We use RF Active X connection as the others do not work. If you are as well, make sure the active x plug ins are installed.
-
I believe it is because you starting at the invoice header level.
You should start from the invoice detail table.
Also, know that you might not retrieve credit memos this way.
-
Paul Stewart wrote:Unfortunately I don’t think anything will. It would require a complete overhaul of the grid system in QC in order for it to work.
-
Alonda what are the decimal place settings for both your cost and qty settings?
If these are not (looks like in your case) 3 places out, numbers will get rounded.
You can check these in the user menu, system settings, global settings.
-
I am not too familiar with the AeroExchange services. All I know is we list our stock on Aeroexchange via the Stock Market and we receive and reply to part quotes via the EDI connection to Aeroexchange.
-
Click User menu, then Interactive SQL
Copy and paste the SQL statement below, then click the lighting bolt
You can click the Disk symbol to save the query results to a CSV file
select cm.company_name, cm.company_code, tm.term_code, tm.description from companies cm, term_codes tm where cm.tmc_auto_key=tm.tmc_auto_key
-
The licensing tool is supposed to be added to security in coming releases. I will email it to you separate though.
-
We have been using the Aeroexchange EDI bridge for a couple years now. There are some things to be aware of. For example, you can not send notes via the EDI and you must reply one for one and cannot combine items or add items.
-
Jake, if the users are using QC Oracle, you don’t have to create any connections, they should already have it. You can create a file and connection string with msquery. Here is an example.
This is a query we use to manage our exchanges. It pulls in sales, purchase and RMI exchanges. The first 3 lines is the connection string to the database, including the user name and password. If you copy and paste this into a notepad text file, then save it as .dqy file you should be able to double click it and open it with MS Excel. You can then take the excel spreadsheet and save it. This will retain the database query.
XLODBC
1
DSN=QC Live;UID=CRYSTAL;DBQ=MAXQPROD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;MLD=0;ODA=F;
select ‘CPP’ “TRAN TYPE”, (case when ex.core_ret_date>to_date(‘1990/01/01:12:00:00AM’, ‘yyyy/mm/dd:hh:mi:ssam’) then ‘CLOSED’ else (case when ex.canceled_date>to_date(‘1990/01/01:12:00:00AM’, ‘yyyy/mm/dd:hh:mi:ssam’) then ‘CANCELED’ else ‘OPEN’ end) end) “STATUS”, ex.core_due_date “CORE DUE DT”, ex.core_ret_date “CORE RET DT”, ex.canceled_date “CANCELED DT”, ex.remarks “EX REMARKS”, (select cmp.company_name from companies cmp, wo_operation wo, ci_utl ci, wo_bom wob where ex.cut_auto_key=ci.cut_auto_key and ci.wob_auto_key=wob.wob_auto_key and wob.woo_auto_key=wo.woo_auto_key and wo.cmp_auto_key=cmp.cmp_auto_key) “COMPANY”, (select wo.si_number from wo_operation wo, ci_utl ci, wo_bom wob where ex.cut_auto_key=ci.cut_auto_key and ci.wob_auto_key=wob.wob_auto_key and wob.woo_auto_key=wo.woo_auto_key) “ORDER NUMBER”, (select wob.item_number from ci_utl ci, wo_bom wob where ex.cut_auto_key=ci.cut_auto_key and ci.wob_auto_key=wob.wob_auto_key) “ORDER ITEM”, (select roh.ro_number from ro_header roh, ro_detail rod where rod.rod_auto_key=ex.rod_auto_key and rod.roh_auto_key=roh.roh_auto_key) “RO NUMBER”, (select rod.item_number from ro_detail rod where rod.rod_auto_key=ex.rod_auto_key) “RO ITEM”, (select pn.pn from parts_master pn, wo_bom wob, ci_utl ci where ci.cut_auto_key=ex.cut_auto_key and wob.pnm_auto_key=pn.pnm_auto_key and wob.wob_auto_key=ci.wob_auto_key) “ORDER PN”, (select pn.description from parts_master pn, wo_bom wob, ci_utl ci where ci.cut_auto_key=ex.cut_auto_key and wob.pnm_auto_key=pn.pnm_auto_key and wob.wob_auto_key=ci.wob_auto_key) “ORDER DESC”, (select stk.serial_number from stock stk where stk.stm_auto_key=ex.orig_stm) “ORDER SN”, (select cng.consignment_code from consignment_codes cng, stock stk where stk.stm_auto_key=ex.orig_stm and stk.cnc_auto_key=cng.cnc_auto_key) “ORDER CSNG”, (select wo.si_number from wo_operation wo, stock stk, stock_reservations str2 where stk.stm_auto_key=ex.orig_stm and stk.stm_lot=str2.stm_auto_key and str2.woo_auto_key=wo.woo_auto_key) “ORDER LOT”, (select stk.pn from stock stk where stk.stm_auto_key=ex.stm_auto_key) “CORE PN”, (select stk.serial_number from stock stk where stk.stm_auto_key=ex.stm_auto_key) “CORE SN”, (select cng.consignment_code from consignment_codes cng, stock stk where ex.stm_auto_key=stk.stm_auto_key and stk.cnc_auto_key=cng.cnc_auto_key) “CORE CSNG”, (select wo.si_number from wo_operation wo, stock stk, stock_reservations str where ex.stm_auto_key=stk.stm_auto_key and stk.stm_lot=str.stm_auto_key and str.woo_auto_key=wo.woo_auto_key) “CORE LOT”, ex.return_core_to_lot “RET CORE TO LOT”, (select pn.pn from parts_master pn where pn.pnm_auto_key=ex.pnm_auto_key) “EX PN”, ex.core_serial_number “CORE SN” from exchange ex
UNION select ‘SO’ “TRAN TYPE”, (case when ex.core_ret_date>to_date(‘1990/01/01:12:00:00AM’, ‘yyyy/mm/dd:hh:mi:ssam’) then ‘CLOSED’ else (case when ex.canceled_date>to_date(‘1990/01/01:12:00:00AM’, ‘yyyy/mm/dd:hh:mi:ssam’) then ‘CANCELED’ else ‘OPEN’ end) end) “STATUS”, ex.core_due_date “CORE DUE DT”, ex.core_ret_date “CORE RET DT”, ex.canceled_date “CANCELED DT”, ex.remarks “EX REMARKS”, (select cmp.company_name from companies cmp, so_header soh, so_detail sod where sod.sod_auto_key=ex.sod_auto_key and sod.soh_auto_key=soh.soh_auto_key and soh.cmp_auto_key=cmp.cmp_auto_key) “COMPANY”, (select soh.so_number from so_header soh, so_detail sod where sod.sod_auto_key=ex.sod_auto_key and sod.soh_auto_key=soh.soh_auto_key) “ORDER NUMBER”, (select sod.item_number from so_detail sod where sod.sod_auto_key=ex.sod_auto_key) “ORDER ITEM”, (select roh.ro_number from ro_header roh, ro_detail rod where rod.rod_auto_key=ex.rod_auto_key and rod.roh_auto_key=roh.roh_auto_key) “RO NUMBER”, (select rod.item_number from ro_detail rod where rod.rod_auto_key=ex.rod_auto_key) “RO ITEM”, (select pn.pn from parts_master pn, so_detail sod where sod.sod_auto_key=ex.sod_auto_key and sod.pnm_auto_key=pn.pnm_auto_key) “ORDER PN”, (select pn.description from parts_master pn, so_detail sod where sod.sod_auto_key=ex.sod_auto_key and sod.pnm_auto_key=pn.pnm_auto_key) “ORDER DESC”, (select stk.serial_number from stock stk where stk.stm_auto_key=(select max(stk2.stm_auto_key) from stock stk2,stock_reservations str,so_detail sod where ex.sod_auto_key=sod.sod_auto_key and sod.sod_auto_key=str.sod_auto_key and str.stm_auto_key=stk2.stm_auto_key)) “ORDER SN”, (select cng.consignment_code from stock stk,consignment_codes cng where stk.stm_auto_key=(select max(stk2.stm_auto_key) from stock stk2,stock_reservations str,so_detail sod where ex.sod_auto_key=sod.sod_auto_key and sod.sod_auto_key=str.sod_auto_key and str.stm_auto_key=stk2.stm_auto_key) and stk.cnc_auto_key=cng.cnc_auto_key) “ORDER CSNG”, (select wo.si_number from wo_operation wo, stock stk, stock_reservations str where stk.stm_auto_key=(select max(stk3.stm_auto_key) from stock stk3, stock_reservations str2, so_detail sod where ex.sod_auto_key=sod.sod_auto_key and str2.sod_auto_key=sod.sod_auto_key and stk3.stm_auto_key=str2.stm_auto_key) and stk.stm_lot=str.stm_auto_key and str.woo_auto_key=wo.woo_auto_key) “ORDER LOT”, (select stk.pn from stock stk where stk.stm_auto_key=ex.stm_auto_key) “CORE PN”, (select stk.serial_number from stock stk where stk.stm_auto_key=ex.stm_auto_key) “CORE SN”, (select cng.consignment_code from consignment_codes cng, stock stk where ex.stm_auto_key=stk.stm_auto_key and stk.cnc_auto_key=cng.cnc_auto_key) “CORE CSNG”, (select wo.si_number from wo_operation wo, stock stk, stock_reservations str where ex.stm_auto_key=stk.stm_auto_key and stk.stm_lot=str.stm_auto_key and str.woo_auto_key=wo.woo_auto_key) “CORE LOT”, ex.return_core_to_lot “RET CORE TO LOT”, (select pn.pn from parts_master pn where pn.pnm_auto_key=ex.pnm_auto_key) “EX PN”, ex.core_serial_number “CORE SN” from exchange ex UNION select ‘PO’ “TRAN TYPE”, (case when ex.core_ret_date>to_date(‘1990/01/01:12:00:00AM’, ‘yyyy/mm/dd:hh:mi:ssam’) then ‘CLOSED’ else (case when ex.canceled_date>to_date(‘1990/01/01:12:00:00AM’, ‘yyyy/mm/dd:hh:mi:ssam’) then ‘CANCELED’ else ‘OPEN’ end) end) “STATUS”, ex.core_due_date “CORE DUE DT”, ex.core_ret_date “CORE RET DT”, ex.canceled_date “CANCELED DT”, ex.remarks “EX REMARKS”, (select cmp.company_name from companies cmp, po_header poh, po_detail pod where pod.pod_auto_key=ex.pod_auto_key and pod.poh_auto_key=poh.poh_auto_key and poh.cmp_auto_key=cmp.cmp_auto_key) “COMPANY”, (select poh.po_number from po_header poh, po_detail pod where pod.pod_auto_key=ex.pod_auto_key and pod.poh_auto_key=poh.poh_auto_key) “ORDER NUMBER”, (select pod.item_number from po_detail pod where pod.pod_auto_key=ex.pod_auto_key) “ORDER ITEM”, (select roh.ro_number from ro_header roh, ro_detail rod where rod.rod_auto_key=ex.rod_auto_key and rod.roh_auto_key=roh.roh_auto_key) “RO NUMBER”, (select rod.item_number from ro_detail rod where rod.rod_auto_key=ex.rod_auto_key) “RO ITEM”, (select pn.pn from parts_master pn, po_detail pod where pod.pod_auto_key=ex.pod_auto_key and pod.pnm_auto_key=pn.pnm_auto_key) “ORDER PN”, (select pn.description from parts_master pn, po_detail pod where pod.pod_auto_key=ex.pod_auto_key and pod.pnm_auto_key=pn.pnm_auto_key) “ORDER DESC”, (select stk.serial_number from stock stk where stk.stm_auto_key=(select max(stk2.stm_auto_key) from stock stk2 where stk2.pod_auto_key=ex.pod_auto_key)) “ORDER SN”, (select cng.consignment_code from consignment_codes cng, stock stk where stk.stm_auto_key=(select max(stk2.stm_auto_key) from stock stk2 where stk2.pod_auto_key=ex.pod_auto_key) and stk.cnc_auto_key=cng.cnc_auto_key) “ORDER CSNG”, (select wo.si_number from wo_operation wo, stock stk, stock_reservations str2 where stk.stm_auto_key=(select max(stk2.stm_auto_key) from stock stk2 where stk2.pod_auto_key=ex.pod_auto_key) and stk.stm_lot=str2.stm_auto_key and str2.woo_auto_key=wo.woo_auto_key) “ORDER LOT”, (select stk.pn from stock stk where stk.stm_auto_key=ex.stm_auto_key) “CORE PN”, (select stk.serial_number from stock stk where stk.stm_auto_key=ex.stm_auto_key) “CORE SN”, (select cng.consignment_code from consignment_codes cng, stock stk where ex.stm_auto_key=stk.stm_auto_key and stk.cnc_auto_key=cng.cnc_auto_key) “CORE CSNG”, (select wo.si_number from wo_operation wo, stock stk, stock_reservations str where ex.stm_auto_key=stk.stm_auto_key and stk.stm_lot=str.stm_auto_key and str.woo_auto_key=wo.woo_auto_key) “CORE LOT”, ex.return_core_to_lot “RET CORE TO LOT”, (select pn.pn from parts_master pn where pn.pnm_auto_key=ex.pnm_auto_key) “EX PN”, ex.core_serial_number “CORE SN” from exchange ex
-
Advance QC is a consulting firm that offers custom applications, reports, training, etc.
-
When I upgraded to 10.7 I suddenly started getting errors for no licenses available. For my situation, it might be a little different. I have 2 live databases. Until 10.7 the licensees (I thought) were counted for each database. Now, they are collective. So, my 45 seats are now for both databases. AND.. they now count a license seat for each hand held unit that connects to the DB. So, immediately I was consuming as many as 5 seats with my barcode units. I was furious. I argued and argued. Nicola told me “its always been this way”. I told him of all the people to tell it has always been this way.. I am the last one. He refused to acknowledge that CC has changed the way they read licenses. Oddly enough, he gave me a beta tool that shows all of the license connections. It is pretty nice. However, why was this tool suddenly built if they changed nothing?
Anyway, it just made me so furious. I ended up having to buy barcode licenses so they would not use up my regular user seats.
-
For things like that you might use contact management or create a company for your own company (sound air) and link them to that.
Sorry, no elegant solution here. I have tried to get CC to create work flow instruction type features but it fell on (as it often does) deaf ears.
-
I believe Advace QC has a bridge to that and other accounting packages.
-
I agree. We just upgraded and were forced to buy more licenses. Its a shame they continue to change the rules in the middle of the game.
-
When setting up an exchange on a sales order, the flag is on the item’s exchange tab. “Bill Core Charge”
This is a “sneaky” feature though as it buries the amount within the item. Only recently have they added a feature to break out the core charge amount into a separate line item.
-
We are on the Oracle platform.
-
All purchase management does is collect the requirements from the BOM, then item by item display the vendor quotes and allows you to “approve” them for purchase.
Then, on a second tab you can consolidate your items by vendor and create your purchase orders.
So, in my opinion it is functional and serves its purpose – but could be designed way better. It was definitely an afterthought later in the development of product.
It makes things easier to buy for a job, for sure – but you need to have good data in the system like any other modules.
-
We use the purchase management tools to manage purchasing for bill of materials on work orders.
Do you have specific questions?
-
I could be wrong, but I believe it only does that if the Bill Core Charge flag is set. You are billing the core charges up front?
-
There is not a feature for this that I am aware of.
We use multiple warehouses as well. What we did is change our location codes in the system to begin with the prefix for the location in each warehouse.
For example,
Eagan warehouse = all locations start with EG-
Brisbane = all locations start with AU
Tulsa = all locations start with TU
This way, we can more easily track stock transfers and quickly and easily separate the stock by warehouse just based on the location code. If we see a location code assigned to a warehouse that does not have the correct prefix, we immediately know there is a discrepancy.
This approach allows us to not have to remember all locations assigned to a warehouse, just the prefix. And, historical records are much more accurate.
Of course, we assigned the locations to the warehouses so we could not (in most cases) assign the wrong location case.
We did have to relabel the locations but it was worth it.
-
You can run a simple query in interactive SQL to get this data.
select pg.group_code,pn.pn, pn.description,ind.item_number,ind.route_code,ind.unit_cost,(ind.unit_cost* ind.qty_ship) “EXT COST”, ind.unit_price,(ind.unit_price*ind.qty_ship) “EXT PRICE”, ind.qty_ship,inh.invc_number,inh.post_date from
parts_master pn,
pn_groups pg,
invc_detail ind,
invc_header inh
where
pn.png_auto_key>=pg.png_auto_key and
ind.pnm_auto_key=pn.pnm_auto_key and
inh.inh_auto_key=ind.inh_auto_key and
pg.group_code in (‘1124’) and
inh.post_date > To_Date(’01 12014′,’mmddyyyy’)
You can put all of the group codes you want encased in “” marks, sperated by a comma inside the ()
You can also put your own start date there.
If you want to a Part Number pattern instead of the group code you can replaced the line pg.group_code in (‘1124’) and
with
pn.pn like ‘%655%’ and
Where the % means anything before or after and 655 is the pattern.
-
The credit memos are handled completely differently than a regular invoice. You must create a sub report to pull those in, or duplicate many of your tables.
This assumes you want stock line data in the report. If you don’t care about pulling the stock line data, it becomes a lot easier.
As for the duplication, it is hard to say having to decipher the crystal reports generated sql.
Send me the report and I will take a look at it.
-
Be aware of bugs and changes here. If you use the customer quote module and roll your quote to sales, the due date will be inherited from the quote, and not recalculated.
Additionally, the use ship date option for core due date ONLY works if there is no due date already set, and the override due days setting ONLY applies to the use ship date setting.
Also, the invoice post date option ONLY works if not due date has been established. In other words, it will calculated the date only if you have not already calculated the date and put it in.
Versions prior to latest release of 10.7 also ignore the company due days override. This has now been fixed. Plus, they made it more clear that the override due days option is only applicable for the ship date.
So, in the latest release of 10.7 the following changes have been made
1. The SO will no longer get a core due date from the Quote. It now calculates the due date on its own.
2. The calculation of due date now properly references the company record due days first, then looks to the system wide due days if nothing is set in the company.
3. The override due days setting is now made clearer that it applies only to the use of the ship date from the shipping order module when calculating the due date.
.. Can it possibly be more confusing?
-
Avref integration works well. The cross reference information is based on the National Stock Number (NSN) system.
I do not believe it is based on any technical publications information, but I could be wrong.
The cross reference data and MFG pricing found on ILS and The Stock Market both come from Avref.
You can get NSN and government data for free through the defense logistics agency.
Not all parts are listed there, of course, but many are.
-
All of our freight costs are matched up automatically once the bill is received. We have developed tools that match inbound and outbound freight, charges and fees from all carriers back to the originating orders. It then separates these charges by department and sales person which is then is written to the appropriate buckets in QC. This is all done with little user interaction and is written directly into quantum.
All of that said, unfortunately, I cannot tell you how I came to solve this common issue as it is specific to Worthington.
The good new? It can be done. The bad news? You will have to figure it out on your own.
-
If I understand your question correctly…
The so_category_code is found on the item of a sales order
The field resides in the “so_category_code” table
It joins to the so_detail with the scc_auto_key
-
Click user->Interactive SQL
run the following sql statement
select
cmp.company_name,
cmp.company_abbrev,
cmp.company_code,
cmp.site_code,
tmc.term_code
from
companies cmp,
term_codes tmc
where
cmp.tmc_auto_key=tmc.tmc_auto_key and
tmc.term_code=’NET 30′
Or if you want to look for multiple term codes, use this SQL statement and put your own term codes in between the ‘ ‘ quotes.
select
cmp.company_name,
cmp.company_abbrev,
cmp.company_code,
cmp.site_code,
tmc.term_code
from
companies cmp,
term_codes tmc
where
cmp.tmc_auto_key=tmc.tmc_auto_key and
tmc.term_code in (‘NET 30′,’NET 30 DAYS’)
Then, click the floppy disk icon to save the results to a CSV file which you can open in Excel
-
You should be able to locate him in the user directory and email him from there.
It is under the members only menu
-
Ah, I see. My apology for the miss direction. I don’t know how the MFG module works (don’t use it) but I wonder if these are BOM items, could they instead be turned in then put on a scrap stock issue.
Or, if they are end item scraps, can be turned in, allowing the cost to hit COS but then put on a scrap stock issue to be relieved from inventory and use the distribution code to offset the COS entry..
Just thinking outside the box without a full understanding of things.
-
Physical Inventory and Inventory Shortages addresses how to handle scraping, shortages, overages, etc.
-
Jeff everything you need to know about scrapping, inventory audits etc can be found in my past presentations found under the Members Only menu
-
Quantum allows for the alternate reservations, but they failed to accommodate the business process through it’s entirety.
there are alternate print options on nearly all outbound documents that allow you to select how the document shows the alternate part number. However, this is based on the custom pn selection in the so item detail and not (to the best of my knowledge) based on the item reserved. I do not know (without testing) if the customer pn field gets updated if an alternate is chosen.
In order to incorporate stops in the process which will alert a user to this scenario my best suggestion is to use pop up alerts in the documents that are printed which warn the user of the situation. You can also incorporate statements that appear on your pick ticket, for example, that print when this situation is present which would alert the warehouse to it as well.
-
I spoke with Nicola on this as we are testing 10.7 now.
He acknowledged an issue with the document imaging. Apparently they had to switch it over to new integrated technology because of licensing issues with the previous vendor. that said, it does perform differently. He said it will NOT work with ISIS drivers, only WIA or Twain drivers, so be aware of that. Secondly, he did acknowledge there were issues with the size of the images but this has been addressed in newer releases of 10.7
So, in short upgrade again!
-
I believe your issue is that you are using all inner joins. Therefore, only records with the values assigned in all fields linked will be shown.
A simple layout is as follows
so_detail.sod_auto_key left outer join to stock_reservations.sod_auto_key
Stock_reservations.stm_auto_key left outer join to stock.stm_auto_key
stock.cnc_auto_key left outer join to consignment_codes.cnc_auto_key
stock.stc_auto_key left outer join to stock_category_codes.stc_auto_key
-
I am unable find anything in contact management that is called classifications. Perhaps it is something in a newer version? Can elaborate on it more?
-
The difference is not relative to the user interface. If your question refers to the use of and access to the database, it is 6 of one and half a dozen of the other. The field names are the same in both databases.
You will find more features and fixes in the Oracle DB as CC has slowly reduced the development activity in Firebird.
The user interface in QC is not much different other than to accommodate some functionality not found in the Firebird DB.
John Boyce at Ansett is a great resource for this question. They used Firebird for a very long time and only in the last couple years converted to Oracle.
-
Yes that is correct. Tricerat has recently come out with a competing product. They actually contacted me and requested I beta the product before they released it. I declined as they were not willing to concede to a license for it and their functionality did not meet the needs. They only allow for one device whereas Remote Scan can have multiple devices in use such as a camera and scanner.
-
select
wo.si_number,
pn.pn,
pn.description,
stk.stock_line
from
stock stk,
stock_reservations str,
wo_operation wo,
parts_master pn
where
stk.stm_lot=str.stm_auto_key and
str.woo_auto_key=wo.woo_auto_key and
stk.pnm_auto_key=pn.pnm_auto_key
-
Customer owned stock is identified by the flag on the stock line called “customer_owned” this Boolean field is set to ‘T’ if it is a brokered repair, or removed from a work order.
Brokered repairs can be identified using the so_detail field called route_code. Route_Code is set to ‘I’ if it is a brokered repair.
The link from the RO back to the SO is done through the stock_reservations table.
ro_detail->stock_reservations->so_detail
you can also link back to it via the ro_detail->so_detail via the sod auto key
Either way, if you are just trying to identify customer owned stock, you can get that by going ro_detail->stock_reservations->stock -> customer_owned T/F
-
This is an old feature for users to define their own menus.
This became obsolete when the new menu system was launched in qc which allows you to create your own menus.
-
Good question. We had a similar problem, so we had CC write us a program (a long time ago) that actually used Avref to match up the PNs and AC types.
That said, it ended up being a bit of a mess in the long run.
The OCDIA would be the tool to use to import something like that. You will need to match your AC type to the PN in the import data. It should not be too hard of a script to write.
If it were me, I would just write it in Excel so that it could be used by anyone in the future.
CC will do a custom import for you but you will probably save a lot of money using someone like Advance QC to write something for you. Sorry CC…
-
You need to use the Secondary Applications table found in the Global menu. When records are present, this will make an aircraft icon appear in the icon tray in the part master record.
This same feature is available from the companies table in the global menu, only its called just Application codes
-
I haven’t tested if there is a way to do the require inspection AND import the list.
Might be worth a try though.
-
The link is from vq_detail to po_detail
vq_detail.pod_auto_key=po_detail.pod_auto_key