Reporting upon Accounts Payable Aging NAV 5.0

Last post 08-01-2008 1:40 PM by Bob Palmer. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

07-24-2008 9:05 AM

RichSara
Joined on 07-24-2008
Posts 5

Reporting upon Accounts Payable Aging NAV 5.0

Reply Contact

Colleagues;

As a new contractor at my current location, I have been asked to (among other reporting requests) report upon Accounts Payable Aging in NAV 5.0 using SQL Server RS. It is my 1st foray into this system (background in SAP\JDE ...) and I am a mite stymied trying to figure out how to do so. Part of the problem has been getting table ID's & relations. Having used CTRL-F2 from the aging report in AP I find tables Vendor and Vendor Ledger Entry. The relation looks like vendor# to vendor# yet I can not find any info which would provide the cells which hold the payment or orig amounts. I reviewed the report code as well and this provided little help. Looks like some functions are hidden to me. We have limited documentation and source code access which is a problem. Are there an online resources one could suggest? Lastly, is there a documentation site online which shows NAV entity\attibute diagrams? I noted that NaviToolsER has documented older table versions but was wondering where I might find the 5.0 versions. I did'nt want to but a package or contracting services but our MS Partner seems reluctant to hand things over (they want to continue to "milk the cash cow.")

Any help is greatly appreciated,

Peace! Rich S (RDS)

Tags: EFT Payables, POs

08-01-2008 1:40 PM In reply to

Bob Palmer
Joined on 08-01-2008
Posts 1

Re: Reporting upon Accounts Payable Aging NAV 5.0

Reply Contact

Rich,

If you run the table (or open it in SQL), you'll see that you have several key fields on the table. Original Amount, Remaining Amount, Due Date, Posting Date, Vendor No., etc.

You will need something to sort these into aging buckets by date, which can be accomplished by a SQL function or two.

Finally, there is some documentation and training which you should have available if you are current on your Software Upgrades contract with Microsoft. This will be available to you under CustomerSource. The ID that MS refers to is most often your telephone number with area code (10 digits).

Call customer service if you need further assistance.

Good luck.

-bob-

Page 1 of 1 (2 items)