Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Generate check numbers with ER configuration on Method of payments.

(0) ShareShare
ReportReport
Posted on by 20

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

pastedimage1674521034133v1.png 

ER config

pastedimage1674521303436v3.png

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.

pastedimage1674521154514v2.png

Anyway to configure this dialog box in ER

  • 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'?

    pastedimage1674593958170v2.png

    pastedimage1674594446229v3.png

  • Suggested answer
    Arcadi  Profile Picture
    Arcadi 786 on at
    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:

    pastedimage1674567513850v2.png

    map it to the destination (import)

    pastedimage1674567573788v3.png

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

    pastedimage1674567653039v4.png

    Add the bankchequetable  in the destination:

    pastedimage1674567780353v6.png

    bind them (you may need more fields):

    pastedimage1674567858931v7.png

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

    pastedimage1674567204633v1.png

    Add the import definition

    pastedimage1674567932152v8.png

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

    pastedimage1674567994629v9.png

  • 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?

  • Suggested answer
    Arcadi  Profile Picture
    Arcadi 786 on at
    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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans