You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Update gl_date in ra_interface_lines_all before calling AutoInvoice job

Received Response
122
Views
5
Comments

Summary:

Need to update gl_date in ra_interface_lines_all to current OPEN period instead of FUTURE period.

Content (required):

Need to update gl_date in ra_interface_lines_all to current OPEN period instead of FUTURE period.

AR is closed on Day 1 of following month. For e.g. During September month end, AR closed on OCT 2nd. Transactions created on Oct 1 and Oct 2 should have GL_DATE of 30-SEP-2023 instead of OCT. Does REST API support this in Fusion cloud?

Goal is to update interface table and then submit Autoinvoice job so that invoices are created with the right GL date. Transactions are imported from Subscription and Order Management sources and hence updating interface table seems to ideal solution if it is possible to do so.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!