Dynamics Community Forum Thread Details

Requirement: I need to display the status per SO Line – which lines are still on open order, picked, packed or invoiced (we invoice per sales line).

Problem: One of my enum values is not passing – nothing fancy, just as simple assignment from view to temporary table. The enum value does seems to be “NOT being saved into the temp table”. What am I missing here? I hope someone can help.

On my temp table, the column has enum type of XXX_APG_ECOStatus(acquired from SalesLineStatus on an AOT view)

The enum contains these elements.

When retrieving the search result, ECOStatus (or Sales Line Status) does not yield.

I checked my temp table, the value is not indeed existing.

I am sure I set my datasource correctly.

I went to check by breaking point every affected line; I even made another column and a variable to make sure and see the data. Everything is fine. Both ecoResultTempTable.ECOStatus & ecoResultTempTable.SalesLineStatus are not being used or reassigned new values after these lines.

Nothing is fancy on my code – just a very simple straightforward assignment.

This issue also persists on other elements of the enum – not just “Open Order”.

What I already did but was NOT successful:

Created a new column in temp table.
Created a new column in the source query/view and took the value from there instead.
Created and assigned an EDT for the affected enum both for temp table and the query/view.
Cleared my usage data.
Restarted my computer (to clear local cache)
Restarted AX.
Re-created this form.
Re-created my query.
Re-created my view.
Praying and contemplating for hours on this. T.T

Full code below.

void clicked(){

XXXX_APG_ECOView ecoView;

XXXX_APG_ECOTempTable ecoResultTempTable;

XXXX_APG_ECOStatusType ecoStatus; /*temporary for debugging*/

;

if(XXXX_APG_ECOTempTable::ValidateFroToDates(lsdFrom, lsdTo)){

ttsBegin;

while select

SalesId

,CustAccount

,SalesName

,SoCreatedDate

,SalesStatus

,SalesConfirmStatus

,ShippingDateRequested

,RecId

,CostMatrix

,LCNo

,NCODate

,Expiry1

,Expiry2

,Expiry3

,NCO

,RefNo

,Packaging

,Brand

,CasesPerFCL

,ProductStatus

,LabelStatus

,CartonStatus

,configId

,PaymentTerm

,PaymTermId

,BGColor

,FGColor

,ItemId

,CanSize

,InventDimId

,ItemBOMId

,Media

,NetWeight

,PCW

,DrainedWeight

,SALT

,FLAKES

,OBR

,Tins

,DlvTerm

,LSDLatest

,LSD2

,LSD3

,Destination

,Freight

,ShippingNominations

,PackId

,PackQty

,PackDate

,InvoiceId

,InvoiceDate

,InvoiceQty

,PickQtySum

,PickLatestDate

,SalesOrderRecId

,SalesLineStatus

from ecoView

order by LSDLatest asc

where(

ecoView.LSDLatest >= lsdFrom /*declared from classdeclaration*/

&& ecoView.LSDLatest <= lsdTo /*declared from classdeclaration*/

) //end of where clause

{

/*Sales Header START*/

ecoResultTempTable.SalesId = ecoView.SalesId;

ecoResultTempTable.SORecId = ecoView.SalesOrderRecId;

ecoResultTempTable.CustAccount = ecoView.CustAccount;

ecoResultTempTable.SalesName = ecoView.SalesName;

ecoResultTempTable.SoCreatedDate = ecoView.SoCreatedDate;

ecoResultTempTable.SalesStatus = ecoView.SalesStatus;

ecoResultTempTable.SalesConfirmStatus = ecoView.SalesConfirmStatus;

ecoResultTempTable.ShippingDateRequested = ecoView.ShippingDateRequested;

/*Sales Header END*/

/*Sales Line START*/

/*General Setup START*/

ecoResultTempTable.CostMatrix = ecoView.CostMatrix;

ecoResultTempTable.LCNo = ecoView.LCNo;

ecoResultTempTable.NCODate = ecoView.NCODate;

ecoResultTempTable.Expiry1 = ecoView.Expiry1;

ecoResultTempTable.Expiry2 = ecoView.Expiry2;

ecoResultTempTable.Expiry3 = ecoView.Expiry3;

ecoResultTempTable.NCO = ecoView.NCO;

ecoResultTempTable.RefNo = ecoView.RefNo;

ecoResultTempTable.Packaging = ecoView.Packaging;

ecoResultTempTable.Brand = ecoView.Brand;

ecoResultTempTable.SalesQty = ecoView.CasesPerFCL;

ecoResultTempTable.ProductStatus = ecoView.ProductStatus;

ecoResultTempTable.LabelStatus = ecoView.LabelStatus;

ecoResultTempTable.CartonStatus = ecoView.CartonStatus;

ecoResultTempTable.Buyer = ecoView.configId;

ecoResultTempTable.PaymentTermName = ecoView.PaymentTerm;

ecoResultTempTable.PaymTermId = ecoView.PaymTermId;

ecoResultTempTable.BGColor = ecoView.BGColor;

ecoResultTempTable.FGColor = ecoView.FGColor;

ecoStatus = ecoView.SalesLineStatus;

ecoResultTempTable.ECOStatus = ecoStatus;

ecoResultTempTable.SalesLineStatus = ecoStatus;

/*General Setup END*/

/*Buyer specs START*/

ecoResultTempTable.ItemId = ecoView.ItemId;

ecoResultTempTable.CanSize = ecoView.CanSize;

ecoResultTempTable.InventDimId = ecoView.InventDimId;

ecoResultTempTable.BOMId = ecoView.ItemBOMId;

ecoResultTempTable.Media = ecoView.Media;

ecoResultTempTable.NetWeight = ecoView.NetWeight;

ecoResultTempTable.PCW = ecoView.PCW;

ecoResultTempTable.DrainedWeight = ecoView.DrainedWeight;

ecoResultTempTable.Salt = ecoView.SALT;

ecoResultTempTable.Flakes = ecoView.FLAKES;

ecoResultTempTable.OBR = ecoView.OBR;

ecoResultTempTable.Tins = ecoView.Tins;

/*Buyer specs END*/

/*Pick START*/

//TO-DO

/*Pick END*/

/*Ship START*/

ecoResultTempTable.DlvTerm = ecoView.DlvTerm;

ecoResultTempTable.LSDLatest = ecoView.LSDLatest;

ecoResultTempTable.LSD2 = ecoView.LSD2;

ecoResultTempTable.LSD3 = ecoView.LSD3;

ecoResultTempTable.Destination = ecoView.Destination;

ecoResultTempTable.Freight = ecoView.Freight;

ecoResultTempTable.ShippingNominations = ecoView.ShippingNominations;

/*Ship END*/

/*Invoice START*/

//TO-DO

/*Invoice END*/

/*Sales Line END*/

ecoResultTempTable.insert();

}

ttsCommit;

XXXX_APG_ECOTempTable_1_ds.research();

}//if statement end

}//click method end

Community site session details

One of my table fields with enum is not saving.

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Leaderboard > Microsoft Dynamics AX (Archived)

Featured topics

Product updates