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.
Solved
Customizing FA643000 Report
Best answer by BenjaminCrisman
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>>>>>),
+4Hi
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?
+4First, 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
+4The 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>>>>>),
1 person likes this
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?
+4It 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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.