Microsoft Dynamics AX (Archived)

Financial Transactions for Kanban Rules - how to select?

(1) Share

Report

Posted on by Adriaan Van Nuffel

391

Hi, we're using Ax 2012 R3.

I want to create Kanbans that do financial transactions (they already do inventory transactions).

When I configure a new Kanban "manufacturing" rule, the check box "Financial transactions" is not checked. How do I get it checked?

On the technet (https://technet.microsoft.com/en-us/library/hh227370.aspx) I find:

Financial transactions

This check box is selected when the kanban rule creates inventory transactions, and one or more of the following conditions are true:

The kanban type is Manufacturing.
The kanban type is Withdrawal, and the picking and receipt locations are managed by subcontractors.
The kanban type is Withdrawal, and the picking and receipt locations are on different sites.
The kanban type is Withdrawal, and one of the following conditions is true:
- The picking activity updates the available inventory, and the receipt does not update available inventory but is transferred to WIP (work in process).
- The picking activity does not update available inventory, but the receipt is transferred from WIP and does update available inventory.

But the kanban rule that I've created is type manufacturing, and creates inventory transactions. So why is the check box not checked?

Some additional info:

- I did not fill in any financial dimensions (yet) in the Production Flow, or in the Work Cell. Do you think this is necessary?

- When I try to do Production control > Periodic > Backflush costing calculation, and then "Resume production flows", I get this error: "Account number for transaction type Production offset account receipt does not exist."

- I'm a complete rookie when it comes to "Financial transactions" and "Inventory transactions", so any short tips explaining the difference between the two are greatly appreciated.

Thanks for any input you may have.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Fredrik Sætre 12,644 on at

Like (1)

Report

RE: Financial Transactions for Kanban Rules - how to select?

The Production offset account receipt needs to be set up for you item, item group, item purchase category or for all items in the inventory posting setup. You can access this through the inventory management setup menu or directly from the item under posting.

Does the item you have selected have an item model group that allow financial transactions?

Was this reply helpful? Yes No
Adriaan Van Nuffel 391 on at

Like (0)

Report

RE: Financial Transactions for Kanban Rules - how to select?

Hi Fredrik, thanks for the feedback.

Here are some parameters that I checked that might be imprtant (or not).

In Production control > Setup > Production control parameters: the ledger posting is "Item and category"

In Production control > Setup > Production > Production groups: initially, nothing was filled in, all the fields were blank. In an effort to solve my problem, I filled in some accounts (I'm guessing our accountants can tell me later which accounts to use, this is a test system).

When I filled in these accounts, the nature of the error I get when trying to do the "Backflush costing calculation", "Resume production flow p..." has changed:

This is now the error I get:

You must select a value in the Department field in combination with the following dimensions values that are valid:

MainAccount 609203.

The combination was not validated beyond the Department financial dimension.

Dimension values were validated with this account structure: BE P&L Dep CT Project

Update has been canceled because of an error.

Since it's a new error, I think I'm getting some progress.

The items that I use in my Kanban Rules have financial dimensions configured for them.

As you ask, the item group has some accounts filled in as well: see screenshot. I see that there is no "Lean service WIP receipt" filled in. Would that be the issue?

As for the Inventory management setup menu you refer to, is this the menu you're referring to, to do this? Inventory management > Setup > Inventory and warehouse management parameters

Many thanks for the help :-) much obliged.

Was this reply helpful? Yes No
Adriaan Van Nuffel 391 on at

Like (0)

Report

RE: Financial Transactions for Kanban Rules - how to select?

Since the error I'm getting now seems similar as the explanation here ( https://community.dynamics.com/ax/b/axfaqblog/archive/2016/08/23/getting-you-must-select-a-value-in-a-dimensiond-field-valid-in-combination-message ), I thought I'd check the Chart of accounts setup, so here it is:

I'm guessing somewhere the financial value for Department is not filled in.

Don't know where, though...

Was this reply helpful? Yes No
Adriaan Van Nuffel 391 on at

Like (0)

Report

RE: Financial Transactions for Kanban Rules - how to select?

Well, this thread is slowly becoming my personal diary, but I'm guessing it might be useful for someone in the future, so...

Dear diary...

I filled in the financial dimensions (Costtype, Department) of the production flows, this solved my error, and gave me a new one.

The latest error:

Account number for transaction type Production substitution variance does not exist.

Account number for transaction type Rounding variance does not exist.

Also, as a side remark, I noted that the calculations for the Withdrawal Kanban - production flows have ended succesfully, it's only the production flow that I have running that are giving me "wahalla".

Was this reply helpful? Yes No
Adriaan Van Nuffel 391 on at

Like (0)

Report

RE: Financial Transactions for Kanban Rules - how to select?

And this is what the Inventory management > Setup > Posting > Posting looks like

I added the Item code Group "K" just now, but it didn't solve the error.

Is there any easy way to see which item exactly is causing the problem?

Was this reply helpful? Yes No
Verified answer

Fredrik Sætre 12,644 on at

Like (1)

Report

RE: Financial Transactions for Kanban Rules - how to select?

I've had developers go and further improve that error message before to inform what item is in the wrong, but not by standard.

You would read through the items involved one by one and check it... Is the BOM big?

Was this reply helpful? Yes No
Verified answer

Adriaan Van Nuffel 391 on at

Like (0)

Report

RE: Financial Transactions for Kanban Rules - how to select?

Well, I got rid of the errors by going to Inventory management > Setup > posting > Posting, and then choosing an account for Item code "All", instead of "Group". I'm not sure if this is the ideal solution.

So now that I can do financial transactions succesfully - this brings me again to my initial question: why isn't the "Financial transactions" check box checked (automatically)?

The kanban rule creates Inventory transactions, and the kanban type is Manufacturing...

Was this reply helpful? Yes No