Posting picking list for selected saleslines through code

(0) Share

Report

Posted on by Piotr_Kulakowski

200

How create picking list(from code), but not for whole SalesOrder, but only for selected lines , e.g. with any checkbox marked.

*This post is locked for comments

All responses (6)

Answers (2)

In AX2012 in the In... 499 on at

Like (0)

Report

RE: Posting picking list for selected saleslines through code

Dear Piotr_Kulakowski

Please find the attachments below

1.

2.

1st Image shows the salesline selected, 2nd Image shows corresponding Packing Slip for sales line ,

My Requirement is if i select any of the particular salesline (Through Check box),i need only selected lines of Saleline to appear in Picking list Form (Form Name:SalesEditLines),

In (SalesEditLines Form), the (datasource Salesparamline) has (Join Source Property as SalesParmTable) , and the tables Salesline and SalesParamLine has a relation as SalesParmLine.SalesLineRecId == SalesLine.RecId.

with above said properties and relations ,

Please help me on my Requirement to get only selected lines of salesline in SalesParamLine.
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

RE: Posting picking list for selected saleslines through code

Hi Piotr,

With the above mentioned code are you able to perform the printing of picking list just with a click of the button?

Or did you make any changes in the code, please confirm.
Piotr_Kulakowski 200 on at

Like (0)

Report

RE: Posting picking list for selected saleslines through code

Thanks, I found other solution:

static void autoGenLP(SalesId salesId)

{

SalesFormLetter_PickingList salesFormLetter;

SalesTable salesTable = salesTable::find(salesId);

QueryRun queryRun;

Query query;

;

if (! salesId)

{

throw error("@SYS25407");

}

try

{

salesFormLetter = SalesFormLetter_PickingList::newPickingList();

query = new Query(QueryStr(SalesUpdate_bon));

query.dataSourceTable(tablenum(SalesTable)).addRange(fieldnum(SalesTable, SalesId)).value(salesId);

query.dataSourceTable(tablenum(InventLocation)).addRange(fieldnum(InventLocation, AutoGenLP_bon)).value(queryValue(NoYes::Yes));

queryRun = new QueryRun(query);

salesFormLetter.chooseLinesQuery(queryRun);

salesFormLetter.transDate(systemDateGet());

salesFormLetter.update(salesTable,

systemdateget(),

SalesUpdate::All,

AccountOrder::None,

NoYes::No,

NoYes::No);

// info(strfmt(" ", salestable.SalesId));

}

catch

{

info('');

}

}
Verified answer

Florian Hopfner 2,451 on at

Like (0)

Report

RE: Posting picking list for selected saleslines through code

Take a look at method createParmUpdateFromParmUpdateRecord of the SalesFormLetter framework.
Verified answer

Piotr_Kulakowski 200 on at

Like (0)

Report

RE: Posting picking list for selected saleslines through code

Thanks for answer. But there is no salesFormLetter.createParmUpdate() method in AX2012.

Do you have any idea?
Suggested answer

Florian Hopfner 2,451 on at

Like (0)

Report

RE: Posting picking list for selected saleslines through code

See How to post picking list for a group of sales orders? for code to post a picking list. One way to do this for only selected lines is to change the query so it only includes the selected lines.