In some scenarios general ledger entries are posted in two different periods regardless that user setup has been open for both periods - for example when price differs on a purchase order, when purchase invoice is received after you already have started selling the item.

It gets more specific below with the details of the problem, but to me it is obvious that this is causing discrepancies in the financial books. I have seen this at several of my customers.

Here it goes – be patient now….:

Items (FIFO costing method) received on a purchase order 15^th of august 100 PCS on Location LOC1 to 50 EUR. (Not invoiced). This will not give general ledger entries. (In my scenario Expected Cost Posting on “Inventory setup” has been turned off)

Action a:

Items delivered on a sales order and invoiced to customer 21st of august 10 PCS from LOC1 to a cost price of 50 EUR.

Action b:

Items moved from LOC1 to LOC2 23th of august 20 PCS.

Now we reach 1st of September, and the bookkeeper do the following:

General ledger setup is set as “Allow Posting from” 1st of September and “Allow posting to” 30^th of September.

User Setup for the bookkeeper (a user) is set to 1st of AUGUST to 30. September.

Inventory setup is set to Automatic cost posting and “Always” in “Automatic cost Adjustment”

The bookkeeper is still allowed to post in august and the rest of the firm are only allowed to post in September. Adjustments will be posted automatically in the same go as the update of the purchase invoice.

We receive the purchase invoice for the 100 received items (let’s say we receive the 2. Of September), but it cost 54 EUR – The date of the document is 29^th of august – so we want to post it in august.

My expectation is that everything is posted in august because that is what I am allowed to do on my User Setup.

Everything about the purchase is posted fine in august, and this part of the action is respecting the dates in the USER setup. This is great.

However, …

The adjustment of the applied Item ledger entries for both the sale and the movement is posted on the 1st of September (based on general ledger setup) and the value entries are also created with 1st of September date. This should in my opinion have been posted (and value entry created) on the date of the sales invoice/movement or if these dates are before “allow posting from” from User setup on the 1st of august. For some reason it does not “respect” user setup when creating the value entries and posting the adjustment.

The same happens when you for some reason wants to adjust this cost price from now 54 EUR to 75 EUR. In this scenario you use an Item Revaluation journal to adjust the price from 54 EUR to 75 EUR. The new Value entries and the general ledger entries of the adjustment of the value will happen in august. But connected transactions from sales, production or movement will appear in September. (more or less same scenario in https://experience.dynamics.com/ideas/idea/?ideaid=f83006f8-1db3-eb11-89ee-0003ff459e23)

In general, one half of the process will respect settings in “User setup” and other half will respect settings in “General Ledger setup” – causing discrepancies in the financial books.

To me it is obvious that “User setup” should be respected in all these scenarios – otherwise we should not have the possibility to set dates on user setup.