infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Financials Product Customer Community [READ ONLY]
Add Ins Query for Prior Year amounts
Legacy Contributor
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
Comments
gwhiteford
Did you try adding the two years you want into your criteria?
Legacy Contributor
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.
Legacy Contributor
That's what I was afraid of... : ) Thank you for your response! Have a good day!!
downloadexport1519_1.zip
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
