Dynamics 365 Finance

The idea is not include positive inventory journal transactions in the average cost calculation, in the inventory close. The average cost must include purchases and adjustments only.

Here is an explanatory example of a test:

D365 ASIS MODEL

• As of 01/01/2022 the initial balance has qty 200 value (€) 86 and average price 0.430
• On 02/01/2022 enters a supplier order of qty 150 value (€) 15 the average price is 0.289
• On 03/01/2022 a negative consumption count is made of qty 60 value (€) 17.31 the average price is 0.289
• On 04/01/2022 a positive adjustment is made of qty 50 value (€) 14.43 the average price is 0.289
• On 05/01/2022 a supplier order of qty 100 value (€) 1500 enters the average price is 3.632
• On 06/01/2022 a positive adjustment is made of qty 5 value (€) 18.16 the average price is 3.632
• On 31/01/2022 a monthly closing recalculation of consumption is made at the updated average price of qty 0 value (€) 177.01 the average price is 3.239
• At the end of the operations the weighted average cost will have qty 445 value (€) 1439.27 with an (incorrect) Average Price of 3.234

The final average cost of 3.234 is "wrong" due to two transactions relating to positive inventory journals, which are managed as if they were purchases and are calculated in the average of the calculation.

IMPROVED AVERAGE COST CALCULATION MODEL

• As of 01/01/2022 the initial balance has qty 200 value (€) 86 and average price 0.430
• On 02/01/2022 enters a supplier order of qty 150 value (€) 15 the average price is 0.289
• On 03/01/2022 a negative consumption count is made of qty 60 value (€) 17.31 the average price does not change
• On 04/01/2022 a positive adjustment is made of qty 50 value (€) 14.43 the average price is 0.289 the average price does not change
• On 05/01/2022 a supplier order of qty 100 value (€) 1500 enters the average price is 3.558
• On 06/01/2022 a positive adjustment is made of qty 5 value (€) 17.79 the average price does not change
• On 31/01/2022 a monthly closing recalculation of consumption is made at the updated average price of qty 0 value (€) 32.70
• At the end of the operations, the weighted average cost will have qty 445 value (€) 1601.00 with a (corrected) Average Price of 3.558

Wish there is an option to easily track workflow opposals, featuring conventional approvals is helpful, however featuring opposes maybe optimum, for purpose to easily identify approvers, opposes and non voters or desisters users.

With tax calculation method Total, the detailed tax calculation is not stored when the total amount is 0.

I would suggest to always store the detailed amounts on line level. This shouldn't be a big change, since the calculation already happens (otherwise you wouldn't know whether the total result is 0 or not).

This will allow to use the breakdown on line level in several functionalities (eg reporting on specific lines, writing off specific lines etc.).

in Nov 2021 I have booked an asset with an Acquisition value of 100,000, later on in 2022 I discovered the asset acquisition value is wrong it supposed to be 120,000.

how to adjust going forwarded? taking in to account the asset base value need to be revised to 120,000 and the allowance for deprecation in under valued by two month worth of deprecation.

it is useful, to be able to define periods where certain VAT Posting Setup and Posting Setup are valid.

Therefor the Entires should have an optional Start- And EndDate.

this allows easier changes in the setups also during periods where regualtions change for example VAT Rates.

The validation check should take place either on Document Date or Posting Date via a setup.

By now there are no data entities to migrate the following tables' content:

ReverseChargeItemGroup_W

ReverseChargeItemGroupData_W

ReverseChargeRule_W

In our localization we'll create them, but it would be useful for others, too.

Wish there is an option to easily enable find search command to easily search for records created within specific period range (e.g. 7days, 15 days or 3 days), for all users or a user in specific, for purpose to easily identify fresh or new records. (e..g upsell, company services presentations, new products, legal entity policies disclosures, terms or conditions, etc...).

When customer generate payments (Supplier Payment Journal) the files are saving to Desktop, please introduce one feature in future.to stop saving the files automatically.

Into Immediate Payment Terms (Details Worksheet)  reports generated via Electroninc Reporting (and schemes provided in standard by MS).

It's not possible to exclude vendors from the reporting based on their terms of payments. Even if vendors with Immediate payment terms needs to be excluded from this reporting. The only parameters that could be used (when "Calculate Statistics" process), only Posting profile and Vendor groups are available.

Wish there is an option to easily interference an alternative or an additional bank account when running a check payment generation for purpose to easily OFFSET account type and account when potentially running out of banking balance limits.