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

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 PO line item expected cost with the latest FOB cost.

This feature is added to the PO Line screen, F5 Window (PO --> Processing --> Purchase Order Processing --> Change --> Line Item screen --> F5=Display Order.) See sample screen below: 


 Press F5 to go to the Order Line Search window.  Note the new "F4=Sync to Current FOB Cost" option.

After pressing F4, the heading will change from Exp-Cost to Exp/New-Cost, and for those lines where there's a new FOB cost, the new calculated cost will appear on the line below the current cost.

At this point, no database changes have occurred to the Line Item file yet. So this is a good time for you to review all affected line items by using the Page Up/Down keys.

A.  If Escape is pressed before the F5 window is closed, the following message will appear:
If No (default) is selected, the program will return to the Line Item screen and no changes will occur to the Line Item file.

B.  If Escape is pressed and Yes is selected, all line items that have a new cost value will be changed and the program will return to the Line Item screen.  In the Line Item screen, If the user presses the ESC key again to exit and the Print Immediately PO option is turned on, the system will prompt the user and ask if he/she wishes to print the changed PO right away.

C. The F5 window also allows the user to press the RETURN key to select a particular line item. The selected line item will be returned to the Line Item screen.  If the user does so, that implies that the user is canceling the "F4=Sync to Current FOB Cost" operation. No cost change will occur to the Line Item file.

If there are unposted receiving transactions where the PO line item unit cost is updated, user will receive the following message:
    Update XXXXXXXXXXXXXXX cost from 999,999.9999 to 999,999.9999 in Receiving Trx?
See sample screen below:

Modified program: PO0111, POUPDCST

DLM



    • Related Articles

    • 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 ...

    • FOB Cost Will Not Be Changed Because It Was Manually Overridden

      Release Date: 02/17/2022 Version: 8.5 & Higher Q - We sometimes run into the warning message shown below when changing cost on PO line items that have previously been changed by using the import method to change the cost. The discount percentage will ...

    • Feature - Support Negative PO Line Item Unit Cost

      Release Date; 5/25/2018 It has been suggested that if we can enter a negative unit cost for a Purchase Order Line Item, then we can use it to represent deposits paid on the purchase order, which would be very helpful. We did an internal test of this ...

    • Feature - Allow to Enter Unit Cost in PO Warehouse Receiving Add Mode

      Release Date: 04/19/2018 The original design philosophy of warehouse receiving is that this is a function for the warehouse to perform receiving. The warehouse should not have any business in entering receiving unit cost. Therefore, during the Add ...

    • AP05S1 Accounts Payable A/P Open Item Report

      Reports A/P Open Item Report Application Overview The A/P Open Item Report contains detailed information about the invoices on a vendor's account and summarized vendor aged totals aged by invoice or due date. The report shows each vendor's aged A/P ...