Hi
I need help because i want to view my RefNbr on my GLTran base on my module
but when i click this
it is not getting the record of the refnbr
Answer
Journal Transaction get the RefNbr Data Depends on Module
Best answer by nhatnghetinh
Hi
Because when you click on RefNbr on the report it will call the screen of that RefNbr. And [GLTran.RefNbr] cannot call the correct screen of RefNbr.
You need to join with APPayment & ARPayment to call the correct screen of that RefNbr
Please refer to the screenshots below.
Best Regards,
NNT
+11Hi
Please share the .rpx file
Best Regards,
NNT
+11Hi
Because when you click on RefNbr on the report it will call the screen of that RefNbr. And [GLTran.RefNbr] cannot call the correct screen of RefNbr.
You need to join with APPayment & ARPayment to call the correct screen of that RefNbr
Please refer to the screenshots below.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
+11Hi
I tried using the if function to use only 1 column for Ref. No but without success.
= IIf( [APPayment.RefNbr] <> NULL, [APPayment.RefNbr]
, IIf( [ARPayment.RefNbr] <> NULL, [ARPayment.RefNbr]
, '' ) )
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
=Switch([GLTran.Module]='AP',[APPayment.RefNbr],
[GLTran.Module]='AR',[APPayment.RefNbr],
)
i tried this i think its okay. Thank you
+11Hi
I realized this problem as I told you above. It seems that RefNbr link on the report is not calling different screens according to conditional functions.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.