04-Document Report - Vendor Payment Schedule and add related fields in Purchase Invoice
Specification
Spec_Vendor Payment Schedule & Advice_220307-R1.xlsx
Report Menu
Report menu for Vendor Payment Schedule - Excel added. User can find in Departments => Financial Management => Report and Analysis User can use the standard function Add to Actions on Role Center Ribbon if needs. |
Report filter option
- Due Date must enter for filter the report.
- Option - show outstanding only for filter out the document it have been fully settled (i.e. Remaining Amount is 0 in related vendor ledger entry)
Setup - Payment Method
Paid by Vendor column in Vendor payment schedule to be show the value from Payment Method.
User need to create the payment method it use for select in purchase document and show on Vendor Payment Schedule
Please see the example in case 3 below.
Case 1 - Purchase Invoice - Unreceived purchase
Handling for Unreceived Purchase (Temp Invoice with Status is Pending) |
---|
1- When create the Purchase Invoice, click on ... button it next to No. then select No. series for Temp. Purchase Invoice |
2 - Fill up the General Information such as Due Date, Vendor Invoice No, External Document No (if any) |
3 - Enter Item line - due to the goods is not received yet, select the item for "Pending" then enter the Unit Price |
4 - Set Status to Pending - Check the Action Button Set Pending after complete on the data for the purchase invoice Status Changed to Pending User can click Release / Reopen / Send Approval Request when the status is Pending. |
5 - Vendor Payment Schedule 1) Doc. Type - Shows the No, Series Description. 2) Status Shoe Pending |
6 - Once actual PI is ready to create for the temp PI, then |
Case 2 - Purchase Invoice - Hold Payment
Description | Screen Capture |
---|---|
Purchase Invoice / Purchase Invoice New Fields Hold Payment and Reason of Hold added for indicate the payment to be on hold | |
Payment Journal If the Hold Payment is checked in posted purchase invoice, the vendor ledger entry is not able to select in Apply document when create payment journal | |
Vendor Payment Schedule Report Column 'Hold' - show the hold payment Column 'Remarks'- show the Reason of Hold |
Case 3 - Purchase Return (Debit Note) settle by Purchase Invoice
Description | Screen Capture |
---|---|
Case Example Purchase Return created the Debit note amount to be offset by other vendor invoice
the payment method to be shows on Vendor Payment Schedule for indicate the debit note to be off set by vendor invoice
Once the purchase return is posted the remaining amount for both invoice and debit note (i.e. purch. credit memo) to be deducted accordingly. | |
Sample for Vendor Payment Schedule, the Purchase Debit Note (i.e. Purchase Return) is offset by other vendor invoice | |
If the applies to document is entered in the purchase return, after post, the debit note to be offset by the invoice |