Open Forum

Expand all | Collapse all

Can you populate Parent Name and ID when doing a General Journal Entry?

  • 1.  Can you populate Parent Name and ID when doing a General Journal Entry?

    Posted 21 days ago
    We do a lot of reporting on revenue ledger activity - the problem we have is there is no way that I know of to post a General Journal Entry with a Parent ID and Name. Is this possible or is this something that can only be done through the sales module?

    I would like to have the ability to run a smart list for any revenue account and see the fields Parent Name and ID populated with the related customer. We do accruals for some customers invoices, or correcting entries but I do not know of a way to populate these fields through a JE.

    ------------------------------
    Stephanie Nemetz
    Manager Of Accounting
    WOW Logistics Company
    Neenah WI
    ------------------------------


  • 2.  RE: Can you populate Parent Name and ID when doing a General Journal Entry?

    GPUG ALL STAR
    Posted 21 days ago
    Hi @Stephanie Nemetz

    Natively, just through the Sales Module.  But a custom view can be written that would pull it in by linking ​first to the originating transaction number and then to the Customer Master which has the Parent ID in it.

    ------------------------------

    ------------------------------



  • 3.  RE: Can you populate Parent Name and ID when doing a General Journal Entry?

    Posted 21 days ago
    Is this something that would mean having to customize the journal entry screen? Would the user then have the ability to populate the Parent Name and ID when doing a journal entry?

    ------------------------------
    Stephanie Nemetz
    Manager Of Accounting
    WOW Logistics Company
    Neenah WI
    ------------------------------



  • 4.  RE: Can you populate Parent Name and ID when doing a General Journal Entry?

    GPUG ALL STAR
    Posted 21 days ago
    Hi @Stephanie Nemetz

    No, not at JE Entry, only at SOP Entry.  If you explain why you would post a manual JE for a Sales transaction I may be able to better advise on the best way to get this type of information at the JE level because there are a few options for it.​

    ------------------------------

    ------------------------------



  • 5.  RE: Can you populate Parent Name and ID when doing a General Journal Entry?

    Posted 21 days ago
    We accrue for revenue in some cases due to terms of the agreement we have with some our our large lease customers - they have to approve the detail/data prior to us invoicing. We also book reversing deferred revenue entries as well. These are done as manual General Journal Entries, not in the sale module.

    ------------------------------
    Stephanie Nemetz
    Manager Of Accounting
    WOW Logistics Company
    Neenah WI
    ------------------------------



  • 6.  RE: Can you populate Parent Name and ID when doing a General Journal Entry?

    TOP CONTRIBUTOR
    Posted 21 days ago
    Hi Stephanie,
    have you looked at Revenue and Expense Deferrals (RED)?
    Look at this blog Jim and see if this can replace your manual JE

    https://www.gpug.com/blogs/jim-bertler/2017/08/16/dynamics-gp-revenue-and-expense-deferral


    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------



  • 7.  RE: Can you populate Parent Name and ID when doing a General Journal Entry?

    GPUG ALL STAR
    Posted 9 days ago
      |   view attached
    Hi,
    If your people can manually type in the customer (or whatever) name or ID, you can use modifier to modify the scrolling entry on the General Transaction Entry screen and then it could be available on a SmarList. You'll need to make the new fields Editable, because they come across as not editable. I've attached an incredibly rough modified window to show you what I mean. Keep in mind, the fields are not labeled and I didn't take the time to change the tab order. Let me know if this even resembles what you were looking for.
    Kind Regards,
    Leslie

    ------------------------------
    Leslie Vail
    Accounting Systems Consulting, Inc.
    DALLAS TX
    leslievail@earthlink.net 972-814-8550
    ------------------------------

    Attachment(s)



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