Category Archives: Integration

How to solve “No Current record” error while posting the Purchase Invoice

Recently there was an issue while posting the purchase invoice in Sage X3, where system was giving a pop up message “No current record found“. All the taxes and other configuration were right still while positing any purchase invoice, it was giving an error as shown in the below screenshot. New Stuff: Formatting of text… Read More »

Formatting of text using HTML tags for Sage X3 Reports

In Sage X3, every company/site/supplier/customer have their addresses that we fetch from the respective screens to Standard or Custom reports. Normally we create a formula in Crystal Report for address with the required fields and place that formula wherever required. This can be also achieved by using HTML tags in formula. Using this method can… Read More »

Formula based Material Issue

This “Formula based material issue” concept will be mostly useful in Pharmaceutical Industries, as these type of industries produce medicines. In manufacturing process, drugs will be considered as Raw Material to produce one particular tablet/ medicine. For this, quantity of required drugs should be correctly calculated. By using this formula based concept we will be… Read More »

How to flow custom fields from Customer master to Sales order screen

In Sage X3, in customer master user have provision to define multiple addresses with different address codes. So one of our client has requested to add some custom fields on address tab of customer master. And flow it to the Sales order depending on the address code selection on Sales order screen Suppose user wants… Read More »

Purchase Receipt quantity not flowing to Purchase Invoice screen in Sage X3

In Sage X3, we faced an issue for the Quantity not getting flown from Purchase Receipt to Purchase Invoice screen on the selection from the left list. As per the standard process, we create a Purchase order, and further we create a Purchase receipt using the same Purchase Order. Further, while creating the Purchase Invoice… Read More »

How to add Comment Text from transaction screen to the Crystal Report

In Sage X3, user have an option to add comment against every transaction screen on right panel after attachment symbol. In this comment field user can enter an additional information as per the requirements for e.g. description, terms & conditions, declaration, note etc. This comment field is considered as a header comment field which is… Read More »