Update gl_date in ra_interface_lines_all before calling AutoInvoice job
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.