-
Do not allow the system to Mark as Reconciled the Bank Reconciliation when there is no matched transactions.
In Dynamics 365 for Financials and Operations, when users go Cash and bank management | Bank statement reconciliation| Bank reconciliation.
1. Click New.
2. In the Bank account field, enter or select a value.
3. In the Cut-off date field, enter a date.
4. Click Worksheet.
5. Make sure that there is no matched amount.
6. Click Mark as reconciled.
When this is done the reconciliation proceeds even though there is no matched transactions.
The system should not allow this process as there are not transactions being reconciled.
-
Fixed Asset to meet the Australia Tax regulation number AASB116
Description of problem:
When revaluing a fixed asset, according to AASB116, accumulated depreciation needs to be eliminated against the gross carrying value of the asset at the time of revaluation. What this means is that if i revalue an asset that was originally acquired for 5,000.00 and I have depreciation of 450.00 and I have a revaluation of $6,000.00 then the new "cost" of the asset needs to be $6,000.00 and this is the amount that is to be depreciated.Error message:
There is no error it is just that the revaluation does not "reset" the asset valueRepro steps:
1. Create a fixed asset and run depreciation for three period
2. Process a revaluation journal for the asset and increase the value for the asset
3. Check the balance of the asset
- the balance of the asset is the original acquisition price, less any accumulated depreciation plus the revaluation amount.Dynamics 365 currently does not support this and all the recordings need to be done manually by posting the revaluation transaction to update the net book value.
-
Have the ability to setup workflow Escalation for a Work Item queue
In Dynamics 365 for finance and operations, there is an ability to setup the workflow and escalate if needed.
In the current design, the users can only select to escalate the workflow to the following options:
Hierarchy, Workflow user and users.
If users are using the Work Item queue, they would like to be able to escalate the workflow to a specific queue instead.
This option is currently not available in the application and will be nice to see as part of the standard workflow feature.
-
Exclude Credit Notes during the Customer Payment Proposal Process
Our customer would like to have the ability to exclude the Credit Notes during the cutsomer payment proposal process.
They are currently using a payment method of Total and the system includes the Credit note in the calculation of the Customer balance.
If they set the Payment method to Invoice, the system creates one payment per document (invoice and credit notes) and then they can set to delete negative payments.
This does not work for the customer as this includes the Credit note still and this will include all the transactions
They would like to have a feature specific to exluding the credit note in the customer payment proposal process
-
Have the ability to change the Receipt date for Product Receipt correction
When reversing a purchase order receipt that was posted in a ledger period that is marked as On Hold the system brings the receipt reversal forward to the next available posting period. This works as designed, however the system does not factor in that the next available posting period may be set to Open, but restricted to certain user groups, and therefore the user is unable to reverse the product receipt as they are not a member of that group.
The customer would like to have the ability to change the Date field in the Product Receipt Journal form to allow the users to post to a date/period that the user has access to.
-
Budget check workflow parameter for Expense transactions
Description of problem: There is no option to add a condition based on budget check results in the either the expense report or expense report auto posting workflows, meaning that it is possible to submit, approve and auto-post an expense claim without seeing any budget check warnings. The workflow should behave the same way as for purchase orders and accounts payable invoice journals and provide the ability to route to a specific member of staff it the available budget is exceeded. Repro steps: 1. Configure budget control for a specific ledger account; 2. Enter an expense claim, with a line mapped to the ledger account from step 1 above. Ensure amount exceeds budget; 3. Submit Expense claim to workflow; 4. Approve claim; 5. Auto-post using workflow. In this scenario, because there is no budget check component in the workflow, the process completes. We would like to see a budget check feature in the workflow for the Expense transactions -
Intercompany timesheet posting in the Lending company requires the Ledger Posting type of All to allow the posting
On posting the timesheet created in the lending company, an error will be thrown saying that no account exists for the account type Cost. This is because in the existing logic the ledger dimension is searched based on project account type ‘Cost’ and not based on any project Id or category id. Hence the ledger dimension is searched for all the default values(All projects, all category record) other than for project account type in the posting profiles of the lending company. As there is no record present for All projects, all category in the posting profiles of the lending company (i.e. GBSI), on posting the timesheet the error will be thrown saying “no account exists for the account type Cost”. Our customer would like to have the ability for the Lending company to use the account seutp for either the Category or the Project. Feedback from the partner and the customer: I can see issues with having to use an All option for posting of inter-company transactions. I don’t know why they haven’t allowed using the project/ project group and category/category group from projects in another company when doing the cost postings in the lending company. There is nothing stopping a company from setting other company project/category group to control posting cost on inter-company postings – they chose to do it to control their postings. This is just normal posting behavior, if the specific doesn’t exist, fall back to group or the all. Not allowing it, limits users ability to control postings and potential mix intercompany cots postings with other normal project postings for the company. Anyway feels like someone has put blinkers on for this and taken a very small view. -
AU BAS Reporting automation
At present the standard BAS reports generated from 365 Finance and Operations do not provide the user with clear and concise documentation to support the Business Activity Statement as lodged. In order to produce a satisfactory report, the user is required to export data and use an external program such as Excel to edit and format reports to support the Business Activity Statement. This manual work around is inefficient, labour intensive and tedious. The user is required to sort the GST into payable and receivable. The user is also required to create formulas to calculate totals each GST direction. This report will be used by over 163 finance personal of differing abilities and must be a standardised. The current 365 Finance and Operations solution is open to error and miscalculation that could lead to harsh penalties. Auto Population of BAS Boxes The out of the box system only fully supports one type of the Australian taxes (the GST) however other Australian taxation obligations are only partially supported or not supported at all. PAYG, FBT, Fuel credits are among the taxes which Australian companies are obliged to report to Tax Authorities. Manual tax calculations must be performed in external tools, such as Microsoft Excel, which are a labour intensive and error prone and often lead to tax penalties. https://www.ato.gov.au/Business/Business-activity-statements-(BAS)/In-detail/Instructions/FBT---how-to-complete-your-activity-statement-labels/#F1ATOinstalmentamount The user is required to manually look up the Withholding Tax by generating a report separate to the BAS. The user must then manually transfer this figure to the W4 box on the BAS statement. It is a requirement that organisation report withholding tax. https://www.ato.gov.au/business/payg-withholding/paying-and-reporting-withheld-amounts/ The user is required to manually look up the PAYG and Total Payroll by generating a report separate to the BAS. The user must then manually transfer this figure to the W1 and W2 boxes respectively on the BAS statement. It would be a far more efficient solution to have this figure automatically populated. The manual transfer of data is open to error. There will be several hundred staff over 163 schools that will need to do this process, some of which do not have the required knowledge to confidentially complete a Business Activity Statement manually. The room for error is high and as such could result in invalid tax reporting which could result in high penalties. Once the BAS is completed and posted, the user is still required to manually journal. Collectively the additional time required to process and submit the BAS and clear out postings is significant.
-
Allow negativefee transaction without consumption of the spend amount
Description of problem: We have configured our project contracts to have funding limits for all transactions. When I post a negative FEE transaction, i get an error around the inability to allocate revenue. This is based on the funding limit. If there is NO funding limit, negative fee transactions can be posted. There is no issue with negative hour transactions being posted. Error message: Posting - Journal Journal: PPJ000030 Voucher: PJFE0000004 Line number: 1.00 Revenue could not be allocated. Verify that funding rules have been set up to allocate the revenue. Repro steps: 1. Create a time and material project 2. Assign a project contract and assign a funding limit for 10,000.00 3. Process a negative hours journal - no issue 4. Process a negative fee journal - cannot post with error above. Repeat step 1-4 for a Time and material project with no funding limit. All transactions post. This scenario is currently not supported in the application. The scenario here is that there is no conusmption of the Spend amount earlier and we are posting negative transactions. There might be no consumption of the Spent amount because the Funding limits might have been added later after several transactions are posted and now the customer wants to create a negative transaction or a credit note. Currently the system does not support this scenario. The Spent amount should be consumed first before allowing negative transaction or credit notes.
-
Bank to Bank transfer Journal
On the menu Cash and Bank Management under Bank Accounts there is a designated Bank transfer function. A bank transfer function would support a very standard business process of transferring money from one bank account to another. Th is is why this type of function exists in most ERP solutions. However - This Finance and Operations bank transfer function has the following issues: 1) It does not open journal line with a default to a Bank transaction entry type but rather opens to the ledger transaction type. 2) This is just the General journal so there is no point in its existence in its current state. 3) It should support the standard business process of bank to bank transfers without having to route it via a temporary ledger account. In its current out of the box state - it prevents this standard process and therefore is not a bank transfer function as per the menu option Repro steps: Menu: Cash and Bank Management > Bank accounts > Bank transfers Create a jnl (and it is a general journal) Go to lines Aim to enter a bank transaction type in both the main and offset accounts The user is prevented from posting this type of entry Customers would like to have a designated Bank to Bank journal instead of using the General Ledger journal form to allow them to do a bank to bank transfer which is a standard business practice without having to use the General Ledger Journal form.
You’re offline. This is a read only version of the page.
