Modifiying Aging

Hi,
Wondering if anyone knows of an easy way via SQL Statements to modify RMS'
aging for all customers to "Net 30 Days" instead of "Revolving". For
whatever reason, when we had the system seutp/installed 2+ yrs ago, the
manager at the time opted to configure the system for Revolving but we
really need it to be Net 30 Days.
Any help would be greatly appreciated.
Tracy B

Tracy,
If you can submit both the Account Codes from the Net 30 Days account
and the Revolving account I can whip up a script for you to do this.

Thank you,

Ryan Sakry
Program Manager

http://www.rite.us
320-230-2282 ext. 4002 (Office)
320-230-1796 (Fax)

On 8/2/2010 10:13 AM, Burke, Tracylee wrote:
> Hi,
> Wondering if anyone knows of an easy way via SQL Statements to modify
> RMS' aging for all customers to "Net 30 Days" instead of "Revolving".
> For whatever reason, when we had the system seutp/installed 2+ yrs ago,
> the manager at the time opted to configure the system for Revolving but
> we really need it to be Net 30 Days.
> Any help would be greatly appreciated.
> Tracy B
>

Sorry to sounds dumn but how would I get tihs info?

"Ryan @ RITE" <> wrote in message
news:...
> Tracy,
> If you can submit both the Account Codes from the Net 30 Days account and
> the Revolving account I can whip up a script for you to do this.
>
> Thank you,
>
> Ryan Sakry
> Program Manager
>
> http://www.rite.us
> 320-230-2282 ext. 4002 (Office)
> 320-230-1796 (Fax)
>
> On 8/2/2010 10:13 AM, Burke, Tracylee wrote:
>> Hi,
>> Wondering if anyone knows of an easy way via SQL Statements to modify
>> RMS' aging for all customers to "Net 30 Days" instead of "Revolving".
>> For whatever reason, when we had the system seutp/installed 2+ yrs ago,
>> the manager at the time opted to configure the system for Revolving but
>> we really need it to be Net 30 Days.
>> Any help would be greatly appreciated.
>> Tracy B
>>

As it turns out, there isn't a problem with the way our aging is calculating
and the system is properly configured for Net 30...the actual issue is the
report column headings...they are decieving and don't use standard
accounting terminology, i.e. the report shows the following columns:

Current 1-30 31-60 61-90 90+

When in reality it should read:

Current 31-60 61-90 91-120 120+

Does anyone have suggestions on how I can modify the report headings and
also verify the calculations are correct?




"Burke, Tracylee" <> wrote in message
news:...
> Sorry to sounds dumn but how would I get tihs info?
>
> "Ryan @ RITE" <> wrote in message
> news:...
>> Tracy,
>> If you can submit both the Account Codes from the Net 30 Days account and
>> the Revolving account I can whip up a script for you to do this.
>>
>> Thank you,
>>
>> Ryan Sakry
>> Program Manager
>>
>> http://www.rite.us
>> 320-230-2282 ext. 4002 (Office)
>> 320-230-1796 (Fax)
>>
>> On 8/2/2010 10:13 AM, Burke, Tracylee wrote:
>>> Hi,
>>> Wondering if anyone knows of an easy way via SQL Statements to modify
>>> RMS' aging for all customers to "Net 30 Days" instead of "Revolving".
>>> For whatever reason, when we had the system seutp/installed 2+ yrs ago,
>>> the manager at the time opted to configure the system for Revolving but
>>> we really need it to be Net 30 Days.
>>> Any help would be greatly appreciated.
>>> Tracy B
>>>
>

All you would need to do is modify the Title field for each of the
columns in the Customer - Account Receivable (Summary) Report.qrp file
located in the Reports Folder of RMS.

Thank you,

Ryan Sakry
Program Manager

http://www.rite.us
320-230-2282 ext. 4002 (Office)
320-230-1796 (Fax)

