Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Summarize Standard Ledger Posting in AX Journal Transactions

Posted on by 640

Dear all,

I am using AX 2012 R3 Cumulative Update 12.

Can we modify standard journal transaction for purchase invoicing in AX?

Here are the illustrations for every journal transaction created when :

A. Post Invoice Prepayment for this Purchase Order :

Advance Payment $250

Tax $25

Account Payable Prepayment $275

B. Payment for Invoice Prepayment of this Purchase Order :

Account Payable Prepayment $275

Bank Account - USD $275

C. Purchase Receiving

Finished Goods Inventory (Product Receipt) $1000

Accrued Purchase - Received Not Invoiced $1000

D. Purchase Invoicing

D-1 :

Tax $100

Accrued Purchase - Received Not Invoiced $1000

Account Payable - Domestic $1100

D-2 :

Finished Goods Inventory (Inventory Receipt) $1000

Finished Goods Inventory (Product Receipt) $1000

D-3 :

Account Payable - Domestic $275

Advance Payment $250

Tax $25

Is it possible to summarize D-1 and D-3 in AX with modification to generate journal transaction like below?

Tax $75

Accrued Purchase - Received Not Invoiced $1000

Account Payable - Domestic $825

Advance Payment $250

Anyone ever modify AX's standard ledger posting like example above? (or any other posting which you need to summarized the ledger?)

Please suggest. Thank you.

Best regards,

Johanna

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans