LYR and YTD Problems In SmartList (GP9)
Ryandb2
SmartList since our most recent year end close.
My understanding of them is below:
LYR - Would be all entries from two closes ago to the most recent close.
YTD - Would be all entries since the most recent close.
Is this correct? Currently LYR is displaying 2006 information even though
we have had a fiscal year close on 1/1/2006, 1/1/2007, and 1/1/2008. We
never close our tax year since we don't use that functionality so it is
currently set at 0/0/0000, could this be an issue? YTD is currently
calculating from today (May 13th 2008) to May 13th 2007.
Does anyone else have any issues with these columns or know some general
troubleshooting tips for them, such as what they rely on?
Thanks!
Don
Can you please let me know which smartlist you are having a problem with the
LYR and YTD numbers.
In the past within the sales and purchasing module if you did not close
these subledgers off at the end of your fiscal year the LYR an YTD numbers
would be incorrect. I have developed a couple of scripts that will correct
these numbers for you.
Thanks
Don
Ryandb2
The module we are having trouble with is purchasing. More specifically we
are trying to pull these into a Vendor Smartlist.
This might be a dumb question but is there an easy way to tell if we closed
the subledgers at end of year?
Ryandb2
module. Is there an easy way to tell when we closed out these subledgers?
Thanks!
Don
need to go into Tools --> Routines --> Purchasing --> Year End Close. Within
this screen you will be able to see what the last close date was for the
module.
The steps are the same for the Sales module as well.
Thanks
Don
Ryandb2
wonder why it is the 25th. And apparently we forgot to close the purchasing
module this year completely. Is there anyway to fix this? It doesn't look
like we can specify a date so if we were to close today then our year end
would be May 13th, which wouldn't be any better.
Thanks for your help Don!
Don
I will be checking into this today and get back to you if there is a
positive or negative solution on this issue.
thanks
Don
Frank Hamelly, MCP-GP
Fiscal Periods setup. It doesn't matter what date you close the year,
the LYR, YTD, and LTD amounts will reflect activity based on your
fiscal year setup.
It's a little confusing but the date in the Year-end Closing window is
the date the last closing process was run, not the date the close was
run through.
Frank Hamelly
MCP-GP, MCT
East Coast Dynamics
www.eastcoast-dynamics.com
Don
This is not a true statement, When you close the subledgers it will take the
dollar values upto the date that you close and move them into the LYTD bucket
and anything that is processed after the close will be processed into the YTD
buckets. This is the reason why Microsoft has provided the abilty within the
Vendor Yearly summary the views of Amounts since last close, fiscal year and
Calendar year views.
Thanks
Don
Frank Hamelly, MCP-GP
I did a 2007 Purchasing close as of today and the 2008 YTD values were
retained. Additionally, I've done series closes before, mid-way
through a fiscal year, and the LYTD and current YTD values are
correct. I imagine that if 2007 were closed previously and 2008 were
closed today, then 2008 YTD values would be moved to LYTD and current
YTD would be zero but I haven't tested that.
TROOTBMI
bucket to the LYR Bucket. Not a lot happening and it happens pretty quick.
I recently had a client close twice without realizing it. They were
wondering why their Year to Date was zero and their Last Year was so small.
A good way to view Vendor Balances Cards>Purchasing>Summary>Yearly (lower
right hand corner) select Calendar Year/Fiscal Year and then calculate. You
can view Amount Since Last Close and this will only be accurate to the
Calendar/Fiscal year if you are able to close each year before you post to
the following year.
(on the other side RM) I had to run a query by document to obtain accurate
yearly sales totals for a client that closed Sales (for 2007) after the 1st
quarter (2008). They had the best of intentions and were surprised and
expected it to work like Frank mentioned. They selected only Fiscal for
Year-End close. But when they ran a smartList report for YTD Sales it showed
zero and they knew that it should have been much greater.
GP should allow for an option to determine how to reset YTD and LYR when
performing year-End Close for Sales and Purchasing. Many companies do not
close before posting to the new year. I have had many clients complain that
their YTD and LYR totals are not right and want to know why... This process
has been the main reason why
Frank Hamelly, MCP-GP
what I did to get the results I got.
Thanks for the info TROOT.
Don
I just wanted to follow-up on this post as I do have two SQL scripts that
correct the problem in the sales module. due to the fact that I just
recently came across this issue in the payables module I am in the process of
developing a script to correct the amounts here as well.
If you would like the scripts please let me know and I will forward them.
Thanks
Don
Michael
Would I be able to get these scripts from you also?
Thanks,
Michael
Don
Please send me an email at doncr...@hotmail.com once I receive the email I
will forward the Scripts for the sales module and when I have completed the
script for the payables module I will send it along.
Thanks
Don
Katie Bley
Katie
kb...@keyquestconsulting.com
> On Tuesday, May 13, 2008 10:37 AM Ryandb wrote:
> We have been having problems with getting correct values for LYR and YTD in
> SmartList since our most recent year end close.
>
> My understanding of them is below:
> LYR - Would be all entries from two closes ago to the most recent close.
> YTD - Would be all entries since the most recent close.
>
> Is this correct? Currently LYR is displaying 2006 information even though
> we have had a fiscal year close on 1/1/2006, 1/1/2007, and 1/1/2008. We
> never close our tax year since we don't use that functionality so it is
> currently set at 0/0/0000, could this be an issue? YTD is currently
> calculating from today (May 13th 2008) to May 13th 2007.
>
> Does anyone else have any issues with these columns or know some general
> troubleshooting tips for them, such as what they rely on?
>
> Thanks!
>> On Tuesday, May 13, 2008 3:24 PM don.crai wrote:
>> Hi Ryandb2,
>>
>> Can you please let me know which smartlist you are having a problem with the
>> LYR and YTD numbers.
>>
>> In the past within the sales and purchasing module if you did not close
>> these subledgers off at the end of your fiscal year the LYR an YTD numbers
>> would be incorrect. I have developed a couple of scripts that will correct
>> these numbers for you.
>>
>> Thanks
>> Don
>>
>> "Ryandb2" wrote:
>>> On Tuesday, May 13, 2008 3:34 PM Ryandb wrote:
>>> Thanks for the response.
>>>
>>> The module we are having trouble with is purchasing. More specifically we
>>> are trying to pull these into a Vendor Smartlist.
>>>
>>> This might be a dumb question but is there an easy way to tell if we closed
>>> the subledgers at end of year?
>>>
>>> "Don" wrote:
>>>> On Tuesday, May 13, 2008 3:35 PM Ryandb wrote:
>>>> The problem is occuring while running vendor reports in the purchasing
>>>> module. Is there an easy way to tell when we closed out these subledgers?
>>>>
>>>> Thanks!
>>>>
>>>> "Don" wrote:
>>>>> On Tuesday, May 13, 2008 4:54 PM don.crai wrote:
>>>>> Yes there is away to find out if you have closed the subledgers. You will
>>>>> need to go into Tools --> Routines --> Purchasing --> Year End Close. Within
>>>>> this screen you will be able to see what the last close date was for the
>>>>> module.
>>>>>
>>>>> The steps are the same for the Sales module as well.
>>>>>
>>>>> Thanks
>>>>> Don
>>>>>
>>>>> "Ryandb2" wrote:
>>>>>> On Tuesday, May 13, 2008 6:03 PM Ryandb wrote:
>>>>>> Well that's scary, it says 1/25/2007. We always close on new years so I
>>>>>> wonder why it is the 25th. And apparently we forgot to close the purchasing
>>>>>> module this year completely. Is there anyway to fix this? It doesn't look
>>>>>> like we can specify a date so if we were to close today then our year end
>>>>>> would be May 13th, which wouldn't be any better.
>>>>>>
>>>>>> Thanks for your help Don!
>>>>>>
>>>>>> "Don" wrote:
>>>>>>> On Wednesday, May 14, 2008 7:57 AM don.crai wrote:
>>>>>>> Hi Ryan,
>>>>>>>
>>>>>>> I will be checking into this today and get back to you if there is a
>>>>>>> positive or negative solution on this issue.
>>>>>>>
>>>>>>> thanks
>>>>>>> Don
>>>>>>>
>>>>>>> "Ryandb2" wrote:
>>>>>>>> On Wednesday, May 14, 2008 1:02 PM don.crai wrote:
>>>>>>>> Hi Frank,
>>>>>>>>
>>>>>>>> This is not a true statement, When you close the subledgers it will take the
>>>>>>>> dollar values upto the date that you close and move them into the LYTD bucket
>>>>>>>> and anything that is processed after the close will be processed into the YTD
>>>>>>>> buckets. This is the reason why Microsoft has provided the abilty within the
>>>>>>>> Vendor Yearly summary the views of Amounts since last close, fiscal year and
>>>>>>>> Calendar year views.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Don
>>>>>>>>
>>>>>>>>
>>>>>>>> "Frank Hamelly, MCP-GP" wrote:
>>>>>>>>> On Wednesday, May 14, 2008 6:03 PM TROOTBM wrote:
>>>>>>>>> Don has it right. The Closing process is pretty much just moving the YTD
>>>>>>>>> bucket to the LYR Bucket. Not a lot happening and it happens pretty quick.
>>>>>>>>> I recently had a client close twice without realizing it. They were
>>>>>>>>> wondering why their Year to Date was zero and their Last Year was so small.
>>>>>>>>> A good way to view Vendor Balances Cards>Purchasing>Summary>Yearly (lower
>>>>>>>>> right hand corner) select Calendar Year/Fiscal Year and then calculate. You
>>>>>>>>> can view Amount Since Last Close and this will only be accurate to the
>>>>>>>>> Calendar/Fiscal year if you are able to close each year before you post to
>>>>>>>>> the following year.
>>>>>>>>>
>>>>>>>>> (on the other side RM) I had to run a query by document to obtain accurate
>>>>>>>>> yearly sales totals for a client that closed Sales (for 2007) after the 1st
>>>>>>>>> quarter (2008). They had the best of intentions and were surprised and
>>>>>>>>> expected it to work like Frank mentioned. They selected only Fiscal for
>>>>>>>>> Year-End close. But when they ran a smartList report for YTD Sales it showed
>>>>>>>>> zero and they knew that it should have been much greater.
>>>>>>>>>
>>>>>>>>> GP should allow for an option to determine how to reset YTD and LYR when
>>>>>>>>> performing year-End Close for Sales and Purchasing. Many companies do not
>>>>>>>>> close before posting to the new year. I have had many clients complain that
>>>>>>>>> their YTD and LYR totals are not right and want to know why... This process
>>>>>>>>> has been the main reason why
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> "Frank Hamelly, MCP-GP" wrote:
>>>>>>>>>> On Thursday, May 15, 2008 10:35 AM don.crai wrote:
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> I just wanted to follow-up on this post as I do have two SQL scripts that
>>>>>>>>>> correct the problem in the sales module. due to the fact that I just
>>>>>>>>>> recently came across this issue in the payables module I am in the process of
>>>>>>>>>> developing a script to correct the amounts here as well.
>>>>>>>>>>
>>>>>>>>>> If you would like the scripts please let me know and I will forward them.
>>>>>>>>>>
>>>>>>>>>> Thanks
>>>>>>>>>> Don
>>>>>>>>>>
>>>>>>>>>> "Frank Hamelly, MCP-GP" wrote:
>>>>>>>>>>> On Thursday, May 15, 2008 5:11 PM Michae wrote:
>>>>>>>>>>> Hi Don!
>>>>>>>>>>> Would I be able to get these scripts from you also?
>>>>>>>>>>> Thanks,
>>>>>>>>>>> Michael
>>>>>>>>>>>
>>>>>>>>>>> "Don" wrote:
>>>>>>>>>>>> On Friday, May 16, 2008 7:50 AM don.crai wrote:
>>>>>>>>>>>> Hi Michael,
>>>>>>>>>>>>
>>>>>>>>>>>> Please send me an email at doncr...@hotmail.com once I receive the email I
>>>>>>>>>>>> will forward the Scripts for the sales module and when I have completed the
>>>>>>>>>>>> script for the payables module I will send it along.
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks
>>>>>>>>>>>> Don
>>>>>>>>>>>>
>>>>>>>>>>>> "Michael" wrote:
>>>>>>>>>>>>> On Friday, May 16, 2008 8:52 PM Frank Hamelly, MCP-GP wrote:
>>>>>>>>>>>>> The fiscal year close is based on your Fiscal calendar as defined in
>>>>>>>>>>>>> Fiscal Periods setup. It doesn't matter what date you close the year,
>>>>>>>>>>>>> the LYR, YTD, and LTD amounts will reflect activity based on your
>>>>>>>>>>>>> fiscal year setup.
>>>>>>>>>>>>>
>>>>>>>>>>>>> It's a little confusing but the date in the Year-end Closing window is
>>>>>>>>>>>>> the date the last closing process was run, not the date the close was
>>>>>>>>>>>>> run through.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Frank Hamelly
>>>>>>>>>>>>> MCP-GP, MCT
>>>>>>>>>>>>> East Coast Dynamics
>>>>>>>>>>>>> www.eastcoast-dynamics.com
>>>>>>>>>>>>>> On Friday, May 16, 2008 8:53 PM Frank Hamelly, MCP-GP wrote:
>>>>>>>>>>>>>> That's interesting Don. I tested it just before posting my comment.
>>>>>>>>>>>>>> I did a 2007 Purchasing close as of today and the 2008 YTD values were
>>>>>>>>>>>>>> retained. Additionally, I've done series closes before, mid-way
>>>>>>>>>>>>>> through a fiscal year, and the LYTD and current YTD values are
>>>>>>>>>>>>>> correct. I imagine that if 2007 were closed previously and 2008 were
>>>>>>>>>>>>>> closed today, then 2008 YTD values would be moved to LYTD and current
>>>>>>>>>>>>>> YTD would be zero but I haven't tested that.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Frank Hamelly
>>>>>>>>>>>>>> MCP-GP, MCT
>>>>>>>>>>>>>> East Coast Dynamics
>>>>>>>>>>>>>> www.eastcoast-dynamics.com
>>>>>>>>>>>>>>> On Friday, May 16, 2008 8:53 PM Frank Hamelly, MCP-GP wrote:
>>>>>>>>>>>>>>> Huh. I guess I'm going to have to go back and test it again to see
>>>>>>>>>>>>>>> what I did to get the results I got.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Thanks for the info TROOT.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Frank Hamelly
>>>>>>>>>>>>>>> MCP-GP, MCT
>>>>>>>>>>>>>>> East Coast Dynamics
>>>>>>>>>>>>>>> www.eastcoast-dynamics.com
>>>>>>>>>>>>>>> Submitted via EggHeadCafe
>>>>>>>>>>>>>>> ASP.NET Base64 Image Encoding via the Data: protocol
>>>>>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/70f76817-e6d2-415d-8849-849d8c6c5385/aspnet-base64-image-encoding-via-the-data-protocol.aspx
Gloria Schrock
Thanks!
>>>>>>>>>>>>>>>> On Wednesday, February 09, 2011 11:36 AM Katie Bley wrote:
>>>>>>>>>>>>>>>> Can I get those scripts as well? I have an issue where PM and RM were closed as of 02/04/11, which is throwing the YTD numbers for 1099 and for Sales. I hope you are still following this post, because I see it is several years old.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Katie
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> kb...@keyquestconsulting.com
>>>>>>>>>>>>>>>> Submitted via EggHeadCafe
>>>>>>>>>>>>>>>> Pass Values Between Windows Forms
>>>>>>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/a3e1e170-21d9-4a59-a659-3ead05bb36f2/pass-values-between-windows-forms.aspx