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

By | November 13, 2019

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, Purchase and Accounting modules.

Date prohibited error for the sales module
Date prohibited error for the sales module

Sales transaction:

VENSTRDAT – Sales start date: This folder parameter is used in the invoice/credit memo management, in order to prohibit the entry of invoices/credit memos having a date prior to the specified one.

When used together with the VENENDDAT – Sales end date parameter, it is used to limit the entry of invoices/credit memos to the date range defined by these two parameters.

Navigate To: All>>Setup>>General parameters>>Parameter Values

Expand TC Common Data to get to the folder level.

Parameter setup
Parameter setup

Right-click group CLO and select ‘Detail’

Change or Clear VENSTRDAT and VENENDDAT parameter field values.

Now you will be able to create sales invoice.

Accounting transaction

These two parameters, start date and end date respectively, define the duration for which accounting transaction should be active.

The parameters are as follows:

  1. CPTENDDAT – Accounting end date

This folder parameter is used to restrict accounting transactions to date beyond the specified one. The transaction should be created before the specified end date.

2. CPTSTRDAT – Accounting start date

 This folder parameter is used to limit the entry accounting transactions to the date prior to the defined start date. It means, transactions should be created with date after start date.

Parameters
Parameters

Purchasing transaction:

ACHSTRDAT – Purchase start date: This folder parameter is used in the purchase invoice management, in order to prohibit the entry of invoices having a date prior to the specified one.

ACHENDDAT – Purchase end date parameter, it is used to limit the entry of invoices to the date range defined by these two parameters.

Purchase parameter setup
Purchase parameter setup

This above parameter set up works for Sage, Purchase and Accounting module.

About Us

Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange. For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.