Automatic Allocation Problem when posting Purchase Packing Slip. AX 2012 R3 CU8

(0) Share

Report

Posted on by Ghetz

2,987

We have setup some automatic allocation terms setup for some Accounts.

Basically we follow the instructions described in http://www.bdosolutions.com/ca/insights/using-automatic-allocations-in-microsoft-dynamics-ax-2012/

When posting Sales Documents, the automatic allocation works perfectly, and the Amounts are correctly assigned to the Accounts configured.

However, when posting Purchase Packing Slips or Invoices, the automatic allocation is not working. Any ideas? Could someone try if it's working in their environment?

Thanks!

*This post is locked for comments

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

RE: Automatic Allocation Problem when posting Purchase Packing Slip. AX 2012 R3 CU8

Hi ,

I am getting the same issue,did you able to find the solution.can you please let me know about this
Community Member on at

Like (0)

Report

RE: Automatic Allocation Problem when posting Purchase Packing Slip. AX 2012 R3 CU8

Hi Ghetz,

Did you find a solution on this?

Your debugging eased my mind because all of a sudden ledger allocation terms did not work on my purchase-related accounts. Indeed, we deactivated the use of the charge account.

So I would be very interested in your final solution to the situation.

Cheers,

mrt
Ghetz 2,987 on at

Like (0)

Report

RE: Automatic Allocation Problem when posting Purchase Packing Slip. AX 2012 R3 CU8

We've been debugging this for a few days. One thing we've noticed is that some options in the Vend Parameters change the bahaviour of ledger posting.

We need this parameters to be checked. Please could you try posting the allocations with this Vendor options checked and confirm that the behaviour is correct in CU9?

Accounts Payable Parameters:

- Updates section: "Post product receipt in ledger"

- Invoice section: "Post to charge account in ledger"

Debugging we've seen that with this options checked, when making the LedgerVoucher, the PackingSlip Offset account, which is the account where we have setup the allocation is been taken twice, so the amounts are cancelled. We detected this by putting breakpoints in LedgerVoucherObject.Addtrans().

However, in the final voucher the Offset account is there, but without allocations. This is quite deep into the AX Code, but it seems like it's taking the account generated by the Account Distribution process (AccountingDistributionProcessor class), then this is inserted into the SubledgerJournalAccountEntry (SubledgerJournalizer class) and into the Final Voucher (GeneralJournalAccountEntry table). In this process, the account allocations are not taken into consideration.

So we're not sure if we need to fix the LedgerVoucher creation, or add support for account allocations in the Account Distribution/SublledgerJournalizer part of the process.

Damn! this is gonna be a hard one :(
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Automatic Allocation Problem when posting Purchase Packing Slip. AX 2012 R3 CU8

Hi Ghetz, I checked it in AX2012 R3 CU9 and everything worked fine with the allocations for purchase orders. Then I tried to setup the same in a AX2012 R3 CU8 environment and initially got many error logs when setting up the allocation rule. I hardly managed to leave the allocation setup window but finally an allocation was made. It was not what I intended but an additional transaction was created. To me it seems that Microsoft made some changes between CU8 and CU9. Do you have the chance to compare classes and methods related to the allocation functionality with a developer? Since I was able to generate an additional (but wrong) allocation posting in CU8 I believe that you can make it work properly by comparing and possibly changing some lines of code. All the best, Ludwig
Ghetz 2,987 on at

Like (0)

Report

RE: Automatic Allocation Problem when posting Purchase Packing Slip. AX 2012 R3 CU8

Thanks for the answer,

The thing is, as I said in my post, that automatic allocations are working for Sales. When I do a Sales packing Slip or Invoice, the amounts are allocated acording to the automatic allocation terms. We dont use financial dimension default templates in Sales.

This is an example of correct Sales Allocation:

So the user is expecting the allocations to work for Purchase as well. One interesting fact is that the allocation is working correctly in AX 2012 R3 even for Purchases, so I'm thinking this may be a bug in CU8?

Could anyone please try purchase automatic allocations in AX 2012 R3 and in AX 2012 R3 CU8, and see if they get the same behaviour?

Attached a screenshot of our configuration:

Thanks!
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Automatic Allocation Problem when posting Purchase Packing Slip. AX 2012 R3 CU8

Hi Ghetz, The allocations described in the post you refer to work only if you post transactions manually in GL. If you work with purchase orders you rather have to setup and use financial dimension default templates. They can be setup in GL and linked to your PO in the PO line details - financial dimension section. Hope it helps, Ludwig