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
[email protected]
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>
 
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)
 
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
 
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,

I have been trying to get the function "Validate Account Number" to work -
using just ANI...

I don't seem to be mapping the parameters correctly... at least I am not
getting the returning values that I would expect.

Hints?



Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x
 
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
 
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,

Thanks! I had the right business function, I just didn't have the brains to
figure it out (Monday, no coffee, little mountain dew and not enough
snickers)..

Got it to work... with your assistance!


Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x
 
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
 
Back
Top