|

»

Ledger SMB - Development

Question related to acc_trans

View: New views

3 Messages — Rating Filter: Alert me

	Question related to acc_trans by markus-22 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. Dear All, I need to discuss a point that I face now. Some Sales invoices have a lot of records in the acc_trans. These records are not belong to it but share the same trans_id. If I repost it, everything will be corrected. I don't know the reason until now, any help would be appreciated. Best wishes, Shaekir, ledger-smb-devel@... Dear All, I need to discuss a point that I face now. Some Sales invoices have a lot of records in the acc_trans. This records are not belong to it but sharing with trans_id. If I repost it, everything will be corrected. I don't know the reason until now, any help. Best wishes, Shaekir, ledger-smb-devel@... ReadySetGet a great deal on Windows 7 See phenomenal deals on Windows 7 now ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel@... https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
	Re: Question related to acc_trans by Chris Travers-5 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message On Tue, Oct 27, 2009 at 9:10 AM, <markus@...> wrote: Dear All, I need to discuss a point that I face now. Some Sales invoices have a lot of records in the acc_trans. These records are not belong to it but share the same trans_id. If I repost it, everything will be corrected. I don't know the reason until now, any help would be appreciated. Best wishes, Shaekir, Can you please send sample data (i.e. before/after repost). The following query would be helpful: SELECT accno, description, amount, category, transdate from acc_trans a join chart c on (a.chart_id = c.id) where trans_id = [transaction id]; ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel@... https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
	Re: FW: Question related to acc_trans by Chris Travers-5 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message On Tue, Oct 27, 2009 at 11:20 AM, shaker Khzym <shakerramses@...> wrote: Dear Chris, I have many samples , this is one from them. Thank you so much for your quick replay. Ok. Can you also send the info on the relevant part from the invoice? Something seems rather screwed up with that part. Best Wishes, Chris Travers ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel@... https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel