• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

ANI Validation

DBohner-(db)

Legendary Poster
OK, I am having a serious brain cramp...

Look as I may, I can't seems to locate the BSFN to do a F0901 or F0911
validation for Z-Table validation against records that have ANI filled in,
but not MCU, OBJ & SUB.

Basically our import Z-Table has the ANI filed (###.####.##) but not the
other account fields. I want to validate against the ANI - but not have to
substring the ANI out to populate the Business Unit, Object Account &
subsidiary...

What is the Business Function I am looking for that will use ANI (Account
number - Input (mode unknown)?

Thanks!



Daniel Bohner
drbohner@existinglight.net
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x<P ID="edit"><FONT SIZE=-1>Edited by DBohner on 7/23/01 09:59 AM.</FONT></P>
 

Christian Audet

Moderator
Staff member
Daniel,

Look in module XX0901, you will find many validation function for a ANI field. theses functions do not require a separate MCU,OBJ,SUB they will get the the info from the F0901 table with the ANI field.

Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

WSchmatz

Active Member
Daniel;

Try using the function "Validate Account Number".
It will transform your account from Mode unknown to
AID or any other mode you want. It will also return
Posting edit code if you want to check if the account
can be posted to.

The functional description on this BSFN is pretty good
so I think you will find it easy to use.

Bill Schmatz
Business Systems Solutions, Inc.



Bill Schmatz
Business Systems Solutions, Inc

B7332, AS400
 

Bill_Feeney

Active Member
Daniel,
This might work for you, however our server is down right now so I can't
give you the BSFN name, but the description is
"F0901 Edit Account Number". You supply the account number and it edits and
returns the components and description.

Bill Feeney
JDE Technical Developer
B733.2, SP 13.1, Unix, Oracle 8.1.6




Bill Feeney
B7332 SP 13.1 Sun Unix Oracle 8.1.6
 

Bill_Feeney

Active Member
Daniel,
These are the two main elements of the mapping from ER Printout(server still
down):
GC Account Number <> szAccountNumber
"7" -> cBasedOnFormat

Let me know if this helps.


Bill Feeney
JDE Technical Developer
B733.2, SP 13.1, Unix, Oracle 8.1.6




Bill Feeney
B7332 SP 13.1 Sun Unix Oracle 8.1.6
 

WSchmatz

Active Member
Daniel;

Put your ANI in the szAccountNumber and szUnstructuredAccount.

Use the constant 2 for cBasedonFormat.

If you want the AID returned:
Use the constant 5 for cFormatAccountNumber
and map your return field to szAccountID.

If you want company, currency, posting edit code etc just map the return fields to those parameters.

If this is used in an application the field will be flagged as an error.

For a UBE I could not get the errorID to be returned, but it will return nulls in the AID if the account is not found.

Hope this helps.

Bill



Bill Schmatz
Business Systems Solutions, Inc

B7332, AS400
 

Bill_Feeney

Active Member
Daniel,
I'm glad I could help...next time it'll be your turn (-:

Bill Feeney
JDE Technical Developer
B733.2, SP 13.1, Unix, Oracle 8.1.6




Bill Feeney
B7332 SP 13.1 Sun Unix Oracle 8.1.6
 
Top