Solved

Default Sales Order Request Date field to two weeks after document date based on conditions

  • 12 July 2023
  • 1 reply
  • 81 views

Userlevel 1
Badge

Hello, team - I’m trying to create a customization for one of our branches.  They would like all new Sales Orders of Type = “QT” to have the Requested On date be the OrderDate + 14.  This would only be relevant to Branch 05 in our system. 

 

I’ve attempted to put a formula in the Requested Date Default field.  I’m aware that this doesn’t identify any branch conditions, but figured I’d give it a try anyway.

=[OrderDate]+IIf( [OrderType]='QT', 14, 0)

However, this only resulted in an error, so my guess is that it’s the wrong way of going about it.  Any thoughts?  Thanks!

icon

Best answer by dcomerford 12 July 2023, 22:16

View original

1 reply

Userlevel 7
Badge +12

You will need a development resource to do this for you. It is a fairly straight forward customisation but it will need some code/

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved