Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Posting Date Vs. Invoi...
Microsoft Dynamics NAV (Archived)

Posting Date Vs. Invoice Date on ILE

(0) ShareShare
ReportReport
Posted on by PeterSwift 80

Most of our sales reporting reads from the ILE.  Unfortunately, there is sometimes a gap between the date that the items are posted and the date they are invoiced.  This usually indicates additional warehouse processing, or pre-processing an order prior to a customer's requested ship date.  Invoicing occurs on or after the ship date and once the order has been manifested.

However, because there can be a time difference between invoicing and posting (sometimes weeks), our sales reporting can be thrown off, since the ILE recognizes the date of the posting, but not the date of the invoice.

How can this be reconciled? Is it possible to add an "invoice date" field to the ILE that is updated at the time of invoicing and change our reporting to look for those dates?  Or do we need to match posting dates with invoicing dates?  There was a fear that GAAP requires posting dates to match invoicing dates as well - is there any legitimacy to that?

*This post is locked for comments

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Posting Date Vs. Invoice Date on ILE

    You cannot directly take the details from ILE because ILE only maintain the movement of the inventory. What is the best way?

    You can take the details from the value entry table.

    At the time of GRN one entry will be posted to Value entry with the expected cost and once you invoice the order it will again post another line with the actual cost.

    So Value entry would have 2 lines against this.

    There is a link with the ILE and Value entry

    In the value entry table you will be able to see "Item Ledger Entry No." and that is your key to the solution.

  • serendipity Profile Picture
    serendipity 1,010 on at
    RE: Posting Date Vs. Invoice Date on ILE

    Hi,

    I am confused with this query.  First in standard NAV, there is NO 'invoice date' either in the Item Ledger Entry table (could be a customized field on your scenario) or in the value entry table (we have the valuation date and posting date).  Valuation Date is used to calculate the inventory value as of a specified date.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Posting Date Vs. Invoice Date on ILE

    Hi Lets Get Efficient,

    The ILE is purely for the movement of the Inventory related data.  If you think from a wide angle, there could be multiple invoices for single shipment.  In such circumstances, the ILE will have only a single entry for the Shipment and the storage of multiple invoice dates in a single line will not be possible.  So the related details are stored in the Value Entry table.  you may relate your ILE with the Value Entry and get the details.

    Best Regards,

    MMV

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans