Browse By Tags

  • Make Date Read Only if not null

    I have this datetime field that i am trying to make read only once its populated, but i cant seem to validate if its 'blank' or not. Here is my latest attempt. Thanks! if (Values('oppo_proposalduedate') === '12:00:00 AM') { readonly = false; } else…
  • Problem with changing program date after archiving old period

    We've just archived an accounting period and are starting into a new one. When I set the program date to the start of the financial year, its posting transactions on the date entered, not the date from the start of the year. This is throwing out all my…
  • Vat return

    I have found a number of supplier invoices & payment from the previous accountant that have not been posted to supplier accounts. I want to post them now to reconcile the accounts & reclaim the vat. I also want to post everything on the correct date.…
  • Utiliser date calculée dans recherche rapide

    Bonjour Comment faire pour filtrer mes factures avec une recherche enregistrée utilisant une date calculée. Exemple : je veux voir toutes les factures dont la date d'échéance est dépassée de 7 jours. Une idée ? Une solution ? Merci d'avance …
  • Yesterdays date is NOT 28th Nov.

    We log out of Sage every day, today I wanted to check all accounts were synced but all transactions I processed yesterday (29/11/2023) are showing as 28/11/2023! Is this just a glitch in the matrix that will rectify itself during the course of today…
  • Default Dates

    When we open up any date generated list (Suppliers / Customers / Activity / Communication etc) the default date range that appears in 01/01/1980 - 31/12/2099. For some of our older and more active accounts this results in a huge amount of data being returned…
  • Update the expected receipt dates of purchase order lines when updating shipment dates of intersite/intercompany sales order lines

    The expected receipt dates of purchase order lines are not updated when updating shipment dates of inter-sites/companies sales order lines : Would it be possible to suggest the update of expected receipt dates of the purchase order lines when recording…
  • Document Date and Posting date

    When I have used Sage Previously there has only been a single Date Field which caused problems when months old invoices finally found their way to accounts. You were faced with a choice of entering the Date incorrectly, technically a big no no with VAT…
  • Company Start Date

    I would like to change the Company start date from March to May how do I do this? Thank you
  • Date Customer Last Purchased

    Hi Guys I am looking for a field within sage that gives a date that the customer last made a purchase. The only date I found which was similar was LastActivityDate but this can be triggered by lots of different things. Do you guys know if this exists…
  • Reabertura Exercício

    Tenho o exercício 2021 encerrado e precisava reabrir para efetuar retificações mas surge o erro Run-time 32014 Specified Date is Invalid. Podem indicar como ultrapassar? Obrigado
  • Purchase Order Date defaults to todays date

    Good day. ORDDAT on Purchase Order Screen POH0 set to "entered" Purchase Orders are being pushed from Purchase Requests This Purchase Order defaults to the current date upon creation via the Purchase Request Screen and does not allow the user…
  • Workflow Rule - Operations

    Good afternoon Folks Does anyone have a good guide to what the operations all mean? I'm trying to have this send 30 days before the date in the field, but I dont think create or modify will work for an even like this.
  • Unable print _Manual check and payment register_databace connector error

    Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!
  • Sale Order -Delivery Date

    Hi Guys, I need some help! I'm trying to create a sale order in sage which has different delivery dates to it. I'm trying to add the different due dates in the ' sales order status' section but I can't do it. Does anyone know if this is possible?…
  • sage crashes when I change dates

    Hi, My sage is crashing at least once a day when I change dates (inputting invoices for the next day or recording customer receipts). It works fine and then suddenly it decides it doesn't like this task anymore, so it crashes. Has anyone else had…
  • Administration Syracuse > Paramètres > Paramètres généraux > Modifier la date limite haute de conversion

    Bonjour, En standard dans l'administration Syracuse > fonction Paramètres généraux > la date l imite haute de conversion d'une date à 2 chiffres vers une date à 4 chiffres est 2029. Serait-il possible qu'en standard cette date soit plus éloignée, comme…
  • Setting or Updating Date Fields using a Table Level Script

    This little tip shows how you can use a Table Level Script to set a value for a field that is not displayed on the screen. In my example a customer needed to implement a business rule that when a user updates the company field 'Type' to be a Customer…
  • Working around Date/Time field issues in Web to Lead forms

    The feature 'Web to Lead' in Sage CRM enables you to create web pages for collecting lead information automatically. The process generates the HTML to define a web form page for entering lead details. This HTML page can be inserted into a corporate website…
  • Date input on custom screen

    Hi, How to add a date input with a calendar button in a custom screen using .NET API for generating report? Thanks.
  • System Date is off by exactly 1 month

    When I close a case, the Closed Date field updates automatically. However, it is the wrong date. In the database, it is the Case_Closed field, which is a date/time field. It shows 2014-11-02 13:48:00.000 when it should show 2014-12-02 13:48:00.000.…
  • Jscript on date only field

    Hi All, Hoping someone can help me, a bit rusty on my java I have a custom field comp_c_enddate , this field is set as date only The default value for this field sets it at current date plus 1 year but what i need to do is onchange event of this field…
  • Customer Crystal Report Date Parameter Wrong on 1/4 computer

    I have a custom Crystal Report that I created and when entering the same date parameter on 4 computers, one will show the wrong information. Example: 09/01/2019 - 09/20/2019 (September 1, 2019 - September 20, 2019) 3 computers bring up the same correct…
  • Is it possible to calculate the number of days between two fields using the graphical query?

    A client has requested a new query, specifically looking at outbound deliveries. I have created a query that shows all deliveries with a departure date, and the arrival date (for this client, any delivery with a blank arrival date will trigger an action…