Tag Archives: Sage X3

Use of MAXALLQTY parameter

In a normal business scenario, Manufacturing plays an important role as it is a key part of any business process. Manufacturing is the creation or production of goods with the help of equipment, labour, machines, tools, and chemical or biological processing or formulation. It is the essence of the secondary sector of economy. The manufacturing… Read More »

How to Solve “WMAUHSTD: Nonexistent screen” Error while opening Usage Audit table inquiry screen

Sage X3 has inquiry screens for every module in which we can audit our transactional data. For example, in the sales module we have created a number of invoices, so to check invoice data we can use the list of invoices inquiry screens of the sales module like List of invoices, invoice lines, invoice by… Read More »

Data Models In Sage Enterprise Intelligence(SEI)

Sage Enterprise Intelligence gives business users, managers and executives the   power to analyze and create business reports, dashboards and views. In this blog we will have a look on how we can design data model and views in Sage Enterprise Intelligence. In order to design report in SEI, Firstly we need to design data model… Read More »

Dynamic Row-Column structure report for Quote comparison

In Sage X3, one of the client’s requirements was to have a comparison report for Quotes made by the suppliers for the given RFQ products. This report needed to have a dynamic nature of rows-columns design for which we’ve implemented the use of cross-tab option in Crystal report. New Stuff: Weigh Bridge Integration in Sage… Read More »

Restriction on Sales Order if Advance Payment is not done

Sage X3 has a special feature of prepayment in the sales order screen which can be created against sales order. Using this feature, user can create prepayment with the order amount against sales order and then user has to create advance payment for the same amount. New stuff: Dynamic Departure time change based on Arrival… Read More »

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 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 »