Sales Credit Memo/Purchase Credit Meno

Markandey_Pandey · 2009-12-28

Hi all,

I am using Sales Credit Memo and Purchase Credit Memo for cancelling Sales Invoices and purchase invoices respectively.

Here what is want is, the reason code that i am selecting on Sales Credit memo should get updated on Posted Sales Invoice when i am posting the Sales Credit memo.

Can anybody tell me the solution.

Savatage · 2009-12-28

You'll have to use code to do that.

Hopefully what you are doing is applying the credit memo's to their Invoices.
So if you have to in the future figure out how that invoice was closed you will be able to navigate to the applies entry and see that it was a credit memo and look at that credit memo to see the reason code.

You can also enter info into the Invoices Notes/Comments about what is goin on with that invoice

Markandey_Pandey · 2009-12-29

Any help on how to get the referenced Posted Invoice No.

chengalasettyvsrao · 2009-12-29

at the time of posting the creditmemo - > Just selct the field in the application tab.

Applies - to Doc Type , Applies -to Doc No.

when posted credit memo - > Invocing tab - > Applies - to Doc Type , Applies -to Doc No.

Markandey_Pandey · 2009-12-29

chengalasettyvsrao wrote:

at the time of posting the creditmemo - > Just selct the field in the application tab.

Applies - to Doc Type , Applies -to Doc No.

when posted credit memo - > Invocing tab - > Applies - to Doc Type , Applies -to Doc No.

Thanx, i got it.

Markandey_Pandey · 2009-12-29

Hi all,

I have written the following code for updating the Reason Code of Posted Invoices on OnPush trigger of Post Button of Sales Credit memo but its not working:

SalesInvHeader.RESET;
SalesInvHeader.SETRANGE(SalesInvHeader."No.","Applies-to Doc. No.");
IF(SalesInvHeader.FIND('-')) THEN
SalesInvHeader."Reason Code":=SalesHeader."Reason Code";
SalesInvHeader.MODIFY;

can anybody suggest me the solution.

ssingla · 2009-12-29

Check whether the client license has the permission to Sales Invoice Header table.

ssingla · 2009-12-29

Use GET Statement instead of setrange and find('-')

mkpjsr · 2009-12-29

ssingla wrote:

Use GET Statement instead of setrange and find('-')

i have tried that also

SalesInvHeader.GET("Applies-to Doc. No.");
SalesInvHeader."Reason Code":=SalesHeader."Reason Code";
SalesInvHeader.MODIFY;

Savatage · 2009-12-29

you should change your code a bit for testing like this with an if statement "just in case" so the code doesn't crash

if SalesInvHeader.GET("Applies-to Doc. No.") then begin
SalesInvHeader."Reason Code":=SalesHeader."Reason Code";
SalesInvHeader.MODIFY;
end else begin
message('doc not found');
end;

But as above, the first issue I see is that the Sales Invoice Header is usually not editable
I have to add the editable field to CU391 in my version.

Markandey_Pandey · 2009-12-30

Savatage wrote:

you should change your code a bit for testing like this with an if statement "just in case" so the code doesn't crash

if SalesInvHeader.GET("Applies-to Doc. No.") then begin
SalesInvHeader."Reason Code":=SalesHeader."Reason Code";
SalesInvHeader.MODIFY;
end else begin
message('doc not found');
end;

But as above, the first issue I see is that the Sales Invoice Header is usually not editable
I have to add the editable field to CU391 in my version.

Here SalesInvHeader is a variable of Record Type (Subtype- Sales Invoice Header)
and all the fields of the table is editable.
But Reason Code is not getting updated, i have tried your code also

idiot · 2009-12-30

This field has Tablerelation to Reason Code

ssingla · 2009-12-30

Run the debugger and check whether your code is getting executed or not?

Where have you put your code and how it is getting fired?

Sales Credit Memo/Purchase Credit Meno

Comments

Categories