Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Connie Thompson]

Germany has a requirement to post balance sheet type transactions first to the P&L accounts; i.e., inventory from purchase order receipt.  We recently upgraded AX2012 RTM to R3 and the solution we used in RTM via Posting Definitions does not work in R3.  If you are successfully meeting this requirement in R3 in Germany, I would like to speak with you.

Thanks!

——————————
Connie Thompson
MIS Financial Services Manager
Alltech Inc.
Nicholasville KY United States
http://www.axug.com/lexington
——————————

[Kelly (Kane) Gustafson]

Connie,

Have you found anyone to talk to about this?

——————————
Kelly Kane
Information Systems Specialist
Algood Food Company
Louisville KY
AXUG Kentucky Chapter Leader
http://www.axug.com/lexington
http://www.axsoup.com
——————————
——————————————-

[Connie Thompson]

No one on the forum has responded.  We are talking to Microsoft but not making a lot of progress.

There was functionality in 2012 RTM that we used to accommodate this posting requirement and Microsoft admits this functionality was eliminated in R3 but they are asking for proof that it is a true legal requirement.  We are trying to get it escalated in Microsoft but I was hoping someone in the community had addressed this in R3.

Any insight will be appreciated.

——————————
Connie Thompson
MIS Financial Services Manager
Alltech Inc.
Nicholasville KY United States
http://www.axug.com/lexington
——————————
——————————————-

[Zvika Rimalt]

Connie – maybe provide a simple example of what you are trying to achieve, and we might be able to put our brain power together and come up with an idea?

——————————
Zvika Rimalt
Functional Solution Architect
Vancouver BC Canada
——————————
——————————————-

[Martin Drude]

Connie,

I coordinate the AX group within the Microsoft Business Forum, the German AXUG partner organization.

If you provide a detailed description of your problem, I will be happy to forward it to our members and try to find someone who deals with this situation.

Greetings,

Martin

——————————
Martin Drude
IT Manager
Trützschler GmbH & Co. KG
Moenchengladbach
——————————
——————————————-

[Helen Fay]

Hope this helps, let me know if you need more information

For the German Posting issue, please see below the Before in RTM postings and after in R3 Posting we are missing the postings marked in Red in R3.

RTM postings before R3 upgrade: –

Journal number	Voucher	Date	Year closed	Ledger account	Posting type	Currency	Amount in transaction currency
GLGJT017439	APPRV000000615	28/10/2016	No	16080	Purchase, accrual	EUR	-3,930.00
GLGJT017439	APPRV000000615	28/10/2016	No	16090	Purchase expenditure, un-invoiced	EUR	3,930.00
GLGJT017440	IWMRCV00615	28/10/2016	No	16090	Purchase expenditure, un-invoiced	EUR	-3,930.00
GLGJT017440	IWMRCV00615	28/10/2016	No	39601	Purchase, stock variation	EUR	-3,930.00
GLGJT017440	IWMRCV00615	28/10/2016	No	39601	Product receipt	EUR	3,930.00
GLGJT017440	IWMRCV00615	28/10/2016	No	34200	Purchase, charge	EUR	3,930.00

R3

Journal number	Voucher	Date	Year closed	Ledger account	Name	Currency	Amount in transaction currency
GLGJT017469	APPRV000000622	06/12/2016	No	16080	Receiving Accrual (RECEIVING ACCRUAL)	EUR	-9,470.00
GLGJT017469	APPRV000000622	06/12/2016	No	16090	PURCHASE EXPENDITURE UN-INVOICED	EUR	9,470.00
GLGJT017469	APPRV000000622	06/12/2016	No	39601	Bestandsveränderung  (STOCK MOVEMENT PURCHASES)	EUR	-9,470.00
GLGJT017469	APPRV000000622	06/12/2016	No	39601	Bestandsveränderung  (STOCK MOVEMENT PURCHASES)	EUR	9,470.00

Germany require a stock transaction to hit the P&L first before it posts to the Balance Sheet.

 

We need the accounts 16090 and 34200 to be hit at the Purchase Order receipt Stage.

——————————
Helen Fay
European AX Project Manager
Alltech Inc.
Dunboyne
——————————
——————————————-