Sunday, July 19, 2015

Pages that needs to be configured in order to configure a new company

You need to configure the below pages in order to configure a new company
Steps for setting up a new company
  1. Create new company
  2. Company information
  3. Accounting periods
  4. No. Series
  5. Chart of accounts
  6. Dimensions
  7. G/L Setup
  8. Sales & receivables setup
  9. Purchases & payables setup
  10. Inventory setup
  11. Customer posting group
  12. Bank posting group
  13. Vendor posting group
  14. Inventory posting group
  15. Gen. bus. Posting group
  16. Gen. prod. posting group
  17. Location
  18. Gen posting setup
  19. Inventory posting setup
  20. VAT posting setup
  21. Currency
  22. Vendor
  23. Customer
  24. Item

Friday, July 17, 2015

Summation of a field in report with groups:

Summation of a field in report with groups:
write code in Report Properties:
Shared Total as Decimal

Public Function SetTotal(ByVal Value as Decimal)
Total+=Value
End Function

Public Function GetTotal
Return Total
End Function
And then call GetTotal Function in respective table box(in report) where you want to get the Total
Code.GetTotal
And then in report , data for which you need total to be calculated. In that text box, call SetTotal function

=Fields!BudValue.Value+Code.SetTotal(Fields!BudValue.Value)

Method 'Page256.a60Action46a62_a45_OnAction' not found.

Microsoft Dynamics NAV
---------------------------

Method 'Page256.a60Action46a62_a45_OnAction' not found.
---------------------------
OK
---------------------------



This error occurs when the RTC runs on rapid start implementation profile.

Solution:

Change the profile to sales order processor Profile.. profile ID 9006.

Thursday, July 16, 2015

error: the record has been locked in the table

error: the record has been locked in the so called table

reason: due to background posting of the said record or cancellation in between or parallel usage of the same record might get it locked.

Solution: restart the service and try again. This will stop all the process  and will enable you to unlock the locked record in the said table.

Wednesday, July 15, 2015

Error : TableData 2000000001 does not exist

Solution : This Error Occurs when DBOwner permission is not given to the  concerned login id in the SQL server to the concerned database.