Undo Receipt in Subcontracting Production Order & Synchronise Security

Business Central/NAV Technical Forum
1

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

2

“Undo Receipt” : which error?

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

3

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

4

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 :slight_smile:

5

oooops…

i mean:

  1. release purchase order

  2. receive item via purchase order

6

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.

7

I really can recommend you to read this whitepaper document:

Security Synchronization in Navision 4.0 SP3

8

hi Erik,

thanks for your recommendation

now i can do the synchronisation

All,

any solution for my Undo Receipt in subcontracting?

thanks

9

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

10

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.