Automated Receipts Processing (R03B551 / R03B50)

Eric B.

Eric B.

Member
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.
 
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,
 
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
 
JDE Allows for a hierarchial approach. Start with R03B50D and work your way down to other methods if a match is not found.
 


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
 
You can set up values for item Doc, dct,... in table Z1.

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

Good lucks

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.
 
Back
Top