Results 1 to 6 of 6

Thread: Automated Receipts Processing (R03B551 / R03B50)

  1. #1
    New Member Eric B.'s Avatar
    Join Date
    Jun 2005
    Location
    Baltimore, Maryland
    Posts
    2

    Automated Receipts Processing (R03B551 / R03B50)

    Please help!!

    We have an issue with Automated receipts processing (R03B551 / R03B50). When processing receipts we currently run:

    A. R03B551 - Update receipts register
    B. R03B50 - Apply receipts to invoices

    R03B50 submits R03B50D - Known invoice match with amount.

    Our problem is - When a receipt is processed where there are multiple pay items in F03B11 the total amount of the receipt is applied against the first pay item ignoring the second pay item.

    For example. We have a receipt in the F03B13Z1 file for 374.34. In F03B11 there are 2 pay items (sfx 001 and 002) for the document. In this case the document is 68946361 for both the F03B13Z1 receipt and the F03B11 pay items. In F03B11 pay item 001 is for the amount of 324.34 and the amount for pay item 002 is 50.00. When we run the Apply Receipts to Invoices job the full amount of 374.34 is applied to the first pay item. The open amount (AAP) is updated to -50.00. The second pay item is not addressed.

    In this case the first pay item should have been fully paid and the remaining 50.00 should have been applied to the second pay item.


  2. #2
    Member Sef's Avatar
    Join Date
    Sep 2001
    Location
    Adelaide, Australia
    Posts
    765

    Re: Automated Receipts Processing (R03B551 / R03B50)

    Hi Eric

    How are you populating the F03B13Z1 file?
    Are you able to split the entries in your Z-file by pay item? The receipt amount (only recorded against the first pay item) is still the total amount received but the amount applied is split over multiple lines.
    Do you run a custom written interface to populate the z-file? You could read the F03B11 table first for open invoices and than populate the Z-file according to the format of the Invoice.
    In both cases R03B50D will run as intended.

    Alternatively you can change/expand your execution list and user other matching methods eg R03B50E.

    Good luck,
    Sef van den Nieuwelaar
    Australia

  3. #3
    Member
    Join Date
    Sep 2005
    Location
    DUBAI
    Posts
    96

    Re: Automated Receipts Processing (R03B551 / R03B50)

    HI Sef,
    i want to use this functionality like I want to match Invoices with receipts ina scenario where most probably the amount will be same so while going through I can see reports starting from R03B50A to R03B50E which one is best suitable for situation I mentioned above?

    Thanks & regards.

    MANDAR
    United Arab Emirates
    JDE Functional Finance/Inventory
    E1 8.12/8.11/8.10
    One World Xe 7.33
    World Soft

  4. #4
    Member Sef's Avatar
    Join Date
    Sep 2001
    Location
    Adelaide, Australia
    Posts
    765

    Re: Automated Receipts Processing (R03B551 / R03B50)

    JDE Allows for a hierarchial approach. Start with R03B50D and work your way down to other methods if a match is not found.
    Sef van den Nieuwelaar
    Australia

  5. #5


    Good afternoon Eric / SefCould you solve the problem?I'm having the same problemI'm having the same problemood afternoon Eric / SefCould you solve the problem?I'm having the same problem

  6. #6
    New Member thienduong584's Avatar
    Join Date
    Mar 2015
    Location
    Danang,Vietnam
    Posts
    5
    You can set up values for item Doc, dct,... in table Z1.

    And setup Version
    R03B551 > R03B50 (B,F,D)

    Good lucks

    Quote Originally Posted by Eric B. View Post
    Please help!!

    We have an issue with Automated receipts processing (R03B551 / R03B50). When processing receipts we currently run:

    A. R03B551 - Update receipts register
    B. R03B50 - Apply receipts to invoices

    R03B50 submits R03B50D - Known invoice match with amount.

    Our problem is - When a receipt is processed where there are multiple pay items in F03B11 the total amount of the receipt is applied against the first pay item ignoring the second pay item.

    For example. We have a receipt in the F03B13Z1 file for 374.34. In F03B11 there are 2 pay items (sfx 001 and 002) for the document. In this case the document is 68946361 for both the F03B13Z1 receipt and the F03B11 pay items. In F03B11 pay item 001 is for the amount of 324.34 and the amount for pay item 002 is 50.00. When we run the Apply Receipts to Invoices job the full amount of 374.34 is applied to the first pay item. The open amount (AAP) is updated to -50.00. The second pay item is not addressed.

    In this case the first pay item should have been fully paid and the remaining 50.00 should have been applied to the second pay item.

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.