I am looking to modify the FA643000 report.
In the stock report I see a table called FAProjectedGLTran.
What is the source of this data?
Maybe I am missing something but I can find no reference to this table other than in the report builder.
I am looking to modify the FA643000 report.
In the stock report I see a table called FAProjectedGLTran.
What is the source of this data?
Maybe I am missing something but I can find no reference to this table other than in the report builder.
Hi
You can find a little more about it by using the DAC Schema browser:
Thank you
I looked for that information here:
https://help.acumatica.com/(W(9))/Help?ScreenId=ShowWiki&pageid=122a92bd-bfd5-bf34-16f0-867e57dea9f8
However, I didn’t find the information you posted. Where and how do I locate what you posted?
However, even within what you posted, what is the source of the SignedAmt value?
First, from the screen you provided click the Home button in the top left:
Then locate the DAC Schema Browser menu option:
The second option is if you are already in the software you can click the Customization option on any screen > Select Inspect Element > Find an element to explore and click it > Click the Data Class link
The SignedAmt is a calculated field based on the transaction type it looks like:
PXDBCalced( typeof(Switch< Case<Where<APAROrd.ord.IsEqual<short1> .And<FATran.tranType.IsEqual<FATran.tranType.purchasingMinus>> .And<FATran.debitAccountID.IsEqual<FATran.creditAccountID>> .And<FATran.debitSubID.IsEqual<FATran.creditSubID>> .Or<APAROrd.ord.IsEqual<short0> .And<FATran.tranType.IsEqual<FATran.tranType.purchasingPlus>> .And<FATran.debitAccountID.IsEqual<FATran.creditAccountID>> .And<FATran.debitSubID.IsEqual<FATran.creditSubID>>>>, decimal0, Case<Where<APAROrd.ord.IsEqual<short1>>, FATran.tranAmt, Case<Where<APAROrd.ord.IsEqual<short0>>, Mult<decimal_1, FATran.tranAmt>>>>>),
I see FA.Namespace and PX.Objects DAC Reference but nowhere do I see any reference to FAProjectedGLTran.
FAProjectedGLTran doesn’t even appear if I search for it.
Most importantly, where is the value in ‘SignedAmt’ derived from?
It might depend on which build you are on also, the Schema Browser was added in 22 R1 I believe
Thank you
This is what I was trying to learn through this exercise.
I appreciate your help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.