Enhance Visual Production Planning in NAV

visual

Enhance Visual Production Planning in NAV by customizing tooltip and label information

In the Visual Production Scheduler, our Gantt add-in for visual production scheduling, tasks, resources, and capacities are displayed along a timeline, thus providing an optimum overview for planners. A visual plan always faces the dilemma of having to show all the information needed for the planner to quickly recognize planning conflicts and intervene while on the other hand avoiding to show too much information to not jeopardize the clarity. This is where the tooltip and bar label come in: Important data is only shown when needed and presented in an understandable way.

Grasping the importance of a meaningful tooltip and bar label, we implemented an enhancement in the last VPS release: The standard NAV information can now be supplemented for each of the VPS objects (PO line, PO routing line, work center, machine center) by equipping up to five internal custom fields with data to use them in tooltip and bar label.

To do this, follow the instructions given in this blog post.

How to proceed

To use five additional fields, only some C/AL code adjustments are needed.

Step #1

Open the C/AL code of the XMLport 5416000 NETRONIC VPS Export and adjust the assignments for the variables as described below. The necessary code lines are already present, but have to be activated:

  • POLCustomField 01…05
  • PORLCustomField 01…05
  • WCCustomField 01…05
  • MCCustomField 01…05

visual

Step #2

In the code units 5416015 NETRONIC VPS Tooltip Mgt. and 5416016 NETRONIC VPS Label Mgt. you find the procedures Add*CustomFields for the variables having been defined before. In the procedures, you’ll find some demo code you can activate and adjust to your requirements.

Step #3

Save and compile all your modifications.

Result

The newly defined fields are now available in the “Configuration tooltip and label” menu in the VPS.

www.allonline365.com

Resource Credit | NETRONIC

Reducing Supermarket Food Waste with Dynamic Pricing

dynamic pricing

The ability to react and cater to consumer demand is nearly always a competitive advantage, but it also comes at a price. Naturally, when a shopper heads to the store to buy their groceries, they expect everything on their list to be available, and their products fresh.

But as supermarkets manage a growing number of products with varying expiration dates, they’re faced with the increasing challenges of selling these items before they expire while making sure they generate as much profit as possible. Failing to accomplish this not only hurts the retailer’s bottom line but also leads to unnecessary food waste. In fact, one-third of the food produced for consumption is lost or wasted globally, and grocers are significant contributors.

In order to save sales and limit loses, grocers often incentivize shoppers to make purchases by discounting products nearing their sell-by date. However, the challenge is that they often struggle to find the perfect pricing and timing balance that will maximize sales and also minimize the discount they need to offer. They walk a thin line of discounting too early or offering discounts that are too high.

With hundreds of thousands of SKUs, internal teams simply can’t manage the complexity of this process. Fortunately, the emergence of AI-enabled solutions makes a responsive price strategy on perishable food far more simpler and more profitable.

Let’s explore how artificial intelligence allows grocery retailers to bypass old roadblocks by enabling dynamic pricing strategies that pad margins and reduce food waste.

Traditional limitations to pricing

Historically, responsive price adjustments were a hassle, or even impossible, especially in physical stores. The process relied on rules-based algorithms that required significant manual oversight.

Picture the pricing gun – employees have to manually walk through the store and change the price on each individual product if there is a sale or special offer on these items. For supermarket and food retailers, the selling period for marked down products is very short, creating a major pain point when attempting to optimize prices in real-time.

These obstacles have led to the development of new tools that automate efforts around identifying optimal prices and enable retailers to make the resulting adjustments quickly.

Optimizing price around sell-by dates

Today, the use of artificial intelligence has led to breakthroughs in markdown pricing. Aggregating demand behavior (historical and current) with inventory information, competitor pricing and sell-by dates allows for pricing strategies that can be optimized in real-time, across all areas of business, and at scale.

For example, bananas that begin to ripen need to be sold while consumers are still willing to pay for them, but not before a new shipment comes in. Providing discounts to shoppers on products that are still fresh gives shoppers an incentive to buy now. This can even be done on a granular, individual store level, as inventory and consumer buying patterns vary based on store geographies. What this means for customers is that products are available at any time at the best possible price, ultimately leading to less wasted food.

