Re: [Axapta-Knowledge-Village] Re: Import the text file and create journal,lines and settle the open transactions

Hi Naveed, Can we use the same if i want to import an Excel file and do the same tasks mentioned in mail chain? I have a requirement of that sort regarding the customer payment reciepts i will recieve a excel from customer in which he will be mentioning the details for payment ag

[Axapta-Knowledge-Village] Re: Import the text file and create journal,lines and settle the open transactions

Hi Sanjeev, Following is the code that creates the Journal, marks the transaction (indicated by invoiceid) for settlement and then posts the Journal. server static boolean ProcessPayment(CustPaymMode _paymMode, AccountNum _accountNum, InvoiceId _invoiceId, AmountCurCredit _amountCurCredit, Tr

[Axapta-Knowledge-Village] Re: Import the text file and create journal,lines and settle the open transactions

Hi, You can find all the marked trans in SpecTrans table. The field RefTableId = 865 refer to CustTransOpen, and then RefRecId refer to recId in CustTransOpen. The field SpecTableId refer to where it's marked (eg. 212 = LedgerJournalTrans), and SpecRecId refer to recId in that table Regards To