infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Financials Product Customer Community [READ ONLY]
Add Ins Query for Prior Year amounts
unknown
Has anyone had any success using Add-Ins to query prior year and current year GL data, in the same query? I am creating a query that shows monthly amounts and units in columns and I would like to cross over two years. Thank you!!
Find more posts tagged with
Infor Lawson Financials Group - Discussion
Comments
gwhiteford
Did you try adding the two years you want into your criteria?
unknown
Thank you Barbara! Yes I did, and it does produce results, but both years are in the same column. I was hoping for CY columns and PY columns to allow for trending and easier uploading. Have you come across anything like this...or have you seen a workaround?
gwhiteford
Unfortunately, I don't think Addins will produce what you're wanting unless you sort it in Excel afterwards. My suggestion is to use RW.
unknown
That's what I was afraid of... : ) Thank you for your response! Have a good day!!
downloadexport1519_1.zip
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Popular Tags
Infor Lawson Human Resources Group - Discussion
Infor Lawson Technology Group - Discussion
General Discussions
VISUAL - Enterprise General Discussions
Infor Lawson Supply Chain Management - Discussion
Process Automation (IPA) - General Discussions
Pegasus - Partner General Discussions
Infor Lawson Supply Chain Group - Discussion
Infor Lawson Financials Group - Discussion
Infor EPM Discussions