Gross Margin by Customer Report

  • By Semra Tuzin
  • 30 Nov, 2017

This report can be used to view the Gross Margin per Customer. It can also be used to view Sales for a particular day or date range. You can filter the report to show all customers, specific customer, Sales Order or even Item.

1. Click Area Page node: Sales and marketing -> Reports -> Statistics -> Customer -> Gross margin by customer.

Form name: Gross margin by customer

2. Switch to the General tab on the Gross margin by customer form.

3. Click Summary if you would like to view a Summary per Customer as oppose to a detailed view. See # 7 for an example.

4. Click the select button.

5. Here you can narrow down what you would like to show up on the report. In the Field field you can select multiple fields to view. In the Criteria field you can filter by what exactly you want to see. If you would like to view the report for a specific date. You would select the Field dropdown and select Date . In the Criteria field you would select the date or date range by adding a ".." between the dates.

6. Click the OK button.

Form name: Gross margin by customer

7. Switch to the Options tab on the Gross margin by customer form.

This is what the report would look like if you select the summary checkbox.

Below is what the report would look like if the summary checkbox was not selected.

By Simon Bradford 14 Dec, 2017

Inventory planners have a tough job, they need to make decisions on inventory based on incomplete data, for multiple items and warehousing locations. AX Forecasting is designed to help remedy some of the guess work by allowing customers to inform you of their expected needs, avoiding supply headaches and surcharges for late deliveries.

By Remington Hall 12 Dec, 2017

Convenience:  We give you an opportunity to learn from the comfort of your home, office, or client location. If you have an internet connection you are ready to learn!


Clarification:  Opportunity to ask questions with interactive, hands on answers.


Affordability:  We hold our webinars at no cost, saving you time, and money while avoiding travel.


Recorded:  We try to record every webinar, giving you the ability to share content with co-workers. Also allowing you to watch the webinar if you signed up but were unable to attend.


Knowledge: Gaining knowledge on something you weren’t familiar with before can always be beneficial whether it be applicable in the present or the future: Knowledge is power!


Learn from the Pros: Since webinars are time saving, companies are able to get their most knowledgeable employees to participate/ present these online presentations.


Just the beginning:  After attending a webinar, you are able to see if the topic is suitable for you. If so, we are able to simply schedule a more in-depth call or webinar with you individually.


Relevant Topics: You are able to know exactly what we will be discussing in the webinar before attending, if you see that you are not suitable for the webinar it is much easier exiting a tab than driving back to the office.

By Semra Tuzin 07 Dec, 2017

Role Centers is a dashboard that can have transactional data, alerts, links, common tasks, reports and more. It contains Web parts which are located in zones. Web parts display data and allow the user to customize what data they would like to see. Web parts can be arranged into different web part zones on a page (Would you like this information to show on the right side, left side, Infolog, header, footer and etc.?). You can customize to show only information you are interested in. There are two types of views: personal and shared. Personal means that you are customizing the role center so only you can see the customized view. Shared is when everyone can view the customizations.

By Sarah Breuls 05 Dec, 2017

When it comes to taxes in Sage 300 ERP, there are 4 main steps that need to be done

1. Tax Authorities – This is where you create the individual tax code with a configuration that will define whether the tax amount is to be added to the cost or has to be expensed out with it comes to purchasing. We also assign the liability account that will be used for transactions

2. Tax Classes – This is where you define the classes for each individual authority which is setup in step 1. Typically, it will have two classes one will be “taxable” and the other “non-taxable” this will be setup for Sales/Purchases, Customers/Items and Vendors/Items

3. Tax Rates – This is where you will define the rate of which the authority will calculate at for both Sales and Purchases

4. Tax Groups – This is where we can assign multiple tax authorities together as some transactions may need to have multiple tax codes calculate at once. This will also need setup for both Sales and Purchases

By Semra Tuzin 30 Nov, 2017

This report can be used to view the Gross Margin per Customer. It can also be used to view Sales for a particular day or date range. You can filter the report to show all customers, specific customer, Sales Order or even Item.

By Aleks Azarchankau 28 Nov, 2017
In this blog, we will be discussing how to create and post trade agreements in Microsoft Dynamics AX via X++ code. This will be done via the PricePriceDiscJournalService , which is an AIF service.
By Semra Tuzin 23 Nov, 2017

1.     General ledger  > Periodic  > Journals  > Periodic journals .

2.     Click on New.

3.     In the dropdown under Name click GLRECURRIN journal type.

4.     In the top ribbon click Lines.

5.     Click New.

By Jennifer Holman 21 Nov, 2017

We often find ourselves needing to find more information on customers, transactions, balances, projects, and expenses. We want this information quickly and easily visible. Microsoft AX 2012 and Dynamics 365 visual grids exports to excel using a simple keyboard:

command, Ctrl T.

Take Customer Transactions as an example:

Navigate to the ALL Customers – Highlight the customer account to review the Transactions. And Select the Transaction Button

By Jennifer Holman 16 Nov, 2017

When Implementing a new solution like Sage 300 or Microsoft Dynamics look at funding options for your business in Canada.

A funding program we partner with is the Canada Job Grant (CJG),  it helps cover training costs during an implementation based on the number of employees on staff and involved in the ERP Software training.  

By Semra Tuzin 14 Nov, 2017

1.       Accounts Receivable > Common > Customers > All Customers

2.       Double click the “Child” Customer. In this example the child is ABC Company 2 and the parent is ABC Company.

3.       Click Customer > Edit

4.       Scroll to the bottom and select the Invoice and Delivery tab

5.       Click on the dropdown menu and select the “Parent” Company

More Posts
Share by: