Dynamics Community Forum Thread Details

Posting Date Error

Hi,

I have multiple Service orders that are requiring us to move the posting dates in User setup to get the service orders to post without an error.

We can bypass by changing the posting date to/from in user setup however this will leave the client wide open for postings. This is an issue for them.

Apologies I mis read the email.

I have taken a look and I can spot the issue.

The issue is that there is a rounding ledger entry for 1p that is being attempting to be posted for this transaction.

The rounding is due to cost of the item being 0.02965 and the quantity being 3 equalling to 0.08895.

In your general settings you have a rounding precision to the nearest penny.

This explains why the transfers are being done.

The date of 27/04/2022 is being pulled from a transfer receipt on 27/04/2022 for that Item.

The quantity was 2 and there is a remaining quantity of 1 left on that transfer.

Taking FIFO into account, the service order is trying to use that remaining quantity to assign to the service order meaning that the rounding part of that posting will have that posting date of that transfer it is pulling the quantity from.

How can we get around this without changing the posting to/from date.

Any help would be much appreciated

Categories:

Dynamics 365 Business Central

Quick Links

Leaderboard