Open Forum

Expand all | Collapse all

AR Aging report - how do I get the GL Account associated with Detailed Customer Ledger entry records?

  • 1.  AR Aging report - how do I get the GL Account associated with Detailed Customer Ledger entry records?

    SILVER CONTRIBUTOR
    Posted 15 days ago

    we are building an AR Aging report off Detailed Customer Ledger entry and want to show the GL account associated with the detailed customer ledger entry but are not sure how to make the connection.

    Has anyone else done this and any advice/tips on how to do it?


    Thanks



    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: AR Aging report - how do I get the GL Account associated with Detailed Customer Ledger entry records?

    TOP CONTRIBUTOR
    Posted 14 days ago
    You can't directly from the Detailed Customer Ledger Entry. But the Customer Ledger Entry has a field called Customer Posting Group. Use that to do a Get from table 92 Customer Posting Group. The G/L account is located in the field called Receivables Account.

    Detailed Customer Ledger Entries don't always result in G/L entries. If you apply a credit memo to an invoice (assuming they both went to the same A/R account), that doesn't result in a G/L entry.

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Duluth GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: AR Aging report - how do I get the GL Account associated with Detailed Customer Ledger entry records?

    SILVER CONTRIBUTOR
    Posted 14 days ago
    Thanks we will give that a try!

    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: AR Aging report - how do I get the GL Account associated with Detailed Customer Ledger entry records?

    TOP CONTRIBUTOR
    Posted 14 days ago
    Benji,

    Good Day. When you say 'show the GL associated' are you speaking about the AR Account affiliated with the Customers AR entry? If so, I am thinking you could use the Customer Posting Group/AR Account field affiliated with the Customer to pull from the related record. Is this what you are trying to accomplish?

    Thanks and Stay Safe,
    Steve

    ------------------------------
    Steven Chinsky
    Senior Functional NAV/BC Consultant
    Tigunia
    Mansfield MA
    NAVUG All-Star, Granite Award Recipient, DCMP
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: AR Aging report - how do I get the GL Account associated with Detailed Customer Ledger entry records?

    SILVER CONTRIBUTOR
    Posted 14 days ago
    Thanks Steven, yes we will give that a try, I think that is similar to what Kyle suggested.

    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role