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

production journal batch name per user

(0) Share

Report

Posted on by bert L

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

All responses (8)

Answers (0)

MetaKa on at

Like (0)

Report

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

Like (0)

Report

RE: production journal batch name per user

Hi Daniele,

The page production control does not exist in Business Central.

Thanks anyway!

Bert
bert L 85 on at

Like (0)

Report

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

Like (0)

Report

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

Like (0)

Report

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 32,748 Super User 2024 Season 1 on at

Like (0)

Report

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 9,272 Super User 2024 Season 1 on at

Like (0)

Report

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 59,194 Super User 2024 Season 2 on at

Like (0)

Report

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.