Increasing profitability through product affinity

Retailers can also increase profitability by optimizing pricing on products with strong affinity. Analyzing data on products that are sold together, retailers can detect cross-sell opportunities and markdown one product while driving sales of other related products at full price.

As shoppers head to the grocery store for the fourth of July, retailers can find areas to increase sales with perishable and non-perishable items typically paired together. For example, offering a markdown on cherries nearing their sell-by date, if bought with a pie crust, or similarly, full-priced hotdogs and discounted buns.

By linking multiple items, retailers can lower prices of certain products that may have otherwise expired while still increasing the bottom line by ensuring sales of higher-margin items.

Empowering retailers to reduce food waste and better serve shoppers.

When a business deploys dynamic pricing, they become more sustainable – both environmentally and financially. But it also has the benefit of generating loyalty among shoppers who receive the best deals and competitive prices. In addition to time-sensitive food, retailers can also see the advantages of markdown pricing for seasonal items or products with short selling cycles.

With dynamic pricing driven by AI, retailers can gain a holistic view of their entire inventory in real-time, as well as the connections between products, and can optimize their strategies on the fly in order to reduce food waste and better serve shoppers.

allonline365 specializes in retail solutions to help manage your business. We offer solutions that address your current business needs as well as your future ones. Choose a solution that digitizes your business and grows along with you. Contact us on  info@allonline365.com or  +27 (21) 205 3650.

www.allonline365.com

Resource Credit | Progressive Grocer 

New Filter Experience for Power BI Reports

Announcing the New Filter Experience for Power BI Reports

The wait is over!

Power BI has announced that the new filter experience is now generally available. We have updated the look and feel and added a ton of new functionality.

Let’s walk through what’s included in the new filter experience.

Pop-up Filter List

With the new filter experience, report consumers can hover over the filter icon in the visual header to see and read-only list of all the filters or slicers affecting that visual. This makes it super easy for end-users to understand what filters are applied to a visual.

Here are the types of filters this view shows:

  • Basic filters
  • Slicers
  • Cross-highlighting
  • Cross-filtering
  • Advanced filters
  • Top N filters
  • Relative Date filters
  • Sync-slicers
  • Include/Exclude filters
  • Filters passed through a URL

Format and Theme

Report creators now have control over the look and feel of the filter pane. The goal here is to make your filter pane feel cohesive with your report.

You can also modify the default formatting of the filter pane with a JSON theme file.

Lock and Hide Filters

You can now lock filters so that report consumers can see that those filters are applied but they cannot modify them.

Additionally, you can hide filters from your report consumers. Hiding filter cards is typically useful if you need to hide data cleanup filters that exclude nulls/blanks or unexpected values. Hidden filters don’t show up in the filter pane nor the filter dialog for a visual.

Sort Filters

Report creators can custom sort their filters in the new filter pane. This is helpful if you want certain filters to be pushed to the top or if you want certain filters to be next to each other.

new filter experience

You can also choose to alphabetically sort the filters.

new filter experience

Rename Filters

You can double-click on the filter car titles to change the display name so that they are more user-friendly for your report consumers.

new filter experience

When you update the display name, it also gets updated in the filter dialog.

new filter experience

Capture Filter State in Bookmarks

With the new filter pane, you can capture the visibility and expanded or collapsed state of the filter pane in your bookmarks. This is useful when you want to customize how the filter pane fits into your data story:

  • Hide the pane when you don’t need it.
  • Collapse the pane when you need more horizontal real estate for your canvas.
  • Keep the pane visible and expanded when you want users to interact with it.

new filter experience

Learn more about Power BI capabilities and get in touch with allonline365 if you are ready to transform your reporting. Contact us on  info@allonline365.com or  +27 (21) 205 3650.

www.allonline365.com 

Resource Credit | Power BI

xxx

allonline365 Newsletter

Call Now Button