Question

Change Due Date on Supplier Invoice

  • 31 January 2020
  • 6 replies
  • 587 views

Badge +1

Hi. Can you change the Due Date or Payment Term Base Date on a Supplier Invoice that has moved to PostedAuth status or beyond?

Thanks


6 replies

Userlevel 7
Badge +15

Hi Paul,

 

Yes. You can.

 

First you will have to remove the authorized check box of the ‘Installment Plan and Discount’  (RMB from manual supplier Invoice> ‘Installment Plan and Discount’ )

Then it will be updated to the status  ‘Posted’

Now you should be able to check the Payment Term from the LoV.

This will update the Due Date of the invoice.

After updating..

Hope this helps.

 

Thank you,

Shehan Almeida.

Userlevel 4
Badge +6

As per above advice, you can also simply update the due date if you do not have the relevant payment term to support the requirement.

 

 

Userlevel 5
Badge +10

Hi,

Wee are trying to do this for a number of invoices that ‘slipped though’ - we can change the due date for invoices that have arrived this month - but for the prior month it is not letting us,.​​​​​​​

 

Any thoughts?

 

Matthew

Userlevel 6
Badge +19

Hi,

Wee are trying to do this for a number of invoices that ‘slipped though’ - we can change the due date for invoices that have arrived this month - but for the prior month it is not letting us,.

 

Any thoughts?

 

Matthew

 

Hi

 

Try changing on installment plan and discount window. Go to supplier analysis, find the invoice and installment plan and discount

Userlevel 5
Badge +10

Thanks for the response - alas it is not updating the table I need (though it is a good post to have on the community)


We have a couple of reports scheduled from the MAN_SUPP_INVOICE table looking at the DUE_DATE field.

That will update the ABSTRACT_PAYMENT_PLAN2 table.

It is strange as it only seems to affect SUPPEXT invoices from prior periods - not SUPPINV.

 

Nothing I can see in config that differs - though if anyone has any thoughts, welcome to check.

Userlevel 6
Badge +19

Hi Matthew,

 

Maybe you should use function from API. invoice_api.Get_Due_Date or payment_plan_api.Get_Due_Date would help?

 

Regards

Reply