JSHOEMAKE
Forum Replies Created
-
Thank you Mike
-
What we do in this situation or any time we have an External WO with multiple qty and partial scrap is to create a sub WO for the scrap units. This will allow you to return or scrap locally and keep the remaining qty on the original WO.
-
I’d be interested (jshoemake@icrr255x.com)
-
For Shop Control, WO templates with large BOM. Add the ability to import a list of BOM like you can from the WO Parts management screen but with option to flag as deferred or not.
-
I have attempted to update the information as described and am getting no errors when compiling. However when I go to preview I receive the following messages.
var
qc : TOracleDataset;
begin
Text:=”;
qc := TOracleDataset.Create(nil);
qc.SetSession;
qc.Sql.text := ‘Select STOCK.STOCK_LINE from STOCK where stm_AUTO_KEY = ‘+ REC_STOCK[‘stm_AUTO_KEY’] inner join ‘ +
‘PO_DETAIL on STOCK.POD_AUTO_KEY = PO_DETAIL.POD_AUTO_KEY ‘ +
‘where PO_DETAIL.POD_AUTO_KEY = ‘+ REC_STOCK[‘POD_AUTO_KEY’];
qc.Open;
IF not qc.eof then
Begin
Text := qc.FieldByName[‘STOCK_LINE’].AsString;
end;
qc.Free;
end;
-
John,
We utilize an app for Quickbooks online for Bulk Import by SaasAnt for importing invoices. You can do a download of your invoices for a date range in Quantum and use the app to upload into Quickbooks. It has worked really well for us.
-
Mike,
The issue I have had is one line item but multiple stock lines will be received either due to SN or different batch/lot numbers for consumables.
For example: If I order 3 tubes of adhesive and each has a different lot/batch number then when receiving, 3 tags are printed with correct information except the SL# is the same on each tag printed. I am having to go to each stock line and reprint a barcode label to reflect correct SL# when this occurs.
-
Greg,
Thank you 🙌. It worked perfectly.
-
Thank you Mike and Pietro.
-
Katy,
We too have been working in the integration/setup for quite some time, before November for us. We have had AEX and CC on conference calls etc. to try and get it worked out. There seems to limited resources and people who know how it works. Very frustrating so far.
-
Mike,
SELECT “WO_OPERATION”.”COMPANY_REF_NUMBER”, “WO_OPERATION”.”DUE_DATE”, “WO_OPERATION”.”SI_NUMBER”, “WO_STATUS”.”DESCRIPTION”, “WO_STATUS”.”STATUS_TYPE”, “WO_OPERATION”.”ENTRY_DATE”, “WO_OPERATION”.”BILL_NAME”, “SM_HEADER”.”TRACKING_NUMBER”, “WO_OPERATION”.”CLOSE_DATE”, “WO_OPERATION”.”WO_UDF_003″
FROM (“QCTL”.”SM_HEADER” “SM_HEADER” LEFT OUTER JOIN “QCTL”.”WO_OPERATION” “WO_OPERATION” ON “SM_HEADER”.”WOO_AUTO_KEY”=”WO_OPERATION”.”WOO_AUTO_KEY”) INNER JOIN “QCTL”.”WO_STATUS” “WO_STATUS” ON “WO_OPERATION”.”WOS_AUTO_KEY”=”WO_STATUS”.”WOS_AUTO_KEY”
WHERE “WO_OPERATION”.”BILL_NAME”=’International Component Repair’ AND (“WO_OPERATION”.”ENTRY_DATE”>=TO_DATE (’21-02-2021 00:00:00′, ‘DD-MM-YYYY HH24:MI:SS’) AND “WO_OPERATION”.”ENTRY_DATE”<="" p="">
ORDER BY “WO_OPERATION”.”DUE_DATE”
-
Thanks Mike! I have attempted several different methods and all seem to yield the same results. It seems for the tracking number to display the WO must be in a released state which doesn’t display any open orders.
Do you have any other suggestions or work arounds?
-
Mike & Warren,
Thank you for your replies.
-
Nadim
Thank you for the information. Profit browse provided exactly what I was looking for.
As for the pricing matrix and billing groups, I am unfamiliar with how these work. I have tested in the training database, but do not see how it functions. Is the pricing created in the matrix meant to push/pull to a WO quote?
-
I have had no luck on this one. I have tried multiple different methods.
-
Thank you Rolando and Jake.
-
I am curious about this as well. This would help a lot.
-
I would like to get a copy of this report as well.
-
Norm,
We have contacted CC regarding the syncing to QB online. However at this time it is not a priority item for the development team and first estimates would cost us at least 8k for CC to develop online QB sync/bridge.
I would like to see if there is interest from users to help push CC to develop the bridge/sync abilities with quick books online.
-
Ok. Thank you. We don’t utilize the accounting module so I was primarily just wanting to correct the customer. I can always print to PDF and update the PDF document.
-
Jim,
We split the SL of the main component to represent the quantity of good versus bad. We then Global – batch options- build sub WO and select the SL for the sub WO. We can scrap the units locally and or return as unserviceable to the customer.
We determine the serviceability at receiving inspection and at that point there is not a lot of cost associated to the WO or sub WO. If the unserviceable units incur any charges such as scrap fee etc., we build a quote from the sub-WO and close/create billing from there. The original WO will be processed as normal and quote/billing for the remaining items.
-
Mike,
I could use the help trying to figure this out. I have looked several times where the invoice brings in the BOM from the WO and I can’t seem to find where that is as that is what I am trying to limit from pulling to the invoice.
-
Pietro,
Unfortunately there is not a switch for showing the BOM or not. The only way I have is to limit the line item numbers allowed on the document but I have to change at each occurrence. I do not see where the BOM is being pulled onto the invoice. The quote lists all the separate WOs without the BOM but when it pulls to the invoice all of the BOM come along as well.