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 snipped-for-privacy@rite.us
Sorry to sounds dumn but how would I get tihs info?
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?
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 snipped-for-privacy@rite.us
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.