Tag Archives: sales invoices

Guide to add SQL Query in Sage Enterprise Intelligence (SEI)

If you need to retrieve data based on a more complex query than just selecting the field from a single table, you will need this feature. The SQL Query can be as much complicated as the database provider can support. This means that you could join tables, do summarization and grouping without any issues. Follow… Read More »

How to solve ‘Accounting destination’ error while creating payments in Sage X3

Payment is the transfer of money or goods and services in exchange for a product or service. A payment can be made in the form of cash, check, credit card and debit card. Payments can be done against invoices that are generated from Sales/Purchase Invoice and Customer/Supplier BP invoice from the AP-AR accounting module. Payments… Read More »

How to enable serial number field in sales invoice screen in Sage X3

A sales invoice is an accounting document that records a business transaction. Sales invoices provide the business with a record of the services they’ve provided to a client, when the services were rendered and how much money the client owes the business. Typically, a sales invoice will include a description of the service provided, the… Read More »

How to solve ‘Non-existent Account’ error while posting Sales invoice

A sales invoice is an accounting document that records a business transaction. Sales invoices provide the business with a record of the services they’ve provided to a customer. When you post an invoice or credit note, the value of each invoice line posts to the nominal account specified for the item. But sometimes we get error while posting sales invoice due… Read More »

How to overcome ‘Date prohibited ‘error in sales, purchase and accounting module

In Sage X3 we can control transaction creation by specifying the duration for which creation should be allowed. In order to prohibit the entry of invoices/credit memos Sage X3 provide a parameter level control where we can specify the duration for which sales transaction should be active these parameter set up is available for Sales,… Read More »

How to use ‘Invoicing methods’ for Customer invoicing in Sage Enterprise Management

Sage ERP X3 provides us with a feature to setup different invoicing methods. These methods are subsequently used for issuing invoices to customers. E.g. An instance where we want to raise a weekly invoice for a customer i.e. invoicing for all the deliveries to the customer in a week, how we can effectively use the… Read More »