AAI 4230

[mjb]

I have an issue with AAI account selection. I have set up three GL Class codes to process Sales to three accounts

One is the Standard IN30 for product sales
the others

IN36 - Shipping Code
INTX - Tax Codes

I have an AAI set up for these items in 4230 to process to three different G/L Accounts. However, As I run the update it post the balances to the one account assigned to IN30.

Can anyone suggest why this happens? What am I missing?

Any help would be appreciated.

Thanks,

John B

 

[Guest]

Is IN36 assigned to a Freight Item setup in the Item Master. If so, then
check the G/L class in two more locations--the Item/Branch, and then drill
down to the Item/Branch/Location file. Sales Update pulls the value from
the Item/Branch/Location file--the F41021.

Is the INTX value setup in the Tax Areas that are being pulled into the
Sales Order? The system reads the tax area (I think at the Sales detail
level or it could be the header) and then goes out to the Tax Area file to
read the GL class there.

Andy Klee, dabbler in Advanced Pricing and Sales Order




Andy Klee
www.JDETips.com

 

[mjb]

Re: RE: AAI 4230

Andy,

They are both set up as Stock items as the information comes in from a third party system I have them set up as if they are non-stock product. They are selected as part of any other product and an amount entered for the value? This is true for both Shipping & Tax items.

The GL Code is found to be the same in all places
Primary location - Not using location is IN36 as is base and branch plant.

John

 

[Craig_Potter]

Re: RE: AAI 4230

John,

What G/L Class do you have on your Sales Order lines?

* If they are all IN30, check the program which uploads these Orders.

Do you have Advanced Pricing with Pricing Overrides turned on? What G/L
Class do you have on these F4074 records?

* The 4230 G/L Class comes from the F4074 if you have "Override Price" flag
turned on in Adv Pricing Adjustments.


If this still does not solve it for you, run your R42800 with Debug logging
turned on and scan the JDEDEBUG.LOG for "F4095" and review the SELECT
statements on this file.

Hope this helps.

Craig



*********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager ( [email protected])
Important Notice: Berri Limited scans all incoming and outgoing
emails for possible inappropriate content. Procedures to rectify problems with the email system may result in others reviewing
the content of any incoming or outgoing email.
The Berri Limited Email system is for Business use only.
*********************************************************************



Craig Potte

 

[Guest]

RE: RE: AAI 4230

John, how about calling me at 970.856.4811. I think I can help you better
over the phone than through postings.

Andy Klee