I am lost to where the last cost comes from that is populated in the purchase order screen 0425000 after a vendor and Inventory ID is entered.
I would expect that it would come first from the VendItem Table if the InvID had been receipted in a PO for the Vendor.
If never receipted under that Vendor it would get the Last Cost from the ItemSite Table.
I have tested this in our test database and don't always get predictable results.
Is this the method Solomon uses and I am missing something or is it somehow different.
*This post is locked for comments