Skip to Content
0
Former Member
Oct 17, 2006 at 06:04 PM

RSBBS Jump: AR Line Item Query to R3 Customer Line Item Display

68 Views

I am attempting to create a 'Jump Target' from the 0FIAR_C03 AR Line Item Infocube to the R3 FBL5N Customer Line Item Display transaction.

The query that the jump is to be performed from an Aging query.

The user will be running this query for all transactions posted up to and including the end of the previous calendar month. The posting date is provided by the user when submitting the query (via variable 0P_KEYD2). The aging report works just fine.

Where I'm having the problem is when the user wishes to jump to the R3 transaction FBL5N to display the Customer Line Items. The user wants the 'Line Item Selection' in R3 to inlcude 'Open Items' (this button should be selected -- it is the default setting) where 'Open at Key Date' is to be derived from the query result in the Excel workbook.

I have created the RSBBS Sender/Receiver Assignment so that it goes and retrieves the line items from R3 for the correct customer. However, I have not been able to figure out how to populate the 'Open at Key Date' with the end Posting Date (OPSTNG_DATE) from the query.

I've tried every combination I can imagine in the 'Assignment Details' section in RSBBS, but so far I have not been able to make it work.

Has anyone else out there tried this?

If you have, were you able to populate the 'Open at Key Date' (ALLGSTID) field in the R3 FBL5N transaction? If you were able to do this, how did you do it?

All ideas appreciated . . .