1) VAT is a transaction tax that is paid by end consumers
2) Setting up of VAT Posting Group is the same as the General Posting Group
a) VAT Business Posting Group - Customers & Vendors (Who)
b) VAT Product Posting Group - Items & Resources (What)
3) VAT Business Posting Groups
a) FINANCIAL MANAGEMENT -> SETUP -> VAT POSTING GROUP -> BUSINESS
b) Code field can accept 10 characters
4) VAT Product Posting Groups
a) FINANCIAL MANAGEMENT -> SETUP -> VAT POSTING GROUP -> PRODUCT
b) used to calculate tax based on types of item perchased or sell.
5) VAT Posting Setup
a) Matrix of VAT Business Posting Groups and VAT Product Posting Groups
Showing posts with label Technical. Show all posts
Showing posts with label Technical. Show all posts
When you want to make a changes or post something and the following messeage come out:
"table is Locked by another user"
This means that another user is also modifying data in the same table. Navision has locked the table for the user to modify so that no other users can modify the same data at the same time. Any other user who want to modify the same data must wait until the user who locked the table to finish his/her changes first. Once the user has finish modifying the data, Navision will release the table lock for other users to use.
Navision allow you to check which user is locking other users.
1) Go to File-->Database-->Information.
2) Select the Sessions tab.
3) Drill down to the current sessions.
4) Check on the Blocking user id column to find out who is locking other people.
You have created a simple dataport and very confident that the dataport can import data into your table without any problem. Then, you try to run the dataport (Ctrl + R) and import a file into your table. The import process completed successfully. Then you go to your table to check the imported data but the luck is not with you. The data not found in your table.
First thing you need to check is the AutoSave and Auto Update properties of your property. Set it to Yes if it is in No status.
Still cannot. Make sure you have saved and compiled your dataport and run it from the Object designer. Very often, you are very confident that your dataport will work perfectly because it is just a simple dataport. So, you just design and run the dataport without saving it so that you can save one object license. Your dataport will not save data in your table if you just run it in design mode without saving it first.
After upgrade from 4.0 to 4.0 SP2 and syncronize your windows user Id, you are still not able to login to your database through windows login. You already grant all the necessary roles and permission to your users. You even grant them dbowner and super role, but still can't login. If you use database login, you can login successfully. If this happens to you, most probably is because you have not update the xp_ndo.dll file in you SQL Server Binn directory.
When you upgrade to 4.0 SP2, make sure that you update the xp_ndo.dll on all instance of your SQL Server. You can find the step-by-step instruction on how to update the file from the sql_esp folder in Navision 4.0 SP2 Disk 1 CD.
How To determine what objects can be read with the current license file?
Posted by mojacho | 1:21 PM | Technical1) Create a Tabular Form with the Form Wizard.
2) Enter 2000000044 as the table name.
3) Complete the wizard and run the form.
Table 2000000044 is a virtual table used to stored license information. You cannot find this table in object designer but you can use it as data source in form.
0-9999 - developed by Microsoft Navision
10000 - 49999 - developed by Microsoft Navision Territory REpresentatives
50000-99999 - Microsost Solution Center
1000000 - 98999999 - add on products
Subscribe to:
Posts (Atom)
Posts
