Create Purchase order invoice without product receipt through X++ code

(0) Share

Report

Posted on by Rhushikesh R

758

Hi Everyone,

I need to create Purchase order invoice of multiple purchase line of a confirmed purchase order through X++ code without using product receipt.

Can anyone please help me with the code?

Thank you in advance.

I have the same question (0)

All responses (22)

Answers (2)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

Give link below a try:

shyamkannadasan.blogspot.com/.../code-to-create-purchase-order-and-post.html

All you need is PO number and use purchformletter.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

Hi Satish,

I need to pass Purchase Line Number and Qty as well.

The code mentioned on link will invoice all purchase lines.

How can I achieve my requirement?

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (1)

Report
Hi Rhushikesh,

I used this snippet in AX2012.

purchFormLetter = PurchFormLetter::construct(DocumentStatus::Invoice); purchFormLetter.purchTable(purchTable); purchFormLetter.transDate(InvoiceDate); purchFormLetter.printFormLetter(NoYes::No); purchFormLetter.prePromptInit(); purchParmUpdate = purchFormLetter.purchParmUpdate(); purchFormLetter.initParameters(purchParmUpdate); purchFormLetter.purchParmUpdate(purchParmUpdate); vendInvoiceInfoTable = VendInvoiceInfoTable::findPurchId(purchTable.PurchId, purchFormLetter.parmId(), true); purchFormLetter.purchSelectLines(purchTableSet, purchLineSet, vendInvoiceInfoTable);

PurchTableSet is set of PurchIds

PurchLineSet is set of PurchLine RecIds

To update quantities you can access vendInvoiceInfoLines after they are created

while select forupdate vendInvoiceInfoLine where vendInvoiceInfoLine.ParmId == vendInvoiceInfoTable.ParmId && vendInvoiceInfoLine.TableRefId == vendInvoiceInfoTable.TableRefId { //Update needed fields }

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

Hi Sergie,

I didn't find purchSelectLines method in D365. It gives me error. Also it would be great if you share full snippet of your code.

Thanks.

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (1)

Report
Hi Rhushikesh,

Yes, forgot to mention that purchFormLetter type is PurchFormLetter_Invoice.

And to run posting you will need to run the next code at the end.

if (purchFormLetter.validate()) { purchFormLetter.reArrangeNow(false); purchFormLetter.run(); }

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

Thanks Sergie. But May I know how to store records in purchtableset and purchlineset?

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (1)

Report
Hi,

Sure,

purchTableSet = new Set(Types::String); purchLineSet = new Set(Types::Int64); //Add as many lines as you need to the sets purchLineSet.add(YourPurchLine.RecId); purchTableSet.add(YourPurchLine.PurchId);

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

But Sergie, do I need to create the record in vendInvoiceInfoTable first before writing above code?

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Rhushikesh,

No, it should be created automatically (when you call prePromptInit).

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report
Hi Sergie,

I am getting below error while creating PO Invoice

No lines for posting or quantity = 0

Posting has been canceled.

Please check my code below,

public static void postPOInv(InvoiceId _invoiceNo, real _lineNum) { PurchFormLetter_Invoice purchFormLetter; PurchTable purchTable; PurchLine purchLine; PurchParmUpdate purchParmUpdate; VendInvoiceInfoTable vendInvoiceInfoTable; VendInvoiceInfoLine vendInvoiceInfoLine; VendInvoiceInfoSubTable vendInvoiceInfoSubTable; VendInvoiceInfoSubLine vendInvoiceInfoSubLine; PurchId purchId; PackingSlipId packingSlipId; ; purchId = "WCLPO-00102"; ttsBegin; purchTable = PurchTable::find(purchId); select purchLine where purchLine.PurchId == purchId && purchLine.LineNumber == _lineNum; Set purchTableSet = new Set(Types::String); Set purchLineSet = new Set(Types::Int64); purchTableSet.add(purchTable.PurchId); purchLineSet.add(purchLine.RecId); purchFormLetter = PurchFormLetter::construct(DocumentStatus::Invoice); purchFormLetter.purchTable(purchTable); purchFormLetter.transDate(today()); purchFormLetter.printFormLetter(NoYes::No); purchFormLetter.prePromptInit(); purchParmUpdate = purchFormLetter.purchParmUpdate(); purchFormLetter.initParameters(purchParmUpdate); purchFormLetter.purchParmUpdate(purchParmUpdate); purchFormLetter.parmParmTableNum (_invoiceNo); vendInvoiceInfoTable = VendInvoiceInfoTable::findPurchId(purchTable.PurchId, purchFormLetter.parmId(), true); purchFormLetter.purchSelectLines(purchTableSet, purchLineSet, vendInvoiceInfoTable); if (purchFormLetter.validate()) { purchFormLetter.reArrangeNow(false); purchFormLetter.run(); } ttscommit; }

Was this reply helpful? Yes No

Join the conversation

Community site session details

Create Purchase order invoice without product receipt through X++ code

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

Create Purchase order invoice without product receipt through X++ code

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