web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

production journal batch name per user

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    61,005 Super User 2025 Season 2 on at

    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

  • Suggested answer
    DAnny3211 Profile Picture
    11,397 on at

    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
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    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,.

  • AD-22040756-1 Profile Picture
    642 on at
    [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?

  • bert L Profile Picture
    85 on at

    Hi Mohana,

    Thanks for the help!

    I've managed to create the bachtes.

    Thanks,

    Bert

  • bert L Profile Picture
    85 on at

    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
    85 on at

    Hi Daniele,

    The page production control does not exist in Business Central.

    Thanks anyway!

    Bert

  • MetaKa Profile Picture
    on at

    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!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans