Update the Item Vendor Field 6 Last Purchase Cost When PO Line Item FOB Cost Is Changed

Update the Item Vendor Field 6 Last Purchase Cost When PO Line Item FOB Cost Is Changed

Release Date: 12/05/2022
Version: 8.5 & Up

Q - When users enter and prints a PO and there is an Item Vendor Record, Elliott updates field 6. See sample screen below:

But if users change the PO cost, this field is not being updated. I understand it has to do with situations where there might be another PO for the same item and a different cost. I see the point, but the discrepancies that are created because of the cost in field 6 are worse than the benefits. I suggest updating field 6 if the PO line cost is changed, or at least have a Global Setup option that will allow users to do it.

A - It is a timing issue.  I remember it used to work the way you'd like it to. That is to say, when a changed PO was printed, the Item Vendor file, "6. Last Purchase Cost" was also updated. Then we received complaints from users that the Last Purchase Cost value was incorrect in some situations. Here is an example: On 1/1/21, a PO for item A has a purchase cost of $100. On 1/1/22, another PO for item A has a purchase cost of $110. The Item Vendor file field "6.Last Purchase Cost" is $110 at this moment. With the old logic, if we go ahead change the older PO on 1/1/21, we may or may not change the line item FOB cost.  The result of printing the changed older PO is that item A's last purchase price is now changed back to $100 and this causes problems.

Obviously, you can argue this either way. But I believe the old logic is more damaging than helpful. Having a Global Setup flag does not necessary solve the problem. The likely scenario is that we will spend time  investigating for unhappy users why the value in "6. Last Purchase Cost" is “wrong.”

To really solve this problem, we need a sophisticated logic to check if this changed PO line item is the last PO of item A for this vendor. Since there’s no existing index to support this operation, it will result in performance problems. This might be a V9.0 improvement we can consider.

The solution in this scenario is that the user can cancel the old PO or PO line item with the wrong cost, then add a new PO or PO line item. Then the new PO cost will be updated to the Item Vendor’s “6. Last Purchase Cost.”


EMK


    • Related Articles

    • Can I Edit the Ship Date Field in PO Line Item Screen?

      Q - I noticed that there is a "Ship Date" field in the Purchase Order Line Item screen. It is not editable right now. What settings are necessary to gain access to the Ship Date field? See sample screen below. A - Before answering this question, we ...

    • Canceled PO Line Items Still Exporting on EDI

      Released Date: 11/7/2022 Version: 8.5 & Up Q - We’ve seen this happen twice in the last month. We create a purchase order, then cancel line items on it. When we export the EDI document again, it still contains the cancelled line items on it, which we ...

    • AP0100 Accounts Payable Vendor File Maintenance

      Maintenance Vendor File Maintenance Application Overview The Vendor File is used to store information on all companies and individuals from whom materials, supplies, and services are purchased. This application allows entry of information into this ...

    • Feature - Allow to Mass Update PO Line Item Cost & Synchronize to Current FOB Cost

      Release Date: 7/9/21 Versions 8.5 & Up This feature is useful when your vendor raises a price and new price is applicable to an outstanding purchase order. It allows your buyer to bring up the affected PO one line item at a time to synchronize that ...

    • AP1801 Accounts Payable FOB Code File Maintenance

      FOB Code File MaintenanceApplication Overview The FOB Code File represents the normal location that merchandise shipped by the vendor is Free on Board (see FOB in the Accounts Payable Glossary). It is used in the Purchase Order and Receiving package ...