Custom mod for posting

(0) Share

Report

Posted on by Community Member

Hi,

I am making a solution for subscription to be get into GL account over different periods. This is 2013 verision, and i noticed they have built it in the newer versions of NAV.

I have created a codeunit that creates a General Journal and fill lines up and post it. It works fine - but I am in question were to put this function to trigger.

The functions have following parameters - Amount (from sales line), Date(for when posting should start), Period(over how many months). Maybe information from header would be nice aswell so i can write the invoice no. in the description.

When the client is making a sale they are using G/L Account - 01325, So i am only interrested in when they make a sales with type GL Acc.

I have looked at codeunit 80 - it seemed like a good place to add my function, but there are many thousands of lines to place it. Do you have any suggestions?

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

You can add the code after posting customer entries, search for Post customer Entry, try to add the code after the line

PostICGeenJnl.

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

Hello Christopher,

You can call your custom CodeUnit after posting of Balance Entry in Balance Account.

Please search for "PostBalanceEntry" function in Invoicing and call your CU from there in Sales-Post CU.

-Yogesh Kulkarni

Please verify, if you find answer helpful.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Suresh Kulla thanks. I have insertet my code where you suggested. My code looks like this where i insertet it after the PostICGenJnl.

IF Invoice THEN IF "Document Type" IN ["Document Type"::Order,"Document Type"::Invoice] THEN BEGIN CASE SalesLine.Type OF SalesLine.Type::"G/L Account": IF (SalesLine."No." <> '') AND NOT SalesLine."System-Created Entry" THEN BEGIN CollTypeMeMa.SETRANGE(CollTypeMeMa."G/L Account",SalesLine."No."); IF CollTypeMeMa.FINDFIRST THEN BEGIN CHOCU.Foo(SalesHeader."External Document No.",SalesLine."Amount Including VAT",SalesLine."From date",12,SalesLine."No.",CollTypeMeMa."Period Account",'01325'); END; END; END; END;

]

I get this error and understand why it happens, but can I get around it without using a COMMIT?

Thanks in advance

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report
What is the code it is executing in this function

CHOCU.Foo

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

http://pastebin.com/GZF6gVyr

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

In your code you are using TryGetNextNo of NoSeriesMgt which is causing that error try to use GetNextNo function instead of TryGetNextNo function and hopefully that should solve your issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks @Suresh Kulla it works.

Was this reply helpful? Yes No