How to set aggregate criteria of accounting interface parameters?

Sage X3 has function where you can set the aggregate criteria of journal. Navigate to: Setup>Stock>Accounting Interface parameters If all the criteria are equal, one journal entry is created with as many lines as necessary. These lines can be aggregated by account, nature, tax code, entry title by using the automatic journal. For example: If… Read More »

How to Know the Eclipse Port Number in Sage X3 ?

The port number defines the TCP/IP port in which connection server expects connection requests from folder. For development in X3 version 7, while creating new X3 project in eclipse, we have to define following parameters: Hostname Port Folder Here, Hostname: System IP address. Port number: To be known Folder: SEED\X3 We can find out port… Read More »

How to allow text from a purchase request line to transfer into supplier order line

In Sage X3 users are allowed to add the line text while creating the purchase request, this text can be a short message related to the product or supplier .If user wants the same text in the purchase order created against that request, Sage X3 allows handling the flow of text from purchase request to… Read More »

How to add additional filter criteria to automatic shipment creation function

Standard function FUNAUTDLV (Order deliveries) is used for bulk shipment creation. There are several filter criteria’s available on this function. But, what if you want to add any additional filter criteria for the orders being passed for shipment creation? Using an Entry transaction we can easily add the additional criteria, follow the below steps for the same.… Read More »

Cash Forecast Management in Sage X3

Cash Flow Forecast Management helps to judge if the business has sufficient cash to avoid any crisis of liquidity. Cash flow acts as a bottom line of all businesses, hence it becomes essential that forecast of cash flow is calculated to make sure the business endures the monetary obstacles. Cash Flow Management in Sage X3… Read More »

eCommerce for Fashion industry

Initially, consumers used to visit stores and high street to buy apparel and accessories. In this new era shopping concept is changed and now consumers loves to shop online from their computers or mobile. The success of eCommerce can also be seen in this industry.  From small retailers to big luxury brands have now opened… Read More »

Making Bank Payments using the ACH NACHA Bank files from Sage X3

Every company has to make a series of payments to its Suppliers / Vendors. Nowadays, payments made using ACH are preferred by maximum companies because it not only saves time and money but is also easier and quicker to make payments/get paid with increased security while preventing the possibility of frauds. Many of the Sage… Read More »

How to automatically allocate the work order

Sage X3 has a feature where we can automatically allocate automated work order generated from sales order at the time of creation. To successfully implement this functionality follow below steps: Navigate to: Setup>Manufacturing>Entry transactions>Work orders>AUT (Automatic generation) Select AUT Automatic transaction. Select Automatic global () or Automatic Click on save Click on Validation button

How to assign the allocation and issue rules on product categories?

You may come across a scenario where you want to set the allocation and issue rules on product categories. Sage X3 has standard feature where you can set the allocation rule. Create the allocation and issue rules on below path. Navigate: Setup>Stock>Allocation and issue rules Assign the above created allocation rule on product category. Now… Read More »

How to avoid clashing between local variable and table column name?

In Sage X3, we may come across the situation where we may be having some variable name declared in the code file and the same variable in table. Sage X3 has special keyword to make differentiation between local variable and the table variable as there can be same name used while declaring the local variable… Read More »