Difference between Transfer Journal and Transfer Order?

What is the difference between a transfer journal and a transfer order?
Transfer journal – The Inventory Manager transfers the items from one dimension (warehouse, location, color, etc) to another one instantaneously.

Transfer order is used for registering in the system the items that must be moved from one warehouse to another and for managing this process.

Process Includes:
Create Transfer Order
Pick Items to Transfer->then->Picking list registration
or
Pick Items to Transfer(No Picking list registration)
Ship Transfer Order
Receive the Items at other end.

Personalize Dynamics 365

With the release of Dynamics 365 you are now able to do a quick personalize Dynamics 365

We will personalize “Release product” form.

Follow path : Product information management > Products > Released products. click on “Option” button to Personalize release product form.

On below screen click on “Personalize this form” this will open small panel for personalize this form; which include move grid from one place to another, hide any field, add any field etc.

Click on “+” sign to add field in form. then click on any field, this will open one small window to add fields on selected form.

Select the check box to add field and click on “insert” button to add it. this will add field on selected form.

you can also export and import any personalization from “Manage” button.

Hope this will help you to personalize Dynamics 365

 

Try out Dynamics 365 for Operations now for free!

With the release of Dynamics 365 you are now able to do a quick demo of the client with a VERY limited set of functionality.

By going to: https://aka.ms/D365OperationTrials you will be able to get your very own company to play around with.

The experience of setting it up is remarkably simple.

Just add you email addresse in the registration box (Mine was in my native language). You do need to have an Office 365 subscription (or atleast an Azure tennant). Invite some collegues to join you in the demo experience (from your domain) and watch the magic happen.

Ready to explore

You will then be presented with an environment that is only accessable by you and the people you invited from your organization.

After the intro the system will send you directly to the scripted Task guide demos.

You can then click through any of the three scripted demos on your own to experience the Dynamics 365 for Operations web client.

If you want to roam around the application on your own, you can do so. There are however a very limited set of things you actually can do.

The access level is very restricted as you can see in the modules available.

It gets even more apparent when you look at the individual modules.

Not much to click on, but the full blooded version might be a bit daunting (as shown below) and this is maybe more close to the actual experience of a simple application user.

You cannot create a sales order,  but it is however possible to create a new purchase order.

So this is most definite NOT a feature demo, but a simple demo of the user experience which is pretty awesome. Contact your Dynamics Partner or Cloud Service Provider to get a full demo of the functionality.

Also check out the AppSource for more industry specific or scenario related application demo.

Return purchase order in AX 2012

Introduction

In this post, we will walk you through return purchase order/ Vendor return in AX 2012. Many times company want to return goods which they have received from vendor due to various reasons such as damaged product, Expired product, Wrong product etc.

In order to return goods to vendor, we create a return purchase order in AX 2012.

There are two ways to create Vendor return in AX 2012:

1. Create purchase order with negative quantity

It is useful when there is no reference to specific purchase order or Return merchandise authorization is not required. In other word, company can return any item to vendor without any negotiation or notification.

This process is same as normal purchase order process with negative quantity.

2. Create a return purchase order.

 Return order is created in reference to specific purchase order and it should be authorized by vendor i.e. vendor should provide RMA number which indicates the permit for return of goods to vendor.

Requirement

Purchase order should already be created and invoiced in order to create a return order for it.

Background

Let’s assume that the inventory manager accidently found some items are damaged. He notifies the purchasing manager about the issue. Purchasing manager decides to return the damaged items to the vendor. Purchasing manager creates a return purchase order to facilitate return of goods to vendor.

Steps to create return purchase order

1. Go to Account payable –> Common –> Purchase orders –> All purchase orders.

2. Click on Purchase order button to create new purchase order.

3. Enter:

   a. Vendor account number: It is the same vendor to whom we are returning goods.

   b. Purchase type:Select purchase type as “Returned order“.

  c. RMA number:As soon as we select purchase type as returned order, we can see RMA number field appears in the form. Enter the RMA number received from the vendor which permits the return of goods to vendor.

  d.Enter other details as per requirement.

4. Click ok to create purchase order.

5. Now we need to add lines in the order which we can do it manually or with the help of credit note.

Add lines through Credit note

6. Go to Purchase order form–>click on purchase order lines–> Click on credit note

    or 

    Go to purchase order form–>go to purchase fast tab–> click on credit note.

7. Select the appropriate purchase orders and their lines.

Note:We can select multiple purchase orders and their specific lines to get them in return purchase order. Purchase orders specific to vendor selected in the return purchase order can only be seen in credit note form.

8. Click ok to get the lines in return purchase order.

9.Here you can see line in the return purchase order with negative quantity.

Confirmation

10. Post the Return purchase order confirmation after verifying all the details.

Receipt list

11. Post the receipt list for the items in the return purchase order.

12.The status of the inventory transactions goes to Physical reserved i.e. items will get physically reserved in the warehouse to get it picked for return.

Picking

13.Unfortunately, it is impossible to create a picking task for a purchase order line (or for an output order that can be created for the purchase order line). So, we cannot use the Picking form (Inventory management > Common Forms > Picking routes). We assume that the Purchase Manager calls the Warehouse Worker and asks him to perform the picking task: pick the broken items from a specific location, transfer the broken items to the outbound location, and inform the Purchase Manager about the operation being completed. The Warehouse Worker receives this in an informal form from the Purchase Manager, because we can’t create the picking instruction document in Microsoft Dynamics AX for the returned items. When the Warehouse Worker completes the picking task and informs the Purchase Manager, she or he does the following: in the lines area of the Purchase order form, click the Update line –> Pick button.

14. Click on Add picking list update button to get the items available for picking list update.

15. Click on Register all to update the picked item in the system.

.16.Once done,Issue status goes to “Picked”.

17. We can see inventory transactions status is updated from “Reserved physical” to “Picked”.

Product Receipt

18,We assume that the items are loaded to the truck and delivered to the vendor. When the items are delivered, the Purchase Manager posts, prints, and sends the Packing slip document for the vendor to sign. The Packing slip document is a guarantee that the vendor receives the broken items.

19. Go to purchase order –> Receive fast tab–> Click on product receipt.

20. Enter the product receipt number.

21.Click ok to post the product receipt which is then send for the vendor to sign.

22. Once done, we can see inventory transactions status is updated from “Picked” to “Deducted” as the items are deducted from the warehouse.

Invoice

23.The Purchase Manager posts, prints, and sends the invoice document for the vendor to sign. This document confirms that the vendor must pay (return) some amount of money for the broken items.

24. Go to purchase order –>Invoice tab–> Click on Invoice button to post the invoice for the order.

25. Enter the invoice number and click on Post button to post the invoice for the order.

26. Once done, invoice will send to vendor for signature. It confirms that the vendor must pay for broken items.

27. Go to inventory–> Transactions–>The status is updated from “Deducted” to “Sold“

 

Note:The invoice document which is generated has the title “Credit note“. To view the credit note report, go to purchase order form–>go to Invoice tab–> Click on invoice journal–>click on Preview/Print –>Click on original preview/Copy preview.

In this way, we can create a Vendor return / Return purchase order in AX 2012.

Please post if any queries or suggestions to be made for improvement.

Keep Daxing…

AX – View Role assign to User

Source: AX – View Role assign to User

Setup and process for intercompany trade in Microsoft Dynamics AX 2012 R3

Source: Setup and process for intercompany trade in Microsoft Dynamics AX 2012 R3

Setup and process for intercompany trade in Microsoft Dynamics AX 2012 R3

 

 

Dynamics AX 2012 R3 allows for the capability to handle intercompany trade transactions. Intercompany trade transactions allow organizations to sell products and services to other business units or legal entities within the organization for fulfillment of a customer order.

This blog will outline the setup and process of creating a sales order for an external customer with the help of intercompany trade process.

For example, we have an organization with two legal entities, GCCI and USMF. GCCI receives the order from a customer, but does not have inventory to fulfill order. Therefore, USMF will fulfill the order with their inventory and deliver directly to the customer on behalf of GCCI. For this to occur, GCCI will use the intercompany trade transactions process.

The first step is to create a vendor in GCCI in the USMF entity. A new vendor can be create by navigating to Accounts payable > Common > Vendors > All Vendors.

Next, let’s create a customer record in USMF for the GCCI intercompany customer. To create a new customer, navigate to Accounts receivable > Common > Customers > All Customers.

Once the customer record has been created, open the customer record and open the miscellaneous Fast Tab. Then check the create intercompany orders option.

Then go to the general tab in the action pane and select Intercompany.

Once in the intercompany menu, check Active to setup trading relationship. Under Purchase relation, select the vendor company and specify the intercompany vendor record created in GCCI.

In the purchase order policies tab, a set of options will be available for a user to select. These options dictate how the intercompany purchase orders and intercompany sales orders will behave. To fully understand the various options available for intercompany trade relation setup, refer to this TechNet article: Set up intercompany trade [AX 2012]. In this example, Post invoice automatically under Original sales order (direct delivery) and Post invoice automatically  under Intercompany purchase order (direct delivery) are checked.

In the sales order policies tab, the intercompany sales order tab lists options that dictate how the intercompany sales will function. In our example, the sales order numbering and customer payment journal is specified

