Small and medium business | Business Central, N...

Adjust Cost only on certain periods

(0) Share

Report

Posted on by Esteban Navarro

241

Hello everyone,

I need to close the inventory period of october 2021, I haven't run the cost adjustment in while. The Close Inventory Period - Test says that I have to adjust cost for a certain number of items.

Is there a way to run the Adjust Cost – Item Entries for only the october movements?

Many thanks in advance.

I have the same question (0)

All responses (8)

Answers (0)

Dallefeld 211 User Group Leader on at

Like (0)

Report

No. However, you can setup your general ledger allow posting from date to 10/31/21 and any entries in October will adjust to the 10/31/21 date. This will also adjust entries in November to November dates and December to December dates and so on.

I think this will work for you. You can always create a copy of your company and try before you run it in production.

Was this reply helpful? Yes No
Suggested answer

Vaishnavi J 3,062 on at

Like (0)

Report

Hi ,

If you have inventory periods then there is no way you can close the inventory period before running the adjust cost item entries manually or adjust the cost item automatically by setting the Automatic Cost Adjustment to true in Inventory setup.

Refer the below link for more information.

docs.microsoft.com/.../design-details-cost-adjustment

Also to add Kim's point.

if the user who is trying to adjust the entries has some posting date restriction on user setup them make sure ‘Allow Posting From Date’ within GL Setup must be within the date range of the Users who are posting Inventory Transactions.

Posting date on value entries - Business Central | Microsoft Doc s

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi Kim Dallefeld

Thanks for info. Can you please provide more info about "However, you can setup your general ledger allow posting from date to 10/31/21 and any entries in October will adjust to the 10/31/21 date". I am interested to learn more about this method.

Thanks

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (1)

Report

BC uses the general ledger allow posting from and to dates for the Adjust Cost routine.

Let's say that you have that set to 2/1/22 and 2/28/22, when you run adjust cost any entries being adjusted prior to 2/1 will post using the 2/1 date while entries during February will post using their actual dates.

Does that help you?

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Thanks Kim. Yes it did.

Was this reply helpful? Yes No
Suggested answer

Vaishnavi J 3,062 on at

Like (0)

Report

Just to add Kim's point

The cost adjustment function uses the posting date of the original value entry in the adjustment entry, unless that date is in a closed inventory period. In that case, application uses the starting date of the next open inventory period. If inventory periods are not used, then the date in the Allow Posting From field on the General Ledger Setup page will define when the adjustment entry is posted.

Below is the link for more information

docs.microsoft.com/.../inventory-how-adjust-item-costs

Was this reply helpful? Yes No
Suggested answer

Esteban Navarro 241 on at

Like (3)

Report

Hello everyone, We opened a case with Microsoft and there's no way to cost only certain periods. The only solutios is to take the blow and run the costing process for all items.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

It would really break the system logic if that was possible especially for the items other than standard cost items.

Running cost adjustment regularly is considered best practise.

Was this reply helpful? Yes No