AP Tables

cclarke

Could someone please give me a list of the AP tables with Navision.

We are exporting data out of Navision into a 3rd party application for our sister company.

Any help will be greatly appreciated.


Chris

Slawek_Guzek

Hi,

In my localized version (PL) there are 900+ standard tables

Do you really think that such a list helps you ? Are you sure you want to export data from all of them ?

My suggestion is - better find local NSC or smart freelancer and let them earn some money

Regards,
Slawek.

Alex_Chow

For AP (Accounts Payable), it's just the vendor ledger entries.

cclarke

deadlizard wrote:

For AP (Accounts Payable), it's just the vendor ledger entries.

Just that one table...


Chris

nunomaia

cclarke wrote:

deadlizard wrote:

For AP (Accounts Payable), it's just the vendor ledger entries.

Just that one table...


Chris

I don't know your current Navision version (if it's really financials) but if have a later version you should also look at Detailed Vendor Ledg. Entry

Alex_Chow

If you're only looking for balances to be moved to another system, then the vendor ledger is all you need. This is assuming you already know to bring over the vendor table.

The detailed vendor ledger gives the application detail, which is not that useful if you don't want to bring over A/P history.

cclarke

Thanks, I will take a look at that table...

It seems as though that is exactly what I want....

Cheers,

Chris.

Slawek_Guzek

Sorry, my misunderstanding :oops:

I thought AP = application

Regards,
Slawek