Skip to main content
Solved

Additional Doctype

  • January 14, 2025
  • 12 replies
  • 156 views
  • Translate All
Jr Varsity III
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

12 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@jhoncandare04 

I see your report is displaying DocType.

 

Best Regards,

NNT

Translate
I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
    Jr Varsity III
    Forum|alt.badge.img

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

     

    Translate
    nhatnghetinh
    Captain II
    Forum|alt.badge.img+14

    Hi ​@jhoncandare04 

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

    Please check again.

     

     

     

     

     

     

     

     

    Best Regards,

    NNT

    Translate
    I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
      Jr Varsity III
      Forum|alt.badge.img

      so its correct already? 🤣. Thank you 

      Translate
      nhatnghetinh
      Captain II
      Forum|alt.badge.img+14

      Hi ​@jhoncandare04 

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

       

      Best Regards,

      NNT

      Translate
      I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
        Jr Varsity III
        Forum|alt.badge.img

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

        Translate
        Jr Varsity III
        Forum|alt.badge.img

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

        Translate
        Jr Varsity III
        Forum|alt.badge.img

        its working. Thank you

        Translate
        nhatnghetinh
        Captain II
        Forum|alt.badge.img+14

        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

        Translate
        I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
          Jr Varsity III
          Forum|alt.badge.img

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

          Translate
          Jr Varsity III
          Forum|alt.badge.img

           

          Translate
          Jr Varsity III
          Forum|alt.badge.img

           

          I already fix this. No need help hahaha

          Translate
            Terms & ConditionsAccessibility statement
            About Acumatica ERP system
            Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
            © 2008 — 2024  Acumatica, Inc. All rights reserved