Best Of
Re: Calculating Date Difference in Days
[Topic moved from 'General Chat' forum to 'NAV Three Tier' forum]
kriki
5
Re: Purchase Order invoice - adding VAT?
Do not try to modify VAT % on the Invoice statistics Page. Change the VAT Product or VAT Business Posting Group on the Purchase Order lines instead. Change one or both to a combination setup to attract the desired percentage of VAT.jonathanchye wrote: »Normal way of applying VAT here is via Purchase Invoice Statistics (F9 button in the line) but I’m unable to adjust VAT amount as the VAT % field is locked to 0.
Re: FORMAT property
<Standard Format,0> is saying to use Standard Format 0. Each type has several Standard Formats - refer to the link you added at the start of your post to see what these are.
The 0 after TheNumber refers to the length (padding) - setting a 0 means use the full length.
The 0 after TheNumber refers to the length (padding) - setting a 0 means use the full length.
Kishorm
5
Re: Sales Blanket Order - fully invoice at start?
Unless you have a really old version, why not using prepayment set to 100% and ship and invoice as the customer requests?
AK
5
Re: Android Universal App Won't connect to NAV 2017
Hi, I think that I have encountered the same error. Check this site as this fixed my problem regarding the Server Timeout. https://mbs-businesscentral.blogspot.com/2018/05/nav-app-error-server-connection-timeout.html
ambangis
5
Re: TABLE, PAGE, REPORT Properties not showing
Hello jhanvincent14,
looks like u did hide the column.
Just rightclick in the header, and click at "show column" and select the "value" Column.
You can click at View -> Show Column... as well.
looks like u did hide the column.
Just rightclick in the header, and click at "show column" and select the "value" Column.
You can click at View -> Show Column... as well.
Aluan
5
Re: NAV 2018 on NVMe disks
I'd thought that the NVMe is the most expensive solution, then the SSD, and then 'old good' 15k spinners
The overhead of software RAID will be miimal comparing to the NVMe performance advantages, so if you really find the NVMe based solution to be the cheapest one go for it.
Usually the NVMes are only used to store volumes where SQL Server transaction log files are kept, to speed up transaction committing. SQL Server can recognize properly configures NVMe based volume and the commit process does not require to copy entire 4k long block of transaction log records onto permanent storage device. It makes massive difference when the SQL Server experiences a big number of relatively short transactions. In non NVMe based environments the problem was alleviated by using delayed durability database setting.
Having said that I am not sure if you will be able to realize fully the NVMe disk based volume advantages in the SQL Server if you put the VMWare layer atop of the NVME disk.
The overhead of software RAID will be miimal comparing to the NVMe performance advantages, so if you really find the NVMe based solution to be the cheapest one go for it.
Usually the NVMes are only used to store volumes where SQL Server transaction log files are kept, to speed up transaction committing. SQL Server can recognize properly configures NVMe based volume and the commit process does not require to copy entire 4k long block of transaction log records onto permanent storage device. It makes massive difference when the SQL Server experiences a big number of relatively short transactions. In non NVMe based environments the problem was alleviated by using delayed durability database setting.
Having said that I am not sure if you will be able to realize fully the NVMe disk based volume advantages in the SQL Server if you put the VMWare layer atop of the NVME disk.
Re: New ID fields in NAV 2018
Hi,
Field 8000 is actual "some kind of surrogate key" that Microsoft uses in the API's.
Take a look at the pages that ends with Entity
Example:
5471 - Customer Entity
You don't use the PK, but the surrogate key.
Like you, I don't have a clue on how this field gets his value.
Field 8000 is actual "some kind of surrogate key" that Microsoft uses in the API's.
Take a look at the pages that ends with Entity
Example:
5471 - Customer Entity
You don't use the PK, but the surrogate key.
Like you, I don't have a clue on how this field gets his value.
BennyVL
5
Re: permission on Table data [TableName] -> [TableID]
[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]
kriki
4
Re: permission on Table data [TableName] -> [TableID]
No chance, I'm afraid.
The error messages generally come from fin.etx file, but 1) the file is protected by some sort of checksum and you cannot modify it 2) even if you could modify the fin.etx in part of the error is hardcoded inside the nav executable.
In your particular example the error is concatenated from two parts, and the table name is supplied by the code inside the NAV binaries.
Slawek
The error messages generally come from fin.etx file, but 1) the file is protected by some sort of checksum and you cannot modify it 2) even if you could modify the fin.etx in part of the error is hardcoded inside the nav executable.
In your particular example the error is concatenated from two parts, and the table name is supplied by the code inside the NAV binaries.
Slawek