Tuesday 21 January 2020

Dynamics NAV/Business Central. Use own numbering on posted Sales invoices

Crazy right ? One of clients i support came up with that crazy idea. They wanted to manually capture the Posted sales invoice Numbers.
With Dynamics NAV/ Business Central default setup, Posted Number Series are added from Sales & Receivables setup.
Solution

  • Add the "Posting No" to the sales order/sales invoice document page.
  • Make sure the posting Nos. selected for Posting Numbers in sales & receivables setup allow manual numbers



The user can now add the posting number manually!

Cheers

Friday 10 January 2020

Dynamics NAV login error "There is no company in the database. Contact your systems Administrator "/"You do not have the following permissions on TableData profile:Read"

Hello reader. This is my first blog in 2020 so Happy New Year. You are welcome. My colleague ran into a nasty error that took us sometime to resolve. Our client reported a problem so we needed to take a back up so we run it on our PCs for trouble shooting
However, upon restoring the database, and running Dynamics NAV 2018. It would throw this error on the screen.


Trying to run NAV 2018 in configuration mode (Via command-line ) now throws this error



To work around this issue, simply create a new user in Dynamics NAV power shell.
Give the new user super permission set.
To learn how to add users using power shell click here

Cheers!!