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
Create a simple report to filter that purchase line and update the date in the report using CAL.
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.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
