Author Archives: Greytrix

How to create a prepayment for a Purchase Order in Sage X3

A prepayment is a payment  that you make before you receive goods or services. Sage X3 provides a new feature i.e creating Prepayment against a Purchase Order. In purchase, prepayment is used where user/supplier may require a deposit before commencing work on an order, or the order may have to be paid in advance. In this blog, we… Read More: How to create a prepayment for a Purchase Order in… »

How to create Purchase order from Work order 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. Basically, work order uses a bill of materials (BOM)… Read More: How to create Purchase order from Work order in Sage… »

Dashboard creation using Classes & Representations

In Sage X3, there are many ways to display records of transactions, customers or suppliers data and other masters data. So, sometimes users want to see the set of records like Sales Order, Sales Invoice, Purchase Invoice and many more when they login to the Sage X3. Sage X3 allows one feature of displaying such… Read More: Dashboard creation using Classes & Representations »

Partial quantity allocated Work order display in Operation tracking plan screen

In Sage X3, we recently faced an issue where partially allocated work orders were not shown in the Operation tracking plan screen. Let’s take an example to understand the issue.The below work order has partial allocation and the Work Order was not being shown in the Operation Tracking plan screen. New Stuff: Enabling reports on… Read More: Partial quantity allocated Work order display in Operation tracking plan… »

Enabling reports on Module specific Automatic generation screens

In Sage X3, one of the client’s requirements was to get a few custom reports to be enabled in the Sales & Purchase module Automatic generation screens. For this we need to enable some options and alter settings in Sage X3 reports dictionary. New Stuff: Sales Invoice creation based on Delivery Type in Sage X3… Read More: Enabling reports on Module specific Automatic generation screens »

Sales Invoice creation based on Delivery Type in Sage X3

In Sage X3, “Document type” is a mandatory field in every transaction screen. So we need to select document type while creating any transaction. Also, “Invoice” button is available in Sales Delivery screen to create Invoice entry of that Delivery from the delivery screen. And when Invoice is created by clicking on that Invoice button… Read More: Sales Invoice creation based on Delivery Type in Sage X3 »

Sage X3 Integration with Weighing Scales

Is it possible to integrate weighing scales to ERP? Yes. In Sage X3, we have established integration with weighing scales to fulfil the client’s requirement in which we have fetched/read a weight programmatically from weighing scale machine which is connected to the user’s machine and loaded the received data in Sage X3. To achieve this… Read More: Sage X3 Integration with Weighing Scales »

Restriction on credit note creation

Sage X3, is a complete business management solution designed to drive productivity and give you total control and visibility of your enterprise. With customizable configuration, the flexible solution equips you with everything you need to drive business success and easy to understand all the modules to the end user.Recently we had a requirement from one… Read More: Restriction on credit note creation »

How to solve an error – “Automatic Journal does not allow validation”

As we all know, we need to post the Sales Invoice entry after creation in Sage X3. And after posting, Journal entry of that posted invoice is created automatically. But sometimes, an error occurs after clicking on the post button on the Sales Invoice screen because of some improper configuration settings. The invoice gets created… Read More: How to solve an error – “Automatic Journal does not… »

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: Dynamic Row-Column structure report for Quote comparison »