Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Pushing data in User Defined fields from the Sales/Purchase Ledger to the General Ledger

Posted on by 20

Hi

We have a custom in house C#.NET application that is built on top of the eConnect DLLs.  At present, this application extracts data from a flat file and generates Sales or Purchase Ledger entries within Dynamics GP.  We then use the Dynamics GP to post these entries through from the Sales or Purchase Ledger to the General Ledger and finally we post the General Ledger entries.  This all works fine.

We have had a request from one of our directors, however, to make an update to this application.  In certain circumstances, we would like to insert a key piece of additional data into one of the User Defined fields within the Sales or Purchase Ledger.  We know how to do this.  However, the director wants this piece of data to then be carried through to one of the User Defined fields within the General Ledger when it is posted from the Sales Ledger or Purchase Ledger.  We do not know how to do this or if indeed it possible.

Does anyone know of a way of configuring Dynamics GP in order that any data in User Defined Field 1 within the Sales Ledger or Purchase Ledger is pushed through to User Defined Field 1 in the General Ledger when a Sales or Purchase Ledger entry is posted?

Thanks in advance

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 10,996 User Group Leader on at
    RE: Pushing data in User Defined fields from the Sales/Purchase Ledger to the General Ledger

    It don't need to be flow from sub ledger to GL ledger while posting if there is not any specific business need, UD values can be read directly from sub ledger to GL Entry windows.

    I have done similar kind of customization where uses also wanted to updated posted sales and purchase transactions user defined fields or enter new values if not already entered on sub ledger from GL windows.

  • AlternateBM Profile Picture
    AlternateBM 20 on at
    RE: Pushing data in User Defined fields from the Sales/Purchase Ledger to the General Ledger

    Hi Almas

    Thanks for taking the time to reply.

    Your response covers how to ensure a User Defined fields is displayed on the General Entry window but this alone will not be sufficient to pull the value from the User Defined field on the Sales or Purchase Ledger and place it in the User Defined field in the General Ledger when the Sales or Purchase Ledger entry is posted unless I am misunderstanding.

    Can you clarify how a value can be mapped/pulled through from the Sales Ledger or Purchase Ledger to the General Ledger when posting occurs?

    Thanks in advance

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 10,996 User Group Leader on at
    RE: Pushing data in User Defined fields from the Sales/Purchase Ledger to the General Ledger

    This needs a small dexterity based customisation.  

    For this following needs to be done.

    1. User Defined field needs to be added on window to display values on General Entry window.

    If you need someone with dexterity customisation experience to do it for you, you can contact me for that, please go through my profile for my contact details.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans