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
1) - clear the detail for temp PI or delete the temp PI
2) - create the actual PI according to the invoice presented by Vendor

Case 2 - Purchase Invoice - Hold Payment

DescriptionScreen 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 

DescriptionScreen Capture

Case Example

Purchase Return created the Debit note amount to be offset by other vendor invoice

  • User an enter Payment Method e.g. Offset by Invoice in the purchase return.

the payment method to be shows on Vendor Payment Schedule for indicate the debit note to be off set by vendor invoice

  • User can also enter the Applies to Doc. Type and Applies to Doc. No. in Purchase Return. 

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

  • No labels