How to get SalesLine record from ReqTrans table using X++ AX 2012

Add these two methods to the ReqTrans table

public SalesLine getSalesLine(ReqTrans _reqTrans)
{
    ReqTrans        reqTrans_Settle,reqTrans_next;
    SalesLine       salesLine;
    ;
    reqTrans_Settle = _reqTrans.getSettleTrans();
    do
    {
        select reqTrans_next
            where reqTrans_next.RefId == reqTrans_Settle.RefId
               && reqTrans_next.Direction == InventDirection::Receipt;
        if (!reqTrans_next)
        {
            break;
        }
        reqTrans_Settle = reqTrans_next.getSettleTrans();
    }
    while(reqTrans_next);
 
    if(reqTrans_Settle.RefType == ReqRefType::Sales)
    {
        salesLine = SalesLine::findInventTransId(InventTransOrigin::find(reqTrans_Settle.InventTransOrigin).InventTransId);
    }
 
    return salesLine;
}
 
private ReqTrans getSettleTrans()
{
    ReqTrans    reqTrans_Settle;
    ReqTransCov reqTransCov;
    ;
 
    switch(this.Direction)
    {
        case InventDirection::Issue:
                select reqTransCov
                    where reqTransCov.IssueRecId == this.RecId;
 
                reqTrans_Settle = reqTrans::findRecId(reqTransCov.ReceiptRecId);
            break;
 
        case InventDirection::Receipt:
                select reqTransCov
                    where reqTransCov.ReceiptRecId == this.RecId;
 
                reqTrans_Settle = reqTrans::findRecId(reqTransCov.IssueRecId);
            break;
 
    }
 
    return reqTrans_Settle;
}

