on 2021 Sep 20 3:14 PM
On the Process Receivables app, we can see the list of open invoices by journal entry number. However, one of our company's use the reference field for the invoice number. This can be seen on the Customer Line Items App but I have checked all 50 available columns in Process Receivables > Invoice Items and none of them contain this data. This makes it difficult to know which invoice the customer is referring to.
We could use the Customer Line Items app but this doesn't show us the open value. So if an invoice is part paid we can only see the original document value.
Is it possible to add the reference column into Process Receivables and/or to see the open value in the Customer Line Items app?
Kind Regards
Nathan
Request clarification before answering.
Hi Nathan,
please select the Business Context: Collections Invoice.
Here you can find the related documentation on the Help Portal:
Best Regards,
Christina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christina,
Thanks for your help. I have been able to create the custom field and I can see it in the Process Receivables Invoice Items screen. However, I am stuck at what needs to be entered in draft logic.
How do I get the data from column DocumentReferenceID (XBLNR_V1) in I_BillingDocument to my custom field YY1_Reference?
Kind Regards
Nathan
User | Count |
---|---|
101 | |
39 | |
8 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.