Skip to main content
Solved

Create a data view

I
Freshman I
Forum|alt.badge.img

Hello. I want to create a dataview in my customization in order to get these data.

In the invoices form, From the credit memo type i want to get its detail total and then go to the application tab and select its invoice and get the Amount from the invoice in the Invoices and Memos form.

I need the detail total from this credit memo

 

And then i will go the applications tab and go to its invoice.
And from the Invoice form i need to get its Amount.

How can i write this into a query where i can create data view for my customization?

I have created this relationship joinin using the report builder for my report but i am unable to come up with the written query for this. Please help!

JOIN 1
JOIN 2

I simply need the written dataview query of the two joins. Thanks in advance.

Best answer by darylbowman

That would look like this:

public SelectFrom<ARInvoice>.
    LeftJoin<ARAdjust>.
        On<ARAdjust.memoID.IsEqual<ARInvoice.noteID>>.
    View View;

 

View original
Did this topic help you find an answer to your question?

3 replies

darylbowman
Captain II
Forum|alt.badge.img+13

 I’m not quite following your report joins. I believe these are the data views that the graphs are using.

public SelectFrom<ARAdjust2>.
    InnerJoin<ARPayment>.
        On<ARAdjust2.FK.Payment>.
    View Adjustments;

 

public SelectFrom<ARInvoice>.
    LeftJoin<ARAdjust>.
        On<ARAdjust.FK.Invoice>.
    View Invoices;

Let me know if I’m misunderstanding something.

Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
I
Freshman I
Forum|alt.badge.img
  • ifelix
  • Author
  • Freshman I
  • 21 replies
  • July 17, 2024
darylbowman wrote:

 I’m not quite following your report joins. I believe these are the data views that the graphs are using.

public SelectFrom<ARAdjust2>.
    InnerJoin<ARPayment>.
        On<ARAdjust2.FK.Payment>.
    View Adjustments;

 

public SelectFrom<ARInvoice>.
    LeftJoin<ARAdjust>.
        On<ARAdjust.FK.Invoice>.
    View Invoices;

Let me know if I’m misunderstanding something.

 

Hello Dear.

I actually need to join ARInvoice to ARAdjust using note id and memo id and comeback from ARAdjust to ARInvoice using the AdjdRefNbr from ARAdjust and RefNbr from ARInvoice. Hope this is is clear.

Thanks.

darylbowman
Captain II
Forum|alt.badge.img+13
  • darylbowman
  • 1746 replies
  • Answer
  • July 17, 2024

That would look like this:

public SelectFrom<ARInvoice>.
    LeftJoin<ARAdjust>.
        On<ARAdjust.memoID.IsEqual<ARInvoice.noteID>>.
    View View;

 

Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
D
Chris Hackett
2 people like this
  • D
    Django
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved