You do not have permission to read the Base Calendar Change

imurphy

I'm fairly new to Nav and I've hit a problem setting up a db.

When I enter purchase/order processing/invoices and try to add a line to an invoice of type G/L Account I get an error message 'You do not have permission to read the Base Calendar Change table'.

Now I am doing this with the administrator account, which has the Super and Super(data) roles assigned to it. We use windows login to the SQL db.

This only occurs if I use the clients key, if I use ours (a partner/designer key) it works fine.

As I said, I'm new to this and its probably something obvious, but I've been struggling with this all day now and not gotten anywhere. Any pointers would be appreciated.

Ian Murphy

Captain_DX4

I believe you've answered your own question in your post...

imurphy wrote:

This only occurs if I use the clients key, if I use ours (a partner/designer key) it works fine.

If a client hasn't purchased certain granules, they may not have access when you use their license. And there is no way around that except determining which dependancies are required and getting the necessary granule put into the client license.

Cheers,

imurphy

Thanks for the quick reply. I found some info in the archives on partnersource which indicated that it could be related to the fact that the db was based on a demo db and a table contains data when it should be empty.

I assumed it was the base calendar table so I've been trying to work out how it is used but you can neither empty it nor do I see how it is used. It seems a bit odd.

Any pointers on working out which granule is missing? Having never done this I'm not even sure where to start. Are there any online docs on the subject?

The licence was configured by an MS Partner (which is to say the granules needed were specified by them) who are running a Navision program here. We hare used a template database supplied by them as the basis for this client.

The client is pretty straight forward. For the moment we are just getting billing, accounts and items up and running to get the base data into the system. Customisation is a way off yet so the client shouldn't need anything much licence-wise.

imurphy

Can anyone post a list of granules used in a license for a basic client?
- billing + accounts, little more.

Our client has the Business Essentials edition. This is the list of granules we have installed. The license is in spanish so the names are translated,

Ian

310 BRL Business Essentials Foundation Pack            1
           410 BRL Business Essentials Full Access Users          7
         1,010 Foundation Layer                                   1
         1,100 Empresas                                           2
         1,140 Empresas - ilimitadas                              1
         1,150 Subsidiary / each                                  1
         1,200 Sesiones                                           1
         1,400 Usuarios - IDs y contraseñas                       1
         1,410 Perfiles y control usuarios                        1
         1,520 Servidor - Windows NT (Intel)                      1
         1,700 C/ODBC                                             1
         1,750 C/OCX                                              1
         1,800 C/FRONT                                            1
         2,010 Server - Microsoft SQL Server Option               1
         2,020 Per Database license                               1
         2,030 Microsoft SQL Server Desktop Engine                1
         2,110 Navision Version 3.xx                              1
         2,120 Navision Version 4.0                               1
         2,130 Navision Version 5.0                               1
         3,010 Contabilidad         - Módulo base                 1
         3,020 Contabilidad         - Distribución dimension      1
         3,030 Contabilidad         - Presupuestos                1
         3,040 Contabilidad         - Esquemas cuentas            1
         3,050 Contabilidad         - Consolidación               1
         3,070 General Ledger       - Basic XBRL                  1
         3,080 General Ledger       - Change Log                  1
         3,260 Ventas y cobros      - Módulo base                 1
         3,270 Ventas y cobros      - Facturación ventas          1
         3,280 Ventas y cobros      - Gestión pedidos ventas      1
         3,290 Ventas y cobros      - Dto. factura ventas         1
         3,310 Ventas y cobros      - Direcciones envío           1
         3,340 Sales & Receivables  - Shipping Agents             1
         3,370 Sales & Receivables  - Sales Line Discount         1
         3,380 Sales & Receivables  - Sales Line Pricing          1
         3,410 Sales Tax                                          1
         3,510 Compras y pagos      - Módulo base                 1
         3,520 Compras y pagos      - Facturación compras         1
         3,530 Compras y pagos      - Gestión pedidos compra      1
         3,540 Compras y pagos      - Dto. factura compra         1
         3,550 Compras y pagos      - Gestión demanda             1
         3,560 Compras y pagos      - Direcciones pedido alt      1
         3,580 Purchases & Payables - Purchase Line Discount      1
         3,590 Purchases & Payables - Purchase Line Pricing       1
         3,760 Aplicación general   - Múltiples divisas           1
         3,770 Compras y pagos      - Envíos directos             1
         3,780 Aplicación general   - Vendedores/compradores      1
         3,790 Aplicación general   - Intrastat                   1
         3,800 Aplicación general   - Textos adicionales          1
         3,810 Job Queue (ver 5.0 or later only)                  1
         4,010 Existencias          - Módulo base                 1
         4,020 Existencias          - Múltiples idiomas           1
         4,040 Existencias          - Almacenes múltiples         1
         4,045 Inventory            - Stockkeeping Units          1
         4,050 Existencias          - Proveedores alternativ      1
         4,060 Existencias          - Lista de materiales         1
         4,100 Inventory            - Location Transfers          1
         4,120 Inventory            - Item Cross References       1
         4,140 Inventory            - Item Tracking               1
         4,150 Inventory            - Item Charge                 1
         4,170 Inventory - Bin                                    1
         4,230 Inventory - Analysis Reports                       1
         4,240 Inventory - Item Budgets                           1
         4,260 Recursos             - Módulo base                 1
         4,270 Recursos             - Gestión capacidad           1
         4,290 Recursos             - Precios múltiples cost      1
         4,510 Proyectos            - Módulo base                 1
         4,540 Jobs Suite - Promotion                             1
         4,760 General              - Departamentos y progra      1
         4,770 General              - Códigos auditoría           1
         4,780 Application Wide     - Advanced Dimensions         1
         5,010 Gestión tesorería    - Módulo base                 1
         5,020 Gestión tesorería    - Confección cheques          1
         5,030 Gestión tesorería    - Conciliación bancos         1
         5,110 Gestión relaciones   - Gestión contactos           1
         5,150 Gestión relaciones   - Gestión tareas              1
         5,190 Outlook Client Intergration                        1
         5,195 Outlook Client Intergration                        1
         5,260 Activos fijos        - Módulo base                 1
         5,760 Recursos humanos     - Módulo base                 1
         7,110 Diseño informes y transferencias                   1
         7,120 Diseño formularios                                 1
         8,600 Objeto aplicación    - Funciones      (100)        1
        10,720 ES Local Granule Package                           1
        98,050 MSSQL Srv 2005 Standard Runtime Edition (Spai      1
     7,000,011 Cartera de Cobros                                  1
     7,000,012 Cartera de Pagos                                   1
    99,004,710 Euro Conversion Tool                               1

Captain_DX4

I have no clue which granules are dependant on what. I've never been good at figuring out that information. *hehe* Talk to you solution centre.

imurphy

Thanks in any case. We've already passed it back to MS.... lets see what they say.

Ian

Captain_DX4

Great. Keep me updated with the outcome on that one, if you please!

Cheers,

ar4ijs

You may find this useful:
http://www.mibuso.com/dlinfo.asp?FileID=336

Captain_DX4

ar4ijs wrote:

You may find this useful:
http://www.mibuso.com/dlinfo.asp?FileID=336

Sweet! That's going in the toolbox right now!

Ta!

imurphy

Thanks for that - I'll give it a go today.

awarn

This is an old thread but it helped me so I'll share. We had this same error in the same place with a new customer DB. Turns out that we have a 'Master Setup' db that we use for countries, zip codes etc and we used that to start the customer's new DB.
Well, in that DB we had filled in data in the Base Calendar Change table. NAV threw this error when reading the table - seems like it was allowed to read it, but threw the error when it saw it contained data.
Solution is to run the table using a dev license and clear out the records. Or, do this from SQL, for every different company. And, make sure your 'Master Setup' company doesn't contain too much data.