On 8/3/2010 10:29 AM, Burke, Tracylee wrote:
> As it turns out, there isn't a problem with the way our aging is
> calculating and the system is properly configured for Net 30...the
> actual issue is the report column headings...they are decieving and
> don't use standard accounting terminology, i.e. the report shows the
> following columns:
>
> Current 1-30 31-60 61-90 90+
>
> When in reality it should read:
>
> Current 31-60 61-90 91-120 120+
>
> Does anyone have suggestions on how I can modify the report headings and
> also verify the calculations are correct?
>
>
>
>
> "Burke, Tracylee" <> wrote in message
> news:...
>> Sorry to sounds dumn but how would I get tihs info?
>>
>> "Ryan @ RITE" <> wrote in message
>> news:...
>>> Tracy,
>>> If you can submit both the Account Codes from the Net 30 Days account
>>> and the Revolving account I can whip up a script for you to do this.
>>>
>>> Thank you,
>>>
>>> Ryan Sakry
>>> Program Manager
>>>
>>> http://www.rite.us
>>> 320-230-2282 ext. 4002 (Office)
>>> 320-230-1796 (Fax)
>>>
>>> On 8/2/2010 10:13 AM, Burke, Tracylee wrote:
>>>> Hi,
>>>> Wondering if anyone knows of an easy way via SQL Statements to modify
>>>> RMS' aging for all customers to "Net 30 Days" instead of "Revolving".
>>>> For whatever reason, when we had the system seutp/installed 2+ yrs ago,
>>>> the manager at the time opted to configure the system for Revolving but
>>>> we really need it to be Net 30 Days.
>>>> Any help would be greatly appreciated.
>>>> Tracy B
>>>>
>>
>

Hi, I actually already figured that out and did the same for the detailed
version. Thanks!!
"Ryan @ RITE" <> wrote in message
news:...
> All you would need to do is modify the Title field for each of the columns
> in the Customer - Account Receivable (Summary) Report.qrp file located in
> the Reports Folder of RMS.
>
> Thank you,
>
> Ryan Sakry
> Program Manager
>
> http://www.rite.us
> 320-230-2282 ext. 4002 (Office)
> 320-230-1796 (Fax)
>
> On 8/3/2010 10:29 AM, Burke, Tracylee wrote:
>> As it turns out, there isn't a problem with the way our aging is
>> calculating and the system is properly configured for Net 30...the
>> actual issue is the report column headings...they are decieving and
>> don't use standard accounting terminology, i.e. the report shows the
>> following columns:
>>
>> Current 1-30 31-60 61-90 90+
>>
>> When in reality it should read:
>>
>> Current 31-60 61-90 91-120 120+
>>
>> Does anyone have suggestions on how I can modify the report headings and
>> also verify the calculations are correct?
>>
>>
>>
>>
>> "Burke, Tracylee" <> wrote in message
>> news:...
>>> Sorry to sounds dumn but how would I get tihs info?
>>>
>>> "Ryan @ RITE" <> wrote in message
>>> news:...
>>>> Tracy,
>>>> If you can submit both the Account Codes from the Net 30 Days account
>>>> and the Revolving account I can whip up a script for you to do this.
>>>>
>>>> Thank you,
>>>>
>>>> Ryan Sakry
>>>> Program Manager
>>>>
>>>> http://www.rite.us
>>>> 320-230-2282 ext. 4002 (Office)
>>>> 320-230-1796 (Fax)
>>>>
>>>> On 8/2/2010 10:13 AM, Burke, Tracylee wrote:
>>>>> Hi,
>>>>> Wondering if anyone knows of an easy way via SQL Statements to modify
>>>>> RMS' aging for all customers to "Net 30 Days" instead of "Revolving".
>>>>> For whatever reason, when we had the system seutp/installed 2+ yrs
>>>>> ago,
>>>>> the manager at the time opted to configure the system for Revolving
>>>>> but
>>>>> we really need it to be Net 30 Days.
>>>>> Any help would be greatly appreciated.
>>>>> Tracy B
>>>>>
>>>
>>