venerdì 29 maggio 2026

D365FFO - Available on location flushing principle

 

Step 1  ·  Open Released Products

Go to Product information management > Products > Released products.

Find and select the finished good item.


Step 2  ·  Open the Engineer menu

On the Action Pane, click Engineer.


Step 3  ·  Open the Formula

Click Edit on the formula header.


   


Click the link in the Formula field to open the formula lines.


Step 4  ·  Enable Available on location

Select the component line you want to configure.

Click the Setup tab.

Switch to Edit mode using the shortcut (pencil icon or Ctrl+Shift+F5).

📌  The 'Available on location' checkbox is on the Setup tab. When enabled, D365FO will generate raw material picking work directly from the production input location, bypassing the standard location directive resolution.

 

Part 2 — Create and Start a Batch Order

Now we create a batch order for the configured item and verify that picking work is generated from the production input location.

 

Step 5  ·  Navigate to Production orders

Go to Production control > Production orders > All production orders.

Step 6  ·  Create a new Batch Order

Click New batch order.

In the Item number field, enter the item.

Click New batch order (confirm the dialog).

Step 7  ·  Fill in Site and Warehouse

In the Site field, enter or select the site (e.g. '1').

Click Yes to confirm site selection.

Close the lookup.

In the Warehouse field, enter or select the WMS warehouse.

Select the row from the list.

Step 8  ·  Set Quantity and Create

In the Quantity field, enter the production quantity.

Click Create.

Part 3 — Start the Order and Verify Work

Step 9  ·  Start the production order

 Find and select the order in the list.

 On the Action Pane, click Production order > Start.

 Click OK to confirm.

Starting the order triggers the release to the warehouse and generates raw material picking work.

 

Step 10  ·  Check Work details

On the Action Pane, click View > Warehouse > Work details.

Verify that the From location on the picking work lines matches the production input location — not a dynamically resolved bin.


Step 11  ·  Review Picking list

On the Action Pane, click View.

Click Picking list.

Part 4 — Complete Picking via Mobile App

The warehouse operator completes the raw material picking using the WMS mobile app. Because 'Available on location' is enabled, the From location is pre-determined — no dynamic location decision is needed.

 

Step 12  ·  Pick on the mobile device

Log in to the Warehouse Management mobile app.

Open the Raw material picking menu item.

Follow the directed picking steps — the app presents the fixed input location as the pick origin.

Part 5 — Confirm Result

Step 13  ·  Verify picking journal is posted

 Reopen the production order.

The related picking list journal is now posted, as shown below.

  The picking journal posted automatically after the mobile app confirmed the pick. The component inventory has been moved from the input location to the production order.

martedì 19 maggio 2026

D365FFO, AX2012 - Contare i record su una tabella

Con questo semplice job è possibile contare il numero di record su una tabella passata come parametro. Il conteggio avviene cross company oppure su determinate company selezionate. L'operazione può essere utile per informazini statistiche. 

In ax 2012 l'informazione è già presente cliccando quì:

 static void LILRecordTableCount(Args _args)  
 {  
   Common    common;  
   DictTable  dt;  
   DataArea   dataArea;  
   int64    totalCount;  
   int64    companyCount;  
   TableName  _tableName = "CustTable";  
   
   
   //metodo 1: usare crossCompany, utile per un conteggio secco  
   dt = new DictTable(tableName2id(_tableName));  
   
   common = dt.makeRecord();  
   
   select crossCompany count(RecId) from common;  
   
   info(strFmt("Totale record su tutte le company: %1",common.recId));  
   
   //metodo 2: usare changeCompany, utile per escludere / includere company nel conteggio  
   if(dt.dataPrCompany())  
   {  
     while select dataArea  
       where dataArea.id != "DAT"  
     {  
       common = null;  
   
       changeCompany(dataArea.Id)  
       {  
         common = dt.makeRecord();  
       
         select count(RecId) from common;  
         companyCount = common.RecId;  
   
         totalCount += companyCount;  
   
         info(strFmt("Company %1: %2 record", dataArea.Id, companyCount));  
       }  
     }  
   }  
   else  
   {  
     common = dt.makeRecord();  
       
     select count(RecId) from common;  
     
     companyCount = common.RecId;  
   
     totalCount = companyCount;  
   }  
   
   info(strFmt("Totale record sulle company selezionate: %1", totalCount));  
 }  
   

lunedì 12 gennaio 2026

D365FFO - Flexible sampling plan (skip lot)

I was eager in the last months to test the new flexible sampling plan (or skip lot for friends). It is a function always required by customers and not easy to implement, if not using vertical solutions.

In order to use it it is required to define the flexible sampling plans in the related form (Inventory management - Setup - Quality control - Flexible sampling plans).


In the example reported above, for the specific plan the test group TG would be applied 3 times in a row for the orders (the status 10 would be reiterated 3 times) and if all the tests are passed the status 20 is reached and the quality orders would be created 1 each 10 orders. The status 20 will be kept till all the quality orders are passed.

In order to apply the specific sampling plan, it is needed to apply it using the quality associations as shown below.


Basically the flag Flexible sampling must be switched on and the Flexible sampling plan code must be defined.

From the flexible sampling plan form it is possible to monitor the status of the sampling level as reported below.



giovedì 8 gennaio 2026

D365FFO - CAPA Management (Corrective and Preventive Action)

After a while I had the chance to test the CAPA management in D365FO. Generally speaking, CAPA cases are managed to keep track of the issues that customer / vendors and employees can raise within the products and processes company related.

In D365FO the CAPA management is available in the Inventory management Menu.



Accessing the CAPA management workspace there are several functions and a list of CAPA cases is available (as reported below).


Accessing one of the cases the following form will be opened.


The CAPA case is managed using a workflow (defined in the field CASE process), using which different actions / tasks are created and assigned to specific users. All the activities are visible accessing the button Activities / View activities.



According to the Case processes emails are sent to the respective assignees of the activities (as reported below).


It is possible to manage as well the electronic signature for the approval / reset status of the activities.

In terms of reports for the feature there is the option to see in a specific period the number of cases by category as shown below.


And a detailed printout per each specific CAPA case.