PartPickList: ID not found:
6c02171f-b586-4cf1-ac1c-b07d16a15ae2

yet in SQL can query it no problem..

select * from APART where AID = '6C02171F-B586-4CF1-AC1C-B07D16A15AE2';

6C02171F-B586-4CF1-AC1C-B07D16A15AE2 2007-08-29 04:30:28.453 2008-07-16 15:39:13.280 1 67E61209-CFEF-4258-9260-D4CB16958FD7 07B40BFF-8A31-45BA-ADE2-D5DC985DD397 1024Mb PC2-6400 DDR2-800Mhz CL5 1.8V Memory (Kingston) NULL NULL 621-KI35 E4EB5066-FB50-4A20-8AE8-89B59FA263AB NULL 84740775-F061-4D68-96B1-55BDAF5DE489  L49744 14B3D75E-BAD4-4CC0-8BB6-F8F015779AE9 73155D 53.77000 0.00000 75BCD99E-0968-4685-A0ED-E1E119AA4BDD NULL  0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

This error occurs because one or more of the parts in the Purchase Order for this particular vendor has had that vendor removed from the part's Wholesaler and/or Alternative Wholesaler field.

To quickly see what the part(s) are in this Purchase Order so that you can edit the part's Wholesaler (or Alternative Wholesaler) back to this vendor:

• If using AyaNova 4, select the record indicator on the grid to the left of this purchase order record so that it is highlighted and underlined (as shown in image #4 in the AyaNova 4 Help file section http://www.ayanova.com/AyaNova4webHelp/printing_from_a_grid.htm)
• Now select to print the Sample Detailed Purchase Order report template (or equivalent) so that you can see via the report what the part(s) is that is selectd in this PO, and you can also see what vendor this PO is for
• Now open the Parts grid and open that parts entry screen (or if a lot of parts, use the Search Database feature and enter the part name)
• Edit this parts Wholesaler or Alternative Wholesaler so that it is the same as the vendor for the PO where you get this error
• Save
• Now return to the PO grid and you can now open this Purchase Order's entry screen.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I guess this still leads to my recent Wish List item of needing to have more Vendors available for each part.

Thanks,

Chris

Not sure what you meant by "it does not show in the normal parts list"? Do you mean the part is not listed in your Parts grid? If so, perhaps you have a filter on that grid which is preventing it from being listed. Or do you mean the part is not listed for selection for a specific vendor in a new PO? If so, that is because only parts that have that vendor selected in Wholesaler or the Alternative Wholesaler will show for selection for that PO for that vendor.

We will look into seeing what is involved with allowing all parts to show for selection regardless of the vendor selected. At this time, one of the reasons is that many AyaNova users have thousands and thousands of parts, and to help with selection when ordering via PO, only the parts for that specific vendor in a PO are shown for selection - so we wouldn't want to remove this feature, but may be able to look into adding an additional feature to allow over-riding of it for those users that don't care about this. Development will look into this for a future version.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Seems to have been an isolated occurance so I'm not sure what to make of it at this point.

Chris

Hi again Chris

I would suggest double-checking that, because if the part shows up when you do a Search Database, it will show up in the Parts grid if no filters and you are viewing all.

1. Do the Search Database again so that you bring up its part entry screen and get the confirmed wording and case of the Part Number as well as the Part Name
2. In the Parts grid, make sure All Rows is selected instead of First 100 Rows (so that if you have more than 100 parts they are all listed)
3. Make sure No Filter is selected, and click on the Refresh menu option
4. Sort by the Part Number (have it as the first column), and than scroll down to find
5. Note: that sort order varies depending on what configration you are using - for example SQL Express or SQL sort order is alphabetically regardless of case, whereas Firebird has a specific sort order based on case - see the bottom of the AyaNova 4 Help file section http://www.ayanova.com/AyaNova4webHelp/moving_and_sorting_columns_in_.htm for details on this)

Do post back that you now see it listed in the Parts grid.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com