Results 1 to 3 of 3

Thread: DataMigraton - Completed Sales Orders

  1. #1

    DataMigraton - Completed Sales Orders

    Is there a std way to migrate completed sales orders?

    R47011 & R47131 don't work as fields like Invoice number/ date aren't included.

    Do I just roll my own UBE to write straight to F42019/F42119?


    E9.2
    SQLServer.

  2. #2
    Member Aarto's Avatar
    Join Date
    Oct 2000
    Location
    Copenhagen, Denmark
    Posts
    389
    Ahemm.. If you want to generate customer ledger records, GL entries and tax entries from the sales orders, then your best bet would probably be to use the F47 or Z-tables and roll your own post-processor to update the imported orders with invoice number, type, company and invoice date and then let sales update take care of the customer ledger/financial records and closing of the order to status "999". However, the financial posting period needs to be open so if you're importing historical orders from years back, you would need to have the oldest period open for A/R and G/L entries

    If you do not need to get the customer ledger or G/L entries then your post processing UBE just needs to set the next status to "999" and G/L date to invoice date and the run R42996 to move the records from F4211/F4201 to F42119/F42019


    Also, if these are stock orders, you would need to set the related P4210 processing options to not check availability and also (in your post processing UBE) set the actual ship date and set on-hand updated (SDSO02) flag to "1". I always favor migrating old sales orders using a non-stock line type just to avoid any integrity issues / false negatives between F4211/F4111/F41021/F41112 and F4115 but you approach could be different based on the requirements

    Hope this helps
    Aarto
    Aarto Reponen

    Managing Director, xperitus Denmark Aps - Your JDE experts in Scandinavia

    LinkedIn

  3. #3
    Thanks for the reply Aarto

    Looks like there is no std solution - bugger.

    Ok - for future reference...

    1) Populate F47011/F47012 and run R47011 to get them into F4211 at status 980/999. (setup as you advised)
    2) Custom UBE to re-read from F47012 and update F4211 with fields that aren't populated etc.
    3) Use R42996 to move them into F42019/F42119.

    Ta

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.