How can I find my custom PO form assignments (by supplier) in DBA?
Custom PO form-name assignments can be difficult to track down when they occur at the supplier-level. It normally requires either exporting the entire supplier data table to a spreadsheet and then manually reviewing it or going through each supplier (in the Suppliers module) one-by-one. This knowledge base article helps speed up this investigation.
For this investigation, go to (Utilities > Database Queries) and copy/paste the following statement into the SQL box:
select SUPPNAME,PORDERTEMP from SUPPLIER where PORDERTEMP is not null
After pasting the above statement into the SQL box, click the OK button. The spreadsheet will populate with data if you have any specific PO forms assigned at the supplier level. It shows which suppliers have this, as well as the form name assigned to them. If you need to attach the spreadsheet to a support ticket or save it for any other reason then, while the spreadsheet data is still displayed on the screen, click the 'Export to CSV' or 'Export to XLS' button.