5
Hi all,
I just implement prepayment on purchase let say DP 20% at the first invoice and than 80% final invoice. but i found in the ledger automatic journal by system that i can't track were is come from. could you please give some advise to fixed this problem and how to avoid this automatic journal?
thank you in advance for your assist.
regards
ebie
*This post is locked for comments
Hi Ludwig,
really appreciated for your reply and assist.
i will double check in demo system and record step by step and came back to you soon with more detail.
thank you very much for your advise.
regards,
ebie
Hello ebie,
The last voucher that you described with ' automatic journal by system' looks strange.
It seems to offset the posting that has been made on the 614201 general parts ledger account that is recorded with the invoice.
Unfortunately, I cannot see all vouchers and relationships and would thus like to ask whether you can
(a) double check that the last lines are not just a different possibly filtered view on the invoice voucher
(b) select the original document button and drill down to the origin of this last voucher to get possibly more details.
If this does not bring any additional insights then try to replicate this issue in a different test or demo system to ensure that this additional voucher is something that you usually get.
If you can replicate the issue please let us know your exact system version so that we can check if this might be related to a system bug. (Note: You can actually check this yourself on LCS).
Best regards,
Ludwig
Dear Dr. Ludwig,
I just use standard purchase order form. just purchase ordinary ones with DP because it was new supplier so they asking DP before delivery. i just check step by step from DP invoice & payment voucher also FP invoice and payment record is correct records as detail below:
| Date | Descirption | Account Code | Account Name | DR | CR |
| 20-Aug | Down Payment | 131110 | ADVANCE PAYMENT | 16,800,000.00 | |
| 20-Aug | Down Payment | 217430 | VAT | 1,680,000.00 | |
| 20-Aug | Down Payment | 212110 | ACCOUNT PAYABLE TRADE - LOCAL | 18,480,000.00 | |
| 20-Aug | Payment | 212110 | ACCOUNT PAYABLE TRADE - LOCAL | 18,480,000.00 | |
| 20-Aug | Payment | 111221 | BANK | 18,480,000.00 | |
| 22-Aug | Product Receipted | 614201 | GENERAL PART(MATERIAL) | 84,000,000.00 | |
| 22-Aug | Product Receipted | 299999 | ACCRUED PURCHASED | 84,000,000.00 | |
| 22-Aug | Product Receipted | 129999 | PURCHASE EXPENDITURE | 84,000,000.00 | |
| 22-Aug | Product Receipted | 129999 | PURCHASE EXPENDITURE | 84,000,000.00 | |
| 29-Aug | Final Incoice | 212110 | ACCOUNT PAYABLE TRADE - LOCAL | 92,400,000.00 | |
| 29-Aug | Final Incoice | 614201 | GENERAL PART(MATERIAL) | 84,000,000.00 | |
| 29-Aug | Final Incoice | 614201 | GENERAL PART(MATERIAL) | 84,000,000.00 | |
| 29-Aug | Final Incoice | 299999 | ACCRUED PURCHASED | 84,000,000.00 | |
| 29-Aug | Final Incoice | 217430 | VAT | 8,400,000.00 | |
| 29-Aug | Final Incoice | 131110 | ADVANCE PAYMENT | 16,800,000.00 | |
| 29-Aug | Final Incoice | 212110 | ACCOUNT PAYABLE TRADE - LOCAL | 18,480,000.00 | |
| 29-Aug | Final Incoice | 217430 | VAT | 1,680,000.00 | |
| 29-Aug | Payment FI | 212110 | ACCOUNT PAYABLE TRADE - LOCAL | 73,920,000.00 | |
| 29-Aug | Payment FI | 111221 | BANK | 73,920,000.00 |
but there is automatic journal as screen shot below, three automatic journal by system with total value 80.400.000 ( 70.200.000 + 6.900.000 + 6.900.000)
then recorded as below:
| Date | Desciption | Account Code | Account Name | DR | CR |
| 29-Aug | Automatic journal by system | 299999 | ACCRUED PURCHASED | 70,200,000.00 | |
| 29-Aug | Automatic journal by system | 614201 | GENERAL PART(MATERIAL) | 70,200,000.00 | |
| 29-Aug | Automatic journal by system | 299999 | ACCRUED PURCHASED | 6,900,000.00 | |
| 29-Aug | Automatic journal by system | 614201 | GENERAL PART(MATERIAL) | 6,900,000.00 | |
| 29-Aug | Automatic journal by system | 299999 | ACCRUED PURCHASED | 6,900,000.00 | |
| 29-Aug | Automatic journal by system | 614201 | GENERAL PART(MATERIAL) | 6,900,000.00 |
because of this journal there balance 614201 Accrued purchase DR 80.400.000 but the balance should be recorded to 614201 General part (material).
it operated Dynamics AX 2012 R3.
regards
ebie
Hello ebie,
Can you let us know whether you make use of the standard purchase order prepayment functionality that is available in the purchase order form or whether you use a different prepayment feature. Also, do you use project related purchase order or just 'ordinary' ones?
Some screenprints would be great.
Can you also let us know the exact AX2012 version that you operate?
Many thanks,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (