SalesStatus automatically set to "Cancelled" on SalesLine

(0) Share

Report

Posted on by Komi Siabi

13,107 Most Valuable Professional

I am creating sales order Via x++.

The header and the line(s) are created successfully, But the sales line status is auto set Cancelled (Once there is a quantity on the sales line).

salesLine.clear();
salesLine.initValue();
salesLine.SalesId = salesTable.SalesId;

salesLine.initFromSalesTable(salesTable);
salesLine.CustomerLineNum = 1;
salesLine.LineNum = 1;
salesLine.modifiedFieldValue(fieldstr(salesLine,LineNum));
salesLine.SalesUnit = pmgParameters.SalesUnit;
salesLine.SalesCategory = pmgparameters.CapacitySalesCategory;
salesLine.initFromItemOrCategory("",salesLine.SalesCategory,EcoResCategory::find(pmgparameters.CapacitySalesCategory).Name);
salesLine.modifiedFieldValue(fieldstr(salesLine,SalesCategory));
salesLine.PmgCapacity = pMGMSRTable.DigitalTotal;
salesLine.PmgConstraintCapacity = pmgMonthlyGeneratorTransLine.TotalConstraint;
salesLine.PmgLessShiroro = - pMGMSRTable.SGRTotal / pmgParameters.ShiroroFactor;
salesLine.PmgNetCapacity = salesLine.PmgCapacity + salesLine.PmgConstraintCapacity + salesLine.PmgLessShiroro;
salesLine.SalesQty = salesLine.PmgNetCapacity;
salesLine.PmgCapacityTariff = pmgTariffCodes.ApplicableCapitalRecoveryRate + pmgTariffCodes.ApplicableFixedOMRate;
salesLine.SalesPrice = salesLine.PmgCapacityTariff;
salesLine.LineAmount = salesLine.SalesQty * salesLine.SalesPrice;
salesLine.SalesStatus = SalesStatus::Backorder;
salesLine.Name = strFmt("Capacity for the month of %1",PMGMonthlyDigitalReadingTable.PMGMonth);
salesLine.insert();

if(!salesLine.validateWrite())
{
throw exception::Error;
}

I have the same question (0)

All responses (5)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Komi,

Could you please share the code for creating the sales order header?

Was this reply helpful? Yes No
Komi Siabi 13,107 Most Valuable Professional on at

Like (1)

Report

Hi Gujan,

Please see below :

ttsbegin;

numberSeq = NumberSeq::newGetNum(SalesParameters::numRefSalesId());

numberSeq.used();

salesTable.SalesId = numberSeq.num();

salesTable.CustAccount = custAccount;

salesTable.initFromCustTable();

salesTable.SalesType = SalesType::Sales;

salesTable.InvoiceAccount = custAccount;

salesTable.SalesStatus = SalesStatus::Backorder;

salesTable.ReceiptDateRequested = today();

salesTable.ShippingDateRequested = today();

salesTable.insert();

ttscommit;

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Hi Komi,

I don't see any issue in the code as such. It does look like you have a few customized fields. Do you have any customization on the insert method? Have you tried to debug the code to check if where the SalesStatus field value is getting set to "Cancelled".

Additionally, you don't need this piece of code for throwing an error.

if(!salesLine.validateWrite()) { throw exception::Error; }

Before insert, the validateWrite method would already have been called. You can put your code in a try - catch block instead.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

Please debug it to learn when the sales line status changes.

Once you find it out, perhaps you can already find a solution. If not, just let us know what caused it and we can figure it out together.

Thanks!

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (1)

Report

Hi Komi,

There are multiple quantity fields on the salesline table. E.g. fields for the inventory unit and remainder fields. If there is a sales quantity and no remainder, the line status will be set automatically. To solve your issue, you have to call the static method SalesLine::salesQtyModified()

Was this reply helpful? Yes No