My client would like to view or print an edit list in AP that shows the allocations that are created when distributing to an Allocation Account. We are prototyping in GP 2016. Has anyone created (or is anyone aware of) a smartlist or SQL view that would allow a user to view the allocations in the AP vouchers before posting?
*This post is locked for comments
Mike,
You're probably better off making this a custom report that trying to do this in Report Writer. Just my 2 cents. I have some code on my blog that would help:
Fixed Allocation: victoriayudin.com/.../sql-view-for-fixed-allocation-accounts-in-dynamics-gp
Variable Allocation: victoriayudin.com/.../sql-view-for-variable-allocation-accounts-in-dynamics-gp
Yes, they want to see the distributions to the Accounts that come from the allocations. I don't think it can be done at the AP level at all due to what Bill refers to. The actual allocations are a GL process. I was directed to an old kb to modify the GL distributions report with many, many steps. I'm not that good in GP report writer and I would think it would take a very long time to do. Back to what Bill said. My own initial response was to tell them that they have to be careful and set up the allocation accounts and percents accurately and then trust that they will "work" correctly.
Challenge here is - do the allocations actually know the distribution at the AP side - before posting and before getting to the GL?
Clarification question - is this something that they are going to want to have 'all' the time and that they will want well after implementation is complete and the system has been running for months/years?
Reason for the question is that we had a situation years back where the client insisted that the Allocations were not going to work and we had to figure out a way to report on this. We were told at the time it was a pretty tricky thing - we are not coders - and was going to be costly
That was the question the developers asked him before starting work and he decided no - he would just have to trust that the Allocations were going to work.
That was my experience - we never did get past that first meeting - but I betting someone else has been down that road - plus since then, maybe things have changed and the process of linking the Allocation to the accounts in the final posting is easier.
Good luck and I will keep my ears and eyes open.
Do you mean the distributions? you could create a report for unposted transactions
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (