Skip to main content
Answer

Using a DAC not related to the Generic Inquiry to use their format

  • February 16, 2023
  • 3 replies
  • 105 views
martingaxiola
Varsity I
Forum|alt.badge.img

I have use the DB-Approval Generic inquiry from the Dashboards as base for a report for one of my clients. The only problem I had, is that they wanted “Approved Total” amount brought into the Generic Inquiry, had 6 decimals, and my client wanted only 2, after spending several minutes trying every single idea I read from this community and AUGForums regarding style, formulas or else, I could not make it work.

So, I added DAC PX.Objects.AP.APInvoice, into the Generic Inquiry and did not related to anything, and used it to have the Schema Field from APInvoice. CuryDocBal, to get the format, and that worked for the GI. Would this cause any issues with the GI? I could not find any issues at first glance, but, wanted another opinion.

 

Thank you. 

Best answer by BenjaminCrisman

Hi @martingaxiola! There won’t be any issues, this is one of the great ways that schemas can work.

No need to join the table into the GI using relations if you’re only going to use it as a schema and pretty sure it’s the only thing you can do with an unlinked table in a GI.

Martin Gaxiola
martingaxiola

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • Answer
  • February 16, 2023

Hi @martingaxiola! There won’t be any issues, this is one of the great ways that schemas can work.

No need to join the table into the GI using relations if you’re only going to use it as a schema and pretty sure it’s the only thing you can do with an unlinked table in a GI.

Neil Cantral
martingaxiola
Chris Hackett
DConcannon
Varsity II
Forum|alt.badge.img+2
  • DConcannon
  • Varsity II
  • February 16, 2023

@martingaxiola Adding a table (DAC) to a GI to use its field formatting properties does not have a negative impact and is the prescribed method to use.

 

martingaxiola
Chris Hackett
martingaxiola
Varsity I
Forum|alt.badge.img
  • martingaxiola
  • Author
  • Varsity I
  • February 16, 2023

Thank you for confirming @BenjaminCrisman, I will deliver this to the client then. I really appreciate your prompt respose.

Martin Gaxiola
BenjaminCrisman
martingaxiola
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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