Looking for field location in SQL: Accounts Receivable Posting Date

Hi all, 

I have recently created a script for the field "invoiceDate" that restricts how far into the future a user can enter the date for. I am wanting to apply these restrictions as well for the posting date. This should be relatively easy, except I can not find the column in SQL at all for this entry field. Could someone please tell me which table this field is under? (Highlighted below). Thanks!

Parents Reply Children
  • 0 in reply to Surya IT

    It restricts how far into the future the GL posting (accounting) date can be set, based on how current you are with closing periods.  It does NOT affect things like invoice date / order date...

  • 0 in reply to Kevin M

    I understand this is how the setting is supposed to work. However, even after restricting the date and using an account that does not have role settings to override, the most "restriction" we can get is a message that says the date is in the future. We can simply click ok through theses screens and continue posting. The only thing that the setting does for us is required users to enter a valid accounting date when prompted the first time entering a module.

  • 0 in reply to Surya IT

    The only time I have ever been restricted on that screen is if I am trying to post to a PRIOR period. Are you restricted on your system on the screen I posted? From what I have gathered, I have not been able to find another person/company who this works for.