web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Inventory transaction ...
Finance | Project Operations, Human Resources, ...
Answered

Inventory transaction filteration

(0) ShareShare
ReportReport
Posted on by Ax-training 65

I tried to filter the transactions of inventory transactions with no financial date (not yet invoiced) by using ="" on the filter option, but it shows the error

Division by zero. - (S)\Data Dictionary\Tables\InventTrans\Methods\CIT Sales Value - line 15 (C)\Classes\QueryRun\next (C)\Classes\FormDataSource\executeQuery (C)\Forms\InventTransItem\Data Sources\InventTransOrigin\Methods\executeQuery - line 28 (C)\Classes\FormDataSource\research (C)\Classes\FormRun\task (C)\Classes\SysSetupFormRun\task - line 27 error
since there were a lot of transactions I can't transfer that data to excel 
Help me to find those transactions which were not invoiced or didn't have any financial date 
I have the same question (0)
  • guntur hakim Profile Picture
    guntur hakim 5 on at
    RE: Inventory transaction filteration

    Hi Dr. Ludwig
    thanks for explaining is very helping me to filter my transaction because I'm new use mics dynamics
    at my company
    best regards

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,669 Super User 2025 Season 2 on at
    RE: Inventory transaction filteration

    Hi AX-training,

    Can you verify if this is caused by a customization? The error is mentioning a CITSalesValue method which could be part of a customization. A developer might have added a calculation and forgot to evaluate the value before using it in the division.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory transaction filteration

    I see.

    If you cannot export the filtered data at once because you have too many records then try to export the data in stages e.g. first all transactions for items starting with A, then for items with B and so on.

    Does that work for you?

  • Ax-training Profile Picture
    Ax-training 65 on at
    RE: Inventory transaction filteration

    Hi ludwig,

    Not only for purchase and sales I need for all transaction, like production, transfer order

    thanks

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory transaction filteration

    Hi AX-training,

    To find transactions that are not invoiced you can make use of the standard shipped not invoiced resp. received not invoice forms in the purchasing and sales modules.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,352

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 810 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 616 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans