Accounts Payable Posting Profile

(0) Share

Report

Posted on by Michael agostini

Der Dynamics Community,

I am trying to configure D365 to do the following:

1) For a specific vendor book the credit against a balance sheet account that is NOT Accounts payable control account but an intercompany account. (we are not using D365 intercompany in this scenario it is just an account name.

2) Based on the setup below I have been able to get that posting profile to work as expected. But the issue is I have the payable against the vendor and we do not need it to be there.

Any ideas how to do this without having the transaction go against the vendor.

I just want a DR to INVENTORY and CR to INTERCOMPANY for this one vendor.

Thanks very much,

I have the same question (0)

All responses (14)

Answers (2)

Suggested answer

ZvikaR 168 on at

Like (0)

Report

I am trying to understand your requirement.

You want to record an invoice, in the AP sub-ledger, to a vendor, but you do not want that balance to show up in the AP sub-ledger?

Aren't you asking for 2 contradictory things in one requirement?

Anything you record to a vendor, will show up on that vendor record - by definition

Or possibly I am misunderstanding the ask?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Michael,

To create a transaction

DR: Inventory

CR: Intercompany ledger account

You can make use of an inventory movement journal.

This journal won't touch AP.

If this is really what you want then I would recommend checking out movement journals and enter the intercompany ledger account in the offset account field.

Best regards,

Ludwig

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

Zvika,

What we are trying to do is not set up a payable as this is a kind of intercompany transaction.

But I understand what you are saying - I cannot avoid hitting the vendor subledger despite what GL account I hit.

Thanks,

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

Ludwick,

Inventory is not the issue here.

Was this reply helpful? Yes No
Verified answer

OsmanIstanbul 2,818 on at

Like (0)

Report

Hi Michael

What is your inventory transaction? Purchase order? Does is contain any tax?

Why simply do not you transfer cr amount from vendor to intercompany account with a journal?

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

I think what I am going to do is set up a method of payment (vendor) that DR's AP and CR's this intercompany account instread of a bank account.

I think that will do it.

Thoughts...

Was this reply helpful? Yes No
Suggested answer

ZvikaR 168 on at

Like (0)

Report

ok, so if what you want is to immediately clear the AP balance into a ledger account, there is a more automated way (this is different from what you asked for earlier, which was to not post into the AP sub-ledger at all)

You can create a Term of Payment type, Payment Method = COD, Cash Payment = Yes, Cash = ledger account for intercompany.

As soon as you post the vendor invoice, the system will automatically create a clearing transaction, and settle it against the vendor transaction. So no open AP transactions remain on the vendor record.

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

I like this!!

Thank you for the suggestion.

Regards,

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

I just tried this and it is not working.

I created the new Terms of payment (as outlined above) and added it to the vendor.

When I posted the invoice the CR still went to Accounts Payable control account not the intercompany account.

Thanks,

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

Do I need a method of payment with this?

Thanks

Was this reply helpful? Yes No