working on two databases in same time

nrapendra
nrapendra Member Posts: 208
edited 2010-04-20 in NAV/Navision Classic Client
Hi All,

I am having two databases, one for current year and one for last year.
Now i have to place a check that all customers who has outstanding amount greater than
6 months should now be billed anymore.
So while creating invoice i have to check customer ledger entry for that customer.
but the problem is that in current database i am having only 15 days data while i need data for 6 months.

is there any way that i can get data from last year database while working on new year database.

-Nrapendra Singh
Nrapendra Singh
(Sr. Tech. Consultant)
Dataman Computer Systems (P) Ltd.
web :www.datamannet.com
mail :nrapendra@datamannet.com

Comments

  • David_Singleton
    David_Singleton Member Posts: 5,479
    Leave everything in one database. Why did you split the databases? And how did you do this?
    David Singleton
  • garak
    garak Member Posts: 3,263
    Are these to databases NAV Databases or is the old one an old 3rd party database?
    If two NAV, why do you use two databases?
    Do you make it right, it works too!
  • David_Singleton
    David_Singleton Member Posts: 5,479
    garak wrote:
    Are these to databases NAV Databases or is the old one an old 3rd party database?
    If two NAV, why do you use two databases?

    Hmmm do we need to ask the same question twice :?: :wink:
    David Singleton
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • nrapendra
    nrapendra Member Posts: 208
    hi,
    thanks for your valuable reply.
    Actually problem is something different.
    We are using Nav-4 SP3 since Last 3 years. Now we have migrated to NAV 2009.
    As you know that there is a lot of difference in table structures in NAV-4 and NAV-2009.
    There are so many fields which are removed in 2009 which exists in 4.
    So we have planned new implementation of NAV 2009.We have created new database and
    transfered the opening balances in new company.

    But the problem is there are some checks which needs last year data verification
    so we want to access both the databases.
    Nrapendra Singh
    (Sr. Tech. Consultant)
    Dataman Computer Systems (P) Ltd.
    web :www.datamannet.com
    mail :nrapendra@datamannet.com
  • Malajlo
    Malajlo Member Posts: 294
    If you did openings, then you have open entries on customers in past.
    Openings on customers/vendors are posted on same date as invoice was recieved/sent. Did you made openings on single date (ie. Jan 1st)?
  • nrapendra
    nrapendra Member Posts: 208
    i have one opening entry on 1st Apr 2010.
    Nrapendra Singh
    (Sr. Tech. Consultant)
    Dataman Computer Systems (P) Ltd.
    web :www.datamannet.com
    mail :nrapendra@datamannet.com
  • Sunset
    Sunset Member Posts: 201
    Using SQL you could use the LinkedObject value. Then extend your check to the linked table.
    Don't just take my word for it, test it yourself

Categories