D365 Finance & Operations and Dynamics AX Forum

​good morning,

     we've recently started ACH payments in AX2012
     however, I cannot figure out how to have a payment to a vendor that includes an invoice and a credit combined on the payment...I need to remove the credit from the payment journal to process the batch (otherwise I receive an error "payment must be a debit amount > 0")
     I do not want to settle it, because we want to show on the payment advice the individual invoices / credits and amounts included in the ACH payments

invoice 1234 for $4,000
credit memo 7 for $100

we'd like the ACH payment to be for $3,900, and the ACH advice to show both of those items
if I use the "settle open transactions" function, then the payment will only show invoice 1234 was paid for $3,900.  our AP dept will be receiving questions of short-paid invoices if we went this route


------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA
------------------------------

In all the ACH versions / variations I implemented in the past we used to create a SINGLE payment line per vendor, and settle/mark this line against all the invoices / credit notes of that vendor. The payment line amount would be the net total, and the payment advice we print for this payment would show all the invoices and credit notes.,

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC
------------------------------

Original Message:
Sent: Aug 01, 2019 09:39 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

​good morning,

     we've recently started ACH payments in AX2012
     however, I cannot figure out how to have a payment to a vendor that includes an invoice and a credit combined on the payment...I need to remove the credit from the payment journal to process the batch (otherwise I receive an error "payment must be a debit amount > 0")
     I do not want to settle it, because we want to show on the payment advice the individual invoices / credits and amounts included in the ACH payments

invoice 1234 for $4,000
credit memo 7 for $100

we'd like the ACH payment to be for $3,900, and the ACH advice to show both of those items
if I use the "settle open transactions" function, then the payment will only show invoice 1234 was paid for $3,900.  our AP dept will be receiving questions of short-paid invoices if we went this route


------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA
------------------------------

does something in the setup allow you to do this?​

------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA
------------------------------

Original Message:
Sent: Aug 02, 2019 02:08 AM
From: Zvika Rimalt
Subject: ACH payments in AX 2012 - how do i include credits in payments?

In all the ACH versions / variations I implemented in the past we used to create a SINGLE payment line per vendor, and settle/mark this line against all the invoices / credit notes of that vendor. The payment line amount would be the net total, and the payment advice we print for this payment would show all the invoices and credit notes.,

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Aug 01, 2019 09:39 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

​good morning,

     we've recently started ACH payments in AX2012
     however, I cannot figure out how to have a payment to a vendor that includes an invoice and a credit combined on the payment...I need to remove the credit from the payment journal to process the batch (otherwise I receive an error "payment must be a debit amount > 0")
     I do not want to settle it, because we want to show on the payment advice the individual invoices / credits and amounts included in the ACH payments

invoice 1234 for $4,000
credit memo 7 for $100

we'd like the ACH payment to be for $3,900, and the ACH advice to show both of those items
if I use the "settle open transactions" function, then the payment will only show invoice 1234 was paid for $3,900.  our AP dept will be receiving questions of short-paid invoices if we went this route


------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA
------------------------------

We are having the same issue. Vendors with N030 payment terms will have invoices selected for a payment using due dates and if the credit note date is later than the invoices dates, the system will select invoices for a payment and omit credit note. At that point, we have no more payments to the vendor, and we are only left  with a credit on the vendor file. Is there a way to make credit notes to be picked up with the current payment, regardless when the credit note is due?

------------------------------
Maria Nowak
Controller
Tigercat International Inc.
Cambridge ON
------------------------------

Original Message:
Sent: Aug 02, 2019 08:04 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

does something in the setup allow you to do this?​

------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA

Original Message:
Sent: Aug 02, 2019 02:08 AM
From: Zvika Rimalt
Subject: ACH payments in AX 2012 - how do i include credits in payments?

In all the ACH versions / variations I implemented in the past we used to create a SINGLE payment line per vendor, and settle/mark this line against all the invoices / credit notes of that vendor. The payment line amount would be the net total, and the payment advice we print for this payment would show all the invoices and credit notes.,

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Aug 01, 2019 09:39 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

​good morning,

     we've recently started ACH payments in AX2012
     however, I cannot figure out how to have a payment to a vendor that includes an invoice and a credit combined on the payment...I need to remove the credit from the payment journal to process the batch (otherwise I receive an error "payment must be a debit amount > 0")
     I do not want to settle it, because we want to show on the payment advice the individual invoices / credits and amounts included in the ACH payments

invoice 1234 for $4,000
credit memo 7 for $100

we'd like the ACH payment to be for $3,900, and the ACH advice to show both of those items
if I use the "settle open transactions" function, then the payment will only show invoice 1234 was paid for $3,900.  our AP dept will be receiving questions of short-paid invoices if we went this route


------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA
------------------------------

Hi Maria,
We are dealing with this issue through process (not automation)

Since all credit notes are entered manually by an accountant, our guideline is when entering a credit note to override the Terms of Payment value from the default coming from the vendor (N30 in your case) to N0.

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC
------------------------------

Original Message:
Sent: Aug 02, 2019 09:08 AM
From: Maria Nowak
Subject: ACH payments in AX 2012 - how do i include credits in payments?

We are having the same issue. Vendors with N030 payment terms will have invoices selected for a payment using due dates and if the credit note date is later than the invoices dates, the system will select invoices for a payment and omit credit note. At that point, we have no more payments to the vendor, and we are only left  with a credit on the vendor file. Is there a way to make credit notes to be picked up with the current payment, regardless when the credit note is due?

------------------------------
Maria Nowak
Controller
Tigercat International Inc.
Cambridge ON

