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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / New field in table 700...
Microsoft Dynamics NAV (Archived)

New field in table 7000004 Closed Cartera Docs.

(0) ShareShare
ReportReport
Posted on by Community Member

Hi.

When I open Payable Closed Cartera Docs Form (7000013), I need to filter by a date where the posted invoices were payed. First, I added a FlowFilter pointing to Document Date in table 380, Dtld. Vendor Ledger Entry, where:

- Vendor Ledger Entry No. = Entry No.

- Entry Type = Entry Type

- Unapplied = No

The Flowfilter works fine but when I try to filter by this field, (for example: 010115..300915), the form shows that inglorious windows finding movs. on table 380. :(

Then I've thought I need to change this field to a normal field, but I need to fill it when it closes a posted doc.

It should close a document, makes movs. on Vendor Ledger Entry and Detailed Vendor Ledger Entry and then, insert a new record on Closed Docs table with this field filled.

Do you know where should be the code to fill this field? I tryed to find it in CU 12 and 7000006 but I'm not able to find it.

Regards.

*This post is locked for comments

I have the same question (0)
  • keoma Profile Picture
    keoma 32,729 on at

    the 70000XX objects seem to be from an external module (not nav standard)

    for usage of flowfilter follow

    www.packtpub.com/.../filtering-microsoft%C2%AE-dynamics%E2%84%A2-nav

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    I answer myself.

    I modified Document Date Payment (new field) as a normal field. Then I added code to OnInsert and OnModify events to as follows:

    IF Type = Type::Payable THEN BEGIN

      CLEAR(DetVendorLedEnt);

      DetVendorLedEnt.SETRANGE("Vendor Ledger Entry No.","Entry No.");

      DetVendorLedEnt.SETRANGE("Entry Type",DetVendorLedEnt."Entry Type"::Application);

      DetVendorLedEnt.SETFILTER(Unapplied,'No');

      IF DetVendorLedEnt.FINDLAST THEN

         "Document Date Payment 2" := DetVendorLedEnt."Document Date";

    END;

    As last, I modify code on CU 700006, where it was ClosedDoc.INSERT, I've modified by ClosedDoc.INSERT(TRUE) to force to execute my new code.

    Now, when a new record is inserted, my new field is calculated and inserted too, and when I try to filter by this field in Payable Closed Cartera Docs it's instant.

    Cheers.

  • Community Member Profile Picture
    Community Member on at

    Thank you, but  my problem came with the usage of flowfilters. I wanted to bypass this and be able to filter by this date without using flowfilters. As I describe above this post, I insert new code in OnInsert event and forcing to use this code in CU 7000006 Document-Post.

    Objets from 70000xx are Cartera Module.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans