CompnayID in tables and DAC in Acumatica

Hello everybody,

today just short notice of DAC and tables. If you create new functionality in Acumatica and look for creating tables, you should know, that all tables which you'll create should have column CompnayID, and that column shouldn't be reflected in DAC.

4 Comments

• anonymous said 2 years ago

  And CompanyID must be the FIRST column in the table schema

• docotor said 2 years ago

  Thank you very much for your valuable comment. I guarantee that it saved time for many Acumatica programmers

• Dimitri Mills said 2 years ago

  Hi,
  
  In a generic query. Do you know the formula to convert days to a month? And then roll it up.
  
  Basically, I can create a daily shipment report. But I can't create a monthly report or a month to day report or report my month for the year. I can do it from the financial.period table; but can't figure out how to do it for shipments.
  
  Thanks in advance,
  
  

• docotor said 2 years ago

  I'm not sure that I understand you correctly. You mean how to convert number for example 45 into 14-th of January?