Posts

Showing posts from August, 2026

After Adding user in F&O not authorized to open url in Dev mahine

Image
 Hi Viwers, Sometimes after adding the user account in system administer>> user  in F&O. User uanble to authorize the F&O url even the user is enable to telemetry not created. In such case, we can directly update objectID to the user by sql. This objectid id unique for each user across all the machines.

Show un committed records in between transaction in Sql

 select * from SALESTABLE  WITH (NOLOCK) 

Get ledger dimension from Main account with combination default dimension in ledgers

 Hi Viewers If you want to get ledger dimension based on only main account. please check below code.         RecId mainAccountRecId =  MainAccount::findByMainAccountIdAndCOA(mainaccount, LedgerChartOfAccounts::current()).RecId;         RecId defaultDimension = MainAccountLegalEntity::findByMainAccountLegalEntity(mainAccountRecId, CompanyInfo::find().RecId).DefaultDimension;         ledgerjournalTrans.LedgerDimension = LedgerDimensionFacade::serviceCreateLedgerDimension(LedgerDefaultAccountHelper::getDefaultAccountFromMainAccountIdAndCOA(mainaccount, LedgerChartOfAccounts::current()), defaultDimension);         ledgerjournalTrans.DefaultDimension = defaultDimension;