Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Sales Budget - Unposte...
Microsoft Dynamics NAV (Archived)

Sales Budget - Unposted sales

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi All

Business question rather a NAV question here

Working on setting up the sales budgets I noticed that until a sales order is received nothing hits any GL

Because of this a sales budget for "expected revenues before the shipment" cannot be added to the budget

We are a FMCG company and orders are received 24/7. Lines that cannot be shipped because of availablilty are recorded as "shortages", the order is marked as - completely shipped- and posted regardless of the outstanging quantities

I would like to avoid having a separate report/ tool for ordered vs shipped and try to match the figures with the budget

My Question

Is there a way to capture the value of the original order in NAV and use this "accrual of expected revenues" in the budget?

*This post is locked for comments

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Sales Budget - Unposted sales

    [quote user="A.Iorio Rondanini UK LTD"]

    The difference between the two would be like a "missed sales opportunity" or something like that..

    [/quote]

    Hi,

    Yes - you could apply a posting, when the Sales Order is deleted manually.
    Please note, going this way you would also have to think about transactions which will decrease your Stock account.

    Basically, when you release, decrease stock account and increase the same amount to the new account.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Budget - Unposted sales

    Thanks Hannes

    I guess what you describe is the standard way of handling this.

    That would add a lot of manual data processing though

    Also, because we use lot Nos. posting the order regardless of what shipped would crearte massive inventory issues

    Ideally we should go for a customization that allow the Tot amount of a sales order to hit a GL when the document is released (as you point out correctly regardless of the qty shipped)

    Then, when shipped it will reverse the accrual and the normal posting will begin

    The difference between the two would be like a "missed sales opportunity" or something like that..

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Sales Budget - Unposted sales

    Hi,

    I think, unfortunately, this is not possible "out of the box". If you do not consider an individual customization from your NAV-partner as a solution, every solution would have a "snag".

    In your situation, when I understand correctly, you post the whole order into the financials. That means even, when the product is not delivered (because of a shortage), the product is posted. Correct?

    In this situation, you could create new posting group for such products. In the posting group setup you could select a specific G/L Account for such situation. Then, when it is not possible to deliver a product you would have to manually change the posting group. When the order gets posted, undelivered products would hit a specific G/L Account which you could catch in the budget.

    Please note, you would need to create a transaction manually when you delivered the product.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans