“The Value FeeRet in the Category field is not valid according to the Category setup” Error in AX 2012

“The Value FeeRet in the Category field is not valid according to the Category setup” Error in AX 2012

Friends,

I have been busy in work after my long vacation  and break from blogging.

Today, I just wanted to write a quick post about troubleshooting an error which you might face while submitting invoice proposals which has retention enabled in it in Microsoft Dynamics AX 2012.

If you come across the error with message“The value “ FeeRet“ in the Category field is not valid according to the Category setup” , where “FeeRet” is the customer payment retention category, then make sure that The “Active in journal” and “Customer payment retention” check boxes are marked in the Category setup under Project Management and Accounting > Setup > Categories > Project Categories.

Refer to screenshot below.

image

Note : Please note that, if you select the ‘Customer payment retention’ check box prior to the ‘Active in journal’ check box, then you cannot mark the ‘Active in journal’ check box anymore, as it will be disabled.

Hope this will help. Lot of new exciting posts coming soon. Stay tuned.

Keep DAXING Smile

Sandeep

[Troubleshoot] -Timesheet Periods have not been created for: 2000 – Error when creating Time sheets in microsoft dynamics AX 2009 PSA

Friends.

Below is a very common error which users always wonder about when trying to create and submit their time sheets in Microsoft dynamics AX 2009 PSA module.

Timesheet Periods have not been created for: 2000” , where 2000 is the logged in employee. The warning message is as shown below.

Issue : This error comes when there are no time sheet periods defined for the employee.

Solution : Follow the below steps to resolve this issue and be able to enter time sheets.

  1. Navigate to Basic > Employee details form.
  2. Select the employee record for which the error is thrown. ( Employee 2000 in this case).
  3. Click the Setup tab.
  4. Verify that a Period code is set up for this employee. If this is not setup already , you have to set a period code by selecting one from the look up.
  5. Then right-click on the period code , and click Go to the main form.
  6. Then, click the Update employee periods button.
  7. Give a suitable start and end date ( say 01/01/2011..06/30/2011) and click OK button.
  8. Click the Update time sheet periods button.
  9. Give a suitable start and end date ( say 01/01/2011..06/30/2011) and click OK button.
  10. Finally click the Show time sheet periods button and verify that there are records created for the time sheet periods for the period code attached to the Employee.

This will fix the error above and the user will be able to enter time sheets then.I will be happy to recommend solution any other issues in PSA related to time sheets.

Thanks, Keep DAXING 🙂

There are no more budget left on forecast model “Test” for the cost- [Error] – Dynamics AX Project budgets

Hi All,

Here is a quick post which talks about a common error which you may receive from dynamics AX system when working with project transactions.(Posting project transactions).

If you encounter the error with message “There are no more budget left on forecast model ” ” for the cost” , this indicates that the “automatic cost reduction” for forecast is enabled in the project forecast model and “Check remaining cost against budget” check boxes are marked for Hours/Expense/Item which causes the system to check for the remaining forecast amounts/qty and there by block the further posting of transactions in the project.

The business scenario for this kind of setup:

In a realtime business scenario , the original forecasts will be created using a Original forecast model which will remain untouched for future references of the original budget. So the automatic cost reduction check boxes will not be marked for this forecast model.

To track the reduction of the original budgets and to have check on the budget control , Microsoft dynamics AX provides the “automatic cost reduction” and “Check cost against the remaining budget” check boxes. So a new Remaining forecast model will be created and these check boxes will be marked to have control over the budget.

Refer to screenshot below.

After the original budgets are created , these will be copied to the remaining forecast model by using the Copy budget periodic job.

Steps to troubleshoot the above error :

  1. Find the forecasts for the project and the type of transactions you are working on. This can be found at Project Accounting > Inquiries > Forecasts > Hour/Item.Expense..
  2. Look for the reduced forecast transactions.
  3. Take a suitable action for the budget by editing it.(You can increase the Qty. / Amount).

I would welcome any sort of questions on this.

Thanks, Keep DAXING 🙂

Inventory Reconciliation in Microsoft Dynamics AX (Introduction, Process, Issues ,steps to troubleshoot and more…

Hello everyone,Here is another learning from my side. Well , most of us might be well ware of the Inventory reconciliation issues and the approach to troubleshoot them in Microsoft dynamics Axapta , In my post below, i will try to explain the way i understood and worked on it.

What is Inventory reconciliation ?

In very simple words ,the process of identifying the discrepancies between sub-ledger(E.g – Inventory sub ledger AP/AR sub ledger..) and the general Ledger values and taking suitable actions to correct these discrepancies can be called as the inventory reconciliation. By the end of the fiscal year , the balances from the sub ledgers are reconciled with the general ledger values to ensure that the sub-ledger and the general ledger are in sync. It is one of  the painful issues for organizations on Dynamics Axapta.

When we perform inventory reconciliation , we validate that the transactions from the inventory and the general ledger agree with the parameter settings in Accounts payable , Accounts receivable , Production and Inventory.

What may cause the Inventory not to Reconcile ?

There are several parameters that can cause the Inventory not to match with the GL. Below are some of the points.

  1. Incorrect setup of posting profiles.
  2. Improper setup of the item groups and ledger accounts in them.
  3. Service type item may have been setup to get posted to inventory accounts.
  4. Date of financial transaction update.
  5. Item groups may have been changed on items by users(May be by mistake)
  6. Posting of manual journals into inventory accounts.

Steps for Inventory reconciliation  – An approach:

You may perform the below steps to identify the possible discrepancies between the inventory sub ledger and the general ledger posting values and take suitable actions to correct them.

  • Perform inventory closing for the period you are reconciling your inventory.(If not already closed)
  • Run the trial balance report for Inventory accounts at GL > Reports > Transactions > Periodic > Trial balance. This can be helpful in ensuring that the opening value of the inventory should be in sync with GL.
  •  Run the Posting by Account report at GL > Reports > Reconciliation > Inventory – Item posting by account and review the transaction by the posting types. This will help in determining the transaction types posted to the inventory accounts and you can ensure that wrong transactions got posted to inventory accounts if any.
  • You can also run the Ledger transaction list report at GL > Reports > Transactions > Ledger transactions list to get a list of all transactions that may not have been captured by the Item posting by account report. This will help in analyzing if any unwanted transactions(Service item transactions , manual entries etc) got posted to inventory accounts.
  • Run the Inventory value report by item group at Inventory management > Reports > Status > Inventory value report by item group and match the financial values of each item group with the trial balance report.
  • Analyze the variances and take suitable actions for the wrong transaction entires. If  incorrect ledger account setups are found , correct them. If manual transaction entires are found , create appropriate reversing entires for them.If service item transactions are found , double-check the setup for the service items.

Other important reports in Dynamics AX that will hep in Inventory reconciliation :

  1. Inventory management > Setup > Inventory value reports
  2. Inventory management > Reports > Status > Inventory value > Inventory value report.
  3. Inventory management > Reports > Status > Inventory value > Potential conflicts – Inventory and General ledger
  4. General Ledger > Reports > All reports under Inventory folder. Please refer to the screenshots below.

From the above mentioned reports , the Potential conflicts report can be found very useful in the inventory recon. process. and these set of inventory value reports are included in hotfix roll up 5 for dynamics AX 2009 service pack 1(Dynamics AX 2009 SP1 RU 5).

So , above steps and information about inventory reconciliation are one of the approaches that one may follow to reconcile inventory and there may exist other better approaches.

Thanks, Keep DAXING 🙂

Finanacial statements does not display the correct balance in a specified interval when running financial statements in Dynamics AX 2009/4.0

Hello,In Microsoft Dynamics AX 2009/4.0, we set a financial statement to display data in a specified interval. However, when we run the financial statement, the financial statement does not display the balance in the specified interval. Instead, the financial statement displays the YTD (“Year To Date” ) balance.

In this post , I will explain a resolution to get correct balances in financial statements when running it for a given interval in Microsoft dynamics AX 2009/4.0 .

STEPS TO TROUBLESHOOT THIS ISSUE :

Let us run the financial statement(Income statement) in standard CONTOSO data for the month of November , 2010. Please refer to screenshot below for the setup to run the statement.

Now , below is the financial statement report which we get, and the data in the report is “Year to date”, but not for the month of November, 2010.

Below are the steps to get the data for this specific interval(NOV , 2010 ).

1. Navigate to General Ledger > Setup > Financial Statement > Financial statement

2. Select the desired financial statement (IS, the Income statement in CONTOSO data)

3. Now, in the lower grid , select the current year record.

4. Click the Transactions tab.

5. Clear the “Include Opening” check box. Refer to screen below.

 

After doing this , run the financial statement again for NOV, 2010. Below is the result which we get and the data in this is not YTD but it is only for the period of NOV, 2010.

Hope , this information will be helpful .

Thanks , Keep DAXING. 🙂