Skip to main content

Notifications

Announcements

No record found.

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

Transfer order not posting for one specific item

(0) ShareShare
ReportReport
Posted on by 53

Hi,

In the past week we've run into an issue where one of our items cannot be transfered or reclassed to a different location. When we try to post either transaction, we get the popup that says "posting 1 line", but nothing happens for 5+ minutes. Also, while this is trying to post, no one can enter the item ledger.

I checked our item setup and there does not seem to be anything wrong and we were able to post this without issue 6 days ago. Issue has been escalated via our developers to Microsoft but any ideas on how to resolve this?

  • Joshua_saul Profile Picture
    Joshua_saul 53 on at
    RE: Transfer order not posting for one specific item

    Hi Hans,

    Thanks for the recommendation on the automatic cost adjustment and for answering my question. On topic, we have one lot number for that item and the date was within the same week. We don't currently utilize serial numbers either.

    Any other ideas on why it would have so many entries? Could it have to do with our costing setup (ie, could BC be recording a slightly different price for all these units so it requires additional entries)? I've experienced this with other systems where inventory with the same lot/SN required multiple entries when it's been received at different times (ie, receive 10 units on one day and 15 on the next day [both with same lot], will have entries of 10+15 when deducting)

  • Joshua_saul Profile Picture
    Joshua_saul 53 on at
    RE: Transfer order not posting for one specific item

    Hi Inge,

    Thank you for replying to my question. When we ran the transfer order, the automatic cost posting was and adjustment was the same as it was in my screen shot (posting on, adjustment set to "never". We run BC online.

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Transfer order not posting for one specific item

    Hi,I think it's a performance issue caused by customization.
    You copy this environment to a new Sandbox, then uninstall this customization, and check if there is still a problem when posting? f the data is the same and there is no problem, you need to ask your partner to optimize your customization.

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Transfer order not posting for one specific item

    I totally agree with Hans here.  Switching the way you do cost adjustment and cost posting is usually not a good idea.

    If you have a performance issue in BC you should try to find the root cause of it instead of switching cost posting and cost adjustment on and off.

  • Suggested answer
    HVGEEL Profile Picture
    HVGEEL 288 on at
    RE: Transfer order not posting for one specific item

    Hi,

    coming back on the Disabling of the Automatic Cost Adjustment.

    I understand why this route was suggested, but this is not the option you constantly want to en-and disable.

    Otherwise... there is nothing much Automatic about is, and you will have to remember running the batch job to recalculate.

    On topic: was there anything peculiar about the item posting that could explain the large number of postings?

    - Strange date (a date far in the past will kickstart a large number of revaluations)

    - Item tracking (lotnumbers? Serial Numbers? The former will generate a large number of additional postings, the latter... a large number per quantity (so if the line qty was 9000, each carrying an individual SN... you could indeed warm yourself (and your coffee mug) for a long run. )

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Transfer order not posting for one specific item

    When the posting was running for 10 minutes was the automatic cost posting disabled as well as the automatic cost adjustment disabled?

    And are you running Business Central on prem or Business Central online?

  • Joshua_saul Profile Picture
    Joshua_saul 53 on at
    RE: Transfer order not posting for one specific item

    Hi ZHU,

    First off, thank you for answering my question and for your blog posts. They've been very helpful! You're correct, we do have customization and have automatic cost posting on. I'm starting to think that this is the reason for our system's performance issues.

    I was able to complete the transfer order by ensuring everyone was out of the system and letting the transfer order post for 10+ minutes. I investigated the transfer order and it looks like this one order for 9000 pieces created ~1,000 entries... It started to make sense that the process took 10 minutes. 

    As a followup to the question, do you know why we would have so many entries on one order? Is this due to the Automatic cost posting or another field on the inventory setup, or would you recommend I look elsewhere?

    pastedimage1673571110295v1.png pastedimage1673571179311v2.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Transfer order not posting for one specific item

    Hi, is there any customization in this environment?
    I suspect it's a data issue.
    You can disable Automatic Cost Posting on the Inventory Setup page and change Automatic Cost Adjustment to Never, and then try it again.

    pastedimage1673484717787v1.png

    Hope this helps.

    Thanks.

    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans