[Kevin Antholt]

You can do with Via Crystal Reports, add the image in their and add the report to Quantum and export or print to PDF

[Kevin Antholt]

Basically Part warning are joined to 2 tables from PARTS_MASTER table
WARNING_TYPES on pnm_auto_key
then
WARNING_MESSAGES on wms_auto_key

Create the warning manually in Quantum then use an SQL insert/delete the data into the warning_types table along with where you want to warning (SO, PO SM) etc.

[Kevin Antholt]

How are you receiving them in? Are they BOM PN’s? There are some Inventory settings you may want to look at.

[Kevin Antholt]

I had this issue also and through searching found that filling out the Buy for Cust is the only way.

Unless you want to cusomize your PO Form Which is what we ended up doing.

[Kevin Antholt]

Try flag

SO_HEADER.RELEASED_TO_SHIPPING

[Kevin Antholt]

Down for us too. Makes me wonder why we pay thousands a year for SMA when they never have any answers.

[Kevin Antholt]

The issue is the display setting on each computer. When printing to a crystal report it makes the screen size at 100%. Most PC’s default at 150%.

Right Click on your desktop and change the scaling setting to 100%, If you need the text and icons to appear bigger then change the Display resolution to a smaller resolution.

This will fix the issue of the Quantum screen size changing when printing a Crystal type report.

[Kevin Antholt]

There has to be somewhere to change both. I have another company and there has a “#” in both the subject and the file name. Like “INVOICE #INV-2213 11-18-2022 12:38:00” Can’t imagine it was different for 2 companies with the same version

[Kevin Antholt]

Here are a couple of differnt Queries I have used for Part Attributes. You will have to check what your auto_keys are but if you knw SQL you should be able to figure this out in a SQL Editor like SQL Developer.

***** List agg Single line check box ***********

select pnm.pn

,(select listagg(uda.uda_code, ‘, ‘)within group(order by uda.uda_code) from user_defined_attributes UDA, uda_checked UDC where pnm.pnm_auto_key = udc.auto_key and udc.uda_auto_key = uda.uda_auto_key and uda.auto_key_prefix =’PNM’ and uda.udg_auto_key = 12)pn_attributes

from parts_master PNM

where (select listagg(uda.uda_code, ‘, ‘)within group(order by uda.uda_code) from user_defined_attributes UDA, uda_checked UDC where pnm.pnm_auto_key = udc.auto_key and udc.uda_auto_key = uda.uda_auto_key and uda.auto_key_prefix =’PNM’ and uda.udg_auto_key = 12)is not null

or

****** Multi Line Check Box ***************

select pnm.pn , udg.group_name, uda.uda_code, udc.attribute_value

from parts_master PNM

left join uda_checked UDC on pnm.pnm_auto_key = udc.auto_key

left join user_defined_attributes UDA on udc.uda_auto_key = uda.uda_auto_key and uda.auto_key_prefix =’PNM’

left join uda_groups UDG on udg.udg_auto_key = uda.udg_auto_key

where udc.auto_key is not null

[Kevin Antholt]

I have as well, No issues. Just shows Direct update by sysdba in audit trail

[Kevin Antholt]

Correct But there has to be a way to change it in the DB or on the Server