How to Use Physical Inventory Journals in D365 BC

Use Physical Inventory Journals in D365 BC:

(1) In this blog, we will learn about the use of “Physical Inventory Journals” in D365 BC. It is mainly used for adjusting item inventory in the system, which means matching the system inventory with the physical inventory of the organization. Physical Inventory Journal used for rectification of stock.

(2) For this go to the search bar and open the “Physical Inventory Journals”, as shown.

Physical Inventory Journals in d365 bc

(3) After that “Physical Inventory Journal” page opens, as shown.

Physical Inventory Journal Page Open in D365 BC

(4) Now go to the Prepare Calculate Inventory, as shown.

Calculate inventory d365 bc

(5) After selecting the above option, a pop window opens and enter the option as per the business requirement and press the OK button as shown.

calculate inventory bsuiness central
Field NameNature of FieldField Description
Posting DateMandatorySpecifies the date for the posting of this batch job. By default, the working date is entered, but you can change it.
Document No.MandatorySpecifies the number of the document that is processed by the report or batch job.
Item Not on InventoryAs Per RequirementSpecifies if journal lines should be created for items that are not on inventory, that is, items where the value in the Qty. (Calculated) field is 0.
Include Item w/o TransactionAs Per RequirementSpecifies if journal lines should be created for items that are not on inventory and are not used in any transactions.
By DimensionAs Per RequirementSpecifies the dimensions that you want the batch job to consider

(6) After that, the system calculates the Inventory from the ILE and creates a line in the journal. Now match the inventory with the physical stock sheet, if any difference finds then enter the differential quantity in the Quantity field as shown.

calculates the Inventory from the ILE in d365 bc

(7) Now Press F9 to post the entries and in this way, Inventory rectification is done.

post the jouranl lines d365 bc

Report Extension Overview in Business Central D365
How to Switch Company and Environment in D365 BC SAAS
New Fields add in Report using Extension in D365 BC
Dimension Set Entries in D365 BC
Dimensions and Dimension Values Overview and Setup in D365 BC
Creation of Chart of Accounts in D365 BC
Set Up or Change the Chart of Accounts– Microsoft Docs

Leave a Reply