AX2012 X++ partial posting of purch lines

(0) Share

Report

Posted on by Community Member

I want to post the invoice of selected lines of purch order(PO) through code. need help in the code. can anyone help me with coding ?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Bilal Issa 4,370 on at

Like (1)

Report

Hi,

as simple method you can use the following:

PurchTable purchTable;

PurchLine purchLine;

PurchFormLetter PurchFormLetter;

;

PurchFormLetter = PurchFormLetter::construct(DocumentStatus::Invoice);

ttsBegin;

purchTable = purchTable::find('PurchId');

while select forupdate purchLine

where

purchLine.purchId == purchTable.PurchId

{

purchLine.PurchReceivedNow = 1 ;// Qty you want to invoice ;

purchLine.modifiedField(fieldnum(purchLine,PurchReceivedNow));

purchLine.update();

}

PurchFormLetter.update(purchTable,'InvoiceNumber',today(),PurchUpdate::ReceiveNow);

ttsCommit;

Regards,

Bilal

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

when I run the above code , it shows error "The result of the invoice matching process for invoice Test1303 is unknown. View the invoice in the Posting invoice form or perform invoice matching on the invoice and then post." ??

is this code does post partial lines. for e.g. I have 10 lines and I want to post 5 out of it for invoice.

Was this reply helpful? Yes No
Mariano Gracia on at

Like (0)

Report

It's more complex than modifying PurchReceivedNow quantity and trying to post invoice. What inventory dimensions will you use in your invoice?, will inventory dimensions be informed in the purch order lines?, will you post partial quantities in the purch order lines?. Have you tried to look at inventory receptions functionallity?, it allows you to post a partial reception, and then, you can post invoice from packing slip.

Was this reply helpful? Yes No
Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report

check if this helps you ? this is for sales invoice but with minor modifications it should work for purchase side also.

axlearning.blogspot.com/.../partial-sales-order-through-code-in.html

Was this reply helpful? Yes No
Srinath Sundaresan 510 on at

Like (0)

Report

Please see the blog

srinathsundaresan.wordpress.com/.../post-a-partial-product-receipt-for-a-purchase-order

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report

Hi All,

X++ Code to Create Purchase Order and Post the Invoice.

Following code will create the Purchase order from code and post the invoice as well by making use of "PurchFormLetter" class.

static void TheaxaptaCreatePOInvoice(Args _args)

{

NumberSeq numberSeq;

Purchtable Purchtable;

PurchLine PurchLine;

PurchFormLetter purchFormLetter;

;

ttsbegin;

numberSeq = NumberSeq::newGetNumFromCode(purchParameters::numRefPurchaseOrderId().NumberSequence,true);

// Initialize Purchase order values

Purchtable.initValue();

Purchtable.PurchId = numberSeq.num();

Purchtable.OrderAccount = '3000';

Purchtable.initFromVendTable();

if (!Purchtable.validateWrite())

{

throw Exception::Error;

}

Purchtable.insert();

// Initialize Purchase Line items

PurchLine.PurchId = Purchtable.PurchId;

PurchLine.ItemId = 'B-R14';

PurchLine.createLine(true, true, true, true, true, false);

ttscommit;

purchFormLetter = purchFormLetter::construct(DocumentStatus::Invoice);

purchFormLetter.update(purchtable, // Purchase record Buffer

"Inv_"+purchTable.PurchId, // Invoice Number

systemdateget()); // Transaction date

if (PurchTable::find(purchTable.PurchId).DocumentStatus == DocumentStatus::Invoice)

{

info(strfmt("Posted invoiced journal for purchase order %1",purchTable.PurchId));

}

}

You can Change the document status to packingSlip , if you want to post packing slip by using the same code.

Was this reply helpful? Yes No