Finance | Project Operations, Human Resources, ...

Posting an invoice to the accounts payable ledger where document date is in a closed period

(0) Share

Report

Posted on by Scott_Bumphrey

Hi All,

I am hoping that someone can assist on an issue we are facing in D365 around accounts payable document dates and closed periods. We have invoices which we are trying to process onto D365 with a document date of a prior month which falls into a closed accounting period, however we want to retain that invoice date as we want the system to use that date from a tax and FX perspective so need the system to use the correct document date. Is there a way for our system to identify that the document date is in a closed period, the the correct FX and VAT rate but post it into the current period?

I have found that Accounts Payable Parameters>Invoice>Update Supplier Accounting using the Invoice Date: Yes gets the system to use the correct FX rate for the invoice date, however it then blocks posting of the invoice with the following error: "Financial period 17/02/2021 is not open. Posting of order cancelled". If this parameter is set to No then it will calculate the FX rate based on the date of input/processing which is not suitable for our business as we have a number of instances where we pay upfront or prior to receipt of the invoice/goods so the system tries to apply a later and incorrect FX rate.

I hope this makes sense and any help is appreciated,

Thanks,

Scott

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Lucas Boewood on at

Like (0)

Report

RE: Posting an invoice to the accounts payable ledger where document date is in a closed period

Hi Scott,

If you're still having troubles here, I suggest opening a support case for us to take a closer look at a specific example and see if there's a way to work around this.

Get support for Finance and Operations apps or Lifecycle Services (LCS) - Finance & Operations | Dynamics 365 | Microsoft Docs

Another option would be to submit this to the Dynamics Ideas site for the dev team to consider:

Ideas (dynamics.com)

Was this reply helpful? Yes No
Suggested answer

Arghhhhhhh 25 on at

Like (0)

Report

RE: Posting an invoice to the accounts payable ledger where document date is in a closed period

Hey Scott,

We are in the process of switching to dynamics 365. During the tests I asked the same question.

The company that is doing the implementation told me: (not interested in the end-users)

it depends how your system is set up. There should be a invoice date and a booking date.

The invoice date is just that...a date field used for reports and lookups.

The booking date is the date used for the financial bookings...

In the manual from microsoft it doesn't mention a booking and invoice date. (Page 501)

You can download the manual here:

https://opdhsblobprod03.blob.core.windows.net/contents/3217822f545149bc956510410f5a4ad3/bc6b2a6ab31d9412581433ea845a20d9?sv=2018-03-28&sr=b&si=ReadPolicy&sig=oDhZZa9zpOGZcXJR1a7r%2FA6DN6dUKqP2ItgbZIqGBe4%3D&st=2021-06-17T10%3A29%3A50Z&se=2021-06-18T10%3A39%3A50Z

I have no access to the test at the moment, but I think that this is customization for our company.

Remember microsoft is also, not interested in the end-users and every workaround is just 362.022 clicks away

Good luck,

Maarten

Was this reply helpful? Yes No
Suggested answer

russell@dynamicspro... 47 on at

Like (1)

Report

RE: Posting an invoice to the accounts payable ledger where document date is in a closed period

You will have seen in some responses that there are two dates here. In plain English, there is the invoice or document date that interacts with payment terms to give a payable date, and the posting (or tax-point or accounting) date, which usually defaults to the date on your device and impacts the Fx rate and accounting period balances. The open period check must use the posting date, so you can't separate out the functionality you want unless the period is open for posting.

It is not unusual to post a supplier invoice into a prior month, but you will need to open the period temporarily to do this.

Periods are typically closed so that the management accounts can be produced and the numbers shouldn't be allowed to change after that output is produced. By back-posting, you will change company results, so someone will also need to post an accrual forward into the open month to balance the accounting. The periods are usually controlled by the same people that produce the reports and I would not encourage your looking for a workaround - it will unbalance the prior and current periods in reporting terms.

If the management accountant is able to open the period and accrue the cost, you have an answer. If they are unwilling to do this, then you just have to accept the compromise and post on the first day of the opening period. The Fx rate is largely irrelevant in the long run, as you will end up paying the invoice at a different rate anyway.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Posting an invoice to the accounts payable ledger where document date is in a closed period

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Posting an invoice to the accounts payable ledger where document date is in a closed period

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates