Tag Archives: Restriction

Total Amount restriction on Purchase Invoice creation in case of PO

In Sage X3, we can create Purchase Invoice transaction against Purchase Order as well as Purchase Receipt with any quantity and amount. But one of our client requested to add limit on the amount while creating Purchase Invoice against Purchase Order only. Customization Required: Invoice can be booked only against PO. Unless amount is lesser… Read More: Total Amount restriction on Purchase Invoice creation in case of… »

Tracking Validation to check proportion of raw material has been tracked or not

During the Production tracking process in Sage X3, it has been identified that there is a need for validation to ensure that the minimum corresponding amount of raw material has been tracked or consumed prior to initiating Production tracking for a specific work order. To tackle this issue effectively, we plan to customize the Production… Read More: Tracking Validation to check proportion of raw material has been… »

Validation on Company name and GST number fields

Sage X3, formerly known as Sage Business Cloud Enterprise Management, is an ERP software suite that includes integrated functionality for financial management, sales, customer service, distribution, inventory, manufacturing, and business intelligence. Recently we had a requirement in Sage X3 from one of our client, that the Customer Name(Company Name field in the Customer Master) and… Read More: Validation on Company name and GST number fields »

Tracking Restriction and Creation on the basis of Stock Availability

As we know, Production Tracking is created against Work Order in Sage X3. But if stock of raw materials/components is not available then creation of Tracking should be restricted. Usually this type of customizations are done to restrict Tracking creation. But here in this customization we have added one more condition to handle partial Tracking… Read More: Tracking Restriction and Creation on the basis of Stock Availability »

Higher Price Restriction on Purchase Order

In Purchase Order, the user can enter the price manually in Lines for any product in Sage X3. But sometimes we use price lists to declare the prices of the products for particular suppliers in the Purchase module. Those price list prices will be valid for the mentioned date range. By using this feature, client… Read More: Higher Price Restriction on Purchase Order »

Restriction when Requirement quantity is not equal to Quantity tracked

In Sage X3, Recently we had a requirement from one of our client, Requirement Quantity on the work order screen should be equal to the “Quantity tracked” on the production tracking screen then only the system will allow the user to create the Production tracking or else it will generate a pop-up and will restrict… Read More: Restriction when Requirement quantity is not equal to Quantity tracked »

Delivery Tolerance Functionality

As per the standard functionality of Sage X3, we can create Sales Delivery against Sales Order with the same quantity or more than the ordered quantity only if the stock of that particular product is available in the system. But one of our client wanted to have validation on delivered quantity on the basis of… Read More: Delivery Tolerance Functionality »

Restriction on Sales Order if date exceeds the defined due date

Due date is defined in every Sales/Purchase transaction in Sage X3 on the basis of Payment terms and Payment terms is a mandatory field in every transaction. One of our client requested to restrict Sales Order transaction on the basis of due date. Number of days beyond which if payment of posted Sales Invoice is… Read More: Restriction on Sales Order if date exceeds the defined due… »

Validation on Gross/Net Price and Qty fields in Sales/Purchase Invoice Transactions

As we all know, while creating any transaction in Sage X3, we can enter quantity and price manually in detail line as per the requirement. But one of our client wanted to restrict the creation of the Sales/Purchase Invoice Transactions if the user is trying to enter ‘0’ in Gross/Net Price and Quantity fields. Even… Read More: Validation on Gross/Net Price and Qty fields in Sales/Purchase Invoice… »

Restriction on Purchase/Sales transactions on the basis of PAN No

In Sage X3, we have a standard “PAN No” field in the Customer and Supplier master. One of our client requested to add one field i.e. “(Total) Invoice Amount” in the header level of Sales Invoice, Sales Order, Purchase Order and Purchase Invoice transaction screens which will reflect the total amount booked for the respective… Read More: Restriction on Purchase/Sales transactions on the basis of PAN No »