Results 1 to 4 of 4

Thread: Non Stock Line

  1. #1

    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


  2. #2
    Senior Member
    Join Date
    May 2002
    Posts
    305

    RE: Non Stock Line

    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.)


  3. #3
    Member
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    324

    Re: Non Stock Line


    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 ( postmaster@berriltd.com.au)
    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

    Craig Potter

  4. #4
    Senior Member
    Join Date
    Nov 2000
    Location
    Houston, TX
    Posts
    548

    Re: Non Stock Line

    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 <jcarlton@helixtechnology.com> 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/showthrea...s&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

    World, OW B733X, Xe, E1 8.0, 8.9, 8.10, 8.11, 9.0 Financial, Distribution, Dev, CNC

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.