Skip to content
← Prepare

Suggest a feature

Prepare: Rules

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Supplier Rule: Set Date Format

There should be a set "date format" option for supplier rules. I have a specific supplier whos dates are always a mess yet they format it consistently in their invoicing. Dext will not consistently read it.

92 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Kathryn Mackenzie shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Melanie Gutu commented  ·   ·  Report

    To set up a rule for certain suppliers that will automatically change the date from the "American" format back to UK format

  • Heidi Lightfoot commented  ·   ·  Report

    I have voted for this, the amount of times I Have been looking for the invoice on quickbooks to realise the date is American format and has been found on the account on for 11th March instead of 3rd November !

  • Kyle Rosin commented  ·   ·  Report

    Create a rule for the date formatting for suppliers dd/mm/yyyy or yyyy/mm/dd

  • Sabrina Johnson commented  ·   ·  Report

    In the Set Supplier Rules add a field for Date format that the AI know how dates are to be read from that supplier. In Canada there is no standard some come in as MM.DD.YY others DD.MM.YY.

  • AdminUserVoice Admin (Admin, Dext) commented  ·   ·  Report

    In Canada, they have a variety of ways that suppliers write the date. Some are DDMMMYYYY, some month-day-year like the US, others are YYYYMMDD and so on. However, each supplier writes them the same way on each document. Is it possible to have a date format choice in the Supplier Rules so that we can preset the date format each one uses. That would allow RB to correctly read that data and save users a lot of time correcting them and the related due dates in the accounting software. Canadians cannot agree on a standard date format, especially since a lot of “Canadian” suppliers are branches of American companies and so use the American date format, but still the currency is CAD. As we have many other ways to customize the suppliers, so the Canadian users would really want this implemented - not tomorrow, but perhaps as part of an upgrade in the future. Many, may users are frustrated with this mixed up way of doing things here, and RB could be on the leading edge of a solution.