Creation of Shipping Calendar to display on dashboard

By | March 29, 2024

To create a Shipping calendar we will use X3 calendar functionality.
The shipping calendar will help us with delivery tracking. Specially it will be helpful for sales and warehouse teams.

For creation of “Shipping calendar” we are going to use SORDER and BPCARRIER table’s.

Step 1: Go to Setup>Usage>Reports>Graphical query tool. Create new query

  • We require following fields: DEMDLVDAT, SOHNUM, BPDCRYNAM, ORDSTA, ALLSTA, MDL from SORDER and BPTBPTNAM from BPCARRIER.

Fig: Graphical query screen 1

Add below lines in selection filed:

Fig: Graphical query screen 2

Activate the check box and validate the screen. Click on RUN button to verify the record.

Fig: Graphical query screen 3

Step 2: Go to Setup>Interactive dashboard>Dashboard view. create new dashboard

Fig: Dashboard screen 4

Fig: Dashboard screen 5

Step 3: Create new menu items. Link type – Query.

Fig: Menu-Item 6

Create new menu item. Link type – Calendar.

Fig: Menu-Item 7

Step 4: Create new Home Page.

Fig: Home Page-8

Select calendar:

Fig: Add gadgets 9

Fig: Add gadgets 10

Fig: Dashboard 11

About Us:

Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.