PURCHASE_QUANTITY_PRICE

Hi ​@ronhu,

What about Inventory Transactions History window? 

Business users can get all procurement-related history from there. They simply need to query all records for Purchase Parts with Transaction Code ARRIVAL.

Regards

Abdul Rehman

​@Abdul Thank you for your reply.

Inventory transaction is listed the cost only. and it might only list the base currency as well. What we need is the purchase price and currency, hence I think this table might not be a good fit for our demand.

Correct me if i was wrong.

Thank you.

​@ronhu the answer to your first question concerning the table PURCHASE_QUANTITY_PRICE, this is the Price List tab on the Supplier for Purchase Part.

Supply Chain is not my strong suit, but wouldn’t price history have a close relation to invoice history, so maybe see if Invoiced Purchase Orders is a place to start?

​@matt.watters Thank you for your reply.

Thank you for let us know the table PURCHSE_QUANTITY_PRICE is from the Price List tab. Not all parts are using price list in our company, thus, this is not a good option.

I appreciated you direct me to another window Invoiced Purchase Orders. will start from there.

Thank you.

The view PURCHASE_QUANTITY_PRICE corresponds to the Price List tab on the Supplier for Purchase Part screen. This is where supplier prices are maintained, which the system refers to when creating purchase orders. Prices in this view can either be entered manually or updated automatically via EDI/MHS. The relevant message type for automatic updates is the PRICAT (Price Catalogue) message, which includes part number, price, discount, and any additional cost details from the supplier.

For detailed guidance, you can refer to section 3.8.1.1 Manage Supplier Prices

In summary: PURCHASE_QUANTITY_PRICE generally stores supplier agreement price lists or valid quantity-based pricing, but it does not track historical prices from actual transactions.

For actual historical purchase prices, consider the following views:

• PURCHASE_ORDER_LINE_ALL: Purchase order line details
• INVENTORY_TRANSACTION_HIST2: Inventory transaction history
• PURCHASE_TRANSACTION_HIST: Purchase transaction history
• MATCHED_RECEIPTS: View for matched supplier invoices and receipts (Manual Supplier Invoice)

Let me know if you'd like help creating a report or query using any of these views.

Hi ​@ronhu,

Yes, you are PO currency information is not available in the Inventory Transaction History window, though, through a quick report using view INVENTORY_TRANSACTION_HIST and MPCCOM_ACCOUNTING, you can get desired data.

Anyway, now you have multiple data sources suggested in this discussion, check which one suits your requirements.

Regards

Abdul Rehman

​@Abdul many thanks for your looking into it.