Skip to main content
Solved

Sales Order Line -> PO Link -> Reporting Join

  • 4 December 2020
  • 3 replies
  • 705 views

StevenRatner
Varsity I
Forum|alt.badge.img

Does anyone know the best way to join an SOLine to the PO Link?  Im looking to add this information into a report but can’t find the best way to join the information.  See my screen shot.

 

 

Best answer by evelkly

Hello!

The PO link data is stored in the SOLineSplit DAC.  I’ve attached the XML for a simple GI that provides the below results, which includes the field you highlighted.  Hopefully this gives you a good base to build upon.

Eric

 

 

In case the XML doesn’t import cleanly, here’s the relevant GI screens, in this case simply filtered to a single SO for brevity:

 

 

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

evelkly
Jr Varsity II
  • Jr Varsity II
  • December 4, 2020

Hello!

The PO link data is stored in the SOLineSplit DAC.  I’ve attached the XML for a simple GI that provides the below results, which includes the field you highlighted.  Hopefully this gives you a good base to build upon.

Eric

 

 

In case the XML doesn’t import cleanly, here’s the relevant GI screens, in this case simply filtered to a single SO for brevity:

 

 


Forum|alt.badge.img
  • Jr Varsity II
  • February 15, 2022

@evelkly 

i have a question, we are not yet Acumatica customer, whenever we need to customize a report, do we have to write something like this? it is almost scary! since a normal user will not be able to write something like this. it should be user friendly, this definitely not

thank you

 


evelkly
Jr Varsity II
  • Jr Varsity II
  • February 15, 2022

Hi @zoeymuff 

There’s a few ways to do reporting in Acumatica, which you can find in the online help.  What you see above (the graphical stuff) comes from the Generic Inquiry screen, which lets you (fairly) easily write queries against your data. As far as I know, all methods of reporting generate an XML file in the background, but you don’t typically need to worry about it.

I believe a “normal” user can learn to create the various reporting methods, as long as they can understand the data, how it is accessed/stored, and how to relate it together (such as a sales order (SOOrder) to a sales order line (SOLine).

Hope this helps reduce some of your concern.

Eric

 


Reply


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