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

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

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

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

• Create PO Receiving Event to Trap Negative Qty on Hand Problem

  Q - Sometimes our receiving department is behind with their tasks in updating received quantities in the Elliott inventory. As a result, it creates a negative quantity on hand in Elliott. The items sold during the period use the old average cost. ...

• BM1501 Bill of Material Feature/Option Configuration Maintenance

  BM1501 Bill of Material Feature/Option Configuration Maintenance ← Bill of Material / Work Order Plus Feature/Option Configuration File Maintenance Application Overview The Feature/Option Configuration File Maintenance application enables the user to ...