Microsoft Dynamics AX (Archived)

RESOLVED (workaround or sp hotfix, The Netherlands): No clieop file generated for Function -> 'Generate Payments'.

(0) Share

Report

Posted on by user5555

7,435

Summary for this thread:

1. Install SP or hotfix roll up ?

Or:

2. You need to change in GeneratePayments() of class: VendOutPaym_NLClieOp03:

   queryRun.reset();
        while (queryRun.next())
        {
            if (batchSerialNumber < 9999) // Max. number of batches
            {
                ledgerJournalTrans = queryRun.get(tablenum(LedgerJournalTrans));
/*                if (!this.parmBankAccountID()
                    ||( ledgerJournalTrans.OffsetAccount == this.parmBankAccountID()
                    && ledgerJournalTrans.OffsetAccountType == LedgerJournalACType::Bank))
*/
                 if (!this.parmBankAccountID()
                    || this.isOffsetAccountValid(ledgerJournalTrans))
                {
                    if (!ledgerJournalTrans.PaymSpec)
                    {
                        checkFailed(strfmt("@SYS54965", ledgerJournalTrans.Voucher,ledgerJournalTrans.PaymMode));
                        throw error("@SYS18447");
                    }
                    vendOutPaymRecord = CustVendOutPaymRecord::construct(ledgerJournalTrans.PaymMode,

You cannot compile this class in user layer. I believe you need developer license in you environment (Nice for MS and partners: NOT for customers). Work around for license policy:

I created an export project in my dev with full dev license and imported the file in my acceptance and then imported it after testing to production.

Thank you Dennis for your kind help in resolving this matter.

P.s. search gives also class 'CustOutPaym_NLClieOp03' which looks like a copy (OO design ???). This bug is suspect to multiple places in code due to bad OO design.

===Hi,

I have filled a payment journal with payment which must be done. I notice next:

Suggestions AX development team:

1. Invoice number clearly visible in the sublines of 'create payment proposal' so that selection is easier by invoice.
2. I wonder if my vendor account no and invoice can be generated automatically to the payment text of the bank ?
3. Bank account nummer is set to a bank account, but the number does not show up in the payment overview

However, I am not able to create a Clieop file which can be uploaded to my bank. It says: 0 records found. I toggles Payment Status to 'none' or 'sent', but still empty. What I also noted is that no bank account number and payment id are filled in the Payments overview. Is that the problem maybe?

Any help appreciated.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

spot 2,515 on at

Like (0)

Report

Re: No clieop file generated for Function -> 'Generate Payments'.

Hi

Cinfirm that in method of payments , file formats tab u attached the respective file format ass per u r bank

revert back for any clarifications

Was this reply helpful? Yes No
user5555 7,435 on at

Like (0)

Report

Re: Re: No clieop file generated for Function -> 'Generate Payments'.

Hi,

You mean in the setup? The file format is set per account type. In the generate payment you can also choose a file format, that does also not give any records for the output. If I look at the design different output formats can be generated. I think a function collects the data and then based on the output type formats it. I think in the 'collection' of data something is not setup properly.

Any more ideas?

J.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Re: Re: Re: No clieop file generated for Function -> 'Generate Payments'.

Hi J.

The reason that the ClieOp file has not been generated can be caused by many issues.

Did you setup the Method of Payment? (AP - Setup - Payment - Methods of payment). File format selected, payment specifications Bank/Giro properly setup.

Did you fill a bank account on the Vendor account and is it selected in the payment journal.

Is there a City mentioned in the VendTable record (originates from Primary address on vendor)

is the Payment method and specification mentioned on each line of the payment journal.

Did you create a company bank account and selected it on the companyInfo

Using transaction text (from Basic - Setup - TransactionTxt), select Vendor - Payment - Vendor (something like that), fill in "%2/", solves your issue about the invoice number not being available in the payment journal. After setting up and selecting the payment it will be visible in the Payment Notes field (tabpage Payment).

Feel free to give me a call 06-10385583 and I can probably help you out.

Kind regards,

Dennis

Was this reply helpful? Yes No
user5555 7,435 on at

Like (0)

Report

MS Suggestion/ debugging: No clieop file generated for Function -> 'Generate Payments'.

Dag Dennis,

I run through debugger since all issues you mention are done according to what I think. I think it has to do with offset not being defined well. I would like to understand better what the impact of it is either.

This piece of code makes that no records are created for formatting.

       if (!this.parmBankAccountID()
                    ||( ledgerJournalTrans.OffsetAccount == this.parmBankAccountID()
                    && ledgerJournalTrans.OffsetAccountType == LedgerJournalACType::Bank))
                {

First of all: MS Suggestion to avoid malfunctioning code: if my developers code like this they get this kind of feedback as well. Use of a temporary value in a if/then should be better.: local string paramBankAccountID = paramBankAccountID() and then use it in the function. The change is small it will occur, but better avoid then let/ make it happen.

       if (!(empty; I think this is AX way of syntax for checking if not empty string???) "BANK" ||( "2030" == "2030" && "Ledger" == LedgerJournalACType::Bank (Kind of syntax construct for "BANK" ????) ))

{

So this function fails on ledgerJournalTrans.OffsetAccountType == LedgerJournalACType::Bank

My question is : what to do with the Offset accountType ?

J.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: MS Suggestion/ debugging: No clieop file generated for Function -> 'Generate Payments'.

Hi Jelle,

I think this issue is solved with SP1 and/or Rollup 3 for AX2009. The code you are referring to is coming from the class VendOutPaym_NLClieOp03 method Generate PaymentLines.

In the syp layer the code is changed to:

" if (!this.parmBankAccountID()
|| this.isOffsetAccountValid(ledgerJournalTrans)) "

the method isOffsetAccountValid(ledgerJournalTrans) is called from the CustVendOutPaym class.

Good luck with the code.

Kind regards,

Dennis

Was this reply helpful? Yes No
user5555 7,435 on at

Like (0)

Report

Re: Re: MS Suggestion/ debugging: No clieop file generated for Function -> 'Generate Payments'.

Hi,

I am Business Ready so I can download the SP1/ Rollup 3 for AX2009 from customer source. Are there any know issues (new bugs/ issues) in this version which will cause other functionality not to work?

J.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: Re: MS Suggestion/ debugging: No clieop file generated for Function -> 'Generate Payments'.

Hi Jelle,

installing SP1 and rollup 3 is not something you can do without preparation. Are you a customer or MS Partner?

Installing SP1 and rollup 3 on a clean standard environment should not give problems, but if you have already customizations done in var, cus, usr layer than merging of code is required. If at this moment this is your only problem than I would recommend to only change this piece of code and not to install SP1 and rollup 3. Just change the code in the method of the class I mentioned earlier and run the generate payment function to see if the issue is resolved.

Kind regards,

Dennis

Was this reply helpful? Yes No
user5555 7,435 on at

Like (0)

Report

CONFIRMED BUG in No clieop file generated for Function -> 'Generate Payments'.

Hi Dennis,

I am a customer with broad background knowledge in ICT, marketing and R&D. We (myself + my collegue in Hangzhou China + persons I contract) build www.bbayt.com and have a demo shop with real life stock www.bzoox.nl. We did not want to build a webshop without experiencing ourselves what is required before launching a commercial version. I recommend any software builder or consultant (also AX team) to do the same. You get much better knowledge of what is required, what it should cost and what is best practice. The problem we currently face is that we bought AX out of the box with as least as possible changes (only report layouts, but I have seen the MS reports are maybe better than those offered by the partner, and less prune to merge conflicts), but the opposite is true. I really dislike to pay and pay for a standard system and therefore we are forcing ourselves to get more knowledge of AX and try to do most of ourselves. Also because we cannot afford the hour rates requested by any partner. We simply do not have huge budgets to get around of all bugs in AX.

Installing the fixes and the way the transport system (AOT) works is like SAP and requires tons of testers or automatic testing. However, this can also be avoided if the architecture is changed and/or integrated in a more highend debugger which allows for refactoring and right hand tooltips like Visual Studio. You can simply not see what the effect is of a code change and where it hooks in other code. Therefor I want to use a standard AX..I thought it would be bug free for the most common functions, but it seems it is not. We got hanging RMA's which cannot be deleted, nor posted. That really blows a way the TCO and I believe many firms hang with their head in a rope fueled by the partner system which does not feedback properly issues to MS. Thus like in Open Source I have decided to share my knowledge here and find people who are interested to help eachother. Not that Open Source is the way to go.

At the moment selling shoes (fashion) is not profitable. So we are thinking about new concepts. Also we want to sell our webshop. We did build www.tennisplanet.com fully integrated with Dynamics Navision in the past (real time multithreaded stock + order + customer data up/download). We created a new architecture which allows us to have a good normalized platform allowing others to build/ develop upon it. I am not sure yet if I got enough budget for it since marketing is biggest issue and also make it in such a way that little to zero support is required. That is only possible with a good product or a team catching up bugs immediately and rolling out bug fixes in a nightly build to all platforms.

We want to integrate AX with our platform more closely and offer our webshop to partners or customers of partners.

J.

Was this reply helpful? Yes No
user5555 7,435 on at

Like (0)

Report

Re: CONFIRMED BUG in No clieop file generated for Function -> 'Generate Payments'.

Hi,

I have changed the code, but the debugger does not step into my (compiled) change. I have the feeling I maybe need to compile at a higher level, but I cannot refactor to see which form calls this function? But would be weird, I only know that a compiler would also compile the top of the calling function stack.

Or is it that my change is not reflected since I am not a partner and this change is done in usr ?

J.

Was this reply helpful? Yes No
user5555 7,435 on at

Like (0)

Report

@MS AX team: CONFIRMED BUG in No clieop file generated for Function -> 'Generate Payments'.

@MS AX team:

It seem that in my development AOS I can compile and it works then without even doing any setting change. So this is a bug (even confirmed), but I cannot fix it in my production due to license restrictions? I have to contact and contract my partner to have this fixed and pay for this crap ? Who coded this? I am in my leasure time now: 23.35 hrs. It is your job to have this work properly from start. Not in a hotfix or sp. Generating a file and check its output is something you do with default units tests. You or AX team not? Not using Team Server?

Shall I calculated what this kind of code costs? I am one customer that is now busy three hours with this bug. Say a partner can do better: 2 hrs * 75 - 140 euro is 150 - 280 euro. Times the instances in use in The Netherlands? Maybe 150 - 500? = 22.500 euro - 140.000 euro. Say that the partners do this for free :-). Then even they would not be billable for those hours....and not even talking about your hotfix or sp release which we customers now need to do and pay for...calculate yourself how much effort and cost is involved for this crap. Or calculate the time needed to enter manually all payments to a bank since automatically it does not work?

Work around for license policy:

I created an export project called 'v4a-bugfixes' in my dev with full dev license and will import the file in my acceptance and then to production. I think somebody of the AX team forgot this. @MS: don't dare to check license policy on import in future releases to make this work around impossible.

J.

Was this reply helpful? Yes No