Who's On?

	Membership:
	Latest: Alanna
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5294

	People Online:
	Visitors: 384
	Members: 0
	Total: 384

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

apdistrib diff's between 7.x and 9.x

3 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Dave

Basic Member Send Private Message

Posts: 13

10/29/2008 7:12 PM

I have a request from our Finance department to make a change to APDISTRIB in LSF9 on a couple of fields. Current values are creating problems in some of their AP reports and their GL190. Wondering if anyone has received a similar request and how you handled it.

They would like to create an external process to replace values reported in LSF9 to the values that used to be there in version 7.x. The change was made in 8.x.

1. Description field. replace the item-number which currently is written to that field with the Vendor/Vname.

2. Dst-Reference. Replace the Voucher number currently written to this field with the Invoice Number. Even though reference field is 10 and invoice can be 22 characters.

They want the changes made in AP175 so this information will also transfer over to the GL to correct their GL290's, GL90's, etc.

I've offered up a few alternatives but they are adamant on the change to the tables. Any advice would be greatly appreciated.

Thank you,

Dave Robertson
davroberts@edisonlearning.com
ERP Manager
EdisonLearning

John Henley

Posts: 3355

10/29/2008 7:39 PM

Actually, the best place to do it is in Design Studio in AP20; AP175 just picks up what is in APINVOICE/APDISTRIB and passes it forward. The other advantage is that--by using Design Studio--you're not customizing a key Lawson-delivered program. What I have done for clients is this:
function FORM_OnBeforeTransaction(fc)
{
if (fc == "C" || fc == "A" )
{
for (var nRow=0; nRow < 5; nRow++)
{
//stamp vendor name into distribution description
lawForm.setDataValue("APD-DESCRIPTION",lawForm.getDataValue("VEN-VENDOR-VNAME"),nRow)
}
}
return true;
}

Dave

Basic Member Send Private Message

Posts: 13

10/29/2008 8:17 PM

Thank you, that's a great idea! One question? Do you see any problems with replacing the delivered values? I don't want to replace the values and find out later I might have broken something in AP or GL.

Thanks again,
Dave

John Henley

Posts: 3355

10/30/2008 5:17 PM

I'm assuming you have posting option = 'D' set up for the AP company on AP00.4 ?

I have not heard of any issues with doing this; you can override either of these fields on AP20; what you're seeing is just the defaults that are entered programmatically if you don't enter anything.

One other option to consider is that vendor number and invoice are passed over to GL via attributes if you have them set up on GL05 for source code AD.