Search Again: Re: Converting to OG From: Shawn Hogan Date: Tuesday, July 6, 1999 Time: 3:54:35 pm Rick wrote: >I have imported all of my users info into OG from an Access database. >As I understand it, now I need to create the billing cycle information for >each user. >But I discovered that at least one of my users had a expiration date of >01/31/1900. >I created an invoice based on my 6-month rate and prorated it and found that >it costs >$20904.48 (including tax) for a century of internet service. ;-) > >But, seriously, is there another better way to take care of this situation >without totally wrecking the accounting benefits of OG? Well, you are definately going to need to fix the expiration dates... The expiration date is date the customer has paid for service up through, and is one of the most important peices of data in the system. If you need to, give yourself access to edit the expiration date by hand, make the changes and then just rebuild the indexes when you are done (that will fix any problems that manual editing of the expiration date causes). - Shawn ------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (619) 452-3696 ------------------------------------------- To subscribe, unsubscribe and list archive please visit http://www.optigold.com/lists -------------------------------------------

Messages In This Thread: Converting to OG by Rick on Jul 6, 1999 at 3:42:19 pm Re: Converting to OG by Shawn Hogan on Jul 6, 1999 at 3:54:35 pm