Paul, This may have been lost in the holiday mail. How do I enter the credit manually with SQL?
Bryan On 2012-12-25 16:11, bryan wrote: > Paul, > > Looks like I erased the credit and prorated "services". > Added them back in as per the original citrus.sql. > > Now how do I insert the credit manually? > > Bryan > > > > On 2012-12-08 00:37, Paul Yasi wrote: >> I cannot duplicate the link failing, it is loading the >> tools/addcredit.php script. The whole payment is recorded, however >> if >> the credit is not entered with that link on that account then it >> must >> be entered manually. Sometimes a customer may pay for two accounts >> or >> multiple invoices with one payment, so you may not always want to >> click that link that automatically adds a credit to the account and >> instead need to find the other account they paid for or the other >> invoice to apply that amount to. >> >> Paul >> >> On Fri, Dec 7, 2012 at 12:25 AM, bryan <br...@inter.net> wrote: >>> Paul, >>> >>> Could you tell me what happens to the credit after a payment is >>> made? >>> It echoes the message: Payment Saved, $31.50 Left over, Add Credit >>> for >>> $31.50 >>> The last is a link the doesn't work for me at least. >>> >>> A payment of $94.50 was entered. >>> Customer only needs $63.00 to pay the invoice. >>> Credit amount is $31.50. >>> >>> If the credit isn't entered is it lost? >>> The full $94.50 shows up on the payment_history table though. >>> >>> Regards, >>> Bryan >>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial >>> Remotely access PCs and mobile devices and provide instant support >>> Improve your efficiency, and focus on delivering more value-add >>> services >>> Discover what IT Professionals Know. Rescue delivers >>> http://p.sf.net/sfu/logmein_12329d2d >>> _______________________________________________ >>> Citrusdb-users mailing list >>> Citrusdb-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > > ------------------------------------------------------------------------------ > LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial > Remotely access PCs and mobile devices and provide instant support > Improve your efficiency, and focus on delivering more value-add > services > Discover what IT Professionals Know. Rescue delivers > http://p.sf.net/sfu/logmein_12329d2d > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users ------------------------------------------------------------------------------ Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
