Wednesday, June 13, 2018

D365- Update 15 (VM) - extend the OS trial period



When open the environment, will get the below message periodically









Solution:  Command prompt à run as administrator







Enter below command for (View Activation, License, and Expiration Date Information) – the current status




slmgr.vbs /dlv






Will get the below message:



Enter below command for extend the OS trial period 


slmgr.vbs /rearm







After a restart







Enter below command for (View Activation, License, and Expiration Date Information) – updated status




slmgr.vbs /dlv







Wednesday, June 6, 2018

D365 - Sales Order Prepayment and settlement (VM/Update 11)



The following steps explain how to link prepayment with sales order and settle as well:

1- Create new sales order



2- Fill the sales order details (Customer, Item, Qty, Price, Etc...)



3- Next, to check on prepayment status, go to sell tab then click the prepayment.




4- The "Total balance" refer to sales order remaining balance and "Amount in transaction currency" refer to prepayment amount as you noticed this sales order doesn't have any prepayment transaction so far.




5- To link prepayment with this sales order, Copy or write down the sales order number and customer code. In this scenario "
000861" is the SO number and customer code is ‘RamPrakash’




6- Create a new Payment Journal.


7- Select the 000861 Sale order customer account code (RamPrakash) under account name, fill the prepayment amount under the credit "300" field and specify the SO number” 000861 “in the “PAYMENT REFERENCE” field
Payment reference, is the link in between prepayment and the relevant Sales order.




And prepayment journal voucher = Yes, under the payment tab.



8- Post the prepayment journal



9- Go back the sales order (000861) and see the update.

Click prepayment. Can view the "Total Balance" Show the sales order remaining balance (1300-300=1000) and “Amount in transaction currency" show the prepayment amount (300).







10- Marked the prepayment line check box before Sale invoice





11- Click 'Yes'



12. Post the sale invoice




13. Cross check the sale transaction under the customer master







Saturday, June 2, 2018

D365 (VM/Update 11) new Storage dimension group - Inventory status


Storage dimension group - Inventory status:

-        Click ‘Active’ check box 


In my scenario, I have created PO (later easily track the PO Item transaction), inventory status dimension in the master


Select PO (inventory status dimension) in vendor master as a default dimension



Default inventory status dimension updated from the vendor master 



After PO confirmed; verify the item transaction:
Go to the Item and click ‘Transaction’



Click ‘Display dimension”


Click ‘inventory status’ check box


Inventory status is visible in inventory transaction line and able to do the filter item transaction through ‘Inventory status’ field.



Please visit following link for more details:

Sunday, May 27, 2018

What if change the user id in the SQL table in D365 (VM/update 11- environment)




I have registered XXX@hotmail via AdminUserProvisioning




Open D365 via XXX@hotmail user id


XXXX@hotmail.com shown as an admin user ID



And the top right corner also shown XXX@hotmail.com as well

Open the “USERINFO” table in SQL.

 Go to the “admin” line


Scroll right side 

Note: under “NETWORKALIS” has been updated XXX@hotmail.com user id. This is updated by “AdminUserProvisioning”

Now, manually changed the XXX@hotmail to XXX@outlook.com


Save and Close the SQL

Now, open the D365 again.
Question: in which login ID (XXX@hotmail.com or XXX@outlook.com), D365 will open


I believe, most of people will think, D365 will open through XXX@outlook.com, however, it is incorrect, reason is, I believe, D365 first check the Azure AD and in AAD the registered user ID is XXX@hotmail.com


1: Login- through XXX@outlook.com



Getting following error, when trying to login through XXX@outlook.com



2: Login- through XXX@hotmail.com



Now, D365 has been opened with the XXX@hotmail.com




However, it is shown XXX@outlook.com as an admin user id, instead of XXX@hotmail.com.



And top right also shown XXX@outlook.com, instead of XXX@hotmail.com
Reason: XXX@outlook.com user id pulls from the SQL, instead of AAD






Bottom line:

During D365 login, internet is needed to validate the login credential (AAD), once logged in the D365 environment, need not require internet connection



Now, I have disconnected/disabled the internet


Still, able to work on D365, without any interruption and posted the below JV.