Question

Get value each column in tab "DETAILS" screen Bills and Adjustments(AP301000)

  • 21 March 2023
  • 6 replies
  • 133 views

Userlevel 3
Badge

Hello expert.

How cant I get data field in the “details” tab screen AP301000 below image? How can i fetch data each row? Thank you so much.

 


6 replies

Userlevel 7
Badge +8

AP Details DAC is APTran not APInvoice.Your “row” variable is declared as APInvoice.

Userlevel 3
Badge

@aaghaei Thank you for your ideal, but it not work. We can’t cast.

 

Userlevel 7
Badge +8

Pal it is not IDEA. This is how you MUST do it. You can not query and use a field that does not exist in a DAC. The SubID is in APTran not APRegister (APInvoice)


By looking at your topics, with all due respect, I highly doubt you should be performing code based customizations. for example, you should not manipulating data in RowSelected event at all. 
 

in your current thread, if you want to access the current APTran line and manipulate, you can use

Base.Details.Current.SubID = “your new value”; 

Base.Details.Update(Base.Details.Current);

but I am not really confident about what you are doing and how it might create unintended consequences.

 

 

Userlevel 7
Badge +8

Edit: Depending on your version the View Name might be different. I just checked in 2022R2 and I see the APTran view names depending on your need are “Transactions”, “AllTransactions” or “TransactionsPOLine”.

So you will be updating your current AP Details Line in one of the above Views as Base.Transactions.Current.SubID = “new value”; but not definitely in RowSelected Event.

If you want to manipulate a given record using EventHandlers, for your purpose you MUST work on “APTran” DAC EventHandlers in your graph extension depending on the situation. i.e. Row updated event will be something like 

protected void _(Events.RowUpdated<APTran> e)
{
APTran row = e.Row;
row.SubID = YourValue;
}

 

Userlevel 3
Badge

@aaghaei Yes, after your commit “for example, you should not manipulating data in RowSelected event at all. “  now I try RowUpdated. Thank you. I doing query data (in SQL Server Management Studio) tab “details” but not found name some table in tab. Can you help me this case?

 

 

Userlevel 7
Badge

Hi @thanhaim were you able to find a solution? Thank you!

Reply


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