janderson
Forum Replies Created
-
Rick we had a number on contractors over the years. What i have now done is i have 50 contractors generic username (Contaractor01, Contractor02,ect…) We don’t use T&A but should be able to do the same. They never log into Quantum just scan the badge they got. We have had 4 different contracting companies at the same time. I just Tell account badge number 1-10 is for ABC Company and 11-20 is for XYZ Company. I have a labor report accounting can look back to see all the hours applied to the work orders matches the Invoice.
-
Maybe you could try adding a condition code of Expired and setup a script to run in event manager that looks to see if the EXP date past then update update the stock table with the new code.
-
Also I use TSPrint this works way better then the RDP redirect.
-
I just checked mine and every PO I look at comes up in line item order. I went to the PO then clicked global – differed receiver. I am on V12.2.10. But as you stated i can not sort it at all.
-
You can also use the number log in global settings. Create a WO Log for each stream.
-
Also we use it for labor tracking.
-
Why should I pay for API to access my files that I accessed the same way for the last 15 years? I pay my SMA Its my server its my data. Time to get on the phone.
-
There are 3 Scans required. User ID, Skill and Task. Since we only have one skill I print it on their badge. If you have many skills I would print them on a reference sheet and laminate it and post at each station but note if the skill is not assigned to the user they can not scan into the job.
-
I talk with our CFO and she said that you should be able to go to the check and move it back to open or clear as you said.
-
I have found i needed to check this box since for what ever reason some computers couldn’t open PDFs inside of Quantum.
-
Is the bank rec still open? And are the batches posted?
-
When you go through the wizard make sure you select return to stock and this will move it to inventory. If you do not it will stay in FG Look at the screen shots below i think you selected reconcile MC.
-
Not that i am aware of.. I ran this and like you said it does not have “Every Thing”
SELECT * FROM AUDIT_TRAIL WHERE SOURCE_TABLE = ‘WOO’ AND
SOURCE_AK = 247571
-
Warren Coykendall wrote:
Or you could update the trigger and throw an error if the sysur_auto_key is blah and the total is over X. That way Oracle will prevent it from happening.
If you do this after upgrades and maybe even patches you will have to change it back again.
-
Warren there is no Labor on Stock Issues just Many piece parts to make 1 kit part.
As far as how costing is applied in all my testing i come up with the correct number as the sum of the actual costs of the stock lines from the piece parts = the unit cost of the kit. I would need to know what fields you are looking at.
Also did you do a partial build say you have 10 kits and needed to build 4 now and 6 later?
-
Did you try the Export Balance Sheet to Excel. You can remove the accounts but will have to write formulas to redo the calcs. Or you could rebuild in Crystal.
-
This should get you there. Just change the red date to the date range you want.
SELECT PN,SOD.ENTRY_DATE, COUNT(SOD.SOD_AUTO_KEY) AS “SO LINE ITEMS”
FROM SO_DETAIL SOD, PARTS_MASTER PNM
WHERE SOD.PNM_AUTO_KEY = PNM.PNM_AUTO_KEY AND
SOD.ENTRY_DATE >= TO_DATE(’01/01/2021′,’DD/MM/YYYY’)
GROUP BY PN ,SOD.ENTRY_DATE
-
Glad you found the Leak. We ran into a similar issue with the WO search header if you typed anything into the Company Ref field it would crash. They have since patched it.
-
Can you take a screen shot of the field or fields you are looking for?
-
Thanks guys that’s kind of what I figured it was for.
-
John, Finally got around to testing this. How are the payments handled i see the cons. View that will show me all my history but how do I know what i paid vs what I still owe?
-
Mike,
This will get you to the security table for the report. Will this work?
SELECT *
FROM CR_ITEM CRI,CRYSTAL_USERS CU, SYS_USERS SYS
WHERE CRI.CRI_AUTO_KEY = CU.CRI_AUTO_KEY AND
CU.SYSUR_AUTO_KEY = SYS.SYSUR_AUTO_KEY AND
CRI_AUTO_KEY = XXX
-
I just changed it to 2021 and works fine…….. Maybe you deleted ” ‘ ” or a ,
SELECT soh.entry_date,
soh.so_number,
cmp.company_code,
cmp.company_name,
COC.COUNTRY_NAME,
NVL(spn.salesperson_name,’_’) sales_team,
CUR.CURRENCY_CODE CURRENCY,
su.first_name
|| ‘ ‘
|| su.last_name employee,
soh.company_ref_number cust_po,
sod.route_code,
stm.stock_line,
stm.SERIAL_NUMBER,
pcc.condition_code,
pnm.PN,
pnm.description,
SOD.QTY_ORDERED,
sod.qty_invoiced,
sod.QTY_ORDERED * sod.CUSTOMER_PRICE tOTAL,
CNC.CONSIGNMENT_CODE STOCK_CONSIGNMENT,
roh.ro_number,
LoC.LOCATION_CODE,
Whs.WAREHOUSE_CODE,
SOS.STATUS_CODE SALES_ORDER_STATUS,
CQH.CQ_NUMBER,
CQH.ENTRY_DATE CQH_DATE,
RCH.RC_NUMBER,
INH.POST_dATE,
INH.INVC_NUMBER,
(SELECT DISTINCT POH.PO_NUMBER
FROM PO_HEADER POH,
PO_DETAIL POD,
PURCHASE_SALES PUS
WHERE POH.POH_AUTO_KEY=POD.POH_AUTO_KEY
AND SOD.SOD_AUTO_KEY =PUS.SOD_AUTO_KEY
AND PUS.POD_AUTO_KEY =POD.POD_AUTO_KEY
) PO_NUMBER
FROM SO_HEADER soh,
SO_DETAIL sod,
PARTS_MASTER pnm,
SALESPERSON spn,
AGENTS AGN,
WAREHOUSE Whs,
sys_users su,
LOCATION Loc,
companies cmp,
ro_header roh,
ro_detail rod,
STOCK stm,
stock_reservations str,
part_condition_codes pcc,
CONSIGNMENT_CODES CNC,
COUNTRY_CODES COC,
CURRENCY CUR,
SO_STATUS SOS,
CQ_HEADER CQH,
CQ_DETAIL CQD,
RC_DETAIL RCD,
RC_HEADER RCH,
EXCHANGE EXC,
INVC_HEADER INH,
invc_detail IND
WHERE cmp.cmp_auto_key(+)=soh.cmp_auto_key
AND soh.soh_auto_key(+)=sod.soh_auto_key
AND AGN.AGN_AUTO_KEY(+)=SOH.AGN_AUTO_KEY
AND spn.spn_auto_key(+)=soh.SPN_AUTO_KEY
AND COC.COC_AUTO_KEY(+)=CMP.COC_AUTO_KEY
AND CUR.CUR_AUTO_KEY(+)=SOH.CUR_AUTO_KEY
AND su.sysur_auto_key(+)=soh.sysur_auto_key
AND pcc.pcc_auto_key(+)=stm.pcc_auto_key
AND pnm.pnm_auto_key(+)=sod.pnm_auto_key
AND CNC.CNC_aUTO_KEY(+)=STM.CNC_AUTO_KEY
AND LoC.LOC_AUTO_KEY(+)=Stm.LOC_AUTO_KEY
AND Whs.WHS_AUTO_KEY(+)=Stm.WHS_AUTO_KEY
AND rod.sod_auto_key(+)=sod.sOd_AUTO_KEY
AND roh.ROH_AUTO_KEY(+)=rod.ROH_AUTO_KEY
AND stm.stm_auto_key(+)=str.STM_AUTO_KEY
AND str.sod_AUTO_KEY(+)=sod.sod_auto_key
AND SOS.SOS_AUTO_KEY(+)=soh.SOS_AUTO_KEY
AND cqd.cqd_auto_key(+)=sod.cqd_auto_key
AND cqh.cqh_auto_key(+)=cqd.cqh_auto_key
AND RCD.SOD_AUTO_KEY(+)=SOD.SOD_AUTO_KEY
AND RCH.RCH_AUTO_KEY(+)=RCD.RCH_AUTO_KEY
AND EXC.SOD_AUTO_KEY(+)=sod.SOD_AUTO_KEY
AND SOD.sod_auto_key(+)=IND.sod_auto_key
AND INH.INh_auto_key(+)=IND.INh_auto_key
AND TRUNC(soh.entry_date) >= TRUNC(to_date(’01/01/2021′,’mm/dd/yyyy’))
-
John thank you for the response. This is MFG part and not from stock does that matter I’ve never used the consignment function before.
-
Nate we have everyone use their bar coded ID cards and us the Generic BC to record labor.
-
If you download a program like Toad it will show you all the tables and fields. I have a very old copy in Excel if you want me to send it over.
-
Maybe add all the images and hide them to the section you want and then based on a parameter show based the input. Also if its based on who created the record or assigned to it you could use the user id as a trigger as well to show the correct one. Just some thought.
-
On the Stock Line you can put a check in the Hold line option. This will still show in your available and OH inventory levels but you will not be able to issue to and Jobs or orders. I am on 10.9 i don’t know if in a later version they adjusted the available QTY then this is checked.
-
Tony,
I would be careful on a SQL statement to update the archive flag. Since you might archive the wrong one.
Did you just import the PNs or both Stock and PN?
If it is just PNs and not stock i would copy live to test. I would run a query to pull all PNs and find the ones that were added by mistake(using excel and some vlookups or index matching). Then i would grab all those PNM_auto_keys and use those in the Where clause and set the flag based on that. I don’t know the fields that would need to be updated off the top of my head. Doing this is test to make sure nothing goes sideways since direct updates can cause unforeseen issues and is not normally recommened.
If you have stock that would be more complex and has GL impacts so i would recommend using the PN merge tool.
Do you not have the flag set to PN must be unique or maybe it says do not allow duplicates checked? Did you import the PNs using import feature in Quantum?
-
If linking with tables you need to use wo_STM_complete as link table to the stock table, Not sure on the RO side (don’t use them) where they go for closed orders.
-
I don’t recall if i had this created or it came with Quantum. But i have a OCDIA import script that brings in just Location Code and Description. If you don’t have one in your environment i would reach out to CC or someone to write you one. Note the one i have only brings the Locations in you still need to assign to a warehouse.
-
I have no Themes in this Schema where i don’t see this. Since this a mainly a MFG schema i am not going to worry about it and just write the instructions to create the WO and go to global edit header and fill in the the modify to PN field.
-
Is there a Unit cost on the stock line? If there is not the system will not make any GL entries.
-
Jake Anderson wrote:
We have a few schemas and in this particular one we we not going to use shop control since its a heavy manufacturing company. But i got a case where i need to make a PN into a different PN. We do this all the time in our other databases using the modifed PN field but it is not there… I have looked all over and can not find where to “Turn” it on. I have screen editor and i checked show hidden and suppress customization. Any one have any thoughts?
I Tried that It looks to be theme related.
-
I think its a Theme on the older database. But i can change in the header that will work for now this is a one off thing anyways. Thank You.
-
Its in the company management Setup. User > System Setup> Companies.
-
Jeff,
What we both posted will update the Stock Table (The stock Lines). you would need a separate statement to update the master parts table with a default stock location is you want that as well.
UPDATE STOCK
SET LOC_AUTO_KEY =
CASE WHEN PN = ‘XXX’ THEN ‘XX’
CASE WHEN PN = ‘ZZZ’ THEN ‘ZZ’
ELSE ‘0’ END
WHERE PN IN (‘XXX’,’ZZ’) and QTY OH >0
-
If that’s the case i would build a Excel file with all my PN in column a and the new location in column b do a textjoin to build out the case statement and where statement. Should look something like this.
UPDATE STOCK
SET LOC_AUTO_KEY =
CASE WHEN PN = ‘XXX’ THEN ‘XX’
CASE WHEN PN = ‘ZZZ’ THEN ‘ZZ’
ELSE ‘0’ END
WHERE PN IN (‘XXX’,’ZZ’) and QTY OH >0
As always do this in test first and test your inventory reports and do some stock transactions to make sure you don’t get any errors.
-
Do you need to change the GL account as well or just the location code? If you don’t it could just be a quick update statement to the Stock table. is this all PNs of XXX,XXX with QTY_OH >0 no matter the stockline?
-
We had CC build us a OCDIA import for MFG templates. I believe these use the same tables for WO and MO Templates / Work Plans. I don’t think it would take much for CC to make you one.
-
As Mike said its a scanner configuration most scan guns come with a configuration book. If they are lost most times they can be found on the support page of the manufacturer.
-
We scan in all our paperwork into Quantum and we use image codes for document types. (RO/PO/WO/MO ECT…) I have created reports from the image lists to get the image file linked and if there is no file or a file without the code we are looking for we flag it in the report and whom ever is responsible for those records needs to go back and fix the records. I have also created a crystal report that you can click on the hyperlink and i have the hyperlink calculated to the file name on the image server. The user does need to have access to view the image folder on the server you would need to be careful on how you deploy that.
In Summary you can create reports that you can tell what files are linked to each module (SO/PO/WO/RC/RO ECT..) easily and just need to create what criteria you are looking for. What has helped us with our paper work is doing Audits on the required paperwork not only if there is a file but also looking at the file its self to make sure it is the correct document. If you have not liked the Image list in crystal before it is alittle tricky and if you need help let me know.
-
Also don’t SUM the QTY_OH from the Stock table i would just take the field QTY_OH from the parts master. Since if you have 2 reservations of a stock line with a qty_oh of 10 you will return a value of 20.
Also what are you saying is off…. is it the QTYs? or something else?
-
We have not started yet. But we are going to use CC to help with this since we do not have extra segments in our accounting setup. We are targeting the end of Q1 to do the first database and i will share how it went and what hurdles we had to over come.
-
I just tried this in test and it looks like its trying to take the piece parts from stock and not adding them into stock.
-
You are missing the link table.
Project Header needs to link to Project Links on the PJH_UTO_KEY
PJT link table you link the CQ_Header on the PJL_auto_key = CQH_auto_key
Then link the companies table from the CQ Header on the CMP Auto Key.
Then do a record select on the Project_links.order_type = ‘CQ’
This should get you going down the right path.
-
Is the performance better then RDP? Also do you run into hidden windows?
-
What are you looking to see? Do you use Sales orders for just part sales and or MFG and WO orders as well? I have a number different reports. Shoot me an email.
-
This is could be a process change for your AP department. When they do the deferred receiving when they get the invoice they need to look at the location of the stock line. If it is in quarantine they check the box on the AP header for Hold payment. Then you can create a automated report and send it to AP department for all AP’s that if hold payment is ‘T’ and the location <> quarantine then they can go back and clear them. You could also make a script to do this both for the flag and the clearing of the flag and have it run every X hours or mins.
-
You could also use receive the item into the system as normal but put the non conforming parts into a quarantine location or warehouse and put a hold on the stock line. You could also put that warehouse in a GEO code that limited people have access to to ensure the parts don’t get accidentally used. If you are worried about accounting paying for items you could put a hold on the AP record.