Small and medium business | Business Central, N...

Sales & Receivables setup - Default posting date

(1) Share

Report

Posted on by Ewon Tan

hi Expert,

Anyone know what is the different if selected as / No Date/ for default posting date?

It seems does not work when import the excel file into business central.

It still follows my work date.

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (0)

Sort by

Mohana Yadav 61,248 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Are you using any custom code to import?

is it possible to share the code?
ManishS 86 on at

Like (0)

Report
Copy link

Link copied!

Did you try to creating a document manually and check what posting date Business central takes.

It seems you are inserting the record first and afterwards modifying the record when importing excel.

Can you share your code for better answer.

The code is written in InitRecord().

if SalesSetup."Default Posting Date" = SalesSetup."Default Posting Date"::"No Date" then

"Posting Date" := 0D;
Ewon Tan 83 on at

Like (0)

Report
Copy link

Link copied!

I did not used any code. I only use excel to import via smart connect tools.

Any idea on this?
Suggested answer

Mohana Yadav 61,248 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

I suggest you to connect with the Smart Connect team and they may help you.
Suggested answer

Ben Baxter 7,216 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

If you are importing the Due Date field with a value, it will insert that value.

The Default Posting Date controls what happens when the Order is created in Business Central. Your import is the same as going to the Posting Date field and typing in a value. If you want the Due Date field to be blank, you need to blank your import file's Due Date field before importing.

I encourage you to leave the Default Posting Date as "No Date", unless you tend to ship orders the same day they are received (like in a POS environment).

P.S. I hope this answers your question. If so, please verify the answer so other forum Users know it was helpful!

Best Regards,

Ben Baxter

Accent Software Inc

Carmel, IN