Scott-Burish
Forum Replies Created
-
Pietro, am I missing how this is tied? Used sod_auto_key to join to stock reservations and no record is returned.
-
That table does not have a record tied to it yet as items haven’t been reserved when the pick ticket is generated as shipping is using barcodes to reserve. However, if I print the pick ticket on an order, and print again using the ignore the previously printed reservations, it still does come off next pick ticket.
-
That field is still false even after it has been printed on our system. I am guessing it has to be something tied to items as there is an option to ignore printed items when printing pick ticket. I have uploaded a screenshot of this, as am sure something has to drive this, but not finding any fields that would be set.
-
in your data pull if using sql use where not insull({STOCK.EXP_DATE}). If not using sql, use record selection and choose formula and use not insull({STOCK.EXP_DATE}). Hope this helps.
-
I have experienced the same thing when using an hdmi cable to connect monitor, rdp or direct. Everything shrinks to a very small font and icon til exit and relogging in. My fix was to just switch to DVI but don’t know if that is an option for you. I didn’t log a case for it, so not sure if there is another fix, but would be handy if there is.
-
you need to label it as something different, like your company name AP Aging. Put it in the same directory and the user should be able to select your document when running the AP Aging report in the document drop down.
-
works great. Thanks Pietro!
-
Thanks Pietro. Just want to ensure I am clear, I pick stock even though document images are stored in the shipping module that I want to send?
-
Basically I just create a visual basic .net program, set the single instance flag, and have the form open the actual program with a wait for invisible form to close. This works for a single pc, but if they are logging in at multiple stations it would not help in that case.
-
I have made a single instance program using vb.net that just encapsulates the executible and put that executable on their start menu and desktop, removing the executable for the same reason. If you have visual studio, I can share the source and you can update to your application path depending on version of quantum.
-
Ok. Didn’t think that was for the SO. It often comes up that the CSR doesn’t know if they sent back a pick ticket as sent right to shipping. I have struggled with this for years. We need to send back manually so shipping isn’t receiving them automatically. I will look into your solution as yet to find where there is an area, but thought maybe with the check box when printing pick tickets to ignore previously printed would be recorded some where.
-
Nevermind. Found the {WO_OPERATION.ACTIVE_FLAG} field that appears to control this.
-
PIetro, I have removed the security, but still have random issues pulling up scanned docs. To avoid, I just set the option previous post to not open in document imaging but separate program.
-
I have run into a few issues with this and have changed the global option in the imaging tab to display pdf in external application if available. It solved it for me.
-
Thank you all. By looking at the views was able to figure out what I needed and had someone validate I was starting with the numbers they were looking for. Now on to create the actual calculations.
-
Thanks Pietro! That will be a huge help. Didn’t know we were allowed to add our own CSS files. When I tried, I was trying to use the font tags within the SQL case statements,
-
I have not found a way to change text color or size. When I have tried to use the font tags, get an error stating something about a potential dangerous operation, but if you want the row colored, you can use a case statement after your selection criteria in the sql like:
select soh.so_number, pnm.pn, sod.qty_ordered case when pnm.pn = ‘1234’ then ‘#ff3333’ END ROW_COLOR
from so_header soh, parts_master pnm, so_detail sod
where soh.soh_auto_key = sod.soh_auto_key
and sod.pnm_auto_key = pnm.pnm_auto_key
order by soh.so_number
The #ff3333 is the hex code for a color in the red shade. You can use any color hex code to pick a color you would like.
-
For RDP we use RemoteScan software which has been acquired by Dell, so can be purchased from there. It is a client/server application so one piece gets installed on terminal server and the other on workstation. Works well with twain scanners.
-
We had a similar issue with random disconnects and base station resets. During my troubleshooting, I tried many things, one ended up being a bad base station and the other had to do with outside interference on the frequency the base station is defaulted to. For the later case you can open the base station, and there is a rotary switch that determines the frequency the base station uses. If you have not tried changing that, it is something you can try.
-
Thanks Paul
-
Unfortunately, with how we operate this does not as they are not invoice ready until picked, which happens in shipping via rf barcode after they receive the pick ticket.
-
Thanks Paul. I thought I was missing something or a link I was not familiar with, but this makes perfect sense.
-
For anyone else who runs into this, it has been confirmed by Quantum that is a bug in version 9.5.17.0 relating to the Custom Crystal option. They have filed tracker 27487 with development on issue.
-
Thanks Paul. Will do.
-
looking at that right now as found that in data dictionary. Will let you know.
-
That also is used for something else as remains false after printing pick ticket in our system. Hitting the ignore printed reservations does work, however, and previously printed items do disappear even though they are not reserved at this point as done in shipping with barcode scanner. Just not sure what drives that and looking for a way to know if a pick ticket was previously printed or not.