Author Archives: Greytrix

Automatic deallocation function in Sage X3

The automatic deallocation processing of material linked to production for a given site, a given period and selected work orders can be initiated using this function. This processing can deallocate the materials based on the initial allocation type (global or detailed). A deallocation processing can be initiated based on the type of initial allocation (global or detailed) for materials assigned to a given site, a given period, and selected work orders. Below are the… Read More »

Working of customer extension in Sage X3

Sage X3 has provided us a function which is named as ‘Customer extension’ (function PROROGC). Sometimes there can be a situation where we need to extend the due date of payments which is pending from a customer. Here by using customer extension function we can update the new date of the payments for specific customers.… Read More »

Product Code and Description Automation

In Sage X3, we recently had a requirement to generate custom product code based on the product category, specifications selected by the user, and to generate product description based on the product code. Screen path:Miscellaneous tables:Development – > Miscellaneous tables – > DefinitionDevelopment – > Miscellaneous tables – > DataWindow:Development -> Script Dictionary-> Windows ->OITM… Read More »

How to Repeat Group Header on Each Page in Crystal Reports

In Sage X3, we developed one custom report for our client where the detail section continues to the next page of the report but the heading/captions did not get printed on each page as captions were placed on the group header section (please refer to screenshot below). One would think that placing the captions in… Read More »

How to solve “Transaction stopped” error while creating sales invoice in Sage X3

Sage X3 is enterprise resource planning (ERP) product which helps organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more. In sales module, sometimes an error occurs – “Transaction stopped” while creating sales invoice as… Read More »

How to create work order without routing in Sage X3

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 »