2,016
greeting everyone
i'v create edit string to search by barcode and change value of delivery now to
how can i do that?
i'm trying this code but still give me error
Share
ReportsalesLine_ds = _salesLine.dataSource();
localSalesLine = salesLine_ds.getFirst(true) as SalesLine;
if (localSalesLine)
{
while (localSalesLine)
{
localSalesLine.SalesDeliverNow =1;
}
} In the modified method of your checkbox, you can call my method.
How exactly to call it depends where you put the findByBarcode method.
Let's assume you put it on the form. Then you can call it by element.methodName().
So, put following code in the modified method of your text box:
element.findByBarcode(SalesTable.SalesId, this.valueStr());
thanks for helping
but i think i do mistake with textbox method because method not accept to declare (SalesId _salesId, ItemBarCode _barcode)
any suggestion for how to search from salesTable_ds
ok thanks but how about the method because i'm using control (editstring )
and method inputSearch()
...
Anyway the code for finding a matching sales line would be something like this. No guarantees, it's just an illustration, your homework is to finalize it :)
All responses (
Answers (
public SalesLine findByBarcode(SalesId _salesId, ItemBarCode _barcode)
{
SalesLine salesLineLocal;
InventItemBarcode inventItemBarcode;
select firstonly salesLineLocal
where salesLineLocal.SalesId == _salesId
exists join inventItemBarcode
where inventItemBarcode.ItemId == salesLineLocal.ItemId
&& inventItemBarcode.InventDimId == salesLineLocal.InventDimId
&& inventItemBarcode.ItemBarcode == _barcode;
info(strFmt("Match found, line number %1", salesLineLocal.LineNum));
// Or, if you want to find out the number of matching records:
select count(RecId) from salesLineLocal
where salesLineLocal.SalesId == _salesId
exists join inventItemBarcode
where inventItemBarcode.ItemId == salesLineLocal.ItemId
&& inventItemBarcode.InventDimId == salesLineLocal.InventDimId
&& inventItemBarcode.ItemBarcode == _barcode;
info(int642str("%1 matching records found", salesLineLocal.RecId));
}
Hi mohammed,
Where are are searching by barcode? Also what error are you getting?
Looking at your code, are you trying to loop through all sales order lines? In that case you an try this code -
Not sure if you are trying to update the record as well in which case you will need include the update statement as well.
[/quote]i'v try your code but it's give me error as you see here
yes but here i'll add more condition if there's duplicate line of barcode like check on qty for example
So, first you need to know which item has this barcode.
Then you need to find all sales order lines (on the selected sales order) that have this item.
And finally you need to adjust the "DeliverNow" for all such order lines.
Correct?
So if you have 20 lines that all have the same item and barcode, you want to adjust the DeliverNow value of all these lines?
sorry for my explain was not very well
this is in sales order lines
i'v create that editstring (in yellow selection) to use it for search and find product by barcode from sales line and if it found any barcode i want it change the value of (delivery now) from line which it found directly
here in this method
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
