Dynamics Community Forum Thread Details

Dynamics Ax 2012 R2 CU7

Project ID: 11-0502-004 Project Name: Adjustment for Project Transaction Project Type: Time and Material

Project Group:

Category setup:

Line Property:

Item requirement through packing slip/delivery note Posted to the Project.

Project and Line property set to accrue the Item Cost. So the Transaction posted with Ledger Status Balance.

Voucher Details:

Transaction type	Posting type	Ledger account	Crediting	Correction	Amount	Quantity	Account name
Sales order	Project - cost - item	24-5214	Yes	No	-92.05	20	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Sales order	Project - cost	24-5214	No	No	92.05	0	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Sales order	Project - WIP cost - Item	22-1051	No	No	92.05	20	WORK IN PROGRESS - MATERIAL - FABRICATED GRATINGS
Sales order	Sales order issue	22-1140	Yes	No	-92.05	0	INVENTORY - RAW MATERIALS

Project Statement:

Adjustment for Project Transaction:

After posting adjustment for project transaction:

Split Qty. 10 each for same project. Transaction are posted correctly except the Ledger Posting:

Voucher Details after posting adjustment:

Transaction type	Posting type	Ledger account	Amount	Quantity	Account name
Project	Project - cost	24-5214	46.03	0	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost - item	24-5214	-92.05	10	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost	24-5214	46.03	0	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost - item	24-5214	-92.05	10	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost	24-5214	-92.05	0	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost - item	24-5214	92.05	-20	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - WIP cost - Item	22-1051	92.05	10	WORK IN PROGRESS - MATERIAL - FABRICATED GRATINGS
Project	Project - WIP cost - Item	22-1051	92.05	10	WORK IN PROGRESS - MATERIAL - FABRICATED GRATINGS
Project	Project - WIP cost - Item	22-1051	-92.05	-20	WORK IN PROGRESS - MATERIAL - FABRICATED GRATINGS
Project	Sales order issue	22-1140	-46.03	0	INVENTORY - RAW MATERIALS
Project	Sales order issue	22-1140	-46.03	0	INVENTORY - RAW MATERIALS
Project	Sales order issue	22-1140	92.05	0	INVENTORY - RAW MATERIALS

Project Statement:

Breakdown of above data

Transaction type	Posting type	Ledger account	Amount	Quantity	Account name
Project	Project - cost	24-5214	46.03	0	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost - item	24-5214	-92.05	10	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost	24-5214	46.03	0	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost - item	24-5214	-92.05	10	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost	24-5214	-92.05	0	COST OF SALES - MATERIAL - FABRICATED GRATINGS
Project	Project - cost - item	24-5214	92.05	-20	COST OF SALES - MATERIAL - FABRICATED GRATINGS
			-92.04
Project	Project - WIP cost - Item	22-1051	92.05	10	WORK IN PROGRESS - MATERIAL - FABRICATED GRATINGS
Project	Project - WIP cost - Item	22-1051	92.05	10	WORK IN PROGRESS - MATERIAL - FABRICATED GRATINGS
Project	Project - WIP cost - Item	22-1051	-92.05	-20	WORK IN PROGRESS - MATERIAL - FABRICATED GRATINGS
			92.05

Project	Sales order issue	22-1140	-46.03	0	INVENTORY - RAW MATERIALS
Project	Sales order issue	22-1140	-46.03	0	INVENTORY - RAW MATERIALS
Project	Sales order issue	22-1140	92.05	0	INVENTORY - RAW MATERIALS
			-0.01

Issues noticed:

Each time Adjustment for Project Transaction posted, Project-Cost-item get credited and Project-WIP Cost-item Debited Not reversing original transaction selected for adjustment as it should be. So the Cost is decreased and WIP increased at the rate of original cost value. In this case 92.05 + 92.05 = 184.10
Project Statement shows Cost of item credited and Project WIP Cost value-item increased double. In this case (46.03+46.03-92.05-92.05) = -92.04

Appreciate any solution, hot fix etc

Thanks in advance.

Adjustment for Project Transaction updating general ledger incorrectly.