We come across the scenario, where we will use POSTMAN software tool to examine the working of external API. Postman is a simple GUI for sending HTTP requests and viewing responses. REST services are available in Sage x3 which returns data in a JSON format. In this blog, we are going to visualize the mapping… Read More »
In Sage X3, using auto numbering feature we can generate document numbers for most of the transaction and masters like Purchase or Sales document numbers or Customer or Supplier numbers etc. But there is no provision to generate account code automatically so we did an add-on customization where Account code gets generated automatically on the… Read More »
At first, we will see, what is an Open PO Amount? After creating GRN/Receipt against Purchase Order, remaining amount of PO i.e. (Total PO Amount including Tax – Total Receipt/GRN Amount including tax) is the Open PO Amount. That means Open PO Amount will be calculated until that PO is open. If PO is closed,… Read More »
As we know, using attachment featured In Sage X3, user can attach various documents/files against any masters or transactions screen. With this feature users can attach file types like word document, Image, Text, PDF and Excel etc. The attached documents can be the reference/source documents of that particular entry. This helps all the users to… Read More »
As we all know, generally after adding fields in screens, we globally validate window of that screen and we are able to see the new added field in that screen. But in inquiry screens, it is little different. In this we will see how we add new field in inquiry screen and how we can… Read More »
As we all know sage x3 uses dimensional accounting which helps to improve and simplify the reporting. There may be a case where dimensions should not be used in combination with another dimension. Restriction codes can be configured to prevent such cases. We have seen how to configure restriction code and setup Account/Dimension restriction code… Read More »
Purchase return is normally a part of business. In which, goods are returned to the supplier if they had any defects or not according to the specifications of the buyer. In Sage X3, while creating Purchase Return we may come across an error like ‘The quantity to be returned exceeds the maximum authorized: 0 UN’.… Read More »
There is functionality in Sage X3 where we can hold stock reservations for each customer based on each site. This functionality is located in sales module. Navigate: SALES -> ALLOCATION -> CUSTOMER ALLOCATION. As shown in the above screenshot, there is also an ‘END DATE’ field which notifies that the customer allocation can be done… Read More »
As we all know sage x3 uses dimensional accounting which helps to improve and simplify the reporting. There may be cases where a specific dimension is restricted for specific account although the dimension type is allowed on the GL account. To prevent such cases Restriction codes can be configured. First we will check how to… Read More »
Sometime we may come under a situation where we have to close the sales order through code. Keyword DIVSOHCLE is used to close the sales order record. For example: Below is a sales order which we have to close through our code. Fig1: Sales order record Use the keyword as… Read More »
