Compnayid In Tables And Dac In Acumatica

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.


  • anonymous said

    And CompanyID must be the FIRST column in the table schema

  • docotor said

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

  • Dimitri Mills said


    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

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

Add a Comment
Comments are closed