Original Message:
Sent: Aug 02, 2019 08:04 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

does something in the setup allow you to do this?​

------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA

Original Message:
Sent: Aug 02, 2019 02:08 AM
From: Zvika Rimalt
Subject: ACH payments in AX 2012 - how do i include credits in payments?

In all the ACH versions / variations I implemented in the past we used to create a SINGLE payment line per vendor, and settle/mark this line against all the invoices / credit notes of that vendor. The payment line amount would be the net total, and the payment advice we print for this payment would show all the invoices and credit notes.,

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Aug 01, 2019 09:39 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

​good morning,

     we've recently started ACH payments in AX2012
     however, I cannot figure out how to have a payment to a vendor that includes an invoice and a credit combined on the payment...I need to remove the credit from the payment journal to process the batch (otherwise I receive an error "payment must be a debit amount > 0")
     I do not want to settle it, because we want to show on the payment advice the individual invoices / credits and amounts included in the ACH payments

invoice 1234 for $4,000
credit memo 7 for $100

we'd like the ACH payment to be for $3,900, and the ACH advice to show both of those items
if I use the "settle open transactions" function, then the payment will only show invoice 1234 was paid for $3,900.  our AP dept will be receiving questions of short-paid invoices if we went this route


------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA
------------------------------

Thank you, Zvika.
We are also changing the payment terms but sometimes they gets missed.
Too bad we are unable to automate it.

Maria

------------------------------
Maria Nowak
Controller
Tigercat International Inc.
Cambridge ON
------------------------------

Original Message:
Sent: Aug 02, 2019 05:48 PM
From: Zvika Rimalt
Subject: ACH payments in AX 2012 - how do i include credits in payments?

Hi Maria,
We are dealing with this issue through process (not automation)

Since all credit notes are entered manually by an accountant, our guideline is when entering a credit note to override the Terms of Payment value from the default coming from the vendor (N30 in your case) to N0.

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Aug 02, 2019 09:08 AM
From: Maria Nowak
Subject: ACH payments in AX 2012 - how do i include credits in payments?

We are having the same issue. Vendors with N030 payment terms will have invoices selected for a payment using due dates and if the credit note date is later than the invoices dates, the system will select invoices for a payment and omit credit note. At that point, we have no more payments to the vendor, and we are only left  with a credit on the vendor file. Is there a way to make credit notes to be picked up with the current payment, regardless when the credit note is due?

------------------------------
Maria Nowak
Controller
Tigercat International Inc.
Cambridge ON

Original Message:
Sent: Aug 02, 2019 08:04 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

does something in the setup allow you to do this?​

------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA

Original Message:
Sent: Aug 02, 2019 02:08 AM
From: Zvika Rimalt
Subject: ACH payments in AX 2012 - how do i include credits in payments?

In all the ACH versions / variations I implemented in the past we used to create a SINGLE payment line per vendor, and settle/mark this line against all the invoices / credit notes of that vendor. The payment line amount would be the net total, and the payment advice we print for this payment would show all the invoices and credit notes.,

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Aug 01, 2019 09:39 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

​good morning,

     we've recently started ACH payments in AX2012
     however, I cannot figure out how to have a payment to a vendor that includes an invoice and a credit combined on the payment...I need to remove the credit from the payment journal to process the batch (otherwise I receive an error "payment must be a debit amount > 0")
     I do not want to settle it, because we want to show on the payment advice the individual invoices / credits and amounts included in the ACH payments

invoice 1234 for $4,000
credit memo 7 for $100

we'd like the ACH payment to be for $3,900, and the ACH advice to show both of those items
if I use the "settle open transactions" function, then the payment will only show invoice 1234 was paid for $3,900.  our AP dept will be receiving questions of short-paid invoices if we went this route


------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA
------------------------------

On the Method of Payment setup, we set the "Period" value to "Total"
We flag all invoices and credit notes with that Method of Payment.

When we execute the "Payment Proposal" functionality to generate the payment journal, it will create a single payment lines for all the invoices of a particular vendor.



------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC
------------------------------

Original Message:
Sent: Aug 02, 2019 08:04 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

does something in the setup allow you to do this?​

------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA

Original Message:
Sent: Aug 02, 2019 02:08 AM
From: Zvika Rimalt
Subject: ACH payments in AX 2012 - how do i include credits in payments?

In all the ACH versions / variations I implemented in the past we used to create a SINGLE payment line per vendor, and settle/mark this line against all the invoices / credit notes of that vendor. The payment line amount would be the net total, and the payment advice we print for this payment would show all the invoices and credit notes.,

------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC

Original Message:
Sent: Aug 01, 2019 09:39 AM
From: jon bartholomew
Subject: ACH payments in AX 2012 - how do i include credits in payments?

​good morning,

     we've recently started ACH payments in AX2012
     however, I cannot figure out how to have a payment to a vendor that includes an invoice and a credit combined on the payment...I need to remove the credit from the payment journal to process the batch (otherwise I receive an error "payment must be a debit amount > 0")
     I do not want to settle it, because we want to show on the payment advice the individual invoices / credits and amounts included in the ACH payments

invoice 1234 for $4,000
credit memo 7 for $100

we'd like the ACH payment to be for $3,900, and the ACH advice to show both of those items
if I use the "settle open transactions" function, then the payment will only show invoice 1234 was paid for $3,900.  our AP dept will be receiving questions of short-paid invoices if we went this route


------------------------------
jon bartholomew
Kayem Foods Inc.
Chelsea MA
------------------------------