At 11:32 PM 9/6/2005, Bryan Bornstein wrote:
Hello everyone, I am fairly new to R:Base, but I am very impressed so far. I am getting along pretty well so far, only I need to add an accounts receivable (A/R) aging report to my program. Is there a way to take the Date and invoice amount and "move" them over to an aging report(such as 0-15 days, 16-30, 31-45, 46-60, over 60)?
Bryan, First, welcome to the R:BASE World! There are many ways to achieve your task of calculating the age of any invoice. The simple and classic way is to define a view (permanent or temporary) to first calculate the days. A very simple example: CONNECT RRBYW9 SET ERROR MESSAGE 2038 OFF DROP TABLE tTotalDays SET ERROR MESSAGE 2038 ON CREATE TEMPORARY VIEW tTotalDays (TransID,InvoiceTotal,Days) + AS SELECT TransID,InvoiceTotal,(.#DATE-TransDate) + FROM InvoiceHeader BROWSE * FROM tTotalDays That will give you the snapshot of Invoice Number (TransID), Invoice Amount and total days since the invoice date. Now based on that temporary view, you can build your logic of grouping days and total amount, etc. There are a few certified accountants on this list who might be able to help you. Randy Peterson and Myron Finegold, just to mention a few. Very Best R:egards, Razzak.
