POP Document Inquiry listing all Shipments and Invoices and Retruns

We had problem in scrolling window like its listing only Shipments BOL number  not as Invoices  BOL Number.This issue was resolved through Dexterity.

Soluion:

l_sResults[1] = “”;
sQuery = “SELECT USER_DEFINED_TEXT01 FROM POP10306 WHERE POPRCTNM like ‘%”+ trim(‘POP Receipt Number’ of table POP_DocumentInquiry_TEMP) +”‘”;
call CW_ExecuteSQL, sQuery, 1, l_sResults;

if empty(l_sResults[1]) then
sQuery = “SELECT POPRCTNM FROM CW_PI10300 WHERE GPINVNO like ‘%”+ trim(‘POP Receipt Number’ of table POP_DocumentInquiry_TEMP) +”‘”;
call CW_ExecuteSQL, sQuery, 1, l_sResults;
end if;
‘(L) BOL’ of window Document_Scroll of form POP_Document_Inquiry = l_sResults[1];
redraw field ‘(L) BOL’ of window Document_Scroll of form POP_Document_Inquiry;

through that we can come out of issue of filling invoices BOL number.

Advertisements

About nijamkhan

I am simple Hardworking,and i would like improve the Knowledge time by time
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s