web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to Insert the Orig...
Microsoft Dynamics AX (Archived)

How to Insert the Original SalesId and the Original InvoiceId in the All Return orders Sales form

(0) ShareShare
ReportReport
Posted on by On-Hand Inventory I... 120

Hi, everyone

Would you please help me how can I insert the Original SalesId and the Original InvoiceId in the All Return orders Sales form because the return form is not insert the original Sales Id and the Invoice Id

I am using AX 2012

 

Best Regards

Jami Alshaibani

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    Hi Jamil Alshaibani!

    Return sales order linked with original sales order and invoice by lines.

    Return SalesLine.InventTransIdReturn and original SalesLine.InventTransId

    Return SalesLine.RefReturnInvoiceTrans_W and   CustInvoiceTrans.RecId

  • On-Hand Inventory I want to Add to the Report ItemName Profile Picture
    On-Hand Inventory I... 120 on at

    Hi Rustem Galiamov!

    Thank you very much for your help ,when I check the data in the SQL Server it give me the result correct as the following  script shown in the screenshot :

    Return_5F00_Sales_5F00_Query.png

     

    Then I create a new  SalesCustInvoiceTrans  query  in the AOT as the following shown in the screenshot  :   

    Return_5F00_Sales_5F00_Query.png

     

    Then I Create a report in the visual studio 2013 when I create DataSets I give it this name

    SalesCustInvoiceTransDS then I select the properties then I  make the Dynamics filters  false

    And the I  select the query for the datasets, when  I select  SalesCustInvoiceTrans query and then I click Next it gives this error : Object reference  not set to an instance of an object

    Waiting for your valuable answer

    Best Regards

    Jamil Alshaibani 

     

     

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,710 Moderator on at

    This error is very generic and it might  not be associated with your query but tooling .Try restarting visual studio , SSRS service.  Also check event log for additional details

  • On-Hand Inventory I want to Add to the Report ItemName Profile Picture
    On-Hand Inventory I... 120 on at

    Hi Sukrut,

    I restart Visual Studio , as well as I stop the SSRS Service in the server, but still I am getting the same message as this Screenshot :

    Obect_5F00_Reference.png

    Best Regards

    Jamil Alshaibani

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 3

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans