Results 1 to 6 of 6

Thread: Error in Sales Update - R42800

  1. #1

    Error in Sales Update - R42800

    We are facing one error while doing sales update. We are calling our own print invoice report and internally its calling first sales update then its printing the invoice.
    We are attaching price adjustments for item being sold.

    The errors in the work center are

    Subject :
    Cause. . . . . The Sales Update program (R42800) has received a General Ledger
    error(s) from the business function F0911FSEditLine in the G/L Batch Number
    8498 and Batch type IB.
    Resolution . . Please review and correct the error(s).


    Subject : Error: Blanks Invalid
    CAUSE . . . . The data field being processed does not allow blanks or zeros
    to be entered.
    RESOLUTION. . Enter a non-blank or non-zero value.

    I have also attached a screen shot of the work center

    Awaiting valuable suggestions at the earliest. Thanks in advance

    EnterpriseOne Xe to 9.2
    Windows/ Unix / AS400
    Oracle , SQL Server, DB2
    WAS , WLS
    AppWorx, Tidal , SmartScheduler

  2. #2
    Join Date
    Apr 2001
    Melbourne, Australia

    Re: Error in Sales Update - R42800

    The old "Blanks Invalid".... was the second level text on this message any
    help???? - only kidding.

    I cannot see your WC screen print attachment on the web site, but this
    normally isn't much help in this situation anyway.

    You mention Advanced Pricing, do you still get errors if you don't have
    Advanced Pricing turned on (overriding the price will do this)? As your
    error is coming from FS0911EditLine, you would suspect that it is a problem
    with the Account Number it wants to post to. Are you using Flex Accounting
    ? Is there an issue with the field you are populating into the
    BU/Subsid/Subledger? That's a start, but it's nearly all guess work as to
    what it could be from here. It could be an ERP8 bug or it could be set up
    related. Does it happen on all orders or only specific scenrios?

    One way to try and narrow this down is to run the job again using the
    'Advanced' option, check the jdedebug.log and set Logging Level = 6. The
    batch job will produce a log which you can review from your submitted jobs
    screen (View Logs row exit). If you scan for F0911FSEditLine you can step
    through what this BSFN is doing (especially the SQL statements - SELECT,
    UPDATE...). You might be lucky and find the culprit. If you have access to
    any technical resource they should be able to help you walk through this.

    Alternatively it is a matter of walking through your set-up again

    Good Luck


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

  3. #3
    New Member ASilveira's Avatar
    Join Date
    Aug 2003
    Curitiba / Brasil

    Re: Error in Sales Update - R42800

    This error usually ocurrs when the sales update did not find one account number (AID) in F0901 whit the key (MCU.OBJ.SUB) from DMAAI and MCU from SO (if the field MCU on DMAAI is blank) and try to update F0911 with this field ( AID ) with blanks.
    <ul type="square">[*]OS/400[*]A5.1,..., E1 8.9[*]GL, AR, AP, PTP...[*]DB2-400, Oracle[/list]

  4. #4

    Re: Error in Sales Update - R42800

    Thanks for your replies guys...

    The problem was with the particular price adjustment schedule I guess. We defined a new price adjustment schedule from scratch and we were able to get it to work. How ever I could'nt really figure out what was wrong with the earlier price adjustment schedule i was using

    Thanks any ways..
    EnterpriseOne Xe to 9.2
    Windows/ Unix / AS400
    Oracle , SQL Server, DB2
    WAS , WLS
    AppWorx, Tidal , SmartScheduler

  5. #5

    Exclamation Sales Update Error in Work Centre R42800


    I need some help please.

    When I run the R42800 it runs into error and sometimes there is NO message in the Work Centre. I rebuild the report and now I get the following message:

    Informational: Call From : Marianne Van Der Walt
    Contact :
    Phone Number :
    Tickler Date : 06/11/2019
    Subject : Error: Invalid Sales Journal Data Select
    Cause: The Sales Journal data selection is using a data item from F4201 table.
    Resolution: Use data selection data items from the F4211 table only.

    Can someone please tell me what this error means and where will I find it
    Thanks Marianne

  6. #6
    I've seen this often when using data selection in sales order processing. The field in the data selection is both in the F4201 (header table) and the F4211 (detail table) for the business view. Go into your data selection screen and find the data selection you are using that states that it is being selected from the F4201 table. Use the drop down to select the same data item but make sure it say F4211. If this isn't clear attach a print of your data selection being used because without seeing that I can't tell what data item you've selected from the F4201 table that is erroring out.

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.