AP26 - Javascript Help - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

AG

Advanced Member

Posts: 29

2/9/2009 2:46 PM

Our Finance team asked us to add two total fields onto AP26. They want to see total dollars and invoice count, when an Inquiry is done on the form.
I added the fields onto the form no problem. I also then added the JS script to loop thru all the lines on the form and display the total dollars and invoice count.
The only issue I ran into is when they hit the page up or page down buttons. My JS only displays the totals for the actual data displayed and does NOT count the invoices not displayed currently.
Does anyone know how I can fix this? Am I going to have to execute a DME directly to the table and add up the totals that way?

TIA.

John Henley

Senior Member

Posts: 3348

2/9/2009 4:57 PM

You are going to have to do a DME against the backend tables.

AG

Advanced Member

Posts: 29

2/9/2009 7:25 PM

Can someone post a sample JS script that shows how to loop through the records that I get back from the DME Call? I have the code and syntax to make the call I just need the syntax for the loop

Ragu Raghavan

Veteran Member

Posts: 469

2/9/2009 7:39 PM

This code looks up APINVOICE for a specific company + invoice and populates a textarea box with the invoice details.

function getAPI (vCompany, vVendor)
{
var s = portalWnd.DMEPath;
s += "?PROD=" + sPDL;
s += "&FILE=APINVOICE";
s += "&FIELD=INVOICE;INVOICE-DTE;TRAN-INV-AMT";
s += "&INDEX=APISET1";
s += "&KEY=" + vCompany + "=" + vVendor;
s += "&OUT=XML";

var sReturn=portalWnd.httpRequest(s);

if (!sReturn || sReturn.status)
{
alert("status s " + sReturn.status);
return true;
}

var vObjXML = new portalWnd.DataStorage(sReturn);
var vRecords = vObjXML.document.getElementsByTagName("RECORD");
var str = "";
for (var ix=0; ix < vRecords.length - 1 ; ix++)
{
var vCols = vRecords[ix].getElementsByTagName("COL");
if (ix != 0)
{
str += "\r";
}
str += vCols[0].firstChild.data + "," + vCols[1].firstChild.data + "," + vCols[2].firstChild.data
lawForm.setFormValue("textarea1",str);
}
return true;

}

Terry P

Veteran Member

Posts: 234

2/9/2009 7:45 PM

Here is my code to add up the total of all distribution lines:

//Construct DME for getting info
sDME = "http://" + window.location.host + "/cgi-lawson/dme.exe?" // version 8
sDME += "PROD=" + strPDL
sDME += "&FILE=MMDIST&INDEX=MMDSET1"
sDME += "&KEY=" + sCompany + "="
+ sSystemCD + "="
+ sLocation + "="
+ sDocType + "="
+ sPONumber
sDME += "&FIELD=DIST-PERCENT"
sDME += "&SELECT=LINE-NBR=" + sPOLine
sDME += "&OUT=CSV&DELIM=~&NOHEADER"

//Return value from table
var objhttp = new ActiveXObject("Msxml2.XMLHTTP")
objhttp.Open("GET", sDME, false)
objhttp.Send("UserInfo")
sReturn = objhttp.responseTEXT

if(sReturn != "") //If there is data returned
{
//Remove the carriage return character, if any.
while(sReturn.search("\r")>-1)
{
sReturn = sReturn.replace("\r","")
}

//Split into individual records on the line feed character.
aRecs = sReturn.split("\n")

//Remove the last blank record
aRecs.pop()

//Initialize Total counter
nTotal = 0

//Break the records into fields and Total
for(i = 0; i < aRecs.length; i++)
{
aFields = aRecs.split("~")
var num = formatCurrency((parseFloat(lawForm.getFormValue("textextamt")) * parseFloat(aFields[0])) / 100)
nTotal += parseFloat(num)
}

var numTotalFormated = formatCurrency(nTotal)
lawForm.setFormValue("distribtotal",numTotalFormated)

var numRemainingFormated = formatCurrency(((parseFloat(lawForm.getFormValue("textextamt"))) - parseFloat(numTotalFormated)))

if (numRemainingFormated == "0.00")
numRemainingFormated = "";

lawForm.setFormValue("undist-amt",numRemainingFormated)
}
else
lawForm.setMessage("No distribution records found")