When creating a vendor bill, our purchase ledger team are unable to set the posting period as the box is greyed out. There is a suite answers on this and it is because the bill is non-posting when it is in pending approval status. If the bill is dated earlier in the year (ie. April, a locked period), the posting period defaults to April despite the ledgers being closed in account settings. This remains true even when the bill is saved in the final approved status - the posting period is set as April despite the period being locked. Does anyone have a solution to this problem that some other clients may have requested?

I've seen this working with a prior customer. I ended solving this by updating a Bill Approval Workflow to preserve the original Bill Date in a custom field, change the Transaction Date to current date which posts into the current period, and then copy the original date back to the Transaction Date.

I did a workflow action script to 'get earliest posting date' which looked up the accounting periods and returned the startdate of the earliest period where AP locked was false; then within workflow, if the date was less than the earliest posting date, i would update the date