Best Of

If I understand correctly, then you have a table with a field (let's call it "Value"), and you have 10 records in that table, right? In that case, this code should do it:

NoOfValues := 0;
if MyTable.FindSet then begin
  repeat
    NoOfValues += 1;
    MyArray[NoOfValues] := MyTable.Value;
  until MyTable.Next = 0 or NoOfValues = 10;
end;

Here:
NoOfValues : Integer;
MyArray : Integer[10];
MyTable : Record "My Table";

@guganvarman_21 - Its a property in the TABLE for Integer Data Types

Check this out

https://docs.microsoft.com/en-us/dynamics-nav/autoincrement-property

Hi @Harshahnk,
When are you experienced database locks is there a specific task that sets of a lock?
When you are expirence lock try running page 9511 - Database Locks and see which user is causing it.
It might clear up why you are have locks. (To get a result with page 9511 you need to to a bit of setting up first https://docs.microsoft.com/en-us/dynamics-nav/monitoring-database-locks)

If that doesn't give you any help try keeping a eye on the Activity monitor which kind of locks you are getting, and what is causing them.

Yes turned out I wasn't calling the report but a codeunit.

You could set up an SMTP server in your local network that has access to the internet and can serve as a relay for your mail (with Exchange it is often done that way).
Or else you need to modify the SMTP Mail codeunit to run client side.

Hi,

Perhaps, you missed something.
Does this code show message with dates for you?

GLAccount.RESET;
GLAccount.SETRANGE("Date Filter", CALCDATE('<-CM>',TODAY),CALCDATE('<CM>',TODAY));
MESSAGE('Min: %1\Max: %2', GLAccount.GETRANGEMIN("Date Filter"),GLAccount.GETRANGEMAX("Date Filter"));

If yes then you have mistake in your code and filter on "Date Filter" is not applied.

You should see table 49 "Invoice Post. Buffer" used in 80 CU.
So you need to add field for example "Document Line No." and change Primary Key in table "Invoice Post. Buffer". After it modify code in 80 CU where filled this table buffer, see InvPostingBuffer[1].PrepareSales method

Hi navisionerin,

Please have a look at the GETRANGEMIN and GETRANGEMAX functions
https://docs.microsoft.com/en-us/dynamics-nav/getrangemin-function--record-
https://docs.microsoft.com/en-us/dynamics-nav/getrangemax-function--record-