Hi You can get those information from table custTransOpen, custTrans
Regards Amit Alessandro Ghidini <[EMAIL PROTECTED]> wrote: Ok, thanks.. Ad about my other question (posted in another message)? Any idea for an invoice list with payment status? Ghidini Ing. Alessandro Kibuz SRL Galleria Ludovico Mortara, 2 - 46100 - Mantova Telefono: +39 0376 220605 Fax: +39 0376 367439 Email: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] _____ Da: Amit Jain [mailto:[EMAIL PROTECTED] Inviato: luned� 7 giugno 2004 11.56 A: [EMAIL PROTECTED] Oggetto: Re: [development-axapta] Obtaining an invoice list Yes, You are right on target. custinvoicejour and vendinvoicejour tables keeps the record of all the invoiced sales and purchase order. if you want to see the lines also which has been invoiced(as there are chances that ur SO/PO are partially invoiced), you can refer custinvoicetrans and vendinvoicetrans table. Jour and trans tables are related to each other through invoiceid and transdate. Cheers eradovevivevodare <[EMAIL PROTECTED]> wrote: I need the list of the posted invoices for cust and vend.. Actually i'm looking to the CustInvoiceJour and VendInvoiceJour.. I'm on the right way? Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT <http://rd.yahoo.com/SIG=129brpesj/M=298184.5022502.6152625.3001176/D=groups /S=1705006764:HM/EXP=1086689019/A=2164338/R=0/SIG=11ed4vqbv/*http:/www.netfl ix.com/Default?mqso=60183349> click here <http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S= :HM/A=2164338/rand=904972093> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
