Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

AP-Vendor Invoice journal

Posted on by 5

AX2012 RTM

I'm importing vendor invoice journal from CSV via X++,i could see the fields like remittance address , method of payment Tax1066 inserted into the table,but it's not showing in the form .....i'm i missing some fields..? also what is ledger journal Trans Extension IN...? i cant find in RTM version..........kindly suggest...

pastedimage1563790997370v1.pngpastedimage1563791058979v2.png

*This post is locked for comments

  • AXFreak Profile Picture
    AXFreak 5 on at
    RE: AP-Vendor Invoice journal

    But I couldn't find that table in AX2012 RTM.

  • AXFreak Profile Picture
    AXFreak 5 on at
    RE: AP-Vendor Invoice journal

    yes,.... made some changes on referring to that.....still not resolved.

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: AP-Vendor Invoice journal

    Hi.. Here is what you can try:

    1. Try creating a single record from the code.

    2. Go to AX in same journal and create record manually and this will be another line

    Now compare what's different. Address may be an issue if linkages are not there, MOP etc. you should be able to see as they might be stored in the table directly.

    This should give you a very good idea on what's wrong with the line created by code. If there are differences (not like voucher number OR line number etc. as they should vary by line in certain scenarios), try to resolve them. Hope this let you see the data on the form.

    Thanks,

    Satish Panwar

    Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.

  • Suggested answer
    KishorJadhav Profile Picture
    KishorJadhav 162 on at
    RE: AP-Vendor Invoice journal

    Hi AxFreak,

    The possibility of data is missing on form is might be table relations. Kindly check the table relations and insert data into all required tables.

    Ledger journal trans extension_IN is storing data related to the line level transaction and GST details. You have to insert record in this table as well with reference data.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AP-Vendor Invoice journal

    Hello AXFreak,

    Have you checked the following blog post already?

    daxingwitheshant.blogspot.com/.../importing-invoice-journal-lines-from.html

    Best regards,

    Ludwig

  • AXFreak Profile Picture
    AXFreak 5 on at
    RE: AP-Vendor Invoice journal

    upgrading latest version and Excel addin not possible...import via code is the only option.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AP-Vendor Invoice journal

    Hi,

    Have you tried using the Excel addin for this import process? The Excel addin should be able to import those data without coding. Because you are running a pretty old AX2012 version, is an upgrade to a later version an option for you?

    Best regards,

    Ludwig

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

Product updates

Dynamics 365 release plans