Consolidated invoices with multiple G/L dates
We are running JD Edwards World version A9.3.1 on an iSeries and recently discovered that pay items on consolidated invoices are posting with G/L dates in different periods when the ship dates on the associated sales orders cross periods (so this is essentially a month-end problem). This is causing an issue with SOX compliance, which apparently requires that orders book to the G/L in the same month in which they ship, regardless of the month in which they invoice.
As a result, our users are asking that we find a way to break and generate a new invoice when ship dates that occur in other periods are encountered while consolidating, but since adding a break on the ship date itself is too specific (we would actually need a break on ship month/year), short of modifying P42565, the only solution we've come up with so far is to duplicate the existing set of invoicing versions to create a new set to be used at month-end, and then adding date selection criteria to the month-end versions so that only those orders