Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Grace Gillenwater]

I am trying to use the functionality of assigning an Invoice Account # to a Vendor Account # in Accounts Payable. We currently use this functionality for Vendors on Purchase Orders. However, this functionality is not working when I try to enter an expense invoice through an invoice journal.

For the Invoice Journal line, Vendor # 12835 is entered.  We have looked through each Tab of the journal to locate the Invoice Account #. We cannot find that information. We posted the invoice to see if the transaction would been seen as an open invoice under Invoice Account # 14550. The posted invoice was visible under Vendor # 12835.

Is there a set up I am missing?  I would think the functionality works the same regardless if an invoice is posted to a purchase order or an invoice journal. 

Any help is greatly appreciated.
Thank you!

——————————
Grace Gillenwater
Accounting Clerk
Landau Uniforms
Olive Branch MS
——————————

[Archive User]

Hi Grace,

Unfortunately, I don’t believe there is a way around this functionality. Given that you are using an invoice journal, AX assumes that you are recording invoices to the invoice account. Another option would be to use service items or procurement categories on a purchase order. There you would select the purchasing vendor (12835) and the invoice account (14550) would be used at time of invoicing, just as you do now. You would see a vendor transaction on the 14550 vendor and an invoice journal on the 12835 vendor.

Hope that helps!

Thanks,

——————————
Ben Mertes
Functional Consultant – Finance
Wipfli
Milwaukee WI
——————————
——————————————-

[Corey Warawa]

Hi Grace,

I don’t believe that you are missing anything in the setup.  The “Invoice account” functionality on the vendor is intended to work only with Purchase Orders.  I attempted to use this a couple years ago on two projects that I was working on but found out otherwise and I don’t believe that Microsoft has plans to change this.

Like you, I wish it did work!!

——————————
Corey Warawa
Solution Architect
Hitachi Solutions
——————————
——————————————-

[Kaare Boraas]

I ran into this a few years ago and was also surprised.  When you post an invoice journal, it uses whatever vendor account you enter.  I does not redirect to the invoice account.

——————————
Kaare Boraas
Solution Delivery Manager
PCL Constructors Inc.
Edmonton AB
——————————
——————————————-

[George Zhao]

I think you may have confused between AP invoice account and AR invoice account.

An invoice comes from the invoice account stays as vendor transaction of the invoice account. But it allows you to match PO(s) down to the order account under the invoice account. But it does not roll up if the invoice account has its own invoice account.

On the other hand, invoicing from an AR order account rolls up and creates customer transactions of the invoice account.

——————————
George Zhao
PAR Technology
New Hartford NY
——————————
——————————————-

[Grace Gillenwater]

Thank you everyone for your assistance.  This naturally is not the answer I was hoping for.  The invoices in question are freight invoices, so it would not be beneficial to create PO’s.

It’s just odd to me that it can work for AR and not AP, except for PO’s.  That is not logical in my mind.

Thanks again everyone!

——————————
Grace Gillenwater
Accounting Clerk
Landau Uniforms
Olive Branch MS
——————————
——————————————-

[George Zhao]

BTW, in your scenario, I would suggest creating a service PO and invoice that PO, instead of entering an invoice journal. This should create vendor transaction of the invoice account.

——————————
George Zhao
PAR Technology
New Hartford NY
——————————
——————————————-