Lock Last Cost allows the user to manually set the Last Invoice Cost on Item Vendors Maintenance, and keep it from being changed when PO Receipts are posted. This ensures that a set cost negotiated with a Vendor is not changed as a result of other costs added to the PO/PO Receipt.
Lock Last Cost can also prevent changes to the Item Cost on a PO, or only allow changes within a set percent variance.
Navigation: Tools >> Setup >> Company >> Setup GP PowerPack
Mark the box next to “TWK-POP: Lock Last Cost*”. The asterisk indicates that this Tweak requires additional setup. Double-click on “TWK-POP: Lock Last Cost” to open the Tweaks Setup window. Locate the POP: Lock Last Cost section:
Password: Provide the password needed to unlock the Last Receipt Cost on Item Vendors Maintenance. The same password will be required to enter a PO Cost when it exceeds the Allowable Variance.
Control PO Cost: If marked, the Unit Cost on a PO will be controlled so that changes beyond the Allowable Variance can only be done with the Last Cost Password.
Allowable Variance: If Control PO Cost is marked, you can set an allowable variance. This value can be zero, which means no changes are allowed to the PO Cost.
Using POP:Lock Last Cost
Once this Tweak is enabled, posting PO Receipts will no longer update the Last Receipt Cost and Last Originating Invoice Cost fields. Additionally, while the Last Invoice Cost is normally locked (when registered for POP), the Last Originating Invoice Cost will also be locked.
When “Edit Last Cost” is selected you will have to enter the password set in the Lock Last Cost Password window. If the password cannot be provided, the Last Cost fields will remain locked. When the correct password is entered, the Last Cost fields will become editable so you can manually set what the cost should be. The new cost will appear on all new Purchase Orders.
If PO Cost Control is enabled, changing the Unit or Extended Cost to a value that exceeds the Allowable Variance will result in a warning that the change exceeds the allowable variance. The user will then be prompted for the Last Cost Password. Entering an incorrect password, or clicking Cancel on the password window, will result in the cost being reset to its original value.