Friday, 21 April 2023

Setup for Posting of GRN Entry into Product Receipt Ledger in MS D365 F&O

Business Scenario

  • Customer wants to post-entry of GRN/Product Receipt into its respective ledger account
  • To ascertain the value of GRNs which remain un-invoiced during the month-end

Note: Generally, this setup is required for businesses having a long time gap between GRN/product receipt and invoicing.


Configuration

  1. Go to Inventory management > Setup > Inventory > Item model groups

Here, tick the bullion POST PHYSICAL INVENTORY, it will allow posting GRN entry into its respective ledger account



Setup of that respective ledger account:

Inventory management > Setup > Posting > Posting > Purchase order tab > Select Cost of purchased materials received and assign ledger account for the same (in our case ledger account is 11221000.)



Outcome

  1. Create new Purchase order and make GRN/Product Receipt 
  2. To Check go to, General ledger > Inquiries and reports > Ledger account transaction

Here, select that particular main account and date range of GRN and submit. We will find GRN entries debited in the ledger account.



Note: After invoicing the Purchase order, the above ledger posting entry will get reversed.

 

Thanks for Learning!

Good Day Blush

No comments:

Post a Comment

If you have any doubt please do let me know

Featured post

Vendor Aging Report with Large Data Volume in Microsoft D365 F&SC

 Introduction There is a thrilling announcement that Microsoft has launched a new functionality for Vendor Aging reports having large data v...