Microsoft Dynamics 365
This issue is related to the fact that Gen. Journal Posting does not allow Entry Type 'Payment' have a Negative Amount for Vendors.
I have created an Open Source PTE to resolve this: https://github.com/TheDoubleH/BCVoidPayment
From a Technical perspective, here is the issue:
When a User voids a check from the Check Ledger Entries page, A call is made to Codeunit 367 – CheckManagement -> Function FinancialVoidCheck
That function sets the Document Type to “ “ (Blank), which leads to the Vendor Ledger Entry to have a Blank Entry Type.
While the Check Ledger is flagged as Voided and the Balance is correctly adjusted, the Detail Vendor Ledger Entry will not tell a complete story;
If We look at Check 206, the ‘initial’ Detailed Vendor Ledger Entries created end up like this:
The issue is that the Calculation formula for the Payments (LCY) Field on the Vendor Table, filters for Entry Type = Initial Entry, “Initial Document Type” = Payment (And Vendor No and other fields)
And THIS leads the Payment to show an incorrect amount on the Vendor Statistics Factbox
By now, I hope You realize that this is indeed an issue that needs to be resolved.
How do we fix it?
I suspect that the Document Type is left blank, due to the fact that codeunit 11 - Gen. Jnl.-Check Line prevents a Vendor Payment with a Negative Amount (Which makes perfect sense).
Luckily the Check Management Financial Void Check function sets a field: “Financial Void” to true. This means, that we have a possibility to negate the Negative Amount for Vendor Payments in CU11, as well as Positive Amounts for Customer Refunds.
At this moment we use QR code to open the page URL with filter applied, is good if Microsoft integrate with BC mobile app.
This can be done using Edit in Excel. Simply go to one of the vendors bank account list and choose Edit in Excel. Choose the filters option on the bottom right and "clear filters". You can then populate and upload against all vendors.
I note that this is "planned" functionality. The 2021 Release Wave 1 preview on Bank Reconciliation says:
The bank reconciliation report, known as the test report for bank reconciliation, is now also available for posted bank reconciliations (bank statements).
I am looking at the Preview version and I can't see that this can be printed. So is it part of this release or not?
Note: Potential supply chain master planning maybe enough, however, sometimes user may have a preference to directly place an order or create the purchase requisition, when already knowing the quantities.
For example (e.g. pandemic, red cross, retail of same size and similar operations, etc...).
Facing the same issue. Need 5 digit precision minimum to match with our CPQ
Integration with Project Operations is a must.
Or for purpose of renewable, reusable or green environment efficiencies or scrap efficiencies as source of alternative sources of revenue generation or team member investment future plans or skill development or community/planet contribution.
This is needed.
It would be great if out the box, D365 also does barcode parsing.