Use the Sales Budget Detail Maintenance window to enter a sales budget for a customer. In this window, you define your sales goals for the customer for the next year. You can set goals in a variety of ways. For example, you can enter a total sales goal for all products or budget individual goals for specific products. You can also assign sales budgets to budget groups to track your own predefined product groups.
Note: Zeroes in any field constitute a customer budget. To assign no budget, all fields must be blank. The window identifies whether the customer uses a foreign currency; if so, assign the budget based on their primary currency.
This topic includes information about:
From the Maintenance > Sales Budgeting menu, select Sales Budget Detail Maint to display the Sales Budget Detail Maintenance window.
In the Customer field, enter the name of the individual or company for which to enter sales goals. This can be either a bill-to or a ship-to customer.
If more than one customer matches your entry, a selection list displays. Select the customer name from the list to return it to the field.
In the Budget Year field, enter the year for which this budget is active.
The system populates this field with the current year.
To enter a general yearly sales budget:
In the Total Budget Sales $ field, enter a dollar amount that represents the total sales budget goal for this customer this year.
The system compares this information to your actual sales during sales budget analysis.
In the Total Budget GP $ field, enter a dollar amount that represents the total gross profit budget goal for this customer this year.
The system compares this information to your actual profit during sales budget analysis.
Note: If you later decide to add product or budget group sales and gross profit budgets, the amount you enter in the Total Budget Sales $ and Total Budget GP $ fields must be greater than or equal to those amounts.
To enter sales goals for specific products or budget groups:
For each product or budget group, in the Product Description, /Budget Group column, do one of the following:
To enter sales goals for a... | Enter a... |
product | descriptive keyword to display a selection list. Select the product to return it to the field. See Searching for Products for additional methods. |
budget group | forward slash (/) and all or part of the budget group name. If more than one group matches your entry, a selection list displays. Select the group to return it to the field. |
In the Sales $ field, enter a whole dollar amount that represents the yearly sales goal for the product or sales budget group.
Complete one of the following fields:
Field | Description |
GP $ | A whole dollar amount that represents the yearly gross profit goal for this product or budget group. If you complete this field, the system populates the GP % field with the corresponding gross profit percentage amount. |
GP % | A percentage amount that represents the yearly gross profit goal for this product or budget group. If you complete this field, the system populates the GP $ field with the corresponding gross profit dollar amount. |
If the total amounts entered in the Sales $ and GP $ fields exceed the amounts entered in the Totals Sales $ and Totals GP $ fields, the system alerts you to the discrepancy and updates the yearly totals.
See Also: