web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Wrong Date format impo...
Small and medium business | Business Central, N...
Suggested answer

Wrong Date format imported to Navision Purchase Line table

(0) ShareShare
ReportReport
Posted on by Cekata 5

Hello,

PO was imported to Purchase Line table, but the field "Expected date at warehouse" has wrong Date format in mentioned order.

In object designer it is impossible to run Purchase Line table, there is an error about wrong date format. Also there is not possible to open order in user interface, the same error.

Maybe you can help me to fix this issue? How it is possible to delete imported order?

Thank you

Kata

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 49,097 Super User 2025 Season 2 on at
    RE: Wrong Date format imported to Navision Purchase Line table

    Create a simple report to filter that purchase line and update the date in the report using CAL.

  • Suggested answer
    Gearoid Profile Picture
    Gearoid on at
    RE: Wrong Date format imported to Navision Purchase Line table

    Hi,

    If you copy the database to a test environment you could try using a tool (e.g. SQL Server Management Studio) to UPDATE the invalid date value on the relevant Purchase Line record to a valid date. Afterwards you may be able to use Dynamics NAV to manage the order in the normal way. I'd suggest trying this in a test environment first to make sure you don't get unexpected results. 

    Alternatively you may be able to use RapidStart to export the record to a spreadsheet, fix the value, and then re-import it into the database. 

    If all else fails I would recommend opening a ticket with your Dynamics NAV partner. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,899 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,444

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,304

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans