HI Girish, Thanks for giving idea.But as per your solution the other database should be there in the intranet or not ? I think one application should be able to talk with the other database. is not it ? Regards Arabinda
--- Girish Bhatkal <[EMAIL PROTECTED]> wrote: > Hi santosh, > Well almost everything is possible. But do they > want just the Sales order and purchase order to > synchronise. What about the inventory? even though > you > get a solution of having the same SO's and PO's > created and posted, this could happen only if > inventory is also updated. > > But if the other things are thought of then you > could write code to read the data from another > database (using to ODBCConnection). After getting > the > data you need to write a function to create the SO's > and PO's. > This function has to be written at both the > applications (assuming they are just copy of the > same > application). Then setup to run this function in > batch, set to run at the end of the day. > > hope this would help you. > > cheers, > Girish > > > --- Varden Morris <[EMAIL PROTECTED]> wrote: > > > > Hi santosh > > > > > > > > I think the solution would be journal entries. You > > can use standard Axapta to export the data from > the > > SalesTable and SalesLine tables for the sales > orders > > and the PurchTable and PurchLine tables for the > > purchase orders. > > > > > > > > After this you could then create tables in Axapta > to > > hold the data from these tables so that you can > use > > standard Axapta to import the data. > > > > > > > > You then need to write code to create journal > > entries from these tables and then use standard > > Axapta to post the journals. > > > > > > > > Varden Morris > > > > > > > > J. Wray & Nephew Ltd. - Group I.S. > > > > 234 Spanish Town Road > > > > Kingston 11, Jamaica, W.I. > > > > > > > > Phone: (876) - 923 - 6141 Ext. 2226 > > Fax: (876) - 923 - 5372 > > > > Cell: (876) - 3833566 > > Email: [EMAIL PROTECTED] > > > > [EMAIL PROTECTED] > > > > > > santosh padhi <[EMAIL PROTECTED]> wrote:Hi > all > > > > Hi all, > > > > My client's requirement is > > > > there is 2 location.there they wants to setup 2 > > separate application and database.There is no > > centrlize server. In 1 location they create 10 p.o > > and > > 15 s.o. > > In another location they creates 5 p.o and 10 s.o. > > on > > the same day all the p.o and s.o will > > synchronize.Mean > > in both of the location all the p.o and s.o record > > should updated.How it is possible? > > > > any solution highly appreciated. > > > > santosh > > > > > ________________________________________________________________________ > > Yahoo! India Matrimony: Find your life partner > > online > > Go to: http://yahoo.shaadi.com/india-matrimony > > > > > > Sharing the knowledge on Axapta. > > > > > > Yahoo! Groups SponsorADVERTISEMENT > > > > > > --------------------------------- > > Yahoo! Groups Links > > > > To visit your group on the web, go to: > > > http://groups.yahoo.com/group/Axapta-Knowledge-Village/ > > > > To unsubscribe from this group, send an email > to: > > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the > > Yahoo! Terms of Service. > > > > > > > > > > --------------------------------- > > Celebrate Yahoo!'s 10th Birthday! > > Yahoo! Netrospective: 100 Moments of the Web > > Send instant messages to your online friends > http://uk.messenger.yahoo.com > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ------------------------ Yahoo! Groups Sponsor --------------------~--> What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> 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/