Once the trading relationship setup is completed, close the intercompany form and go to the GCCI company to begin creating the intercompany sales order. Keep in mind that after the intercompany trade setup is activated, the intercompany vendor account in GCCI will be automatically setup. To process an intercompany sales order, navigate in the GCCI entity to Accounts receivable > Common > Sales orders > All sales orders. Create new sales order and specify the customer for which the order will be fulfilled. Then proceed to fill the necessary information like item, quantity, site and warehouse, and etc. After the sales order is filled, select Header view in the action pane.

In the intercompany FastTab, check the Autocreate intercompany orders’ and Direct delivery options.

Then in the action pane, select Direct delivery. Specify the intercompany vendor account and then flag the Include flag. Then select OK.

An infolog will then appear indicating that a purchase order and an intercompany sales order have been created. Then close the sales order form.

Now the user will go to the USMF entity and navigate to Accounts receivable > Common > Sales orders > All sales orders. Locate the sales order that corresponds to the sales order created in GCCI. In this example, the intercompany sales order can be identified by number sequence.

Open the sales order and process the order as normal. At the end of the process, the sales order should show the status as Invoiced.

After successfully invoicing the sales order in USMF, go to the GCCI company and navigate to the intercompany purchase order. It can be noticed that the purchase order was invoiced automatically. Keep in mind that the status of the purchase order will appear as invoiced because we had set the option in the intercompany relation setup.

Navigating to the original sales order, you’ll notice that the status of that order will also show as Invoiced. Upon completion of the transaction, users can make and receive payments by using the AP and AR payment journals.

 

Import data with the DIEF

This article describes how to import data with the DIEF in Dynamics AX 2012

Step1: Import the file in the staging table

Access: Data Import Export Framework > Common > Processing group

• Click “Get staging data”

• Job ID is given by the system
• Enter a description

• Click “OK”
• Click “Preview” to check if information are correct

• Click “Run”
• and “OK”

• · Data are created in the staging table

Step2: Import data to the target

• Click “Copy data to target”

• Select Job ID used above
• Click “OK”

• Click “Run”

• Click “OK”

• · Records are created

 

 

Create a processing group for positions with the DIEF

This article describes how to create a processing group to import positions with the DIEF in Dynamics AX 2012

Position

Access: Human Resources > Common > Organization > Positions > Positions

I need to import:

• Position
• Description
• Report to position
• Assignment date

Note: The “Report to position” in the DIEF is created via the Relationship. That why you need to setup to fields with value Hierarchy name+Position Id

Setup the Processing group – Option CSV file

Access: Data Import Export Framework > Common > Processing group

• Click “New” and enter a name and a description

• Click “Entities”
• Select Entity = Positions
• Format = CSV
• Select the two options

• Click “Generate source file”: the wizard form is open
• Click “Next”
• Select the fields below
  • Position = Position Id
  • Description = Description
  • Report to position = HcmPositionHierechy_ParentPositionId and HcmPositionHiearchyType_Name
  • Assignment date = HcmPositionDuration_ValidFrom

 

• Click “Generate sample file”

A csv file is open and contains all the fields selected above

• Click “Finish”

 

• Complete the file with all the positions you want to import and add the path to the processing group.

• Click “Generate source mapping”

• Click “Validate”

The processing group is now created and can be use to import data.

Remark: If the report to position refer to positions include in the same file, you will need to import twice the file:

• First round to create all positions
• Second round to assign the report to position

Dynamics Excel Add-In

This article presents an example of the Excel Add In utility in Dynamics AX 2012

Step 1: Identify the table in Dynamics AX

• Open the table you want to use in Excel Add In
• Right click > Personalize

• Note the table name

Step 2: Import the table in Excel

• Open Excel and go to the Dynamics AX tab
• Click “Connexion”
• Select the company

• Click “Add data”
• Select “Add table”

• Retreive the table and add it to the Selected table area

• Select option “Create worksheets”
• Click “OK”

• Table is open in Excel:
• Key fields are automatically selected

 

 

• Add column:
• Double click to add a column

Step 3: Refresh the data of the table

• Close the “Field Chooser” bar
• Click inside the table
• Click “Refresh  All” > “Refresh Current”

• All the data from Dynamics AX are loaded in the Excel file

Step 4: Update or create a new record

You can now update the data:

• for example the description

And load the updated data into Dynamics Ax

• Click “Publish” > “Publish selected” to publish only the current worksheet

• Once the data are published, a new sheet is created with the details of the import status

• Check in Dynamics AX: the table has been updated

Or you can add a new record:

• Create a new line in the excel table
• Populate all the fields

• Click “Publish all”

Remark: If there is an error (a code does not exist for example), the error will be describe in the status report and the record is not imported.

• Check in Dynamics AX: new record has been created