Victoriayudin.com Website Review

i have been asked more than a few times for a script that shows uposted checks and their apply detail. this can be helpful to replace the check batch edit list report, which is universally hated by all gp users i have spoken to. sorry about the strange colors showing up in. create a refreshable excel report based on a sql server stored procedure. a long awaited new feature is being released today for our gp reports viewer – excel reports. what i think is truly amazing about this new feature is the fact that you can set up an excel report based on a stored procedure to allow users to enter parameters and also every year we get a slew of phone calls about closing the year in gp. usually these start in december and i  thought i would beat the rush this year. here are some resources and notes i have compiled over the years on the year end close. i will add to this post as i find more. sql view for rolling 12 months of sales by item by site in dynamics gp. by popular request i have created a variation on my rolling 12 months of sales by item to show a rolling 12 months of sales by item and site id in dynamics gp. this view will return the last 12 months, not including the current month. so if you’re running this today – dynamics gp sales amounts and quantities for rolling 12 months continue reading → i would like to start by saying that i do not normally advocate updating dynamics gp data directly in sql server. most of the things you need to do should be handled either inside the dynamics gp application or with integration tools like integration manager or i often surprise people by telling them to change the void dates when they void payables transactions in dynamics gp. if you’re voiding something that was just entered, leaving the defaulted dates is usually fine. however, when you are voiding an old check because. refreshable excel report for monthly actuals vs. budgets in dynamics gp. a lot of the requests i get are for actual vs. budget reporting. certainly frx and management reporter can do this pretty easily, but