insert data in to inheritance table gives error

(0) Share

Report

Posted on by MAKDAX2012_Ahmed

110

I am facing error inserting data in a table of retail _RetailPeriodicDiscount in dynamics AX 2012 R3 by x++ code table has inherited property how can i insert data in inherited table my code is below

and my Facing the following error.

Database insert operation is not allowed on an abstract table.

static void CreateDiscountScheem_3(Args _args)
{
RetailPeriodicDiscount _RetailPeriodicDiscount;
NumberSeqFormHandler numberSeqOfferId;
LedgerDimensionDefaultAccountController discountDimAccController;
///----- Field-------
RetailOfferIdEx3 OfferId;
Name DiscountScheemName;
//RetailDisabledEnabled ScheeemStatus;
int ScheeemStatus;

CurrencyCode Currency;
RetailDiscountConcurrency _ConcurrencyMode;
Status _ActiveInActive;
RetailDiscountPercentValue _DiscountPercentValue;
ValidFromDate _ValidFrom;
ValidToDate _ValidTo;
RefRecId _PriceDiscGroup;
RetailMemo _Description;
RetailDiscountOfferTypeBase _PeriodicDiscountType;

NumberSeq num;
str test;
//////////////////////////
ScheeemStatus=1;
_DiscountPercentValue=20;

// NumberSeq NumberSeq;
ttsBegin;
num = NumberSeq::newGetNum(RetailParameters::numRefOfferId());
test=num.num();
_RetailPeriodicDiscount.OfferId =test;
_RetailPeriodicDiscount.Name=DiscountScheemName;
_RetailPeriodicDiscount.Status=1;//ScheeemStatus;
_RetailPeriodicDiscount.CurrencyCode='PKR';
_RetailPeriodicDiscount.ConcurrencyMode= (RetailDiscountConcurrency::Exclusive);
_RetailPeriodicDiscount.DiscountPercentValue=_DiscountPercentValue;
_RetailPeriodicDiscount.DiscountLedgerDimension=5637144584;
_RetailPeriodicDiscount.ValidFrom =23\07\2019;
_RetailPeriodicDiscount.ValidTo=31\07\2019;
_RetailPeriodicDiscount.DateValidationType =RetailDateValidationTypeBase::Standard;
_RetailPeriodicDiscount.PeriodicDiscountType=RetailDiscountOfferTypeBase::DiscountOffer;
_RetailPeriodicDiscount.insert();

// info(test);
// num = NumberSeq::newGetNumFromCode(numberSequenceTable::findByNaturalKey('Reta_16').NumberSequence);
// NumberSeq =NumberSeq::newGetNumFromCode(NumberSequenceTable::findByNaturalKey('Reta_16').NumberSequence);
//NumberSeq::newGetNum(RetailParameters::numRefOfferId());

//Info(NumberSeq::newGetNum(FCMParameters::numRefWorkOrderNum()).num());
// _RetailPeriodicDiscount.
ttsCommit;

}

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

Martin Dráb 239,178 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The message says that the table is abstract, therefore you can't insert data directly into it. You use a non-abstract child table instead.

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report
Copy link

Link copied!

actually i want to insert record for integration purpose for auto apply sales discount so i want to use this table, Can you please elaborate this with an example

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

Like (0)

Report
Copy link

Link copied!

You can't do that if the table is abstract, therefore you must change your design (i.e. the fact that you want to use a wrong table).

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report
Copy link

Link copied!

Please guide me how can i use the table for insertion as i show you the hierarchy of table

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

Like (0)

Report
Copy link

Link copied!

You already have code for insertion data to a table, you just have to use a non-abstract one.

I can't tell which of the four child tables you should use - it all depends on your business requirements.

Was this reply helpful? Yes No
Ehtasham Rahman 672 on at

Like (0)

Report
Copy link

Link copied!

Hi!

May I know what is the need of pushing data into these tables using code? I think you can define the periodic discount scheems from front-end.

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report
Copy link

Link copied!

yes exactly

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report
Copy link

Link copied!

I have two system ORM and DAX business user apply discount scheme on ORMS that will flow in to DAX i am doing integration that's why i am doing it by code

Was this reply helpful? Yes No
Suggested answer

Ehtasham Rahman 672 on at

Like (0)

Report
Copy link

Link copied!

Your mentioned table (i.e. RetailPeriodicDiscount) is also part of N-Job (i.e. 1020). It means data is floating from AX to POS.

Anyhow, you need to enter the data into concrete child of the abstract table.

On the table right click -> Add-ins -> Type hierarchy browser, these are the children of the inheritance where you need to insert values.

Was this reply helpful? Yes No