BeyondERP.Newsletter
Menu

Transaction page · Inventory management

Inventory adjustment

A journal page where you post gains and losses to inventory quantities while the item keeps its default ledger offset account.

Business process
Maintain inventory levels
Menu item
InventJournalTableLossProfit
Main table
InventJournalTable
Data entity
InventInventoryAdjustmentJournalHeaderEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA journal page where you post gains and losses to inventory quantities while the item keeps its default ledger offset account.
What you do hereUse this journal to adjust stock levels; posting creates an inventory receipt or issue, changes inventory value and creates ledger transactions.
Inventory adjustment page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processMaintain inventory levels
Menu pathInventory management › Journal entries › Items › Inventory adjustment
Set up firstInventory journal names Microsoft Learn
Related pagesMovement Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Inventory management > Journal entries > Items > Inventory adjustment.
  2. Select New, choose the inventory adjustment journal name, and select OK.
  3. Select New and enter the Item number.
  4. Select the Site and Warehouse, and the Location if the item needs one.
  5. Enter the Quantity, and change the cost price if needed.
  6. Select Validate, and then select OK.
  7. Select Post, and then select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Cost priceThe cost per unit used for inventory receipts on the line.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Technical architect

5Technical

Menu itemInventJournalTableLossProfit Checked in Dynamics 365
FormInventJournalLossProfit Checked in Dynamics 365
TableInventJournalTableShown as “Inventory journal table” in Record infoKey field: JournalId, JournalType, JournalNameId, DescriptionChecked in Dynamics 365
Data entitiesInventInventoryAdjustmentJournalHeaderEntityInventory adjustment headers Microsoft data model InventInventoryCountingJournalHeaderEntityInventory counting journal headers Microsoft data model InventInventoryMovementJournalHeaderEntityInventory movement headers Microsoft data model ProjectItemJournalTableEntityProject item journal header Microsoft data model
Roles to set it up and use itTo set it up or change itWarehouse worker WMSWarehouseWorkerShop supervisor JmgShopSupervisorMachine operator JmgMachineOperatorTo use itQuality control manager InventQualityControlManagerWarehouse manager WMSWarehouseManagerMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkProduction supervisor ProdProductionSupervisorGive people one of these roles. On this system, 23 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=InventJournalTableLossProfit
Integrate withInventInventoryAdjustmentJournalHeaderEntity data entity Microsoft data model
Data migrationInventInventoryAdjustmentJournalHeaderEntity (Inventory adjustment headers): loaded for each company.Microsoft Learn
Table definitionInventJournalTable columns and relations Microsoft data model
Everyone

7Sources