yes, the second database (in second system) should be
able to be connected from the first machine using
ODBC.
--- panda arabinda <[EMAIL PROTECTED]> wrote:
---------------------------------
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/
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor ADVERTISEMENT
---------------------------------
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.
__________________________________
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/
