{"id":19078,"date":"2019-11-13T07:12:26","date_gmt":"2019-11-13T07:12:26","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=19078"},"modified":"2019-11-13T07:12:28","modified_gmt":"2019-11-13T07:12:28","slug":"how-to-overcome-date-prohibited-error-in-sales-purchase-and-accounting-module","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2019\/11\/13\/how-to-overcome-date-prohibited-error-in-sales-purchase-and-accounting-module\/","title":{"rendered":"How to overcome \u2018Date prohibited \u2018error in sales, purchase and accounting module"},"content":{"rendered":"\n

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.<\/p>\n\n\n\n

\"Date
Date prohibited error for the sales module<\/strong><\/figcaption><\/figure>\n\n\n\n

Sales transaction:<\/strong><\/p>\n\n\n\n

VENSTRDAT – Sales start date: This folder parameter is used\nin the invoice\/credit memo management, in order to prohibit the entry of\ninvoices\/credit memos having a date prior to the specified one.<\/p>\n\n\n\n

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. <\/p>\n\n\n\n

Navigate To<\/strong>:\nAll>>Setup>>General parameters>>Parameter Values<\/p>\n\n\n\n

Expand TC Common Data to get to the folder level.<\/p>\n\n\n\n

\"Parameter
Parameter setup<\/strong><\/figcaption><\/figure>\n\n\n\n

Right-click group CLO and select ‘Detail’<\/p>\n\n\n\n

Change or Clear VENSTRDAT and VENENDDAT parameter field\nvalues.<\/p>\n\n\n\n

Now you will be able to create sales invoice.<\/p>\n\n\n\n

Accounting transaction<\/strong><\/p>\n\n\n\n

These two parameters, start date and end date respectively,\ndefine the duration for which accounting transaction should be active.<\/p>\n\n\n\n

The parameters are as follows:<\/p>\n\n\n\n

  1. CPTENDDAT – Accounting end date <\/li><\/ol>\n\n\n\n

    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.<\/p>\n\n\n\n

    2. CPTSTRDAT – Accounting start date<\/p>\n\n\n\n

     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.<\/p>\n\n\n\n

    \"Parameters\"
    Parameters<\/strong><\/figcaption><\/figure>\n\n\n\n

    Purchasing transaction:<\/strong><\/p>\n\n\n\n

    ACHSTRDAT – Purchase start date: This folder parameter\nis used in the purchase invoice management, in order to prohibit the entry of\ninvoices having a date prior to the specified one.<\/p>\n\n\n\n

    ACHENDDAT – Purchase end date parameter, it is used to limit the entry of invoices to the date range defined by these two parameters.<\/p>\n\n\n\n

    \"Purchase
    Purchase parameter setup<\/strong><\/figcaption><\/figure>\n\n\n\n

    This above parameter set up works for Sage, Purchase and Accounting module.<\/p>\n\n\n\n

    About Us<\/strong><\/p>\n\n\n\n

    Greytrix<\/a> – a globally recognized Premier Sage\nGold Development Partner is a one-stop solution provider for Sage ERP and Sage\nCRM needs. Being recognized and rewarded for multi-man years of experience, we\nbring complete end-to-end assistance for your technical consultations, product\ncustomizations, data migration, system integrations, third-party add-on\ndevelopment and implementation expertise.<\/p>\n\n\n\n

    Greytrix<\/a> caters to a wide range of Sage X3 (Sage Enterprise\nManagement) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRM<\/a>, Salesforce.com<\/a> and Magento eCommerce<\/a> along\nwith Implementation and Technical Support worldwide for Sage X3<\/a> (Sage\nEnterprise Management). Currently we are Sage\nX3 Implementation Partner<\/a> in East Africa,\nMiddles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services<\/a>, integrated\napplications such as POS<\/a> | WMS<\/a> | Payment Gateway<\/a> | Shipping System<\/a> | Business Intelligence<\/a> | eCommerce<\/a> and\nhave developed add-ons such as Catch \u2013 Weight <\/a> and\nLetter of Credit<\/a> for\nSage X3 to Sage business partners, end users and Sage PSG worldwide.<\/p>\n\n\n\n

    Greytrix is a recognized Sage Rockstar ISV Partner<\/a>\nfor GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace<\/a>; GUMU™ integration for Sage X3 – Salesforce is a 5-star app\nlisted on Salesforce AppExchange<\/a>. \n\nFor more information on\nSage X3 Integration and Services, please contact us at x3@greytrix.com<\/a>. We will be glad to assist\nyou.\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"

    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,\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5,1],"tags":[31,504,1562,1564,1977,1981],"class_list":["post-19078","post","type-post","status-publish","format-standard","hentry","category-faq","category-features","category-uncategorized","tag-accounting","tag-date","tag-purchase","tag-purchase-invoice","tag-sales","tag-sales-invoices"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/19078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=19078"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/19078\/revisions"}],"predecessor-version":[{"id":19086,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/19078\/revisions\/19086"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=19078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=19078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=19078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}