infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Supply Chain Management Customer Community [READ ONLY]
PO253 & PO254
Legacy Contributor
Hello - We are a new member of ECRI/PriceGuide & I've been asked to upload a 12 month data set. They have recommended we use PO253 & PO254. Does anyone use these jobs regularly that can offer some direction?
dEPM-614-Global features and Workflow in 12.0.6.mp4
Find more posts tagged with
Comments
lxiong3
We are a member of ECRI/PriceGuide as well. We use SQL to pull the require data for them. Based on the require fields they wanted us to supply them PO254 doesn't seem like it would provide enough detail. Please let me know if you should have any questions.
Legacy Contributor
Thanks for the response. I will advise management that we use SQL. I agree in that I do not believe these jobs will satisfy this request. Would you be willing to share your query?
dechevar
The issue with sending PO data only is that it may not reflect what you actually paid. An SQL query is essential to pull in the matched invoice cost.
lxiong3
Sorry for the late response, was out at the WC Lawson User Conference. I've attached the 2 queries, one for 12 Months and the other is the monthly. These were written by my co-worker.
[Updated on 4/2/2014 11:08 AM]
Legacy Contributor
Thanks so much! I have a co-worker who knows SQL so I will send these on to him.
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
ION Connect
ION Workflow
ION API Gateway
Syteline Development
CPQ Discussion Ask a Colleague
Infor Data Fabric
Infor Document Management (IDM)
LN Development
API Usage
FAQs, How-To, and Best Practices