Thursday 13 February 2020

Dynamics NAV "You donot have permissions to modify Item Ledger Entry table"

Hello, one the users for the client i support came up with a crazy request for change. They wanted some data to be added to the external document number from Posted Purchase Invoice for Purchase Receipts.
I had to create a process only report & run it as a batch job to do it.
However on running the report, i received an error above.
The user i was using had super rights in the user permission set.

I looked up the web for some solutions.

The solution is to explicitly add the permission to the object via the object permissions property.

Sunday 2 February 2020

Dynamics NAV/Business Central Inventory Opening Balances

Hello there, as part of setting up new Dynamics NAV/Business Central Production Database. You will be required to import opening balances.
Today I will only talk about Inventory Opening Balances.

First you will be required to;

  • Setup "Inventory Posting Setup" for your inventory items
  • Setup "Gen. Product Posting Groups"


I am assuming that the items are already added to the item register

On your chart of accounts. Create an "Opening Balance Control Account"  Income/Balance should be Balance Sheet

Modify the setup "Gen. Product Posting Groups" let "Inventory Adjmt. Account" be set to "Opening Balance Control Account"

Using Item Journal.
Capture Journal Line.
Posting date should be Closing date of your financial year
Document No. your choice
Entry Type =Positive Adj
Item No. = Select Item
Quantity
The cost is automatically picked by the system
Post the entry.

Verify the Opening Balance Control Account is credited with the total value of stock
Check that the inventory item has the right quantity
Verify the inventory account is debited