web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Reverse Auto-report as...

Finance | Project Operations, Human Resources, ...

Answered

Reverse Auto-report as finished - can it be done?

(1) Share

Report

Report

Posted on by AB-25031441-0

9

Hi everyone,

I have read this post D365F&O – Auto-report as finished in a Retail scenario by @Kurt Hatlevik end I have the following question:

We use the auto-report as finished function on one product (concrete mix, which is made from sand, cement and water). When this report is used in a production order it automatically creates a seperate BOM. This works perfect, but sometimes the production order is half way and then reversed. The BOM for the concrete mix however is already created and finished.

Can this BOM be reversed so that we recreate the original inventory for sand, cement and water?

Thanks in advance for any suggestions,

Arrienne Bosch

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Saif Ali Sabri 2,354 Moderator on at

Like (1)

Report
Copy link

Link copied!
When using the Auto-Report as Finished (ARAF) function in Dynamics 365 Finance & Operations, a production order automatically consumes raw materials (sand, cement, water) and creates a separate BOM for the finished product (concrete mix). If a production order is partially completed and needs to be reversed, you must manually adjust the inventory and production records.
Steps to Reverse Auto-Report as Finished (ARAF) and Restore Raw Materials

Step 1: Check the Production Order Status

Navigate to Production control > Production orders > All production orders.

Locate the production order that needs to be reversed.

Ensure it is in "Reported as finished" or a similar stage.

Step 2: Reverse the "Report as Finished" (RAF) Transaction

Go to Production control > Production orders > All production orders.

Open the specific production order.

Click on Production order > Report as finished > RAF Journals.

Identify the journal entry related to the ARAF process.

If the journal is still open, delete or modify the reported quantity.

If the journal is posted, create a negative RAF journal to reverse the finished goods entry:

Product: Select the concrete mix.

Quantity: Enter a negative value (equal to what was previously reported).

Location & Batch Details: Ensure they match the original transaction.

Post the journal to update inventory.

Step 3: Reverse Material Consumption (BOM Journal Reversal)
Since materials (sand, cement, water) were consumed, they must be manually adjusted:

Navigate to Inventory management > Journal entries > Item transactions.

Locate the original BOM consumption journal linked to the production order.

Create a negative consumption journal for each raw material:

Select the item (sand, cement, or water).

Enter the same quantity but as a positive value to restock inventory.

Validate and post the journal.

Step 4: Close or Reopen the Production Order (If Necessary)

If the order is canceled, set the status to "Canceled".

If production will continue, adjust the BOM and proceed with the new production steps.

Key Considerations

If costing is affected, ensure the financial impact is reviewed and corrected.

If materials were physically used, you may need an alternative inventory adjustment.

If using batch tracking, ensure the correct batch numbers are restored.

This manual reversal ensures that both the finished product and raw materials are correctly reflected in inventory, allowing for proper reporting and tracking.
Would you like additional automation for this process using a custom script or workflow?

Was this reply helpful? Yes No
AB-25031441-0 9 on at

Like (1)

Report
Copy link

Link copied!

Thanks @Saif Ali Sabri! This answers our question 100%.

There is no need to further automate this.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 663

#2

André Arnaud de Cal... 439 Super User 2026 Season 1

#3

Syed Haris Shah 337 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans