12
Issue Description:
When a product charge is applied at a later date from when it was consumed. Or when the invoice differs from the expected cost.
The revalorization is posted to the consumption date, and so is the value entry.
But the problem happens due to the fact that the produt charge is posted at the date for the invoice so the expected value does not take into account the full cost for this item.
This can be particularly troubling if you are analyzing the inventory since depending on the dates studied you will have an accounting discrepancy.

Step-by-step issue-reproduction:
1-Go to ‘Item Card’ (8904-W)
Press Related \ Bill of Materials \ Assembly \ Assembly BOM

Delete all lines except 80001 and 80101

2-Check that Work date = 26-Jan-2023
3-Create new ‘Purchase Order’
Header:
- Vendor = 10000
- Location = BLUE
- Vendor Invoice No. = 1
Line:

First line -
Type = Item
No. = 80001
Quantity = 1
Direct Unit Cost Excl. VAT = 5.80

Second line -
Type = Item
No. = 80101
Quantity = 1
Direct Unit Cost Excl. VAT = 11.70

Post ‘Purchase Order’

4-Set Work date = 01-Feb-2023
5-Create new ‘Assembly Order’
Header:
- Item No. = 8904-W
- Location = BLUE
- Quantity = 1

Post ‘Assembly Order’

6-Create new ‘Sales Order’
Header:
- Customer = 10000
- Location = BLUE
Line:
- Type = Item
- No. = 8904-W
- Quantity = 1
Post ‘Sales Order’

7-Set Work date = 10-Feb-2023
8-Create new ‘Purchase Invoice’
Header:
- Vendor = 10000
- Vendor Invoice No. = 2
Line:
- Type = Charge (Item)
- No. = P-FREIGHT
- Quantity = 1
- Direct Unit Cost Excl. VAT = 5.00
Press Line \ Related Information \ Item Charge Assignment
Press Item Charge \ Get Receipt Lines, select both lines for last posted PO
Press Item Charge \ Suggest Item Charge Assignment, select By Amount
OK

Post ‘Purchase Invoice’
9-Run ‘Adjust Cost – Item Entries’, no filters, OK

Check Item Ledger Entries / Value Entries:

// Value Entries for 80001 component Assembly Consumption additional charge (-1.66) has Posting Date = 01-Feb-2023

// Value Entries for 80001 component Purchase additional charge (1.66) has Posting Date = 10-Feb-2023

// Value Entries for 80101 component Assembly Consumption additional charge (-3.34) has Posting Date = 01-Feb-2023

// Value Entries for 80101 component Purchase additional charge (3.34) has Posting Date = 10-Feb-2023

10-Run ‘Inventory Valuation’ report
- Starting Date = 01-Jan-2023
- Ending Date = 09-Feb-2023
- Item No. (filter) = 8904-W|80001|80101
Preview

We see negative (-1.66; -3.34) lines for end value for components ?! // ..09-Feb-2023 (back date)

Suggestions:
-A separate warning issued when previewing the Inventory Valuation that there are posted modifications that are pending to apply and would compensate the current data shown.

-A warning is issued before finalizing the report showing pending valuations to be applied.

We are open to any additional input to solve this situation that don't imply modifying the invoice dates.
Category: Inventory
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team