Symptom
You have uploaded purchase orders through Microsoft Excel keeping currency field in blank, however system defaults the company currency instead of supplier currency.
Reproducing the Issue
- Go to the Purchase Requests and Orders work center
- Go to the Purchase Orders view
- Select the relevant Purchase Order
- Select Edit
- You can see the Company Currency in the uploaded Purchase Order document
Cause
When user creates purchase order document through Microsoft Excel, the user's data always takes preference over master data maintained in system. In the current design, system does not pull the Purchase Order Currency from Supplier master data when purchase order is created via excel. The Purchase Order Currency from Supplier master data is pulled only for manually created Purchase Order documents.
Resolution
You have to fill the correct purchase order currency during the excel upload and order to your supplier.
Keywords
KBA , AP-PRP , Purchase Request Processing , How To