Skip to main content
Solved

Additional Doctype


Forum|alt.badge.img

i want to add a doctype here in my Book but its not displaying whats wrong with my relationship
 

 

Best answer by nhatnghetinh

Hi ​@jhoncandare04 

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

View original
Did this topic help you find an answer to your question?

12 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 529 replies
  • January 14, 2025

Hi ​@jhoncandare04 

I see your report is displaying DocType.

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Freshman II
  • 59 replies
  • January 14, 2025

can it be display based on module? it only display on AR
 

 


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 529 replies
  • January 14, 2025

Hi ​@jhoncandare04 

I tried testing different Modules and the results were relatively correct.

Please check again.

 

 

 

 

 

 

 

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Freshman II
  • 59 replies
  • January 14, 2025

so its correct already? 🤣. Thank you 


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 529 replies
  • January 14, 2025

Hi ​@jhoncandare04 

Yes, I think it's good. Please check again. If okie you can close your question.

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Freshman II
  • 59 replies
  • January 14, 2025

how i will display the Doctype ARPayment because it will only display ARInvoice


Forum|alt.badge.img
  • Author
  • Freshman II
  • 59 replies
  • January 14, 2025

can i use ARRegister to this so it can read the Payment and Invoice?


Forum|alt.badge.img
  • Author
  • Freshman II
  • 59 replies
  • January 14, 2025

its working. Thank you


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 529 replies
  • Answer
  • January 14, 2025

Hi ​@jhoncandare04 

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 59 replies
  • January 15, 2025

=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 #


Forum|alt.badge.img
  • Author
  • Freshman II
  • 59 replies
  • January 16, 2025

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 59 replies
  • January 16, 2025
jhoncandare04 wrote:

 

I already fix this. No need help hahaha


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings