Forum Replies Created

  • Clinton Wilson

    Administrator
    09/24/2024 at 12:21 PM in reply to: SM Shipper Header address detail tab

    Hi 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.
  • Clinton Wilson

    Administrator
    05/13/2024 at 9:03 AM in reply to: Uploading Doc/Images to Quantum on the Cloud

    Hi 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

    Administrator
    04/30/2024 at 11:20 AM in reply to: Server Unavailable

    yes

  • Clinton Wilson

    Administrator
    03/19/2024 at 8:09 AM in reply to: Daily Report for invoice total by station

    Hi Christi. Which field are you using to identify the stations?

    Also which version of Quantum are you using?

  • Clinton Wilson

    Administrator
    12/14/2023 at 11:11 AM in reply to: Changing shipping statuses

    This should be an easy fix for CC. Who knows, there might be a ticket assigned to this issue already. I’ll find out.

  • Clinton Wilson

    Administrator
    12/14/2023 at 10:59 AM in reply to: Changing shipping statuses

    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

  • Clinton Wilson

    Administrator
    12/14/2023 at 9:57 AM in reply to: Changing shipping statuses

    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.

  • Clinton Wilson

    Administrator
    12/08/2022 at 9:18 AM in reply to: Stockline QTY change

    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.

  • Clinton Wilson

    Administrator
    09/16/2022 at 2:45 PM in reply to: 12.5.7.0 Contact Manager broken

    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.

  • Clinton Wilson

    Administrator
    09/16/2022 at 1:23 PM in reply to: 12.5.7.0 Contact Manager broken

    Check the users assigned to the statuses.

  • Clinton Wilson

    Administrator
    02/28/2020 at 9:07 AM in reply to: QUANTUM WORKSTATION LICENSES

    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

    Administrator
    02/28/2020 at 7:02 AM in reply to: PROBLEM WITH BOM PART RESERVATION PROCESS

    Hi 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.

  • Clinton Wilson

    Administrator
    02/26/2020 at 8:20 AM in reply to: QUANTUM ANALYTICS WITH MS POWER BI

    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

    Administrator
    02/24/2020 at 1:15 PM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURER

    Hi 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.

  • Clinton Wilson

    Administrator
    02/24/2020 at 9:41 AM in reply to: QUANTUM WORKSTATION LICENSES

    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

    Administrator
    02/21/2020 at 2:07 PM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURER

    Jeff:

    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

  • Clinton Wilson

    Administrator
    02/21/2020 at 11:48 AM in reply to: MICROSOFT POWERBI

    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.

  • Clinton Wilson

    Administrator
    02/21/2020 at 7:42 AM in reply to: QUANTUM WORKSTATION LICENSES

    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

    Administrator
    02/21/2020 at 7:21 AM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURER

    However 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

    Administrator
    02/21/2020 at 6:53 AM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURER

    Insert 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

    Administrator
    02/20/2020 at 3:22 PM in reply to: SQL STATEMENT TO CHANGE LOCATIONS BY MANUFACTURER

    Jeffrey,

    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.

  • Clinton Wilson

    Administrator
    01/30/2020 at 9:57 AM in reply to: PAPERLESS SYSTEM

    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.

  • Clinton Wilson

    Administrator
    12/06/2019 at 12:56 PM in reply to: INCOMPLETE RECIEVER

    Hi Larry, yes it will.

  • Clinton Wilson

    Administrator
    11/27/2019 at 9:45 AM in reply to: INCOMPLETE RECIEVER

    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.

  • Clinton Wilson

    Administrator
    08/22/2019 at 9:50 AM in reply to: CUSTOM SQL EVENT AND DOC IMAGES

    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.

  • Clinton Wilson

    Administrator
    07/02/2019 at 2:02 PM in reply to: RO CHARGE COST

    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.