web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Configuration packages

(0) ShareShare
ReportReport
Posted on by 645

The "DYNAMICS365" Configuration Package for one of my clients appears to be corrupt.

In order to figure out which fields are truly necessary before doing a major upload of sales headers and sales line items, I am attempting to upload 2 sales headers, with 3 associated line items.  I have meticulously deleted all other data from the workbook I downloaded from the "Configuration Packages" page.  I added my two sales orders (and line items), imported the spreadsheet back to the Configuration Packages page, and validated it.  The package shows "1328 records" with "1328 errors".  The errors include text that is something like "Quote Nos. must have a value in Purchases & Payables Setup".

I believe these errors have something to do with a previous attempt to upload purchase orders en masse.  I'm also seeing other errors associated with records I am not currently attempting to upload.

Microsofter's.  The client is Siege Sports.  Can you check the tables on the backend to see whether these are corrupted?

The Configuration Packages are very convenient for uploading G/L entries, but are horribly time-consuming when it comes to uploading purchase orders and sales orders.  Is there a better way to do this (perhaps programmatically).  I would much rather load P.O. and S.O. data to SQL tables, and write a program to bring the P.O.'s and S.O.'s in through a service.

Categories:
I have the same question (0)
  • MCarrero Profile Picture
    774 on at

    I have run into this also.  On your spreadsheet, you must delete the extra lines as well, not just the data.

    If there are empty lines that are configured, it will pull them in and show errors.

    You can tell if you look at the number of lines pulled in when you import from excel.  If it is more than the number with data, you need to remove them, then import again.

  • Dave Boehm Profile Picture
    645 on at

    I've found part of the problem.  It is truly disgusting.

    Evidently, the configuration packages retain old data.  You can see this by clicking on "DYNAMICS365".  Once you clear out the records in the "No. of Package Record" column, the records will be gone.  Otherwise you'll keep validating obsolete data.  I really don't know why the designers did this, unless they were trying to allow for packages completed by different people, to be uploaded at separate times.

    In any event, I suspect there is a programming bug somewhere in the Configuration Package process.  I am getting an error of "you cannot base a date calculation on an undefined date. date: 0d formula:"  I've entered dates in all date fields shown on the Sales Header.  I still get this error.

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans