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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Report of all vendor c...
Microsoft Dynamics AX (Archived)

Report of all vendor charges

(0) ShareShare
ReportReport
Posted on by Community Member

Good Afternoon,

I am looking for a report, in AX2012 that will allow me to see all charges, coded to a specific charges code.  I found the invoice journal report in AP, that indicates I can filter by a charge, but when I run it, I get all charges.  Also, in the report there is no field identifying which charge code was used.

Can someone please tell me if there is a way to manipulate this report to give me what I want, or is there a better report that I can use?

Thank you,

Michelle

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Syed Fasih Profile Picture
    Syed Fasih 2,442 on at

    An easier option will be to go to General Ledger > Reports > Account source explorer and search the report by the main account you specified in the charge code. This way, the main account will only have the transactions associated with the charge code.

    Let me know if this works.

  • Community Member Profile Picture
    Community Member on at

    I am reaching out to our IS group, as I do not see the Account Source Explorer as an option.

  • Suggested answer
    Syed Fasih Profile Picture
    Syed Fasih 2,442 on at

    My bad, I gave response according to D365.

    For AX 2012, you will need to go to General Ledger > Reports > Transactions > Groupings > Ledger transaction list.

    In the main account ledger dimension field, specify the main account used for the Charges.

    You will see all transactions.

    Please mark the answer as verified if this resolves your query.

  • Community Member Profile Picture
    Community Member on at

    Thank you for your assistance.  Unfortunately the development team did not assign a main account to the charge group at set up.  AX defaulted the charge to our inventory account.  I was hoping there was a way to run a ledger transaction for the inventory account, but include a filter to only show charge codes.  

  • Verified answer
    Syed Fasih Profile Picture
    Syed Fasih 2,442 on at

    I will suggest you to use the path of General Ledger > Reports > Transactions > Groupings > Ledger transaction list and try to sort the transactions by transaction type/ or posting type.

    You can try to add a column on the grid on the list which says posting type/transaction type. Let me know if that works.

  • Community Member Profile Picture
    Community Member on at

    I will try this as soon a we get our month closed.  While we are discussing charge codes, can you tell me if it is possible to set a department dimension on the charge code as well, or can you only set a main account.  For instance our early pay discount code is hitting all of our branch locations, based on the vendor, but I want the code to only hit our admin location.  Can I set that up in the charge code, or do I have to restrict the dimension on the account itself?

  • Community Member Profile Picture
    Community Member on at

    My system keeps timing out, so I will have to work directly with my IS team.  Thank you for your help.

  • Suggested answer
    Syed Fasih Profile Picture
    Syed Fasih 2,442 on at

    The code can only be tagged with a main account and not a financial dimension.

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans