Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

To populate fields in custom table from general journal page. I am using same field id in both but its not working .How can I transfer data when genreral journal is posted.as when i am posting those fields are npt coming in table 81 gen. journal line ven.

(0) ShareShare
ReportReport
Posted on by 210

To populate fields in custom table from general journal page. I am using same field id in both but its not working .How can I transfer data when genreral journal is posted.as when i am posting those fields are npt coming in table 81 gen. journal line even.

  • Suggested answer
    Govinda Kumar Profile Picture
    Govinda Kumar 2,203 Super User 2024 Season 1 on at
    RE: To populate fields in custom table from general journal page. I am using same field id in both but its not working .How can I transfer data when genreral journal is posted.as when i am posting those fields are npt coming in table 81 gen. journal line v

    So in your process, you are inserting data from the bank ledger to your custom table using a job queue codeunit and there are some fields in your custom table that you want to update directly from the general journal line.. I think you should do some modifications in your job queue codeunit.. you need to get specific record of the general journal line using some filters and update those fields of your custom table during the insertion process..

  • Pragya752 Profile Picture
    Pragya752 210 on at
    RE: To populate fields in custom table from general journal page. I am using same field id in both but its not working .How can I transfer data when genreral journal is posted.as when i am posting those fields are npt coming in table 81 gen. journal line v

    yes , from gen journal it is posted to bank ledger and from bank ledger it is posted to custom table via job queue but some fileds which we do not want to post to bank ledger  but directly from gen. journal line to custom table while posting gen journal line

  • Suggested answer
    Govinda Kumar Profile Picture
    Govinda Kumar 2,203 Super User 2024 Season 1 on at
    RE: To populate fields in custom table from general journal page. I am using same field id in both but its not working .How can I transfer data when genreral journal is posted.as when i am posting those fields are npt coming in table 81 gen. journal line v

    You said you are inserting records into your custom table from the bank account general entry table in your codeunit, if I understand you correctly, now you want certain fields in your custom table to be updated when you post the general entries?.. don't know where/when you are executing your codeunit, but it's important to note that the codeunit where you insert records from the bank ledger entry needs to be aligned with posting general entries.

    Or else you have to manually modify your custom table in the specific event in Post codeunit

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: To populate fields in custom table from general journal page. I am using same field id in both but its not working .How can I transfer data when genreral journal is posted.as when i am posting those fields are npt coming in table 81 gen. journal line v

    How your custom table is inserting the record? Is it when you are posting Gen. Journal?

  • Pragya752 Profile Picture
    Pragya752 210 on at
    RE: To populate fields in custom table from general journal page. I am using same field id in both but its not working .How can I transfer data when genreral journal is posted.as when i am posting those fields are npt coming in table 81 gen. journal line v

    I have made a custom table which contains complete data for posted bank acc. ledger entry page as we need some modifications in bank acc. led entries therefore i made a codeunit to copy whole data from bank acc. ledger entry to custom table but since some fields which are in gen journal and are not posted on bank acc. ledger entry ,these fields are required on our custom table but when i post gen. journal but i cannot figure out how to get these fields on my custom table by directly posting from gen. journal.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: To populate fields in custom table from general journal page. I am using same field id in both but its not working .How can I transfer data when genreral journal is posted.as when i am posting those fields are npt coming in table 81 gen. journal line v

    Hi,

    In this case same field ID does not work, you have to call the right event, by the way where you want to transfer that field's value?

    Thanks.

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

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans