Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Sales & Receivables se...
Small and medium business | Business Central, N...
Suggested answer

Sales & Receivables setup - Default posting date

(1) ShareShare
ReportReport
Posted on by Ewon Tan 72
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:
Business Central
Business Central
Business Central
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,915 Super User 2024 Season 2 on at
    Sales & Receivables setup - Default posting date
    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
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,137 Super User 2024 Season 2 on at
    Sales & Receivables setup - Default posting date
    I suggest you to connect with the Smart Connect team and they may help you. 
  • Ewon Tan Profile Picture
    Ewon Tan 72 on at
    Sales & Receivables setup - Default posting date
    I did not used any code. I only use excel to import via smart connect tools.
    Any idea on this? 
     
  • ManishS Profile Picture
    ManishS 6,578 on at
    Sales & Receivables setup - Default posting date
    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;
     
     
  • Mohana Yadav Profile Picture
    Mohana Yadav 59,137 Super User 2024 Season 2 on at
    Sales & Receivables setup - Default posting date
    Are you using any custom code to import?
    is it possible to share the code?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans