Category Archives: Features

How to create and add formula on inquiry screen

An inquiry screen is used to extract information from one or more table and present it in the from of a grid. It help us to display the records based on the filter criteria we entered. In Sage X3, we have a multiple inquiry screens available such as Stock by product, stock by lot,stock by… Read More »

How to do Period End procedure in Sage X3

Fiscal Period is the period of time reflected in financial statements. Usually, the fiscal period is either the calendar year or a quarter. Fiscal period is also known as an accounting period. The fiscal year is the consecutive 12-month period during which a business or organization plans its budget. It does not have to be… Read More »

How to Align Lot numbers with Work order numbers

A Work order is an order to make one or more products. Conventionally, the work order uses a bill of materials (BOM) to create a list of materials to be issued, and a routing to make a list of operations to be performed on work centers. Work orders dictate what product need to be manufactured,… Read More »

How to restrict dimension relationships within dimension type

As we all know sage x3 uses dimensional accounting which helps to improve and simplify the reporting. There may be a case where dimensions should not be used in combination with another dimension. Restriction codes can be configured to prevent such cases. We have seen how to configure restriction code and setup Account/Dimension restriction code… Read More »