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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Supplier Account Statement (Dimension wise)

(0) ShareShare
ReportReport
Posted on by 1,110

hi,

i want to display the Supplier Account Statement Dimension wise in accounts payable module but the statement could not display when i attach the dimension if i remove the dimension and display only vendor account then statement show completely 

for example:

vendor xyz provide the services to our company in deferment sub offices, the company has made the payment from each sub offices and buck the expenses on sub offices through dimension

vendor is one but dimension are many on suboffice name

i want to display the report through dimensionwise

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hello Rana

    Do you speek about a form or a report; and how did you attached the dimension?

    Hans-Peter

  • Rana Imran Profile Picture
    1,110 on at

    Vendor Statement

    Auto-generated document.

    1. Click Area Page node: Purchase ledger -> Reports -> Transactions -> Supplier -> Account statement.

     

    Form name: Account statement

    2. Switch to the General tab on the Account statement form.

    SUPPLIER ACCOUNT STATEMENT WITH DIMENSION

    3. Change To date from '02/01/2015' to '13/01/2015'.

    4. Change Assessment date from '02/01/2015' to '13/01/2015'.

     

    5. Click the Select button.

    Form name: VendAccountStatementInt

    6. Make sure the selection is changed in table Criteria to:

    Table

    Derived table

    Field

    Criteria

    Suppliers

    Suppliers

    Group

     

    7. Change Field from 'Group' to 'Dimension.BB_STATIONS'.

    8. Make sure the selection is changed in table Criteria to:

    Table

    Derived table

    Field

    Criteria

    Suppliers

    Suppliers

    Dimension.BB_STATIONS

     

     

    9. Change Criteria from '' to '003'.

    10. Click the OK button.

    11. Click the OK button.

    Form name: Account statement

    12. Switch to the Options tab on the Account statement form.

    14. Screenshot on demand: Account statement.

     

    15. Close the Account statement form.

    16. Click Area Page node: Purchase ledger -> Reports -> Transactions -> Supplier -> Account statement.

    Form name: Account statement

    17. Switch to the General tab on the Account statement form.

    SUPPLIER ACCOUNT STATEMENT WITHOUT DIMENSION

    18. Click the Select button.

    19. Make sure the selection is changed in table Criteria to:

    Table

    Derived table

    Field

    Criteria

    Suppliers

    Suppliers

    Dimension.BB_STATIONS

    003

    20. Click the Remove button.

    21. Delete the record(s) in the VendAccountStatementInt form.

    22. Make sure the selection is changed in table Criteria to:

    Table

    Derived table

    Field

    Criteria

    Suppliers

    Suppliers

    Currency

     

     

    Form name: Account statement

    25. Switch to the Options tab on the Account statement form.

    Report VendAccountStatementInt.Report refresh completed

    27. Screenshot on demand: Account statement.

     

     

     

  • Community Member Profile Picture
    on at

    Hello Rana

    I think I understand your intention.

    Please consider that adding this filter on the account statement report only filters after the default dimension by which the vendor is configured and not on the transactions that have been done for this vendor.

    Try the report vendor transactions instead.

    Hans-Peter

  • Community Member Profile Picture
    on at

    Hello

    Was my post helpful for you?

    Hans-Peter

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi.. had same issue in my scenario.,Ur solution did work out..Thanks a lot

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…

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