Finance | Project Operations, Human Resources, ...

How to post invoices from ExFlow with system date as posting date?

(0) Share

Report

Posted on by Vinayak Godbole

We use ExFlow to manage vendor invoices. When an invoice is posted from ExFlow to F&O, we want it to use system date as posting date. Invoice approval process can take a while, up to a few weeks sometimes. Hence we want to use system date as posting date to standardise the process.

Our F&O version is 10.0.27, upgrading to 10.0.29 soon.

Appreciate any guidance on how to achieve this in F&O.

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

Hi,

I think at first you may take this with Sign up team (Exflow), they can suggest something.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 299,149 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

Hi Vinayak,

Exflow is a third party-software solution. You can contact your partner or Signup Software who is the vendor of this solution for more help.

Was this reply helpful? Yes No
Vinayak Godbole 5 on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

Thanks Andre, I was expecting that the control sits in F&O as it should decide what the accounting date should be? But yes I will ask Exflow as well.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,149 Super User 2025 Season 2 on at

Like (1)

Report

RE: How to post invoices from ExFlow with system date as posting date?

Hi Vinayak,

Exflow do have their solution inside of F&O. They control what dates are used within their own tables and import logic. From the invoice overview table, they copy data to standard journals with their own x++ logic. A lot of the behavior can be controlled with parameters. I don't know if they have a parameter for using the system date or other dates. I did an implementation once, but it has been too long ago to remember all details.

Was this reply helpful? Yes No
Vinayak Godbole 5 on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

Thanks Andre, appreciate the feedback, it helps us understand more about Exflow. We went live with F&O earlier this year and still working through a lot of improvements. In this particular scenario, we are getting conflicting responses from Micrsoft and Exflow/Signup. There is a new parameter in F&O with ver 10.0.29 as shown below. Can you please let us know if this parameter can override what comes out of Exflow or is it only supposed to work for any invoice processed within F&O.

Thanks for your help and time.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,149 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

Hi Vinayak,

You would definitely need to get the correct answer from Signup Software if they are aware of this parameter and have implemented it in their coding or are doing it in a different way (or not). Maybe adopting this parameter can be on their backlog if it is not considered yet.

Was this reply helpful? Yes No
SimonCarne 35 on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

Hi Vinayak

Just curious whether you have found a solution to this?. My organisation has recently implemented Exflow with D365 F&O and we have the exact same issue. A big effort is required every month by the AP team to manually update posting dates. Our implementation partner has advised us there is no other solution. I have used D365 F&O in multiple previous roles but I am new to Exflow and I am surprised there seems to be no solution to this.

If it helps I have tested using the change posting date parameters introduced in 10.0.29 in a sandbox environment and unfortunately this does not work with the post cost invoices function in Exflow. It only appears to work for standard tax invoice journals.

I have spoken to our local sign-up software contacts about this and they have referred me to the update invoice date function (when they say invoice date they mean the transaction date or posting date in F&O).

You can set this to run as a recurring batch job and it will update the posting date of invoices in "import form all" that have a posting date in a closed period to the first date in the next open period, if you leave the date blank. Or alternatively you can specify a date in the next open period and it will update the posting date to that. The limitation is this does only work for invoices that have not been loaded to an approval journal (so at the invoice register stage). It helps a bit but still leaves all those invoices in approval journals waiting for approval to be manually updated so they will post once approved. There is also something called posting control in Exflow which lets you route invoices back to the AP team for final approval before posting. If there is an option here may be with an excel template to bulk update the posting dates that could be a solution. I have yet to test this.

Best regards

Simon

Was this reply helpful? Yes No
MldFar 52 on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

hi Simon,

I Exflow you have two options to use the Posting date:

Was this reply helpful? Yes No
Suggested answer

SimonCarne 35 on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

HI Mldfar

Thanks for your reply. I am familiar with those parameters and we use them to assign the scanning date as the posting date on import of the invoice to D365 F&O. However the issue is this": an invoice is scanned and imported on 28 Feb (this is the last day of the period), it is created in D365 with a posting date of 28 Feb. The next day 1 March the invoice is sent for approval. We are now in the new period March and the February period is closed. Several days later our Feb 28 posting date invoice is approved and the auto posting job attempts to post it but fails because the period is closed. We then have to manually change that invoice posting date to March in order for the invoice to post.

That is the problem but I have some possibly good news for the original poster Vinayak. I believe there is a solution. In Exflow there are these two parameters as highlighted below.

If these parameter are on the posting date will be changed to the 1st day in the to the next open period (and allow this into the next financial year if the second parameter is also on). This happens at import and at final posting. As you can see we have these parameters on and I can confirm that the posting date is automatically updated to the first day in the next open period at import. However for us this does not happen at final posting, hence we have to manually update the posting date. I have logged this with Sign-up software support and they have confirmed that with these parameters set on the posting date should be being updated automatically at final posting. I am working with them currently to resolve this. Once I have a resolution I will post an update.

Was this reply helpful? Yes No
Suggested answer

SimonCarne 35 on at

Like (0)

Report

RE: How to post invoices from ExFlow with system date as posting date?

Hi Vinayak

I have posted a possible solution in my reply to the latest post from MldFar.

Hope it solves the problem for you.

Best regards

Simon

Was this reply helpful? Yes No