Results 1 to 5 of 5

Thread: Change G/L class of an address book number

  1. #1
    Member
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    571

    Change G/L class of an address book number

    There is one request I received from Finance Dept to reclassify the G/L Class of address book number.
    For example, the supplier 123 with G/L Class PY03 - Affiliate Payable, will hit 4-113100.
    Now, they want to move the supplier from PY03 to PR13 - Related Parties Payable to hit another account 4-113200.

    What are the things I have to accomplish this task.

    In my understanding (I'm just a developer), I have to do the following.
    - Change GL class to PR13
    - Setup AAI to hit new account.
    - Do journal entry to move balance from old account to new account.
    RAUF MUHAMMED K
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3
    http://www.raufnicole.com

  2. #2
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    Location
    NSW Australia
    Posts
    2,091
    Rauf,

    That's an unusual request for a developer. Changing the GL Class for a supplier or a group of suppliers and creating an AAI (if it doesn't exist already) is correct. The experience and knowledge of doing these tasks, as well as creating journals, would normally be in the Finance/Accounting department. I'm not sure about the need for a journal to move the balance to a new account. However all this can (and probably should) be done by Finance/Accounting users.

    If there was a large number of suppliers to change, then a developer, or probably more appropriately a DBA, may make the changes.

    If the GL class was being changed for all suppliers and the old GL class was no longer going to be used, then there would probably be a need for a journal to move the balance. But if that is not the case moving the balance would not be appropriate because it would include amounts for suppliers with the original GL Class unchanged. If there was a journal required to move the amounts related to the changes to the new account, the transactions that relate to the changes would need to be identified and summed and the result used in the journal. I doubt the accountants would required a separate journal for each transaction involved, but I've seen stranger requests.
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  3. #3
    That's not just all potentially. Does that supplier have any outstanding open AP? If so, then when it is paid, it will come out of the old GL class code GL account instead of the new one.

  4. #4
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,224
    Is this for a consigned stock type issue? (stock you hold but is actually your customers/vendor owned)

    You may have to reverse out the initial GL entries posted to the other accounts before the GL class change as well. But your finance team can tell you more about that and their wishes.

    I've written my own consigned stock process that read through the cardex and then follows rules on suppliers, items and GL Class. I have to reverse out the initial receipt and consumption entries when I do it
    Last edited by johndanter; 12-04-2017 at 01:58 AM.
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  5. #5
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,224
    and what about the F41021 of the current stock you have????
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

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, Oracle or Peoplesoft.