Dear Experts,
We have a requirement to get vendor remaining payment details which is <0, >0 and not equal to 0 into payment voucher. Kindly advise.
Thanks
With Regards'
Mandeep Kaur
*This post is locked for comments
Hi Amol,
Yes, In voucher register Ineed changes.
Let me explain what I have tried on test DB, I have added two tables in the Vendor Register Report
1 DataItem Detailed Vendor Ledg. Entry <Detailed Vendor Ledg. Entry>
VendLedgEntry."Document Type" VendDocType
VendLedgEntry."Document No." VendDocNo
VendLedgEntry."Document Date" VendPostingDate
VendLedgEntry."Due Date" VendDueDate No
"Detailed Vendor Ledg. Entry".Amount VendAppliedAmount
VendLedgEntry.Amount VendDocAmount
VendLedgEntry."Remaining Amount" VendDocRemAmount
2 DataItem Detailed Cust. Ledg. Entry <Detailed Cust. Ledg. Entry>
CustLedgEntry."Document Type" CustDocType
CustLedgEntry."Document No." CustDocNo
CustLedgEntry."Document Date" CustPostingDate
CustLedgEntry."Due Date" CustDueDate
"Detailed Cust. Ledg. Entry".Amount CustAppliedAmount
CustLedgEntry.Amount CustDocAmount
CustLedgEntry."Remaining Amount" CustDocRemAmount
These are the fields which I have taken from particular tables and please find attached screenshot of the report.
Please advise
Thanks
With Regards
Mandeep Kaur
Do you mean to say that when user post the voucher it is displaying voucher register report and you want changes in that report ?
You need to make the changes by taking vendor ledger entry table as dataitem in report and display it.
Hi Amol,
Sorry for late reply, Yes, I want the details in the voucher and when users click on post & print, It shows Voucher register report so I have done the changes in the report layout and code.
Please advise.
Thanks
With Regards
Mandeep Kaur
Mandeep,
Where you are displaying the vendor ledger entry ? Is it in voucher or somewhere?
If you want to display the entries in voucher entry then you need to write code in report.
Hi Amol,
Yes, I need to apply against payment voucher with all outstanding / balance amount.
I have written this code under vendor ledger entry page action tab(Print Voucher). Is this correct, Please verify.
IF GLEntry.FIND('-') THEN
REPORT.RUNMODAL(REPORT::"Posted Voucher",TRUE,TRUE,GLEntry);
IF ((Amount > 0)) OR
((Amount < 0))
THEN BEGIN
"Remaining Amount" := Amount;
END ELSE BEGIN
"Remaining Amount" := 0;
END;
Thanks
With Regards
Mandeep Kaur
Hi Mandeep
You need to customize the voucher report to cater this requirement and you will get all details from Vendor ledger entry
Do you want to display the invoices which is applied against the payment voucher or all the outstanding invoices irrespective of payment voucher applied.
Hi Amol,
Thanks for your reply,
User need the details of remaining amount in the payment voucher itself, Either Cash Voucher/ Bank Payment Voucher in the form of printout. They want when they take a printout of voucher they get these details in printout as well. Kindly advise.
Thanks
With Regards
Mandeep Kaur
Hi Mandeep
In Payment voucher you can click on Apply Entries button where you can find the outstanding invoices to paid where user can see the outstanding invoices and apply them against the payment voucher.
As well as user can look into report -Aged Account Payable also if they want to check the outstanding invoices
Hi Amol,
Thanks for your reply,
Actually, we don't need report, user need the details of remaining amount in the payment voucher itself, Either Cash Voucher/ Bank Payment Voucher. Kindly advise.
Thanks
With Regards
Mandeep Kaur
Hi Mandeep
You need to check the vendor ledger entry and check for outstanding invoices where remaining amount is not equal to zero
Based on Vendor selected in Payment voucher you can display the details in report.
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
