Sometime we may come under a situation where we need to restrict the purchase order if there is no purchase request. This scenario can be handled on the basis of product. We may have a condition where we need to apply this restriction only for some type of product. We can apply this restriction for… Read More: Restricting purchase order creation if there is no request/open order »
Fiscal Period is the period of time reflected in financial statements. Usually, the fiscal period is either the calendar year or a quarter. Fiscal period is also known as an accounting period. The fiscal year is the consecutive 12-month period during which a business or organization plans its budget. It does not have to be… Read More: How to do Period End procedure in Sage X3 »
There are many instances when client wants to give multiple copies of the invoices to their customers, where they must segregate multiple copies into original and duplicate. So we have given option on the report for those client where at the header part Original and Duplicate check boxes are given. So if the specific invoice… Read More: How to add checkbox in Crystal Report »
Most of the clients has requirement to export their supplier payments which are created in Sage X3 so that they can upload the exported payment information on their bank site for making the bulk payments to their suppliers. So to achieve this we have developed a utility which will helps users to export the required… Read More: Exporting Payments in Sage X3 »
In Sage X3, we know that users can create the PO order, PO receipt, PO return and PO invoice transactions against vendors/suppliers using purchase module. So in PO module, whenever user created the receipt from particular purchase order or returning some qty using purchase return screen, then Qty on hand or stock Qty got affected.… Read More: Add Pending Qty column in PO Receipt screen in Sage… »
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: How to Call an API Through POSTMAN Tool and Map… »
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: Generation of Account Code on the basis of Group, Sub-Group… »
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: How to get an Open PO Amount using inquiry screens… »
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: Calculating number of attachments in Sage X3 »
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: How to solve if new field added in inquiry screen… »
