Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Zvika Rimalt]

I wonder if anyone here have seen this surprising behaviour (well, at least surprising to me):

1. I create a simple sales order for $10. sales tax = 0%. It just happens the cost (as displayed in the Sales Order “Totals” form is 1.43
2. I invoice the sales order. an invoice for the amount of $10 is created.
3. I use the out of the box “write off” functionality to write off the invoice.
To my surprised, the resulting journal, instead of creating a single line for $10, breaks it to two lines: 1 line for cost, and 1 line for margin (total = $10)

Needless to say this is burdensome for my users, having to consolidate the lines.
Can this odd behaviour be controlled by configuration? This is a pure vanilla instance.
and don’t get me started about the extra 0$ line created because I had $0 sales tax on my sales order (angry emoticon)

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————

[Ludwig Reinhard]

Hi,
This looks like a system bug to me. What D365FO version did you use for getting this result?
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Zvika Rimalt]

This is the release one before the Spring 2018

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-

[Christopher Ho Yee]

Hi Zvika,

Might it have to do with the dimension combinations associated with the items that were transacted on the original Sales order?

——————————
Christopher Ho Yee
Altius Consulting
Richmond BC
——————————
——————————————-

[Kaare Boraas]

Zvika.  Can you post a screen shot of the journal for the original invoice?

——————————
Kaare Boraas
Solution Delivery Manager
PCL Constructors Inc.
Edmonton AB
——————————
——————————————-

[Zvika Rimalt]

The only “unusual” thing is the fact there are dimensions on the COGS and Revenue account – but I would not imagine this is a very rare setup.

As you can see COGS posted as 1.43 (which is the amount used to split the amount in write-off journal)

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-

[Ludwig Reinhard]

Hi,
I tried to replicate it in a 8.0 PU15 system but could not manage to create a similar write off transaction.
What might possibly responsible for this is the GL parameter ‘values for summary account’.
Can you possibly try to change this parameter and test whether this fixes the issue?
If this does not help and if you are able to replicate the issue I would suggest to contact the MS support because to me the write off transaction does not look correct.
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Zvika Rimalt]

did you mean this parameter? Changing it to “Accounting Distribution”  did not seem to make a difference.
I will focus on re-creating it in demo data…. I can imagine what obscure configuration we made might be triggering this.

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-

[Kaare Boraas]

Thanks for posting the original journal.  The only thing that really surprises me is the financial dimensions.  I would have expected the reversal of the margin to use 1001C-SNAK not just 1001C as per the original transaction.  Any idea why it is dropping the last component of the dimension string?  Does the account structure for the write-off account not include that component of the dimension string?

——————————
Kaare Boraas
Solution Delivery Manager
PCL Constructors Inc.
AB
——————————
——————————————-

[Zvika Rimalt]

Update: I managed to (easily) to re-produce the issue in a Demo Data “Contoso” environment, using unmodified configuration in company DEMF  – so same dimensions, same inventory setup (!!)

All 3 issues showing up in the Demo environment:
1. split sales price/cost
2. dimensions not copied for one of the lines
3. Extra redundant line to recover 0% VAT, although there is 0 amount of VAT.

Quite disappointing I must admit. 

Looks like I have enough to open a Microsoft issue ticket. I am no

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-