Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

Image Added

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)

Image Added

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

...

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.

Image RemovedImage Added

Sample for Vendor Payment Schedule, the Purchase Debit Note (i.e. Purchase Return) is offset by 

the invoice (PI22030024

by other vendor invoice

Image Added

If the applies to document is entered in the purchase return, after post, the debit note to be offset by the invoice

Image AddedImage Removed