Skip to main content

Notifications

Announcements

No record found.

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

production journal batch name per user

Posted on by 85

Hi,

When posting output for a released production order we use the production journal on the released production order page.

We also created a powerapp for 2 specific users in the production area which regularly gives us an error that the journal line already exists.  This is caused when 2 users post output from the app at the same time and due to the delay the same journal line numbers are used.

So what I want to do is assigning a production journal batch per user.

Does anyone has an idea how to this?  Because I do not have an idea where the setup of the production journal is done.

Many thanks!

Bert Lievens

  • MetaKa Profile Picture
    MetaKa on at
    RE: production journal batch name per user

    Hey bert L

    Just a tip

    The correct solution is to create the batches per user, as u already did.

    But the power apps solutions of wich u speak, seems a bad approach.

    Its better to handle all the code inside Business Central instead of the power app.

    I mean sending the request to Business Central (AL code) and posting from BC (creating a log table where u have the json of the data received).

    This will be faster, safer (in many ways) and will use less resources.

    The power app should have just the request and maybe an error mail.

    For example:

    1- Create a Form (Office Forms)

    2- Create a flow of power automate

    3- The flow get the forms info and send the info to BC

    ¡Thats all!

    Must be BC who do the job, so u have less time transactions and Azure (overall) resources being used.

    Inside the bc u can do whatever u need via programming with the data u received.

    ¡Best regards!

  • bert L Profile Picture
    bert L 85 on at
    RE: production journal batch name per user

    Hi Daniele,

    The page production control does not exist in Business Central.

    Thanks anyway!

    Bert

  • bert L Profile Picture
    bert L 85 on at
    RE: production journal batch name per user

    Hi Inge,

    I understand your proposal but the connection between the powerapp and Business Central is sometimes very slow and at time of creating it could occur it will post to the same line.

    If I say slow, it is really slow, it can take up to 5 minutes before the output from the powerapp is registered in Business Central.  That is another problem I need to tackle.  Any ideas to speed this connection are welcome!

    Thanks,

    Bert

  • bert L Profile Picture
    bert L 85 on at
    RE: production journal batch name per user

    Hi Mohana,

    Thanks for the help!

    I've managed to create the bachtes.

    Thanks,

    Bert

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 on at
    RE: production journal batch name per user
    [quote user="DAnny3211"]

    hi

    It sounds like you need to set up separate Production Journal batches for each user in order to avoid conflicts when multiple users are posting output simultaneously from your powerapp.

    To set up Production Journal batches, you can follow these steps:

    Go to Production Control > Setup > Production orders > Production journal names.

    Click "New" to create a new Production Journal name.

    Enter a unique name for the Production Journal, such as "User 1 Journal" or "User 2 Journal".

    Under "Batch number group", select a batch number group that you have already set up or create a new one. This will ensure that each user's journal entries are assigned a unique batch number.

    Repeat these steps for each user who will be posting output from your powerapp.

    Once you have set up the Production Journal names and batch number groups for each user, you can assign the appropriate journal name to each user in your powerapp so that they will only use the designated Production Journal when posting output.

    DAniele

    [/quote]

    ChatGTP or whatever AI service you're using is definitely not yet ready or capable of answering these questions.

    Production control is not even a page that exists in Business Central. Likewise for most of those steps. Perhaps you could verify the AI answers make sense prior to submitting them as your own?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: production journal batch name per user

    You should make the code in your PowerApp more fail safe.

    When you insert new lines into a journal you should always check the journal if there is existing lines in the journal first, Then you can find the highest existing line number in the journal and insert the new lines with a higer number than the last existing record,.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: production journal batch name per user

    hi

    It sounds like you need to set up separate Production Journal batches for each user in order to avoid conflicts when multiple users are posting output simultaneously from your powerapp.

    To set up Production Journal batches, you can follow these steps:

    Go to Production Control > Setup > Production orders > Production journal names.

    Click "New" to create a new Production Journal name.

    Enter a unique name for the Production Journal, such as "User 1 Journal" or "User 2 Journal".

    Under "Batch number group", select a batch number group that you have already set up or create a new one. This will ensure that each user's journal entries are assigned a unique batch number.

    Repeat these steps for each user who will be posting output from your powerapp.

    Once you have set up the Production Journal names and batch number groups for each user, you can assign the appropriate journal name to each user in your powerapp so that they will only use the designated Production Journal when posting output.

    DAniele

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,137 Super User 2024 Season 2 on at
    RE: production journal batch name per user

    Production Journal used Item Journal Line table in the back end so you can create different batches for Prod. Orde Template.

    If you run the Production Journal from Production Order from BC UI then it should create separate batch per userid automatically if I remember correctly.

    pastedimage1681395650459v1.png 

    pastedimage1681395908454v1.png

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans