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: Automatic deallocation function in Sage X3 »

Revised cost calculation in Sage X3

A revised standard cost is usually created in order to prepare for an upcoming new standard cost following the revaluation of a material, an hourly rate, etc. Revised standard costs for the same product and site are retained and can be viewed. A revised standard cost calculation can be associated with an accounting interface, which… Read More: Revised cost calculation in Sage X3 »

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: Working of customer extension in Sage X3 »

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: Product Code and Description Automation »

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 Repeat Group Header on Each Page in Crystal… »

How to export a file outside the SAGE folder in the X3 server

You may come across a scenario where you want to export a file in the sage x3 server itself but in this scenario sage x3 allows you to only export the file in the SAGE folder of D drive, if you wish to export it in different path (Outside Sage folder) or in a different… Read More: How to export a file outside the SAGE folder in… »

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 solve “Transaction stopped” error while creating sales invoice… »

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: How to create work order without routing in Sage X3 »

How to restrict user for accessing certain modules & sub-modules in Sage X3

All users play a very critical role in Sage X3, also it has a feature where we can set a permissions and access to a particular user, so that there is no mishandling of information. The need to restrict users to access ERP Modules can be based on the employees’ role and their department. User… Read More: How to restrict user for accessing certain modules & sub-modules… »