can i use Customer and vendor account no in Chart of Accounts?

Business Central/NAV Developers Forum
1

Hi,

Can i use customer and vendor account in Chart of Account. Like this

9000 RESERVES Balance Sheet Begin-Total 0.00 0.00
9010 P & L Retained Profit Balance Sheet Posting 0.00 0.00
9100 Inter Company Balance Sheet Posting 0.00 0.00
9101 Redhouse Inter Company Balance Sheet Posting 0.00 0.00
9102 GTS Inter Company Balance Sheet Posting 0.00 0.00
9103 GRS Inter Company Balance Sheet Posting 0.00 0.00
9104 Cold Meece Inter Company Balance Sheet Posting 0.00 0.00
9999 Suspense Balance Sheet Posting 0.00 0.00
99999 RESERVES TOTAL Balance Sheet End-Total 9000…99999 0.00 0.00
999999 Balance Sheet TOTAL Balance Sheet End-Total 3000…999999 16,397.01 16,397.01
CUS001 Customer test Balance Sheet Posting 0.00 0.00
CUS002 Customer 2 Balance Sheet Posting 0.00 0.00
VEN001 Vendor Name 1

Balance Sheet

 Posting 0.00 0.00
VEN002 Vendor Name 2 Balance Sheet Posting

1545 1545



4588

I am using Navision 6.00

Thanks

2

This would be possible but very unusual.

In this case you would need to create (manually) all customers as G/L accounts as well and also create one customer posting group per customer and assign the right G/L account to the right customer posting group and the right customer.

This could be supported by some code which would be needed to automate this behavior.

3

Thanks for reply.

By doing this there is no harm with respect of performance and posting.

4

That should not have a big impact on the performance of the system - but of course makes the chart of accounts more complex.

5

You are right,

But this is the requirement from company.

Thanks again.

6

Please "Verify the Solution"in the post which answered your question to show the othermembers of the formum that your problem has been solved.

7

Not quite the same, but take a look at these two blog posts before you’re just giving “what the customer wants”:
http://dynamicsuser.net/blogs/alexchow/archive/2008/12/02/dynamics-nav-navision-can-solve-all-of-your-business-pains.aspx

http://dynamicsuser.net/blogs/singleton/archive/2008/10/30/the-most-powerful-tool-that-a-dynamics-nav-consultant-can-use.aspx

8

From a accountants view: You are requesting for a solution which will nulify the subledger concept of NAV. The requirement seems to be originated from the leagcy system which client might be using.

G/L & sub-ledger have their own importance. You cannot pull all the info of the sub-ledgers in the main G/L as it will make it bulky as well as difficult to analyze. The trial balance will run in hundreds of pages (assuming just 1000 customer/vendor each). Implementation of ERP is more than data punching and statutory report preparation. The management users should be able to analyze the summary and should have the option of drilling down, if required. The client should adapt to the new system and its methods.

I will second Erik’s 2nd link.