Wednesday, June 24, 2009

AX: Post Sales Packing Slip

static void PostPackingSlip(Args _args)
{
SalesFormLetter salesFormLetter;
SalesTable salesTable;
SalesLine salesLine;
SalesId salesId;
;

salesTable = SalesTable::find(salesId);
salesFormLetter = SalesFormLetter::construct(DocumentStatus::PackingSlip);
ttsbegin;
while select forupdate salesLine where salesLine.SalesId == salesTable.SalesId && salesLine.SalesStatus == SalesStatus::Backorder
{
salesLine.SalesDeliverNow = salesLine.pickedInTotalSalesUnit();
salesLine.InventDeliverNow = salesLine.SalesDeliverNow;
salesLine.update();


salesFormLetter.update(salesTable, SystemDateGet(), SalesUpdate::DeliverNow, AccountOrder::None, NoYes::No, NoYes::No);
}
ttscommit;
}

Thursday, June 18, 2009

AX: Inventory Journal Posting Error

There is an error while posting inventory journal if you enable ModifiedDateTime property on InventJournalTrans. It throws following error.
The operation cannot be completed, since the record was not selected for update. Remember TTSBEGIN/TTSCOMMIT as well as the FORUPDATE clause.
There is an hotfix available to fix this issue. Here is the link.
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYSZRRNOTTUKOOSTLLOWROTNNSTXVOSZPTZQZRZRLPWKWPQMWP