How to Move Stock from a Previous Period
In Sage X3

Have you ever found yourself in a situation where you need to move stock from a previous period in Sage X3? For example, in April you moved all but 1,000 lbs of stock from QC to Accepted (A), but now it is May and you need to move the rest. The only issue is that April is no longer open—the stock period is closed.

In this blog post, we’ll show you how you can get around the indefinite period error and get those 1,000 lbs approved and put in the lot.

BALANCE ADJUSTMENT STOCK STATUS

The simplest solution is to try changing the stock status to Balance Adjustment (after confirming with Finance, of course). Balance Adjustment will prevent any new stock records from being entered into the system. However, it will also make it possible for you to update existing transactions. Since you’re just trying to change the status to A, no JE will be generated and therefore there should be no impact on financial statements.

You can also do this after hours as a precaution. In case someone else is trying to update an existing stock transaction in April 2023.  After you’re done with the fix, please make sure to switch the status back to closed!

Here is an extraction from Sage help that describes what Balance adjustment means:

• Balance adjustment
  The period is open to price adjustment movements only. If not absorbed movements exist, they are posted on the first open fiscal period available. This status is used to modify an existing stock transaction (shipments, receipts, etc.) and to launch the price adjustment processing (issues and receipts).

Hopefully, this will help you move stock from a prior period. Should you have any questions about the balance adjustment stock status, or any other questions about Sage X3, please contact us.