Category Archives: Tips

How to update the pay approval on a posted purchase invoice in Sage X3

There may be situation that a user needs to change the due date or pay approval on a posted sales invoice or purchase invoices . Sage x3 provides a functionality called the Open item edit function to make the changes to the due date , pay approval as well as other characteristics for open items.… Read More »

How to process data in Put-away plan in Sage X3

Put-away Plan or  Storage Plan is a functionality to plan stock change from dock location category to another location or internal location. Sage X3 offers flexibility to manage default location for a product within site for different operations. For instance, if a product exists in multiple locations of the site and for each operations (receipts,… Read More »

How to write encode function on node.js by passing input argument from X3

Node.js files contain tasks that will be executed on certain events. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices. Node.js applications are written in JavaScript, and can be run within the Node.js runtime.Node.js files have extension “._js” STEP1: Creating Node.js… Read More »

Data flow from Purchase invoice screen to Journal entry on via AP/AR Payment Posting using Automatic Journal

In our last blog, we see how to flow date from payment screen to Journal entry using auto journal. In this, we’ll see how we can flow data from Purchase invoice to journal entry while posting payment. The “Supplier doc. no.” field present on Management tab in Purchase invoice screen for the invoice entries linked… Read More »

How to print a field once which is repeating in Sage X3 report

In Sage X3, developer has freedom to develop their own reports in Crystal reports as per their client requirement. So we have also developed one of the report in India pack report called as Vendor transaction/Ledger report. This report display all the vendor transactions for selected parameter range. In this report, there is section where… Read More »

How to solve blocking message ” The envelope must be approved before the fiscal year budget can be approved ” while submitting budget for approval

In sage x3, we have a budget envelopes which is used to plan operating or investment expenses that can extend to one or multiple fiscal years defined by the entry of the envelope’s start and end dates. It also includes the concept of  budget type, budget code and project. Budget type: The budget type determines… Read More »

How to Solve error ”Outside of validity date limit” in Journal Entries

In Sage X3, any transaction that impacts a company’s profit and loss needs to be recorded in their accounting system is called ‘Journal Entries’.         A journal entry is used to record a business transaction in the accounting records of a business. A journal entry is usually recorded in the general ledger; alternatively, it may… Read More »