71 Responses to How to get SalesLine record from ReqTrans table using X++ AX 2012

  1. cheap personalized nfl jerseys

    I been exploring for a little for any high quality articles or blog posts on this kind of area post. Exploring in Yahoo I at last stumbled upon this site. Reading this info So i happy to convey that I’ve a very good uncanny feeling I discovered exactl…

  2. cheap nfl jerseys from china free shipping

    As a side note, the more we can use trackbacks, pingbacks, and backlinks to spread the love and our message, the better.we supply cheap nfl jerseys I encourage you to figure out how to use these tools as they can really make our words online much more…

  3. discount nfl football jerseys

    Pretty nice post. I just stumbled upon your blog and wished to say that cheap nfl jerseys china I’ve really enjoyed browsing your blog posts. In any case Il be subscribing to your rss feed and I hope you write again very soon!postwholesale nfl jerseys…

  4. youth nfl football jerseys wholesale

    hello there and thanks on your info ?I certainly picked up something new from proper here postcheap nike nfl jerseys. I did on the other hand experience several technical issues the usage of this website, since I skilled to reload the site lots of time…

  5. … [Trackback]

    […] Find More Informations here: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  6. … [Trackback]

    […] Find More here|Find More|Read More Infos here|There you can find 12991 additional Infos|Infos to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  7. … [Trackback]

    […] Read More here|Read More|Find More Infos here|There you can find 38336 more Infos|Infos to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  8. … [Trackback]

    […] Read More on|Read More|Find More Informations here|There you will find 56239 more Informations|Infos on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  9. DMPK says:

    … [Trackback]

    […] Read More here|Read More|Read More Infos here|Here you can find 83248 more Infos|Informations on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  10. … [Trackback]

    […] Find More on|Find More|Find More Informations here|There you can find 99250 more Informations|Infos on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  11. … [Trackback]

    […] Read More on|Read More|Find More Infos here|Here you can find 95104 additional Infos|Infos on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  12. … [Trackback]

    […] Read More here|Read More|Find More Infos here|There you will find 25775 additional Infos|Informations to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  13. bandar judi says:

    … [Trackback]

    […] Read More on|Read More|Find More Informations here|Here you will find 17620 more Informations|Informations to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  14. poker online says:

    … [Trackback]

    […] Find More here|Find More|Read More Informations here|There you will find 7578 additional Informations|Informations to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  15. 192.168.l0.l says:

    … [Trackback]

    […] Find More here|Find More|Find More Infos here|Here you will find 76853 additional Infos|Informations on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  16. must watch says:

    … [Trackback]

    […] Read More on|Read More|Find More Infos here|Here you can find 70476 additional Infos|Infos on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  17. … [Trackback]

    […] Read More here|Read More|Find More Informations here|There you can find 8744 additional Informations|Infos to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  18. … [Trackback]

    […] Read More on|Read More|Find More Informations here|There you will find 1380 more Informations|Informations to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  19. … [Trackback]

    […] Read More on|Read More|Read More Informations here|There you will find 70170 more Informations|Informations on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  20. Cheap Jerseys China

    They might have rust, corrosion or other imperfections in the walls of these containers. And lastly will it fit in the room space you have?Frankly, between the top ten comparable brands, I have seen very little ?real? differentiation to decide if one b…

  21. Cheap NFL Jerseys Wholesale

    You may also choose to take protection up a notch inside your hotel by installing fingerprint access control systems in the hotel. Now though, nutrition labels can be seen on nearly all food products so that nutrients that the food provides can be seen…

  22. masters says:

    … [Trackback]

    […] Read More on|Read More|Read More Infos here|Here you can find 44554 additional Infos|Informations to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  23. Cheap Jerseys Shop

    What originally commenced as a project to generate a residence shoe that could be offered to Australians countrywide has swiftly proven into a globally operation since customers are looking particularly for boots that have the UGG title.Both the dissem…

  24. … [Trackback]

    […] Find More on|Find More|Find More Informations here|Here you can find 20657 additional Informations|Infos to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  25. … [Trackback]

    […] Find More on|Find More|Find More Informations here|Here you will find 94771 additional Informations|Informations on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  26. Yusuf kısa says:

    … [Trackback]

    […] Find More on|Find More|Find More Informations here|Here you will find 5195 more Informations|Informations to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  27. … [Trackback]

    […] Find More here|Find More|Read More Infos here|Here you can find 28372 more Infos|Infos to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  28. … [Trackback]

    […] Read More on|Read More|Find More Infos here|There you will find 82368 more Infos|Infos on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  29. … [Trackback]

    […] Read More on|Read More|Find More Informations here|There you will find 31009 more Informations|Infos to that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  30. … [Trackback]

    […] Find More on|Find More|Find More Infos here|There you can find 66854 additional Infos|Infos on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  31. …Additional Information ca be found here

    […]you made running a blog glance[…]

  32. …Recent Blogroll Additions

    […]you make blogging glance[…]

  33. …Awesome website

    […]you made running a blog glance[…]

  34. Viagra vs viagra http://rldta.com/

    Incredible lots of valuable advice!

  35. sportotobet says:

    …Awesome website

    […]Wow, marvelous weblog format! How lengthy have you ever been running a blog for?[…]

  36. Cialis coupon http://cialisyoues.com/

    Amazing a lot of valuable advice.

  37. Cialis 20 mg says:

    Cialis generic http://kawanboni.com/

    Really lots of awesome facts.

  38. Low cost cialis 20mg http://cialisvonline.com/

    You’ve made your point very clearly!!

  39. Buy viagra says:

    Online viagra http://viagravonline.com/

    Good write ups. Many thanks.

  40. iq colarts says:

    … [Trackback]

    […] Find More here|Find More|Find More Informations here|Here you can find 68762 more Informations|Informations on that Topic: blog.gandin.eu/get-salesline-record-reqtrans-table-using-x-ax-2012/ […]

  41. cialis tablets http://cialisvus.com/

    Amazing loads of wonderful advice.

  42. tadalafil generic http://cialisbuys.com/

    Wow all kinds of useful knowledge!

  43. tadalafil tablets http://cialisees.com/

    You actually revealed that really well.

  44. essayforme says:

    write my college essay for me http://gsgfsdgfdhjhjhj.com/

    Thanks a lot. Ample advice.

  45. cialis kaufen http://cialisky.com/

    Amazing many of good advice!

  46. Fitflop UK Beads

    Thanks a lot for sharing this with all of us you actually know what you are talking about! Bookmarked. Please also visit my web site =). We could have a link exchange contract between us!

  47. canadian pharmacy online 24 http://cialisonla.com/

    You actually reported that superbly.

  48. Clit vibrator review

    […]here are some hyperlinks to web-sites that we link to for the reason that we consider they are worth visiting[…]

  49. Wand massager

    […]check below, are some absolutely unrelated internet websites to ours, on the other hand, they may be most trustworthy sources that we use[…]

  50. Best couples vibrator

    […]Sites of interest we have a link to[…]

  51. realistic vibrator review

    […]below you’ll uncover the link to some sites that we consider you need to visit[…]

  52. vragen – Java exam

    […]The details talked about within the article are a few of the most effective offered […]

  53. Judi Slot Online

    […]The details mentioned within the report are several of the top obtainable […]

  54. nfl merchandise

    […]Wonderful story, reckoned we could combine some unrelated information, nevertheless actually worth taking a appear, whoa did one master about Mid East has got more problerms at the same time […]

  55. 먹튀사이트 검증

    […]Here is a good Weblog You may Locate Exciting that we Encourage You[…]

  56. Chapter 17 – Employee Stakeholders

    […]The data mentioned in the article are some of the best out there […]

  57. Bank Job says:

    Bank Job

    […]very couple of internet websites that take place to be detailed beneath, from our point of view are undoubtedly properly really worth checking out[…]

  58. pink rabbit says:

    pink rabbit

    […]Here is a superb Blog You might Find Fascinating that we Encourage You[…]

  59. Lego 70350 says:

    Lego 70350

    […]Sites of interest we have a link to[…]

  60. high quality vibrator

    […]Here are several of the web-sites we advocate for our visitors[…]

  61. http://www.blurb.com/user/montu4891

    […]Here is an excellent Blog You may Obtain Interesting that we Encourage You[…]

  62. Detroit SEO says:

    Detroit SEO

    […]Every once in a although we decide on blogs that we read. Listed beneath would be the newest internet sites that we choose […]

  63. detox tea says:

    detox tea

    […]The details talked about inside the post are a few of the ideal obtainable […]

  64. Social Media Marketing Company in Karachi

    […]that will be the end of this report. Here you will come across some sites that we think you’ll enjoy, just click the hyperlinks over[…]

  65. adam and eve magic massager

    […]Here is a great Blog You may Come across Intriguing that we Encourage You[…]

  66. Criminal Defense Lawyer Richmond, VA

    […]please visit the web sites we comply with, including this 1, because it represents our picks through the web[…]

Leave a Reply