Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community

Undo Receipt in Subcontracting Production Order & Synchronise Security

rated by 0 users
This post has 9 Replies | 4 Followers

Not Ranked
Posts 5
Points 85
Member since 09-07-2007
ppiglet2001 Posted: 09-07-2007 17:49

hi all

i have error message when i do "Undo Receipt" via Purchase Order for subcontracted item

also i got error message in Security-Synchronize All says then a user is not exists in SQL. in facts, the user already exists both in Navision and SQL serverl

any clue how to solve them ?

 

thank you very much

 

ppiglet

Top 50 Contributor
Male
Posts 466
Points 6,795
Member since 03-10-2006
DynamicsNAVMVP

"Undo Receipt" : which error?

 In SQL, has that user public-permissions on the DB?

IF Debugging = removing bugs from program THEN programming := putting bugs in program;
  • | Post Points: 20
Top 10 Contributor
Male
Posts 1,407
Points 46,614
Member since 06-05-2005
Moderator

Please give a detailed error message so we can help you.

Nuno Maia
  • | Post Points: 5
Not Ranked
Posts 5
Points 85
Member since 09-07-2007

the error message for undo receipt  is :

"you must not specify Prod. Order No in Purch. Rcpt Line"

 

the scenario was follow:

1. create a release production order

2. calculate subcontract & carry out action message

3. release production order

4. receive item via production order

5. undo receipt via posted purchase receipt

 

did i miss something here?

 

synchronise case:

i never did the "synchronize all" in this db since we create it last month. now the db has many users assigned to roles and a lot of transactions. i made a copy of the db and did some experiments. if i delete all users and left mine only in both nav and sql db, then the synchronize runs well. but if i add even a user both in nav and sql db, then the synchronization fails.

what should i do? when should i do the synchronization?

 

thanks :)

Not Ranked
Posts 5
Points 85
Member since 09-07-2007

oooops...

i mean:

3. release purchase order

4. receive item via purchase order

 

  • | Post Points: 5
Top 50 Contributor
Male
Posts 466
Points 6,795
Member since 03-10-2006
DynamicsNAVMVP

If you have Navision 4.00SP3 or 5.00, you can put the Security level to Standard (and not Enhanced). With this you don't need Synchronization anymore.

Synchronization has to be done everytime an object is added or something in the security is changed.

 

IF Debugging = removing bugs from program THEN programming := putting bugs in program;
Top 10 Contributor
Male
Posts 3,440
Points 106,041
Member since 10-01-1995
DynamicsNAVMVP
Moderator
SystemAdministrator

I really can recommend you to read this whitepaper document:

Security Synchronization in Navision 4.0 SP3

Best regards,
Erik P. Ernst - webmaster at dynamicsuser.net

DynamicsUser.net Admin's Blog

Not Ranked
Posts 5
Points 85
Member since 09-07-2007

 hi Erik,

thanks for your recommendation 

now i can do the synchronisation

 

All,

any solution for my Undo Receipt in subcontracting?

thanks 

Not Ranked
Male
Posts 14
Points 365
Member since 11-20-2005

From My understanding (from 3.70 upgraded to 4.02 SQL) stock NAV does not work nor has it ever to unreceive a subcontract item.

I had a developer look at  it once and there is a buch of code that needs to be changed to get it to work properly. 

I think it's nuts that it will not do this "off the shelf".  To fix your issue, you can issue credits to reverse the receiving and remove the inventory.  It is just not a clean transaction anyway you look at it and really shoul dbe address by MS.  There are also restrictions based on if any of the receipt has been applied, consumed, shipped, etc - It won't unreceive these either (out of the box).

It would really be nice to also be able to undo partial amounts of receipts (100 received, should have been 50, just revers 50 vs 100 and then receive 50).

 

Kevin

Kevin Fons Saris Cycling Group Madison, WI USA
  • | Post Points: 45
Not Ranked
Posts 5
Points 85
Member since 09-07-2007

thanks kevin

its ok if undo receipt does not work for subcontracting. i just wonder what's wrong with my transactions since i some (respond) says that it works well. my developer also do some changes to the source and it works so far .. but still dont know whats the real impact to next transactions. by the way here we're using Nav 4.0 SP3. thanks again.

 .p.

  • | Post Points: 5
Page 1 of 1 (10 items) | RSS


Copyright Dynamics User Group, 1995-2009, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.