cwilson
Forum Replies Created
-
Clinton Wilson
Administrator09/24/2024 at 12:21 PM in reply to: SM Shipper Header address detail tabHi Jonathan. I suggest making a copy of the customs form and modifying it to pull the data from the fields you want it pull from.
-
This reply was modified 1 year, 7 months ago by
cwilson.
-
This reply was modified 1 year, 7 months ago by
-
Clinton Wilson
Administrator05/13/2024 at 9:03 AM in reply to: Uploading Doc/Images to Quantum on the CloudHi John,
How are you uploading the images?
Are you scanning the documents to a local folder and then uploading to the Quantum cloud?
-
Clinton Wilson
Administrator03/19/2024 at 8:09 AM in reply to: Daily Report for invoice total by stationHi Christi. Which field are you using to identify the stations?
Also which version of Quantum are you using?
-
This should be an easy fix for CC. Who knows, there might be a ticket assigned to this issue already. I’ll find out.
-
I just checked it out and you’re right. What’s weird is that it allowed the user, with no assigned permission to that status, to change it on the order. After the status was change the user could not see it, but the damage is already done. Not sure if this issue was fix in a later version. I’m on 12.2.8
-
Yes there is. You can assign users to different statuses. This way they can only see the statuses they have access to.
Select the status then click Users.
Please note that users will only see the shipping transactions that have the statuses they were assigned.
-
Hi Glen,
you can edit the stockline and adjust the cost by entering 0.01. However, adjusting the cost will affect your GL. You may want to find out how your cost got to -0.01 before making the adjustments.
-
Jason, I’m sorry. I thought this status table was like the others. I’m on 12.2.8 and there’s no option to assign users.
-
Check the users assigned to the statuses.
-
Hi Jason,
That solution makes sense. I will talk to CC and see if they will extend that same deal to a smaller company. Just to be clear, you only pay for human connections. So my FEDEX connections will not be counted and therefore I will not have to pay for those connections.
-
Clinton Wilson
Administrator02/28/2020 at 7:02 AM in reply to: PROBLEM WITH BOM PART RESERVATION PROCESSHi Nate,
Do you have any way of identifying those special missions and who initiates the printing of the pick ticket?
I’m thinking if you can identify those special mission by the user you can then program the pick ticket to pop up warning messages to that user before it’s printed in the parts department.
-
For me is Microsoft Access. Takes a few seconds to build my tables. BI is then linked to the tables in Access. I can schedule the update to run multiple times during the day. Only use 1 license for a few seconds then disconnects when Access closes.
-
Clinton Wilson
Administrator02/24/2020 at 1:15 PM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURERHi Jeffery,
If I’m understanding you correctly, the warehouse should not matter in this case. The new location is linked to the warehouse already. All your doing is changing the location of the parts based on the manufacturer’s code.
-
Is there anything we can do?
I really would like to use the FEDEX integration without having to spend for 8 more licenses.
-
Clinton Wilson
Administrator02/21/2020 at 2:07 PM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURERJeff:
log in as sysdba on the training database and use the interactive sql to run the scripts. Use the script below to view / verify the parts before changing the location. Once you are satisfied the data is correct you can run the script in the previous post. You do not need SQL Developer for this task.
SELECT stock.pn, stock.qty_oh, stock.loc_auto_key, parts_master.mfg_auto_key
FROM stock, parts_master
WHERE stock.pnm_auto_key = parts_master.pnm_auto_key and parts_master.mfg_auto_key = Insert mfg_auto_key
-
I use Ms Access to build the tables. It’s really quick (approx 5 secs to build Sales table with 50,000 rows). BI is linked to the access tables. The BI dashboards are then published to our cloud work space and can be viewed via the BI mobile app.
-
What about the Fedex and UPS integration. Using those applications also use up the licenses in Quantum. This is unfair since we pay for the modules already. Does anyone else have this issue?
-
Clinton Wilson
Administrator02/21/2020 at 7:21 AM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURERHowever DO NOT disable the triggers. They are there to provide some automation and to ensure data integrity. Yes, they are a pain sometimes. In this case, they most probably will not be (unless you have stock imbalance or missing SN from serialized parts). Plus the triggers will ensure that your change is captured by the stock audit.
I Agree 100%
-
Clinton Wilson
Administrator02/21/2020 at 6:53 AM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURERInsert the loc_auto_key for the new location.
Insert the mfg_auto_key for the parts that need to be transferred to the new location.
UPDATE stock
SET loc_auto_key = New Location
WHERE stock.pnm_auto_key in (select parts_master.pnm_auto_key from parts_master WHERE parts_master.mfg_auto_key = Insert mfg_auto_key and stock.qty_oh >0)
-
Clinton Wilson
Administrator02/20/2020 at 3:22 PM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURERJeffrey,
do you still need help with this? If you do and you know the loc_auto_key and the mfg_auto_key I can help you with the statement.
-
Hi Jeremy, do you have the dashboard module?
We here at Blue have utilize the dashboard and the statuses of the different modules to go completely paperless from the time the customer PO is submitted to the point when the part is shipped. The only papers printed are the ones that goes with the package.
Also, if you receive the customer PO via email, that PO can be drag and drop on the image section without having to print and scan.
-
Hi Larry, yes it will.
-
Hi Nate. I’m curious. Can you receive the parts without finalizing the receiver then work off the statuses to keep track of the items that are quarantine? This way the quarantine parts are tracked and an AP record does not get created.
-
Hi Erika,
from my experience the image feature in the event manager does not work for all the templates or all the modules. I would have CC test it in their environment so you can be sure if it works or not. In the past I’ve tried with the repair templates only to find out it does not work for repairs.
-
Jake, try adding the fee as a piece part. Create a part number call expedite fee, add a stockline, reserve it as the piece part to the main item. Once the main item comes back from the shop you can receive the piece part in and the cost of the piece part should get rolled into the other repair charges. This way you don’t get stuck with an unwanted stockline.