Finance | Project Operations, Human Resources, ...

Link between sales order and BOM tables

(0) Share

Report

Posted on by AX 2012 r3

2,426

Good Morning,

I am trying to export Data from BOM tables (BOMVersion,BOM,BOMtable) whenever sales order is confirmed .

All i have is salesline buffer .

So i am trying to find the relation between them.

Is there any specific method to find out link.

I found out BomVersion::FindActive().

is this a correct way.

Please provide some light on this.

Regards,

Have a nice day.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi AX 2012 r3,

There is a direct relation between SalesLine and BOMTable based on SalesLine.ItemBOMId = BOMTable.BOMId. If you are looking for a relationship between the BOM tables, you can check BOMItemSpecificBillOfMaterialsHeaderEntity.

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Sir,

As mentioned,you need to check the BOMTable table. It contains all of the bills of materials and for each bill of materials, the information is stored about whether it has been approved and by whom.

Data model diagram for BOMTable, BOM,BOMVersion, linked by BOMId field.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report
Copy link

Link copied!

Hi Gunjan,

Thanks for your reply.

I found there are multiple records in BomVersion.

How can i find Active ones so thati can i export data .

BOMVersion::findActive()

is this correct way.

Because i saw in BOMVersion table have 2 records which are active and Aproved.

So when sales order is getting confirmed i need to export Bomversion.Itemid and etc fields so how can i differentiate which records should i export from BOMVersion

Please show some light on this.

Regards,

Have a nice day.

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi Sir,

Use BOMVersion::findActive() , you can find active BOM version and list its items.

bomVersion = BomVersion::findActive( inventTable.ItemId, systemdateGet(), 1, null ); if ( bomVersion ) { while select bom where bom.BOMId == bomVersion.BOMId { info( bom.ItemId ", " bom.UnitId ); } }

https://sivakumar007.wordpress.com/2009/09/14/finding-active-bom-components-of-item/

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi AX 2012 r3,

You should find the active BOM version. But what details are you trying to export on sales order confirmation?

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report
Copy link

Link copied!

Hi Gunjan,

These are the details i want to export

BOMtable.BOMID

BOMtable.SiteID

BOMtable.Approved

BOMVersion.BOMID

BOMVersion.ITEMID

BOMVersion.Active

BOMVersion.Approved

BOM.ITEMID

InventDimBOM.InventLocationId

BOM.BOMQty

BOM.UnitID

BOM.BOMQtySerie

BOMVersion.FromDate

I do found multiple BomVersions.

bomtable bomTable = bomtable::find(_salesline.itembomid);

While select BOMVersion

where bomversion.bomid == bomtable.bomid

&& bomversion.isActive

{

while select bom

where bom.bomid == bomversion.bomid

{

}

}

Is this correct way.

Please show some light on this.

Regards,

Have a nice day.

Was this reply helpful? Yes No