Adjust Cost - Item Entries question

florynx

Hi
What is the best way to filter Inventory->Periodic Activities->Adjust Cost - Item Entries report to run only for items with Item Ledger Entry posting dates <= than a given date?

thank you

Kowa

Setting a date filter was possible in Navision Financials, where the item ledger entries held both quantity and value and the item cost adjustment was less refined.
Starting with Version 3.01, all Value Entries (no matter when they were posted and with all posting and valuation dates ) attached to each item ledger entry have to be taken into account for determining the correct item valuation. A date filter would disturb this routine.

Alex_Chow

florynx wrote:

Hi
What is the best way to filter Inventory->Periodic Activities->Adjust Cost - Item Entries report to run only for items with Item Ledger Entry posting dates <= than a given date?

thank you

This question depends on the version of Navision you're using.

For versions up to 2.65, you have control over the dates in which you run the adjust cost process. However, with version 3.0 to 3.7a, you don't have the flexibility specifying the dates the adjusting entries go to. However, with version 3.7b forward, although it still adjusts every entry, but the entries will go to the proper period that you specify.

florynx

Ok, another question:
Is it possible to modify this report to insert in Value Entry table not the date that user enters in report's ReqForm but the posting date from Item Ledger Entry table?

ara3n

3.7b adjust cost was changed to use different posting date. I've ported to 3.6 before so it's possible to change the posting date.

Alex_Chow

florynx wrote:

Ok, another question:
Is it possible to modify this report to insert in Value Entry table not the date that user enters in report's ReqForm but the posting date from Item Ledger Entry table?

If you're a solution center, proceed with caution.

If you're an end user, then DON'T DO IT!

David_Cox

florynx wrote:

Ok, another question:
Is it possible to modify this report to insert in Value Entry table not the date that user enters in report's ReqForm but the posting date from Item Ledger Entry table?

This is not advisable as the Posting date on the Ledger entry could be in a closed period, where reporting has already been done.

You can sell an Item today, and not pay the suppliers invoice for another 30 days, so the Adjusted Cost valuation date will be in the future.

You may have reported at the end of the month, and may have posted in an acrual for the Expected Costs.

The way you are proposing may invalidate the historic reports, which may have gone to the shareholders.

Kowa

David Cox wrote:

This is not advisable as the Posting date on the Ledger entry could be in a closed period, where reporting has already been done.
.

The "Closed Period Entry Posting Date" as provided in the Request form of the =>3.70 Version Adjust Cost - Item Entries Report could be used to prevent this. This posting date is used if the value entry posting date lies in a closed period.

Alex_Chow

Kowa wrote:

David Cox wrote:

This is not advisable as the Posting date on the Ledger entry could be in a closed period, where reporting has already been done.
.

The "Closed Period Entry Posting Date" as provided in the Request form of the =>3.70 Version Adjust Cost - Item Entries Report could be used to prevent this. This posting date is used if the value entry posting date lies in a closed period.

This should be used in conjunction with the Allow Posting From from the General Ledger Setup.

All these information is described clearly in the Navision help.