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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

When did the VendTransOpen record created? and what is the usage?

(0) ShareShare
ReportReport
Posted on by 334

Hi, Experts:

Can anyone tell me when the VendTransOpen record created?

I realize The VendTrans table contains posted transaction information for the vendor.

and the SpecTrans  contains records that marked for the settlement, and Records are deleted after they are posted.

So after ledgerJournalTrans marked some records for settlement. these records will insert into specTrans.

After posting , it will create records in VendTrans. and delete records in specTrans.  so what is the usage of VendTransOpens table and when it is inserted records?

 thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Brandon Wiese Profile Picture
    17,788 on at
    RE: When did the VendTransOpen record created? and what is the usage?

    VendTransOpen records represent the un-settled amount (along with supporting information, such as due date) of any open vendor transaction.

    They are created in class VendVoucher (which extends class CustVendVoucher) in the post() method by calling the createTransOpen() method when the VendTrans amount is non zero.

  • JCHI Profile Picture
    334 on at
    RE: When did the VendTransOpen record created? and what is the usage?

    HI.

    Thanks you guys for the answer!

  • JCHI Profile Picture
    334 on at
    RE: When did the VendTransOpen record created? and what is the usage?

    HI, Guys.

    A following up question:

    There is a vendtrans() method in SpecTrans table.

    Since the SpecTrans contains records that marked for the settlement,

    and VendTrand record only created when payment journal lines are posted.

    How can specTrans find corresponding VendTrans? or Vendtrans records are not created during journal line posted? thank,

  • Suggested answer
    Chaitanya Golla Profile Picture
    17,225 on at
    RE: When did the VendTransOpen record created? and what is the usage?

    Hi,

    If you check the method definition of vendTrans method of specTrans, there is switch case between VendTransOpen and VendSettlement.So, based on caller the corresponding vendTrans record is returned. VendTrans records gets created if we make any transaction for vendor like packslip, invoice etc and in your case its vendor invoice before vendor settlement.

  • Verified answer
    Brandon Wiese Profile Picture
    17,788 on at
    RE: When did the VendTransOpen record created? and what is the usage?

    I'm not sure I understand the source of your continued confusion about VendTrans, VendTransOpen, and SpecTrans.  Perhaps we should just go over the sequence of events from start to finish.

    When you're working in a Vendor payment journal, you are creating LedgerJourTrans records, typically with account type Vendor and offset account type Bank, for example.  If you merely do that and then post the journal, you will impact Vendor balance and Bank balance, creating VendTrans and BankAccountTrans records.  You do not have to settle any invoices, it is not required, even though it is the typical workflow using a payment proposal.  

    When any VendTrans record is created that is not 0, a VendTransOpen record is created to track the outstanding amount not yet settled.  Eventually when the VendTrans record becomes fully settled, the VendTransOpen record is deleted.

    Now the next most complicated case is working in a Vendor payment journal, still creating a LedgerJournalTrans record for Vendor offset Bank, but now you're selecting invoices to settle, hence the SpecTrans records.  SpecTrans records merely connect two different records together with an amount.  They are not in themselves a settlement.  Instead, they represent a future settlement in the same way your LedgerJournalTrans record represents a future VendTrans (and VendTransOpen) record.  When you post this journal, a VendTrans, VendTransOpen, and BankAccountTrans record are all created.  Then, in a subsequent step, the SpecTrans records are used to settle the new VendTrans record (the new payment) against other VendTrans records (invoices).  If invoices are settled in full, then their VendTransOpen records are deleted.  If the payment is settled in full, then its VendTransOpen record is deleted.

    There is no requirement to fully settle payments or invoices when posting a journal.  If you want to see for yourself, post a payment of $1,000 and settle an invoice of $500.  This will leave an unsettled payment on the vendor account.  There is nothing wrong with this, i.e. prepayment.

    So in summary, VendTrans records always (when non zero) create VendTransOpen records when they are first created.  Then settlement consumes part or all of these VendTransOpen records.  When a VendTransOpen record is fully consumed, it is deleted.  This can all happen within a single journal posting, so you might be left thinking that no VendTransOpen record ever existed, which is a false conclusion.

    Hope this helps.

  • Brandon Wiese Profile Picture
    17,788 on at
    RE: When did the VendTransOpen record created? and what is the usage?

    As a short follow-up, as SpecTrans records are processed, they are deleted and VendSettlement records are created.  Like SpecTrans record, VendSettlement records merely connect two VendTrans records together with an amount.

  • JCHI Profile Picture
    334 on at
    RE: When did the VendTransOpen record created? and what is the usage?

    Brandon,

    Thank you so much for the thoughtful explanation. It helps me a lot!

  • Husna Yusuf Profile Picture
    1,094 on at
    RE: When did the VendTransOpen record created? and what is the usage?

    Hi Brandon, i have add one field, description in VendTransOpen.[mydescription] table, to save some notes that key in by user.

    and the user need this information in ledgerjournaltrans. i have add one field,Description,also in Ledgerjournaltrans.[mydescription] to patch the value VendTransOpen.[mydescription].

    So when the user marked the settlements, which classes or methods that system call to input/insert all the information from VendTransOpen to LedgerJOurnalTrans?

    Thank you for your information.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
AlissonGodoy Profile Picture

AlissonGodoy 2

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans