Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Can we post vendor ret...
Finance | Project Operations, Human Resources, ...
Answered

Can we post vendor retention from general journal?

(0) ShareShare
ReportReport
Posted on by JohnBright 87
Hi experts, 
I am right now trying to post a vendor retention through code but without using the purchase order process. Technically, I am trying to post a general ledger of a custom journal type with a line that has the vendor retention account. I extended a method under LedgerJournalTransUpdate to return the posting type /Vendor retention/ if the journal is of my custom type. But the Microsoft does not consider this as retention since no record gets populated in VendInvoiceTrans table(Since it gets inserted only when it's processed from PurchFomLetter).
Can any one advice whether it is possible to post vendor retention without PO. Also, will I be breaking anything through this customization? 
 
Thanks in advance! 
John Bright
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Can we post vendor retention from general journal?
    Hi John,
    Glad you solved this issue, you can mark this thread as verified if it is convenient so that other users with similar issues can better see the thread. Please feel free to contact with us if you have any problem.
    Best regards,
    Kevin
  • Verified answer
    JohnBright Profile Picture
    JohnBright 87 on at
    Can we post vendor retention from general journal?
    Hi Kevin, 
    Thanks for your inputs. On my analysis, the vendInvoiceJour gets inserted in VendVoucher class  under createInvoiceJournal method. This class extends an abstract class CustVendVoucher which has a method to create VendInvoiceTrans records as well (createInvoiceTrans) which is called right after the createInvoiceJournal method. 
    I analyzed how microsoft is populating vendInvoiceTrans when it is processed through a PO which happens under the method IniVendinvoicetrans from the  PurchInvoiceJournalCreate class. Upon analyzing that, I have populated the necessary fields. 
    The retention releases will happen in the same spot. Through this way I was able to post retention through an invoice journal. 
     
    Regards, 
    John Bright
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Can we post vendor retention from general journal?
    Hi,
    Posting vendor retention without using the standard purchase order process can be a complex task. Vendor retention typically involves withholding a portion of payment until certain conditions are met, which is closely tied to the purchase order and invoicing processes. If you attempt to post vendor retention directly through code without going through the standard processes, it might not trigger the necessary accounting and updates to the VendInvoiceTrans table as you've noticed.
    You would need to consider the following points:

    1. Accounting Logic: Ensure that your custom code properly calculates and posts the retention amount to the correct ledger accounts and that it follows your company's accounting policies.

    2. Regulatory Compliance: Check if your customization complies with the financial and regulatory standards in your region. Withholding payments from vendors often has legal and tax implications.

    3. Data Integrity: Understand that bypassing the standard processes can lead to data integrity issues. The VendInvoiceTrans table may not be updated, and this can affect reporting and reconciliation.

    Best regards,
    Kevin

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans