i want to add a doctype here in my Book but its not displaying whats wrong with my relationship
Answer
Additional Doctype
Best answer by nhatnghetinh
Hi
I have changed on your report ARInvoice to ARRegister.
When you select the AR Module it will get all AR documents including Invoice, Payment,.. So I have added Parameter DocType so you can sort the Doctype you want.
Please refer to the report file I attached.
Best Regards,
NNT
+11Hi
I see your report is displaying DocType.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
+11Hi
I tried testing different Modules and the results were relatively correct.
Please check again.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
+11Hi
Yes, I think it's good. Please check again. If okie you can close your question.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
+11Hi
I have changed on your report ARInvoice to ARRegister.
When you select the AR Module it will get all AR documents including Invoice, Payment,.. So I have added Parameter DocType so you can sort the Doctype you want.
Please refer to the report file I attached.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
=IIF([ARRegister.DocType]='Payment',[ARInvoice.InvoiceNbr],[ARPayment.ExtRefNbr]
)
can i use this code to view all the payment ref # and Customer ref #
because its only showing payment ref # then if i change the code it will change also to Customer ref #
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.