Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Pushing data in User D...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by AlternateBM 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

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 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 11,003 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans