Skip to main content

Notifications

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

Sales & Receivables setup - Default posting date

Posted on by 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. 
 
 
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,892 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,114 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,114 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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans