Open Forum

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

    GOLD CONTRIBUTOR
    Posted May 21, 2020 05:37 PM

    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
    ------------------------------


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

    TOP CONTRIBUTOR
    Posted May 22, 2020 08:05 AM
    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
    ------------------------------



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

    GOLD CONTRIBUTOR
    Posted May 22, 2020 09:43 AM
    Thanks we will give that a try!

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



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

    NAVUG ALL STAR
    Posted May 22, 2020 10:08 AM
    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
    ------------------------------



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

    GOLD CONTRIBUTOR
    Posted May 22, 2020 08:32 PM
    Thanks Steven, yes we will give that a try, I think that is similar to what Kyle suggested.

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



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