Are there any UK users of AX 2012 who would be prepared to share the way they use AX 2012 for the goods receipting/cancelling purchase order processes please? We experience several issues with these processes and wondered if any other users do also.
Could you describe the issues?
One example is as follows;
Ordered 10 units at £2 each raised on a single line (£20). Goods receipted 10 units on that line. Invoice received and paid for 4 units only (£8). Accounting double entries raised at this stage are;
Entries created at receipted stage;
Debit - expenditure account £20
Credit - grn account £20
Entries created at invoice paid stage;
Debit - grn account £20
Credit - expenditure account £20
Debit - expenditure account £8
Credit - creditors control account £8
Cancellation is now required for the remaining 6 units.
We have tried the following method:
Pressing the ‘cancel’ button which doesn’t work, a new fix has been installed to cancel these entries which changes the purchase order to ‘invoiced’ status but this creates incorrect accounting entries in the grn account and the expenditure account as follows;
Further entries created during attempted cancellation;
Debit - grn account £12
Credit - expenditure account £12
We think the grn account is incorrectly overstated by £12 from this example and the expenditure account is overstated by £12.
Do you have any advice on this scenario please? Thanks
Do you know which CU you are on?
Do you know if the “fix” was a partner written fix or a Microsoft one?
Have you tried a negative receipt for the 6? You cannot cancel the receipt as 10 were received.
The 20 at invoice worries me I will have a look on a CU3 version when I get a chance.
Do you have any customizations/Modifications in your system in this area?
Hi Karen
I am guessing it is to do with your processing and the definition of the “Total Product Receipt Matched” which I am guessing you are not changing and you must.
If I process this you can see the transactions only relate to the $8 (CEU is in $)
Then if I look at the line I can see an invoice remainder
At this stage with a full receipt and a part invoice you cannot do a negative receipt as in previous versions. However you can go to correct and stock update the receipt to 4 which will reverse 6 and set the deliver remainder to 6 which you can then cancel. The correction posts the correct ledger updates as you can see as well:
Hope this helps
Hi, Many thanks for you reply - I will look into your suggestions and advise.
Go to the purchase order and the receipt. In the top bar there is a “correct” option. If you select this it will show you that the received quantity was 10. In fact you received 6, so you update this figure to 6 and it will update the purchase receipt and purchase order. The purchase order will then have 4 remaining on order which you need to deliver remainder to cancel. You cannot reverse/cancel the receipt at this stage because there have been 6 invoiced, so you must use the “correct” option to alter what was actually received.
Many thanks for this. This is what we did I just wanted to double check.
The end of this process works for you but not me. I will raise my issue with the technicians.
Thanks
Hi Karen
The end of the process is where we “correct” the receipt - you are saying this either does not work or posts and does not produce the financial entry? I am more worried if you have 6 in stock, 0 on order and 4 stuck in GRNI financially. I was testing this on AX2012 CU3 for your reference.
The last entry which should be for £12 - is for the full receipt plus the £12. So it has double counted.
I am using the following AX2012 application version 6.0.947.280 - do you believe this is the difference between our outcomes? I’m sorry but I don’t know what the CU3 means. Thanks again.
You are on CU2.
http://blogs.msdn.com/b/axsupport/archive/2012/03/29/overview-of-ax-build-numbers.aspx
I would say that we have a difference in our outcome as my process cleared GRNI and yours did not.
Talk to your partner and ask them to confirm that this is resolved in CU3.
This would seem to make sense and thanks for the URL.
I appreciate your assistance 