HI, I would like to know if it’s possible to manage potentially each single account in the same way as Customer/Vendor accounts. EXAMPLE I would like to have just one account No. for Cash , and have infinite subaccounts like Customers. So I will have Cash Venice, Cash Rome, Cash Milan and so on… For each of these subaccounts I need to have exactly the same functionality of Customers/Vendors like detailed aging. Cheers Giovanni
I have done this for clients, but only a few times. It does seem to be a fairly rare request. I have done it three different ways. 1/ I basically created a seperate Account for each different Cash account. Then copied all the Application code from the Customer Module to the GL Entries (basically the Applies to, remaining amounts etc.). I dd this a couple of times, but in versions prior to the Customer Detail Ledger, and then it was a lot simpler. Now it would not be a good solution. 2/ Was to basically copy the entire Vendor Processing into a whole new function set, by this I mean copy all the tables and functions to User number ranges, and copy all the applicaiton code etc. I did this once, and would not do it again this way. 3/ Just add a new flag to the Vendor Table (“Vendor Type”::Vendor,Cash,etc. use an option, because you will find it uesfull for other stuff later) Then just create new forms for each function type, flow the field through to entires etc, and you have the functionality in about a day of developement. You can ue this for lots of other stuff later also, like paying COmmisisons to contract sales people and stuff like that. PS use vendor, and not customer, since the debit/credit issue looks more logical.
David, In Italy it’s very common to have lots of Balance Sheet Accounts No. managed as Vendors or Customers or with more detailed information. It’s also a legal requirement to detail the final financial statement. I.E. My total debt vs. Employees is equal to £ 10.000,00 . I need to know and I have to specify to the shareholders how this debt is divided. I will have : Employee Bill Clinton total debt £ 3.000,00 Employee Tony Manero total debt £ 5.000,00 Employee Frank Sinatra total debt £ 2.000,00 Every time I use the Debt Vs. Employees Account No. I want to specify the Employee ID. The same occurs for Loans. I can have 10 loans but I want to have just one Account No. The same occurs for VAT debts. In this instance I use 12 subaccounts , one for each month. Is it a good way to use dimensions for each of these accounts? I’m new to Navision so I was thinking on using them, but I’m not really sure. I’m converting data from an AS400 application where lots of Balance Sheet Accounts have this functionality. On the as400 application there’s a flag on the Account No. that specifies the level of detail desired for that account No. and another field to specify which table to look at for the detailed information. Detailed information are generally retrieved from the Vendors or Customers or Employess tables or from another table which is owned by the Chart of Accounts table. Can we do the same way on Navision. Cheers Giovanni P.S. My English is very poor, I hope you can understand what I’m trying to say. Ie. Flag='10
Firstly your English is better than my Italian, and your posting is clear enough [:D] For what you are doing, I would simply use existing Vendor functionality, with the flag to differentiate ebtween real vendors , and GL account detail vendors. Just make sure to be carefull in the posting group setups that users don’t use one of your special posting groups for a normal vendor, since it will cause a lot of problems. I would even go as far as coding the flag into posting groups to prevent this mistake, since it would make a real mess if someone did it. If you have any problems, just post them here for help.
quote:
Firstly your English is better than my Italian, and your posting is clear enough [:D] For what you are doing, I would simply use existing Vendor functionality, with the flag to differentiate ebtween real vendors , and GL account detail vendors.
Originally posted by David Singleton - 2005 Sep 11 : 13:01:49
Hi, David I agree that this would be the the best and easiest to implement solution for this problem. I was just wondering - according to your experience, what do you think would be like to duplicate the whole structure, including the Vendor table and its functions? The new table would have an Option field in the primary key and hold all the many kind of account detail beside Customers, Vendors and Bank accounts and the original Vendor table would be left alone. Anna
Hi Anna, I have done that twice, once in 3.04 Character version, and once in 1.3 Windows. In those versions, there was only really two tables, and fairly limited functionality, so it was very easy. With the current version, it will be much easier to maintain by using the Vendor fucntionality as is,
Hello, we are having similar strict requirements regarding certain accounts (employee loans, investments, banks and cash accounts, etc) and are using a mix of dimensions and bank/vendor/customer usage. E.g. every third party that you own money is setup as customer (with is specific posting group), every third party that owns you money is setup as vendor (e.g. employee loans), every investment account, shareholder or petty cash account is setup as bank account. In this sense, you can take advantage of foreign currency valuation for investments in USD or petty cash accounts in USD, or loans in USD… For us, this approach has really been satisfactory. Saludos Nils
Yes I agree, basically you can use any of them (Cust, Vend, Bank, Fixed Asset) depending on what is closest to your need. I generally though try to stick with one, so that you don’t have to modify them all. I don’t like to use dimensiosn though, since they are not balanced, so its to easy to make a mistake.