Create Production Order through X++

(0) Share

Report

Posted on by Samir Sharma

Hi All,
I am trying to create a Production order in D365 F&O with the following code but a record not getting inserted in ProdTable.
Can someone let me know a solution.
static void _CreateProductionOrder(Args _args)
{
    ProdQty         qty     = 100;
    ItemId          item    = 'ECJ';
 
    ProdTable       prodtable;
    InventTable     inventTable;
    InventDim       inventDim;
    ;
 
    
    inventTable = inventTable::find(item);
 
    
    prodtable.initValue();
    prodtable.initFromInventTable(inventTable);
 
    prodtable.ItemId                = inventTable.ItemId;
    prodtable.DlvDate               = today();
    prodtable.QtySched              = qty;
    prodtable.RemainInventPhysical  = qty;
 
   
    inventDim.initValue();
 
    
    prodtable.BOMId = BOMVersion::findActive(prodtable.ItemId,
                                             prodtable.BOMDate,
                                             prodtable.QtySched,
                                             inventDim).BOMId;
 
    prodtable.RouteId = RouteVersion::findActive(prodtable.ItemId,
                                                 prodtable.BOMDate,
                                                 prodtable.QtySched,
                                                 inventDim).RouteId;
 
   
    prodtable.initBOMVersion();
    prodtable.initRouteVersion();
 
    prodtable.type().insert();// Record not getting inserted 
 
   
    info(prodtable.ProdId);
}

I have the same question (0)

All responses (7)

Answers (0)

Blue Wang on at

Like (1)

Report

HI Samir,

prodtable.type().insert(); running in AX2012.

Please try to use prodtable.type().inserted(); or Inserting().

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Hi Samir, I moved your question from AX 2012 forum. Now I wonder how it is relayed to things like "Windows 8 and Mobile Apps", "Connector for CRM", "Management Reporter" or "Enterprise Portal", which are all categories you've selected for your thread. Please pick them more carefully next time.

Was this reply helpful? Yes No
Samir Sharma 35 on at

Like (0)

Report

Hi Blue,

Thanks for replay,

Yes, it works fine in Ax2012, But in D365 F&O it's not. also, I tried inserted(); or Inserting(). but hard luck.

Regards

Was this reply helpful? Yes No
Samir Sharma 35 on at

Like (0)

Report

Thanks Martin,

Great minds are everywhere, Can you help me as it works fine in Ax2012 but not in D365 F&O

Thanks

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

ProdTableType.insert() is deprecated. If you want to insert records, use ProdTable.insert(). If you want to add extra logic on insert, consider methodsProdTableType.inserting() and ProdTableType.inserted().

Was this reply helpful? Yes No
Samir Sharma 35 on at

Like (0)

Report

Hi Martin,

I alredy tried all this but still no output.

Can you give me working example with above code.

Thanks

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

You can easily find examples by right-clicking ProdTable.insert() and choosing Find Refences, but there is nothing special about calling insert() method. You should rather debug your solution.

Review how you test that data was inserted - maybe you're looking through a form where you record is filtered out because of missing references. Look into the table directly.

Make sure that your code gets called at all and that it doesn't fail. Note that if an exception occurs even after insert(), but in the same database transaction, the insert will be rolled back and therefore nothing will be written to database.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Create Production Order through X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

Create Production Order through X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates