RE: [Axapta-Knowledge-Village] Settling Invoices through code

[Jason Crook]

Hi   Read Through this You could probably put something similar before the super on the Post Button of the Journal,that way Linking the Journal lines to the Open Transactions And then when you post it will do the rest for you. I.e.)This code will do pretty much the same thing as as when you create the payment Proposal. This not the code you should use although it should give you a good idea.This code is used when I am coming from the sales order side and creating a payment Automatically .   ttsbegin;                While                SELECT _CustTransOpen                WHERE  _CustTransOpen.AccountNum == _salestable.CustAccount                JOIN   _CustTrans                WHERE  _CustTransOpen.RefRecId   == _CustTrans.RecId                   &&  _CustTrans.Invoice        == _Salestable.SalesId                     {    While Select * From LedgerJournalTrans                          Where LedgerJournalTrans.JournalNum == ledgerjournaltable.JournalNum                           { _SpecTrans.initValue();                             _SpecTrans.SpecTableId = Tablenum(LedgerjournalTrans);                             _SpecTrans.LineNum     = 1;                             _SpecTrans.Balance01   = -LedgerJournalTrans.amount();                             _SpecTrans.Code        = _salestable.CurrencyCode;                             _SpecTrans.RefId       = _CustTransOpen.RecId;                             _SpecTrans.SpecRecId   = LedgerJournalTrans.RecId;                             _SpecTrans.insert();                           }                     }  ttscommit;   Hope it Helps ,let me know if you require more. Regards Jason Crook Financial Systems Consultant Exordia(A Division Of PricewaterhouseCoopers) Tel     : (011)797-4782 Fax    : (011)209-4782 Cel     : 082 887 0914 e-mail : [EMAIL PROTECTED]   From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: 08 September 2005 01:37 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Settling Invoices through code So has anyone ever through code created a payment Journal, and settled an Invoice? Is there any examples of this anywhere?   thanks in Advance, Brandon From: Brandon George [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 07, 2005 3:22 PM To: 'Axapta-Knowledge-Village@yahoogroups.com' Subject: [Axapta-Knowledge-Village] Settling Invoices through code I have a question. Does anyone have any code examples of Settling an Invoice through code?   Does anyone know what all tables need to be updated? and If there is a class that I can use to settle an Invoice? I am sure it has something to do with creating a Payment Journal. You see we are automating this process for one of our big customer whom we participate in EDI with.   They send us a EFT for money, and also a File that contains what Invoices, etc. was paid with the given EFT transfer. Does anyone have any experience, through code, settling an Invoice and creating a Payment Journal Programmatically?   thanks, Brandon Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS  Visit your group "Axapta-Knowledge-Village" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.