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.

Comments (4) -

  • And CompanyID must be the FIRST column in the table schema
  • Thank you very much for your valuable comment. I guarantee that it saved time for many Acumatica programmers
  • 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,
  • I'm not sure that I understand you correctly. You mean how to convert number for example 45 into 14-th of January?

Add comment