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

I have the same question (0)

All responses (5)

Answers (0)

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Are you using any custom code to import?

is it possible to share the code?

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

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;

Was this reply helpful? Yes No
Ewon Tan 83 on at

Like (0)

Report

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

Any idea on this?

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,620 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No