Non Stock Line

Users here are handling price adjustments by entering a Sales Order with a Non Stock Line type (in this case N). This non-stock line type is set not to interface with inventory. If the users zeros out the cost on the item and processes the order it works fine through Sales Update and simply posts to Sales. If they forget to zero out the cost (99.999%) of the time, Sales Update will hit both CGS and Sales. All of these errors require the Fin dept to do J/E's at Month End.

I realize this can be fixed with user training, but I don't think it makes sense that OW is allowing it to hit a CGS account when the Line Type tells it that it is non-inventory based.

I'm sure JDE handles this, but I would appreciate any help anyone can give.

Xe, SP21, NT, SQL

What I have done is set up an inventory clearing account... and point the
DMAAI for COGS and Inventory to the same account for this particular
transaction... it seems to work for us.



I realize this can be fixed with user training, but I don't think it makes
sense that OW is allowing it to hit a CGS account when the Line Type tells
it that it is non-inventory based.

I'm sure JDE handles this, but I would appreciate any help anyone can give.

Xe, SP21, NT, SQL

_________________________________________________________________
Say “goodbye” to busy signals and slow downloads with a high-speed Internet
connection! Prices start at less than $1 a day average.
https://broadband.msn.com (Prices may vary by service area.)

You said..." I'm sure JDE handles this, but I would appreciate any help
anyone can give."


Well, don't be so sure! Take a look at SAR 4927920 Non-inv interface gen COGS (another way to
throw your Inventory Account out)



DESIRED OUTCOME :
The line type was overwriten to a non-stock line type. Thus
sales update should not hit the COGS & inventory accts where
by 'edit item master for non-stock item' field is checked.





B FINAL DISPOSITION

This is working as designed.
The inventory interface flag does not affect G/L entries.
It only has to do with interfacing to the inventory system.
If the user wishes they may turn off the interface to G/L
for their line type.




Of course, using the suggestion of turning off the G/L interface means that
nothing goes to the G/L

One work around is to use your Activity Rules to ensure that Stock and
Non-Stock lines (those with Edit Item checked) cannot be mixed on a single
Document Type. You would then set your 4220/4240 AAI's for your Non-Stock
DOCUMENT TYPE to point to each other. You also need to review any
Sales/Margin Reports to ensure that Costs are ignored for this document
type.

Regards,




*********************************************************************
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

Here's a solution. As your non-stock line has an item master, use a unique GLPOST code. Then set the AAI for inventory and cogs to the same account using that GLPOST code. This will result in a zero JE.

JDE_JRC <[email protected]> wrote:Users here are handling price adjustments by entering a Sales Order with a Non Stock Line type (in this case N). This non-stock line type is set not to interface with inventory. If the users zeros out the cost on the item and processes the order it works fine through Sales Update and simply posts to Sales. If they forget to zero out the cost (99.999%) of the time, Sales Update will hit both CGS and Sales. All of these errors require the Fin dept to do J/E's at Month End. I realize this can be fixed with user training, but I don't think it makes sense that OW is allowing it to hit a CGS account when the Line Type tells it that it is non-inventory based.I'm sure JDE handles this, but I would appreciate any help anyone can give.Xe, SP21, NT, SQL
--------------------------
To view this thread, go to: http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=Apps&Number=64834

This is the JDELIST Applications Mailing List. To stop receiving these messages, login to http://www.jdelist.com/forums, click Control Panel, then click Edit by "Subscribe / Unsubscribe from receiving board posts by email, change message notifications, etc." and adjust your subscription preferences. JDEList is not affiliated with JDEdwards®


---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now


World, OW B733X and Xe