it
Forum Replies Created
-
I haven’t see this but it means you have a formula somewhere that is trying to be divided by zero. At what point in the process is this coming up?
-
We use the reply date field in the header. I have, however, change the label of that field to ACK Date in my system. You could also use other date fields to confirm acknowledgment. Then, you could create reports that automatically send messages to the vendor requesting acknowledgment if the specified date field has not been filled in.
-
Scott, for the PO_DETAIL table, there is no such field. What you see on the screens is achieved via a formula.
You can create a formula in Crystal called Open_Flag and using the following code
if {PO_DETAIL.QTY_ORDERED}>0 then
(
if {PO_DETAIL.QTY_ORDERED}>{PO_DETAIL.QTY_REC} then
ToText(‘Open’)
else if {PO_DETAIL.QTY_ORDERED}={PO_DETAIL.QTY_REC} then
ToText(‘Closed’)
else if {PO_DETAIL.QTY_REC}> {PO_DETAIL.QTY_ORDERED} then
ToText(‘Error’)
)
else if {PO_DETAIL.QTY_ORDERED}=0 then
ToText(‘Canceled’)
else if {PO_DETAIL.QTY_ORDERED}<0 then
ToText(‘Credit’)
else
ToText(‘Error’)
Then, you can apply filters in your report to filter on Open_Flag based on the outputs defined above.
-
Lydia, the only way you can accomplish is to modify your documents to pull that data in. Or, pay component control to do it.
The Delivery Terms table is the table meant for the INCO terms, so you are on the right track. That FOB field is actually a remnant from the Quick Quote days.
-
Component Control is migrating all forms and reports to Crystal Reports. Although, I think this is a good idea, I believe it would be a bit behind the curve as you can now create and modify most of their documents and reports in Crystal.
If there was enough interest still, perhaps you could coordinate it to happen around the same time as the annual conference.
-
This could be done, fairly quickly, with an SQL statement that is opened in an excel spreadsheet.
I think the key here will be comparing the datetime of the add bom with the release date time. This assumes you would use the release of the work order to indicate it is accepted by the customer and work is authorized.
Shouldn’t be too hard to do. We automated a notice for any BOM added to a job after it has been released. This helps manage out of scope activities.
-
It works with shop control, so it should work with AC Maint.
I suggest you do some testing on the various settings and see what you can find.
-
There are system settings that will check and block transactions if the order exceeds credit limit.
The check can occur when going from Qte to SO, SO to Shipment, SO to PO and/or SO to Invoice.
Settings are found in Quote Module settings and Sales Orders settings . The validate credit before creating invoice applies to shipments as well. If you use Work Orders, you can have that validated too and that setting is found in Inventory settings I believe.
Lastly, the only thing that can override the credit check is the terms. So, you want prepayments to bypass the credit check, you will
Need to set up your term codes properly.
-
Felix, most of the companies using a web portal, that I am aware of, use either their own home grow application, the QC Web Portal or the QC Stock Market.
We have been using the web portal for a while. Your requirements are not far off from what the web portal capabilities are today.
-
FYI – we are using the receiving inspection module for receiving.
-
Our MRO facility has the same requirement. Basically, the PO number ties back to the stock line, which in turn ties to the lot number. The lot number is recorded in the MFG Lot # field on the stock line.
At the end of the job, we print out a crystal report that shows all BOM items that were issued to the job, but also removed from the job so that true consumption is recorded. This “reconciliation” report shows that lot number and PO number. We have also modified our pick ticket and traveler to show this lot number.
If you are using the barcode unit to add, reserve and issue your stock, the display of the lot number in the stock reservations screen becomes less of an issue because you are looking at the documentation that contains that data when you pull it. Just a thought.
-
If the vendor invoice hasn’t been posted, you should be able to void the receiving.
-
Dave, it is easier if you use the lot_costing_log table
You should be able to apply a final filter for your lot number and get what you need with this.
select
lt.si_number “LOT”,
inh.invc_number “INVC NUM”,
pn.pn “PN”,
pn.description “DESC”,
ind.item_number “ITEM NUM”,
ind.qty_ship “QTY SHIP”,
ind.route_code “RTE CODE”,
ind.unit_price “IND U.PRICE”,
ind.unit_cost “IND U.COST”,
ind.unit_price*ind.qty_ship “EXT PRICE”,
ind.unit_cost*ind.qty_ship “EXT COST”,
(ind.unit_price*ind.qty_ship)-(ind.unit_cost*ind.qty_ship) “EXT GP”,
lcl.log_value “PRICE”,
(select max(lcl2.log_value) from lot_costing_log lcl2 where lcl2.ind_auto_key=ind.ind_auto_key and lcl2.log_type=’costreal’)”COSTREAL”,
(select max(lcl2.log_value) from lot_costing_log lcl2 where lcl2.ind_auto_key=ind.ind_auto_key and lcl2.log_type=’cncamnt’)”CNC_PROCEEDS”,
(select distinct(cn.consignment_code) from consignment_codes cn, lot_costing_log lcl2 where lcl2.ind_auto_key=ind.ind_auto_key and lcl2.cnc_auto_key=cn.cnc_auto_key and lcl2.log_type=’cnc’)”CNC”,
lcl.entry_date “E.DATE”,
ind.ship_date “INVC DATE”
from
parts_master pn,
invc_detail ind,
invc_header inh,
lot_costing_log lcl,
wo_operation lt,
stock_reservations str
where
lcl.ind_auto_key=ind.ind_auto_key and
ind.inh_auto_key=inh.inh_auto_key and
lcl.stm_lot=str.stm_auto_key and
lt.woo_auto_key=str.woo_auto_key and
pn.pnm_auto_key=ind.pnm_auto_key and
log_type=’price’
-
Repair Order -> Repair Items -> Delete
You may also need to grant
Repair Order -> Repair Items -> Piece Parts -> Delete
As well as
Inventory Management -> Inventory Functions -> Reservations -> Repair Orders -> Delete
-
Tony, one of the reasons the RO doesn’t show the total in the RO fields is because that is the number that drives the vendor invoice and onto the payable.
I would like to see a new field in the line item indicating the cost, as well as in the header that sums the piece parts cost.
I could do this with screen scripts but haven’t gotten to it.
One thing you might consider is creating a report, as we did, that shows all repair orders, and purchase orders, that have been closed, but have open piece parts. When I first did this years ago, I discovered a mess of unissued piece parts.
Later, after our consignments expanded and we did more ROs for consigned parts, I discovered we needed to manage the usage of piece parts better in that we could be using our own inventory against a consigned repair, or use consigned inventory against our own inventory. There are no constraints to stock this activity. And, depending on your contracts could cause problems. Especially if the piece parts are high dollar.
In short, we solved the whole piece parts management issue with a couple of automated reports as Nick has.
-
Sounds like you need to use the barcode module for starters. You could approach this in a couple of ways.
1. Requestor adds new BOM requirement. System monitors new additions and sends notice to stores. Notice could be a pick ticket. Stores picks parts and when ready reserves the part to the BOM. System monitors new reservations, sends notice to requestor.
The stores clerk could use the barcode unit to very easily and quickly scan the items to the job
2. Requestor goes to stores with their QC generated employee badge and Job Card with WO Task barcode number on it and requests part. Stores person does a quick look up in system, if in stock picks the part. Once in hand scans the task BC, scans the stock BC, scans the employee badge and the part gets reserved against the job and is recorded as being given to that employee.
We use a hybrid approach at our MRO where we have initial static job and traveler, then use NCR non routine forms. Parts are issued at the beginning of the job, and when NR’s are found, those are handed into production for entry. system notified stores and purchasing of newly added BOMs. Parts are ordered or pulled, then given the mechanic.
-
Please describe the current process, even if it is a manual one.
-
Wesley this needs to be reported to CC. That error was written by me, back when I worked at CC over a decade ago. The term Access Violation means that QC tried to access a segment of memory to perform a function, and that segment wasn’t there – probably already released.
Try increasing your page file size, and if you are running a lot of other applications, or have a bunch of windows open this might effect performance as well. Sometimes it is related to bad coding, but often times it is that machine not being able to keep up with the user and QC “trips over itself” trying to keep up. If this is persistent on other workstations, then it points more to bad coding. If it is something on your workstation mostly, then it points to your hardware, or other programs using too many resources on your machine.
-
We don’t have the MFG module, but I believe many of the settings relating to this module are also applicable to the Work Order module. With that said, there is a setting to allow charge codes to be added without creating the PO.
Perhaps this applies to the MFG module as well, and if so, may help you address that issue.
-
There are many things that can contribute to imbalances. Sometimes they are settings, sometimes they are bugs. I know there have been bugs relating to core cost calculations, invoice costs, lot calculations, consignment calculations and PO exchanges as well as returning core cost allocations.
All of which could have an impact on inventory numbers.
I have emailed you about 17 reports that I have used for research in correcting these various bugs. THey will have to modified, most likely, to suit your DB and possibly calculation percentages especially if you use Flat Rate exchanges.
-
Can you tell me what the account number structure is for your inventory? How many accounts do you have?
Do you do exchanges?
-
There is always more to this meets the eye. Can you outline a few things first?
1. If you do a manual sum of stock qty * unit cost does it total to your inventory only GL records?
2. Have you removed all manual entries to the inventory only accounts?
3. Are you reconciling only the inventory accounts, or also including things like the awaiting core, inventory adjustments, etc. in your GL number?
-
Anyone have comments on this?
-
This is how you get the user name of the current user logged into the system.
procedure FormShow(Sender: TObject);
var
q: TOracleDataset;
begin
q := TOracleDataset.Create(nil);
q.Session := Form.OCSession;
// Get the current user who is logged in.
q.Sql.Text:=’select QC_SC_PKG.GET_USER_NAME from dual’;
q.Open;
X:= q.FieldByName(‘GET_USER_NAME’).AsString;
q.free;
End;
You should be able to use this vs. the auto key value.
-
Are you putting this code in the onbuttonclick area or the formshow area of the script editor?
-
Here is a reply from Nicola Hanna regarding this topic
Thank you for bringing this to our attention. After reviewing this thread, it looks like this issue can be resolved by having some method of preventing a shipping order from being created at the sales order level. We already have something in place that should suffice as a solution to this issue.
In our next version of Quantum (10.5), there is an option to include a check box on the sales order header that marks that sales order as “Released†for shipping. If you have this option checked in the SO Control settings, then the checkbox will be visible from the edit sales order header. If you try to create a shipping order from this sales order without the “Released†flag being checked, it will throw an error notifying the user that it will need to be released prior to creating a shipping order.
-
You may be able to change that if you have the forms designer. Honestly, for our shop we don’t use the work order document. The traveler is the primary document and all others are custom crystal reports.
-
Can you tell us what the print settings are for your work order document? Also, what is the disposition setting on the task that is not showing the issued parts?
Is it not showing the bom item at all, or just not the stock lines? If there are more than one stock line issued to the BOM, is showing any of the issued parts at all?
-
You can turn on the option to require barcode log in. This would force a user to scan their badge to log in before using the barcode unit.
Then use standard audit logs to track. I don’t think shipment status changes through barcode are logged though.
-
Eric, what is the purpose of knowing this? What is your objective?
-
The “variables” you see are just objects with a name starting with “var”, like a label. They are not actual vairbles. So, if you put a label on the form, remain it to varSample_Label you have done what you are talking about. Then, in Calc area, you open that object you can put code in for onPrint, onDraw, etc.
If you want to create an actual variable in the forms, this can be done like any other code, locally or globally.
To create a global variable, you initialize it in the REPORT object, usually in the BeforePrint area.
For local objects, that is done in the (for example) onPrint code of that object and is initialized in the VAR section of the code like this
procedure varShipViaAccOnGetText(var Text: String);
Var
qc: TQcDataset;
begin
-
I guess that depends on what the issue is. Are you looking to develop a program, hire someone, or are you getting audited and need legal advice?
Most companies train someone internally, like myself, on export compliance issues.
If you have specific questions, I can try to help
-
A similar requirement is necessary in heavy maintenance. The solution I have seen used for this is the sequence numbers. I don’t much about the MFG module, but I presume it is similar to AC maintenance in many ways. I would look into the task sequences where the top level task might be 1.0 and the subsequent tasks would be 1.1, 1.2, etc.
Also, check and see if the advanced work order task sequencing options apply to this module as well. They allow for fairly advanced work order layout from that perspective.
-
There are ways to do this with the shipping order module. It has a hold functionality. If you combine this with the event manager you could write sripts that place shipments on hold or remove from hold based on conditions being met.
Then, you could build a simple dashboard in crystal similar to what we have in our warehouse that shows shipments in priority and shipments on hold.
The challenge you face is buying and implementing these modules, and having the expertise in house to write these scripts or reports.
One way or another it will have to be paid for. The question is who gets paid.
-
To the best of my knowledge, non stock purchase order distributions are controlled through the default distributions in the GL setup. Both Purchase Charges (D) and Purchase non-Stock (D) activities can be pointed to specific GL accounts by assigning distribution codes to them.
Turning Dynamic Segments on should allow you to identify the segments to be replaced within the distribution code by using the ?? wildcard.
So, if you want to use the order category as one of your dynamic segments, you must specify that as a segment in the GL Control setup. This should apply to both PO and SO orders (RO’s do not have an order category)
Hope that helps
-
Are you wanting your non stock items to all go into a different account, or is it different accounts for different non stock items?
-
I think it would be a good feature if QC had a hold and release screen that allowed authorized personnel to release the order. This hold and release screen could be used to hold orders for payment, for export compliance reasons, or credit increases/reviews or other special circumstances.
But, it doesn’t exist. I think the drop ship factor would not prevent you from implementing new process and policy. Sometime you have rely on people to follow policy and not try to program enforcement.
-
This doesn’t sound right. I suggest you contact component control and have them investigate it.
-
There is no automated way to stop this. We have developed our own internal processes to handle pre paid orders and its been in place for years and has worked well.
1. We modified our pick ticket to throw an alert to the user printing it that states “ORDER REQUIRES ACCOUNTING APPROVAL” and it is thrown if the payment terms are any prepaid terms.
2. We modified our pick ticket to print a large, red font, message block at the top which states the same thing as above right on the pick ticket.
3. We set up a special holding area in the shipping department with a sign that says “HOLD FOR ACCOUNTING APPROVAL”. When these orders come through, the shipments is picked, packed and set in this area.
4. We establish a policy that prepaid orders must have a RED STAMP from accounting stating “ACCOUNTING APPROVED” before the shipment can be processed. This is even stated in our QC manuals.
5. We established a procedure that the sales person is responsible for submitting a copy of the pack slip to account so that payment can be collected. This can be printed or emailed.
6. We established a policy that accounting must go into the warehouse and stamp the pick ticket in order for the shipment to go. In addition, Accounting must make periodic trips back to the warehouse to check for approval orders. In turn, the warehouse tries to make sure accounting knows when an order is back there for approval.
7. Lastly, we built into our bridge to our shipping software the same alert the is displayed on the screen when the pick ticket is printing, and on the pick ticket that the order must be approved.
So, an alert is thrown at the time the pick ticket is printed, its on the pick ticket and an alert is thrown when actually processing the shipment in the shipping software. Additionally, the sales, accounting and warehouse teams work together to ensure the orders are paid and approved prior to the product leaving the doors.
-
I believe the original POD_AUTO_KEY is held in the stock line. So, if you link from the PO_detail to Stock, then back to PO_Detail from the stock line you should be able to match up the original line item with the credit.
-
It would have to be done manually through SQL. There is no dist code merge tool in QC at the moment.
-
I agree that this would nice as well.
-
Dave, yes we photo every part received. The Twain compatibility is the key.
However, you can turn any imaging device into a twain compliant camera using RemoteScan by installing both the client and server on the same PC.
We use Panasonic cameras as they are twain compliant. However, the models we use are no longer available – and we have pretty much bought up every remaining camera on the market – even eBay.
So, if you find a new model, please post it for the community.
-
Jim, welcome to the QUE Group. I think you will find a great deal of information among the users.
If you could post specific questions in the Work Order or other forums that can get the ball rolling for you.
Try to be as specific as possible in your questions.
-
We use the standard oracle backup scripts, then back up those files to an external drive.
-
Dave, it sound like either your screen resolution is too small, or you are displaying your fonts size in your system settings as large instead of normal.
-
The only way I know of to do this would be to link as such
stock.ind_auto_key->invc_detail.ind_auto_key
invc.detail.ind_credited -> invc_detail(2).ind_auto_key
invc_detail(2).sod_auto_key->so_detail.sod_auto_key
so_detail.cqd_auto_key->cq_detail.cqd_auto_key
-
Lydia,
If you see access denied, then the security settings for her profile need to be updated. This setting should be under company management, browses. I do not see a specific setting for contact management, so it is probably somewhere else. I would play around with granting various areas within security to see if you pin down what is causing the problem.
The other thing to check is to make sure that user is assigned to the contact masters you have set up under contact management. Just like the shipping module, you must assign users to the different views.
As for configuring browses, check your security settings for the user settings.
-
Mark, please refer to my past presentations on Export Compliance. It covers all aspect of a compliance program, including screening. You can find them in 2011 and 2013 conferences.
-
I just upgraded to 10.4.33 last night. So far all is good. No word on 10.5