working on two databases in same time

nrapendra

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

David_Singleton

Leave everything in one database. Why did you split the databases? And how did you do this?

garak

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?

David_Singleton

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 :?:

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

nrapendra

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.

Malajlo

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

i have one opening entry on 1st Apr 2010.

Sunset

Using SQL you could use the LinkedObject value. Then extend your check to the linked table.