web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Unable to create Sales...
Microsoft Dynamics NAV (Archived)

Unable to create Sales Budget

(0) ShareShare
ReportReport
Posted on by Sarav 443

Hi All, I'm trying to create Sales Budget based on Dimensions Vs Period. When I key in the value, I'm getting an error message as 'Item No. must have a value in Item Budget Entry: Entry No. = 1. It cannot be zero or empty'.

I could not get enough documentation for Sales Budgets as compared to GL Budget. Kindly request to help me on creating the Sales budget by resolving the Item Budget issue. Thanks in advance.

2017_2D00_08_2D00_10_5F00_9_2D00_43_2D00_59.png

*This post is locked for comments

I have the same question (0)
  • Jalmaraz Profile Picture
    Jalmaraz 669 on at

    I think this could be fixed if you put on "Ítem Filter" a value with an unique Item. Item No. seems be mandatory.

  • ManishS Profile Picture
    ManishS 86 on at

    Yes this is an issue, just checked.

  • Sarav Profile Picture
    Sarav 443 on at

    Dear Jesús Almaraz Martín,

    Though it works, there is a restriction of assigning Budget to each of the Item (which is impossible since we have more than 400 Items).

    In my case, we tagged Dimensions to the Customers and the budget needs to be calculated for the Sales transactions of those Customers.

    Request your suggestion on handling this case.

  • Verified answer
    Jalmaraz Profile Picture
    Jalmaraz 669 on at

    Good morning Saravanan:

    I think there is no good solution in this case. But let´s see the better one (IMO):

    Create a new and fictitious Item only for budgets and set this Item to fill the Budget.

    This could fix the problem, unless otherwise you say: "I want to hide all this to the user. User can´t see the fictitious Item." So, you can follow these steps:

    - A new field in Item Budget Name table "Default Item No.".

    - A Special Item Budget Page, with the Item Filter hidden, and Code to set this filter to the field created above.

    A single question to check before (I can´t check this here): Analysis views work with different Item in Budget and entries. I think yes, but not sure.

     

    I am sorry if not enough useful or difficult. Best regards.

  • Sarav Profile Picture
    Sarav 443 on at

    Dear Jesús Almaraz Martín,

    Thanks much. It works fine now.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans