How to return Prepayment amount associated with a Service order in a GI?

Userlevel 3

Hello, Hoping someone can help with this generic Inquiry (GI) question. 

I am trying to create a GI which identifies work orders having a prepayment applied.  There is a field on form FS300100 labeled “Prepayment Received”.  When looking at the Element Properties for the field, the results are:

Data Class:  FSServiceOrder

DataField:    SOPrepaymentReceive

ViewName:  CurrentServiceOrder

This field would be the perfect field to inspect to identify the Service orders in question.  However, this field is NOT populated in the generic inquiry Results Grid.  The field is blank for all returned rows.

My simple GI has only the FSServiceOrder table and I returned all fields.  I see the result row for the Service order in question, just no data for the Prepayments.  

 Any suggestions are greatly appreciated!


Best answer by Anacarina Calvo 3 August 2022, 16:41

View original

2 replies

Userlevel 6
Badge +4

Hi @bmullen94 

To show the prepayments you need to join with the table FSAdjust using adjdOrderNbr and join with table ARPayment using adjgRefNbr 

I am attaching a Generic Inquiry with this result 

Userlevel 3

@Anacarina Calvo  -  Thank you!


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