erp | Freedom ERP | Portal library

Here is my code:

We process M940 bankstatements in our ERP-system but the bank does not provide the statement number in the file (it always states 00001/00001) so I want to put the statement-date where the statement number should be. Each statement has a statement number preceded with code :28C: and a statement date in a line that starts with :60F: such as below.

:28C:00001/00001
:60F:C220315EUR140379,24
:28C:00001/00001
:60F:C220316EUR440379,24

How can I get Powershell to change 00001/00001 into the date coming from the :60F: line right after it? In the real thing there are lines with codes before :28C: and after :60F: and maybe even other codes in between. However, there will always be a :60:-line with the date after a :28C: line.

:28C:220315
:60F:C220315EUR140379,24
:28C:220316
:60F:C220316EUR440579,58

I already have created some powershell script that adds other neccessary substrings and moves it to a directory depending on the bankaccount mentioned in the file but that part of the script is not relevant for this question therefore not stated here.

I would already be very happy with a link that pushes me in the right direction.

Hello everyone yesterday ı try to do Save Excel Row Via Vba Loop, now my problem is give hyplinks that file via macro. I try to explain in photo and my codes are below

My test dataset

I am trying to find only one occurrence for each customer.

However, in my database I have customers that have been added twice (following an ERP migration)

Currently,

If I try to find a customer that has two occurrences, I have to keep the customer that has a 'C' in the "customer_id" column

In this example we have "Manu Johns" who appears 2x so we must keep the one who has a 'C' in the customer_id column in the final table.

If I only find one occurrence of this customer. But, which does not have a 'C' in the customer_id column. We have to add it as is in the final table

In this example we have "Mathieu Wainers" which appears only once we keep it as it is in the final table

Which query would allow me to have this result : https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=9484f43c0a6c1ccdae7d659ca53e1eab

I have some raw data exported from my ERP. Most of the data has two decimals, but there are a few lines contain numbers with three or more decimal places... When summing up all data with powershell I have a 0,01€ discrepancy between my ERP PDF report and sum of exported data. I tracked the discrepancy to a single number - 2.205. Powershell rounds this number to 2.2 not 2.21 as expected. If I try any other number - 2.215, 2.225 they all get rounded to 2.22, 2.23..

Why is 2.205 not treated the same???

My application upload a list of components into our ERP. The upload process can take 1 or 2 minutes. I would like to notify in real time the user what is going on.

I created a blazor server app. I have the razor page with some UI logics but I didn't want to put all the processing logic inside the razor page. So I put it into a worker.

How the worker can push notification to the blazor component ?

I red about SignalR, but they are mostly about blazor webassembly or too basic for me to see how I can apply it to my situation.

I was wondering what is the good approach ?

This is my first time trying to CI to Google Cloud from Gitlab, so far has been this journey very painful, but I think I'm closer.

I follow some instructions from:

https://medium.com/google-cloud/deploy-to-cloud-run-using-gitlab-ci-e056685b8eeb

and I change to my needs the .gitlab-ci and the cloudbuild.yaml

After several tryouts, I finally manage to set all the Roles, Permissions and Service Accounts. But no luck building my docker file into the Container Registry or Artifact.

this is my failure log from gitlab log:

Good Day Developers!

I'm facing issue in JSON object received from MVC controller to AJAX success request.

The response which received is below.