Recurring Invoicing

[Former Member]

I am useing Recurring Transactions for AR Invoices in SAP 8.81.

I need to execute the Invoices on the 25th of each months but posting date needs to be the 1st of next month.

For example execute August 25 but posting date is Sept1.

I can change the date in the execution screen to the 1st. Is there a way I can change the date for all 300 invoices to the 1st when executing or is it a one by one deal- hope not.

[Former Member]

Rosi,

we are doing this kind of transaction every week

we are upload hundreds of CreditNote from Excel to SAP B1 using macro

You can upload Invoices from Excel to SAP B1 as you needed every month

Nilesh Shah

[Former Member]

Yes for Documents it is ORCL for the new function in SAP 8.81, ORCR is for Recurring Journal Entries SAP has had.

I need a way to update ORCL Scheduled Date field with a mass update not one by one.

Nothing in DTW

[Former Member]

If you can not find it, it means not included in DI yet. You may have to go through each one by one.

[Former Member]

Does anybody know if I can update the ORCL table via DTW? I could not find anything....What would be my other option. There are 300 invoices so one by one is not good!!! Thanks

[Former Member]

In 8.8, the table for recurring posting is ORCR. Are you sure it is changed to ORCL in 8.81?

[Former Member]

Is there a template for the Execution task?

[Former Member]

You may search under template folder. I do not have the same version to check.

[Former Member]

Hi,

I am afraid you have to update them one by one unless you can use DTW to facilitate it.

Thanks,

Gordon