Skip to main content
Question

Invoice Number not displaying

  • 5 December 2022
  • 4 replies
  • 165 views

Forum|alt.badge.img

Hi,

I wanted to get the Invoice Number from the Payments and Applications form.

olcHQI7-1PTHtAWdDkLIZv32EgmcUsyA6YZyXxvBXuqAv1NtfB8EDxJWYcVlCcDP2qgK7uqzVJ1OKUnFgpPTNaEQcEaS-CEOBZ7ZiX5GYZQ2Djlsn36pr0-lAgNq3G-OrS88RGHbRdRhZc5kFgUf5YtHwCbdrRs6jbjy0Xc_hgHjCybCYQ8IHRUyTvHntQ

If we go through the Reference Nbr we can see the Invoice Number related to that Reference Nbr.

wHSD9IEq5d6GTBJcrQTAnsybGdVfPF3T4V_dCtPt6b8mkKwe0_BjgVuBnh3LdphmLUW-seVkltQDlIgmgI_1fwuHLDF6XQdI1yMfdIEigvd9pkV8-xoHt_wgYIJY8160P_InJhUbQyEmqFO2UF0TRLZssyqFbznV1yIQxTnSxIUWeDEuM-OsoEapRP52FA

01A6omAmDeLJ28DsDX48IhFPxSTqqw2q_UmFp1Q8RGqDJrEkDlY-x_o1s8NSLWdvrklzJUzudyAdXhUpyZXzlX0bTCJB5kSchGKdy0nNWk8pm9XLt5F8C5myO2lQWnJe6z-0HnBa0w6XdiI4fzAFJ75f_EJ8fCjip8aSqswrB7l-jB06-lOOj6xDvSJDoA

Here is the relationship and condition to get the Invoice Nbr Value.

QBvTYbtEuxI15ZdajaFuwXzoLkvyFwHuunS1YxpT3MXjI4Y0SY0Au_AIH4zr9h-GAf5f60VlhiiWUkMiwGglOTC_AOb1X6Z6jyuhCOaxjQUfkaNbaOEbb8dfRKcjZciCSLzjRkztwLQie-OXlQ4G_ib2KFZ-Lxvlxo1GaVsEU2_BYAKvbSpg1AhG1icO0A

AWShycAJdKLYCthSdzJGP5afClPCNWe2QAgRytJIot5sxgSFA8q9jlELkyXt7ZJyp4ylf4UR_slYIK3ZbC_FnzZINlimz5K0c_qd2U2dqmghnOeoeNhlziLecq59b_GeS2TqwIeh6s1HlTrBA8KVNU3NUW6W_wMfEBibfjC4dQaWEHU-c6Y_4eTTCOrcsg

But Invoice Nbr is not displaying in the Report.

ZhRHVvwpjKE-hORErjN6JUyjO7H77JuMqaMtPnJbOmPyKM3uUnEKhF5-bj1sJuy0K6WlCVF5EFja6BE5eyemUkIzz2_54rK_yE9Z6Nbsy8mQ8nKjgR1Ea7tkwpZYIJaeQKpbczj_wjMpq9-iylqvmazUfEBtIEaKRZvBAWZSNzapRY0GeVCQxvnlRh67uw

 

Does anyone have any idea what causes this issue and how to fix them?

 

Thanks.

4 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 625 replies
  • December 5, 2022

Hi @RManathungage94! Have you tried joining ARAdjust to ARRegister instead of ARInvoice?

Typically all the transaction detail is stored in ARRegister and only some is stored in ARInvoice.

Let me know if this helps!


Forum|alt.badge.img

Hi @BenjaminCrisman! yes, we have tried that as well. but still results are the same!!!


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 625 replies
  • December 13, 2022

@RManathungage94 Actually, when I check the relations it looks like you are joining ARInvoice, the adjusted document, to ARAdjust on AdjgDocType and AdjgRefNbr. The adjusting doc type is a payment and the adjusted doc type is an invoice, these are not equal.

I see why you want to link to ARInvoice, because ARRegister probably doesn’t have that custom field in it?

Try either using AdjdDocType and AdjdRefNbr to link to if possible


Atiq
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 38 replies
  • March 22, 2024

Hi @RManathungage94 ,

                                              there is a field called " PPDCrMemoRefNbr” in ARAdjust DAC, that Joins to RefNbr of ARInvoice,  which can give you the desired Result,

Let Me know if you face any issues?


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