Finance | Project Operations, Human Resources, ...

PO CRETION ISSUE(Purch order status)

(0) Share

Report

Posted on by D365_FO_Technical_Te

124

Hi everyone,

Can anyone please help me in below code. I am using below code to create a PO. So my PO is getting created, but by default its PurchOrderStatus is Cancelled due to which i am not able to Receive PO.

AxPurchTable axPurchTable;

PurchTable purchTab;

PurchLine purchLn;

numseq = NumberSeq::newGetNum(PurchParameters::numRefPurchId());
numseq.used();
purchtab.clear();
purchTab.initValue();
purchTab.PurchId = numSeq.num();
PurchTab.initFromVendTable(VendTable::find('XX1200'));
axPurchTable = axPurchTable::newPurchTable(purchTab);
axPurchTable.parmPurchaseType(PurchaseType::Purch);
axPurchTable.parmDocumentStatus(DocumentStatus::PurchaseOrder);
axPurchTable.parmAccountingDate(systemDateGet());
axPurchTable.parmPurchStatus(PurchStatus::None);
axPurchTable.parmInventSiteId(salesTab.InventSiteId);
axPurchTable.parmInventLocationId(salesTab.InventLocationId);
purchTab.insert();

PurchLn.clear();
PurchLn.initValue();
PurchLn.PurchId = purchTab.PurchId;
PurchLn.ItemId = cusPckngSlpTrns.ItemId;
PurchLn.LineNumber = lastlinecount + 1;
PurchLn.PurchQty = cusPckngSlpTrns.Qty;
PurchLn.PurchUnit = 'LTR'
PurchLn.VendAccount = 'V-001';
PurchLn.VendGroup = VendTable::find('V-001').VendGroup;
PurchLn.PurchPrice = invntItmPrc.Price;
PurchLn.InventDimId = invDimLoc.inventDimId;
PurchLn.CurrencyCode = 'INR';
PurchLn.PurchStatus = 1;
PurchLn.insert();

I have the same question (0)

All responses (7)

Answers (0)

GirishS 27,827 Moderator on at

Like (0)

Report

Hi D365_FO_Technical_Te

Have you debugged the code and find out the value of PurchStatus while inserting records in PurchTable and exactly at which line the status changed to cancelled. Maybe you can navigate inside the insert method of purch table.

Thanks,

Girish S.

Was this reply helpful? Yes No
D365_FO_Technical_Te 124 on at

Like (0)

Report

Thanks girish for your reply, i debug it but till insertion of my code, it is showing same value of purchstatus which i am writing in my code.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

I guess there must be some logic inside insert method of PurchTable or some customization you have done.

So go inside(F11) of the PurchTable insert method and debug line by line.

Thanks,

Girish S.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Can you change the PurchStatus at header level to PurchStatus::BackOrder and check?

Also at line level, what does purch status = 1 mean?

Was this reply helpful? Yes No
D365_FO_Technical_Te 124 on at

Like (0)

Report

HI Bharani,

I have already change the code to PurchStatus::BackOrder at header and line level both, but still same issue

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Try debugging the code by putting the break points at insert(), validatefield (), validatewrite() methods and in your job and check where it is getting changed.

Was this reply helpful? Yes No
Suggested answer

D365_FO_Technical_Te 124 on at

Like (1)

Report

Hello everyone,

This issue got resolved,

So issue was, we have to use PurchLine.CreateLine method instead of PurchLine.insert Method.

AxPurchTable axPurchTable;

PurchTable purchTab;

PurchLine purchLn;

numseq = NumberSeq::newGetNum(PurchParameters::numRefPurchId());
numseq.used();
purchtab.clear();
purchTab.initValue();
purchTab.PurchId = numSeq.num();
PurchTab.initFromVendTable(VendTable::find('XX1200'));
axPurchTable = axPurchTable::newPurchTable(purchTab);
axPurchTable.parmPurchaseType(PurchaseType::Purch);
axPurchTable.parmDocumentStatus(DocumentStatus::PurchaseOrder);
axPurchTable.parmAccountingDate(systemDateGet());
axPurchTable.parmPurchStatus(PurchStatus::Backorder);
axPurchTable.parmInventSiteId(salesTab.InventSiteId);
axPurchTable.parmInventLocationId(salesTab.InventLocationId);
purchTab.insert();

PurchLn.clear();
PurchLn.initValue();
PurchLn.PurchId = purchTab.PurchId;
PurchLn.ItemId = cusPckngSlpTrns.ItemId;
PurchLn.LineNumber = lastlinecount + 1;
PurchLn.PurchQty = cusPckngSlpTrns.Qty;
PurchLn.PurchUnit = 'LTR'
PurchLn.VendAccount = 'V-001';
PurchLn.VendGroup = VendTable::find('V-001').VendGroup;
PurchLn.PurchPrice = invntItmPrc.Price;
PurchLn.InventDimId = invDimLoc.inventDimId;
PurchLn.CurrencyCode = 'INR';
PurchLn.PurchStatus = PurchStatus::Backorder;;
PurchLn.createLine();

Was this reply helpful? Yes No

Join the conversation

Community site session details

PO CRETION ISSUE(Purch order status)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

PO CRETION ISSUE(Purch order status)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates