Generate check numbers with ER configuration on Method of payments.

(0) Share

Report

Posted on by D365FOAdvancedUser

Hi All

I am able to generate check number using standard format. Has anyone tried to generate check numbers using ER format configuration.

Standard check

ER config

If I discard the standard and generate through ER, system generates the file without check number. Is there a particular configuration in ER so that it gives check number dialog box before generating the file?

Standard check gives below dialog. However, ER do not give that.

Anyway to configure this dialog box in ER

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Arcadi 794 on at

Like (0)

Report

RE: Generate check numbers with ER configuration on Method of payments.

That's kinda easy with new ER updates, you can create a user input field, make it non editable and with a default value.

For the default value you need the table BankPromissoryNoteTable (the table, not the record table). Then in the user input field you add:

BankPromissoryNoteTable.'findNextFree()'("IDOFYOURBANK")

Edit: For check you have the BankChequeTable and the "findNextFree" static method

Was this reply helpful? Yes No
D365FOAdvancedUser 20 on at

Like (0)

Report

RE: Generate check numbers with ER configuration on Method of payments.

Hi Arcadi

Thank you for your response. I configured as you mentioned, and it is generating the next cheque number in the user input parameter.

This way I will be able to tell bank which cheque number should be printed next.

However the functionality is not working as expected. Say I generated the payment, it is not giving me a cheque number in the payment journal.

Standard export format, once payment generated, system updates which vendor is paid etc to the cheque table and update the status as 'paid'. This way user know which vendor is paid against a particular cheque number.

Did I miss something?

Was this reply helpful? Yes No
Suggested answer

Arcadi 794 on at

Like (0)

Report

RE: Generate check numbers with ER configuration on Method of payments.

Ok, what you are asking is a bit tricky but doable. You have to create the logic that the system does with code but with ER.

I don't know that exact logic, but I would think that the system modifies the registers from bankchequetable and marks them as send, maybe even updates fields like voucher and transdate. If you are not a programmer you should ask one what the system does.

In the format you must have a list of transactions (from the ledgerJournalTrans), each with a field with his checknumber, that's something you have calculated in the fly starting from the "next" that you got from the method.

Now you need a new model root in the same model you are using in the format. Something like:

map it to the destination (import)

In the designer and then the model mapping add it to the datasource:

Add the bankchequetable in the destination:

bind them (you may need more fields):

From here you need to create a "callback" in the format and select the import definition you've created:

Add the import definition

And bind them (I'm using a test format, you must have a record list)

Was this reply helpful? Yes No
D365FOAdvancedUser 20 on at

Like (0)

Report

RE: Generate check numbers with ER configuration on Method of payments.

Hi Arcadi

Thank you for your inputs. I am not a developer and will ask someone. It did not sound like something I will be able to do.

On a different note, I was thinking to use standard export format method of payment of 'check'. This will make check functionality work. Then in the check layout configuration, I select ER and give my file output. Is this achievable?

It did not work by using the same ER configuration based on payment model. System threw error that it cannot find 'Payments model'. If I give a format from Payment checks model' system is printing a check layout file. Believe it is not able to find the payment information from 'payment check model'.

Is it feasible to modify 'payments check model' and get the fields I see in 'payments model'?

Was this reply helpful? Yes No