on 2008 Sep 12 10:22 AM
We want to see when an invoice has been paid in the A/R invoice screen. So when you search for the invoicenumber in the A/R Invoice screen it has to show the transfer reference information (table ORCT - TrsfrRef) and the date (table ORCT - TrsfrDate).
For that we are creating two UDF (e.g. Transfer Info and Tranfer Date).
Does someone know what query we will need to 'copy' the transfer reference information (with a formatted search linked to the query) into the UDF.
So when you search for the invoice number in the A/R Invoice screen the query has to find the fransfer reference information and date of that particular invoice.
Our customers always pay there invoices full (so not in terms).
Thanks in advance!
Best regards,
Tim
Hi
Assign this query to the UDF to get Transfer Info
SELECT T0.[TrsfrRef] FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.DocNum = T1.DocNum WHERE T1.[DocEntry] =$[OINV.DOCNUM]
Assign this query to the UDF to get Tranfer Date
SELECT T0.[TrsfrDate] FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.DocNum = T1.DocNum WHERE T1.[DocEntry] =$[OINV.DOCNUM]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the queries.
Somehow I don't get the formatted search right.
In the UDF Transfer Info:
I selected ALTSHIFTF2.
I selected the option: Search in Existing User-Defined Values According to Saved Query
I selected the query for Transfer Info
I selected the box: Auto Refresh When Field Changes
I selected: Document Number
I selected the option: Display Saved User-Defined Values
I have also tried other options, but I didn't become the Transfer Info information in the UDF.
Any idea what the problem is?
Best Regards,
Tim
Thank you for the answer.
Somehow is doesn't seem to work. I've tried several options but I don't get the information in the UDF.
Before you select the option Refresh Regularly you have to select Auto Refresh When Field Changes and then choose a field. In our case we have selected the field Document Number. Is this correct?
-
I have solved it and the query works!
Thanks for the solution!
Best Regards,
Tim
Edited by: T. Verholt on Sep 12, 2008 4:56 PM
Hi Tim,
in version 2007 you only need to rightclick on the header of the invoice, then select 'Reconciled Transactions' & you will be presented with a complete list of all payments, credit notes, journals etc that are or have been reconciled with this document.
From that list you can use the orange link arrows to drill back to those documents.
All the best,
kerstin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tim
There are 3 ways to get this information as follows:
1. Click on money bag (payment means) on menu bar or right click on document and select Payment means or press CTRL Y. This will display the payment(s) against this invoice.
2. Add UDF and use the OINV.ReceiptNum if only 1 payment per invoice.
3. Add UDF and link OINV to RCT2 if multiple invoices per payment or multiple payments per invoice.
Kind regards
Peter Juby
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
116 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.