Error Executing Code : the field with ID '0' does not exist in table 'purchparmTable'

(0) Share

Report

Posted on by Community Member

Hello All,

Pleasant day!

When I am doing this process in Account Payable Module Posting > Goods Receipt Note > Totals for a particular purchase order I am getting this error.

6545.error.jpg

Please share the solution if you know!

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

Please show us the code in question.

1 people found this reply helpful.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi martin there is no customized it's standard.

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

Like (0)

Report

And what's the difference? If you want to understand the error, looking at why it's thrown sound like a good idea to me. I'm not sure how you want to resolve it without finding the cause.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If i had the cause i could try to resolve it. I'm not able to find the cause that's why i asked here!

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (1)

Report

Can you look at the map: VendDocumentTableMap? Do you have customization on it?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There is no customization

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Only for one particular purchase order getting this error, for rest of all the purchase order there is no error!

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

Like (0)

Report

I'm sorry, but there is nothing I can do without information from you. Even if I had AX 4.0 (which I don't have), I likely wouldn't get the same problem you have in your system. If you're not willing to collect more information and share it with us, it's unlikely that we'll be able to help you. The choice is yours.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Following is error code:

void calc()

{

QueryRun queryTransact;

QueryRun queryPurchTableMarkup;

Markup markup;

PurchCalcTax purchCalcTax;

PurchLine purchLine;

VendTable vendTable;

PurchTable purchTableMarkup;

PurchQty purchQty;

InventQty inventQty;

AmountCur lineAmount;

AmountCur roundedOffTotalAmount;

;

this.clear();

currency = purchTable.CurrencyCode;

markup = new Markup(currency);

markup.parmExchRate(this.exchRate(), this.exchRateSecondary(), Currency::noYes2UnknownNoYes(this.triangulation()));

markup.transDate(this.invoiceDate());

purchCalcTax = this.constructPurchCalcTax();

queryTransact = this.queryBuild();

while (queryTransact.next())

{

purchLine = this.queryGet(queryTransact);

if (!purchLine)

continue;

recordListPurchLine.ins(purchLine);

purchQty = this.qtyPurch (purchLine);

inventQty = this.qtyInvent (purchLine);

qty += purchQty;

weight += inventQty * InventTable::find(purchLine.ItemId).NetWeight;

volume += inventQty * InventTable::find(purchLine.ItemId).UnitVolume;

lineAmount = this.lineAmount(purchLine, purchQty, purchCalcTax.invoiceDate());

this.updateOrderBalances(lineAmount);

costValue += Currency::amount(inventQty * purchLine.PurchPrice, '');

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

<-----------continue------------->

if (purchLine.endDisc())

{

this.updateEndDiscBalances(lineAmount);

}

if (purchLine.PurchPrice)

lineDisc += purchLine.calcLineDiscExclTax(purchQty, purchCalcTax.invoiceDate());

markup.calc(purchQty, lineAmount, purchLine, DocumentStatus::Invoice, this.interCompanyLineAmount(purchQty, purchCalcTax.invoiceDate()));

markupAmount -= markup.markupCustVend();

}

queryPurchTableMarkup = this.queryBuildPurchTable();

while (queryPurchTableMarkup.next())

{

purchTableMarkup = this.queryGetPurchTable(queryPurchTableMarkup);

if (!purchTableMarkup)

continue;

markup.calc(1, this.purchOrderBalance(purchTableMarkup.RecId), purchTableMarkup, DocumentStatus::Invoice, this.interCompanyLineAmount(1, purchCalcTax.invoiceDate()));

markupAmount -= markup.markupCustVend();

}

endDisc = this.endDisc();

calculatedEndDisc = this.calculatedEndDisc();

this.calcTax(purchCalcTax);

roundOff = this.invoiceRoundOff();

totalAmount = balance

- endDisc

+ markupAmount

+ this.taxTotal()

+ this.purchTaxRoundOff()

+ roundOff;

if (totalAmount != 0)

{

roundedOffTotalAmount = this.roundedOffTotalAmount();

roundOff += roundedOffTotalAmount - totalAmount;

totalAmount = roundedOffTotalAmount;

}

vendTable = purchTable.vendTable_InvoiceAccount();

if (vendTable.CreditMax)

{

freeValue = vendTable.freeValueMST(Currency::mSTAmount( totalAmount,

currency,

systemdateget(),

Currency::noYes2UnknownNoYes(this.triangulation()),

this.exchRate(),

this.exchRateSecondary()));

}

if (TaxParameters::canApplyCashDiscOnInvoice_ES())

{

onlyOneCashDiscOnInvoice = true;

}

cashDisc = this.cashDisc();

this.purchTotalAmount();

if (TaxParameters::canApplyCashDiscOnInvoice_ES())

{

cashDiscDate = this.cashDiscDate();

}

}

Was this reply helpful? Yes No