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 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Hi martin there is no customized it's standard.

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

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

There is no customization

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

<-----------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