Finance | Project Operations, Human Resources, ...

how to get custInvoiceJour when invoice is posted?

(0) Share

Report

Posted on by BASMA

932

I want to attach file to invoice so :

1. I add new field in salesparmTable

2.I add this field in salesEditLines form :

3.When I click on button ok and checkBox"Archiver doc" =yes :

4.then when I post invoice I don't find the attach file in account receivable > invoices > invoice journal :

this is my code :

[FormControlEventHandler(formControlStr(SalesEditLines, OK), FormControlEventType::Clicked)]
    public static void OK_OnClicked(FormControl sender, FormControlEventArgs e)
    {
        AsciiStreamIo                                   file;
        Array                                           fileLines;
        FileUploadTemporaryStorageResult                fileUpload;
        CustInvoiceJour   custInvoiceJour;
        DocuType          docuType;
        DocuRef           docuRef;
        DocuValue         docValue;
        FormCommandButtonControl  callerButton = sender as FormCommandButtonControl;  //Retrieves the button
        FormRun form = sender.formRun(); //Gets the running form
        //Get the salesParmTable datasource that was selected in  form
        FormDataSource salesParmTable_ds = form.dataSource(formDataSourceStr(SalesEditLines, SalesParmTable)) as FormDataSource;
        SalesParmTable salesParmTable = salesParmTable_ds.cursor();
            
        Info(strFmt("account: %1, check: %2 ",salesParmTable.InvoiceAccount,salesParmTable.ILBArchiveDoc));
        select * from custInvoiceJour where custInvoiceJour.InvoiceAccount==salesParmTable.InvoiceAccount && custInvoiceJour.SalesId==salesParmTable.SalesId;
        Info(strFmt("recId: %1 ",custInvoiceJour.RecId));
        if( salesParmTable.ILBArchiveDoc == NoYes::Yes )
        {
            fileUpload = file::GetFileFromUser() as FileUploadTemporaryStorageResult;
            Info(strFmt("nom du fichier %1",fileUpload.getFileName()));
            Info("good");
            ttsbegin;
            docValue.clear();
            docValue.FileName = fileUpload.getFileName();
            docValue.FileType = docuType.TypeId;
            docValue.insert();
            Info(strFmt("docValue %1",docValue.RecId));
            docuRef.clear();
            docuRef.RefCompanyId = custInvoiceJour.dataAreaId;
            docuRef.ValueRecId = docValue.RecId;
            docuRef.RefTableId = custInvoiceJour.TableId;
            docuRef.RefRecId = custInvoiceJour.RecId;
            docuRef.Name = 'Automatic file  for sales order 001512';
            docuRef.Notes = 'Added from X   by baw';
            docuRef.insert();
            ttscommit;
            info("Document note has been added successfully");
        }
        
    }

I have the same question (0)

All responses (16)

Answers (0)

BASMA 932 on at

Like (0)

Report

have any idea about this?

Was this reply helpful? Yes No
Anton Venter 20,345 Super User 2025 Season 2 on at

Like (0)

Report

Hi Basma,

Your code is executed before the CustInvoiceJour record is created. Investigate and find a place to extend with your code after the CustInvoiceJour record has been created when posting. You will have to do this because it will take some time to figure it out.

Was this reply helpful? Yes No
Alex VN 1,994 on at

Like (1)

Report

Hi,

I think you are using onclicked event of the ok button but clicked the Ok button does not mean that you will get a CustInvoiceJour as there is other validation and actions need to be done before the invoice is posted.

Hence I think you might need to check for the code when the CustInvoiceJour record is created and hook on the event after that.

Regards,

Anh Ong

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

Hello, thanks for reply ,

I don't find exactly when the CustInvoiceJour record is created

how to hook on the event after?

Was this reply helpful? Yes No
Alex VN 1,994 on at

Like (0)

Report

Hi,

I think for this one, the most simple place is Insert method on CustInvoiceJour table. You might also refer to SalesInvoiceJournalCreate & SalesInvoiceJournalPost.

Hope this helps.

Regards,

Anh Ong

Was this reply helpful? Yes No
Suggested answer

Suresh M. Parmar 340 on at

Like (0)

Report

Hello Basma,

As I have seen the requirement you are attaching the document at the time of invoicing. The attachment can be done after posting the invoice, that's standard functionality.

If you are really want to use it at the time of invoicing then you need to call your code after invoice post only.

What if the user wants to add multiple attachments or delete unwanted documents which are uploaded by mistake?

Thanks,

Suresh Parmar

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

The standard e-invoice feature can create the attachment out of the box without having to code something.

Please have a look at this feature.

Best regards,

Ludwig

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

Thanks for reply ,

@Ludwig Reinhard, I Have idea about e-invoice , but it's a task affected to me to code automatic attach after the invoice is posted.

@Suresh Parmar, when the user wants to add multiple attachments or delete unwanted documents which are uploaded by mistake he can do it manually.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
I create an extension of table custInvoiceJour like this :

[ExtensionOf(tablestr(CustInvoiceJour))] final class ILBCustInvoiceJour_Extension { public void insert() { next insert(); } }

but I haven't any idea to pass datasource to class extension because I need a field from one datasource.

this is the code that I set it in onclicked enventhandler :

public static void OK_OnClicked(FormControl sender, FormControlEventArgs e) { FormCommandButtonControl callerButton = sender as FormCommandButtonControl; //Retrieves the button FormRun form = sender.formRun(); //Gets the running form //Get the salesParmTable datasource that was selected in form FormDataSource salesParmTable_ds = form.dataSource(formDataSourceStr(SalesEditLines, SalesParmTable)) as FormDataSource; SalesParmTable salesParmTable = salesParmTable_ds.cursor(); }

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Hello ,

I create an extension of table custInvoiceJour :

then I use COC and set my code after next insert() like this :

public void insert() { next insert(); SalesParmTable salesparmTable; DocuType docuType; DocuRef docuRef; DocuValue docValue; select * from salesparmTable where salesparmTable.InvoiceAccount == this.InvoiceAccount && salesParmTable.SalesId == this.SalesId && salesParmTable.Ordering == DocumentStatus::Invoice; Info(strFmt("account %1, salesId %2, archive doc %3 ",salesparmTable.InvoiceAccount ,salesparmTable.SalesId, salesparmTable.ILBArchiveDoc)); select * from docuType where docuType.ILBAutoArchive==NoYes::Yes; if(docuType && salesParmTable.ILBArchiveDoc == NoYes::Yes ) { AsciiStreamIo file; FileUploadTemporaryStorageResult fileUpload; fileUpload = file::GetFileFromUser() as FileUploadTemporaryStorageResult; //Info(strFmt("nom du fichier %1",fileUpload.getFileName())); ttsbegin; docValue.clear(); docValue.FileName = fileUpload.getFileName(); docValue.FileType = docuType.TypeId; docValue.insert(); Info(strFmt("docValue %1",docValue.RecId)); docuRef.clear(); docuRef.RefCompanyId = this.dataAreaId; docuRef.ValueRecId = docValue.RecId; docuRef.RefTableId = this.TableId; docuRef.RefRecId = this.RecId; docuRef.TypeId = docuType.TypeId; docuRef.Name = 'Automatic file for sales order added by baw'; docuRef.Notes = 'Added from X '; docuRef.insert(); ttscommit; info("Document note has been added successfully"); } else if (!docuType && salesParmTable.ILBArchiveDoc == NoYes::Yes) { error("Erreur du paramétrage d’archivage"); } }

When I execute this code I get the following message error :

"Stack trace: Cannot run form on non interactive session."

Was this reply helpful? Yes No