Skip to main content
Question

inventory discrepancy lines

  • December 9, 2025
  • 1 reply
  • 19 views

Forum|alt.badge.img+6

Hello,

We need to be able to extract all the inventory discrepancy lines modified/validated by Jingyi in recent days "in € amount"... do you have a procedure?

Kindly help me with this.

Regards,

Kruthika

1 reply

Forum|alt.badge.img+7
  • Do Gooder (Partner)
  • December 30, 2025
  1. Run the Inventory Transaction History (or equivalent) report.

  2. Filter by:

    • User = Jingyi

    • Date range = last X days

    • Transaction type = inventory discrepancy / count difference / adjustment only.

  3. Export to Excel.

  4. In Excel, add columns for:

    • Line value = Qty × Unit Cost

    • EUR value = Line value × FX rate

  5. Sum EUR value for the period.