Finance | Project Operations, Human Resources, ...

legder account need to update in PO product receipt in AX 2012 R3

(0) Share

Report

Posted on by @rp@n

hi all,

PO- Product receipt

I have created a PO. Confirmed and then Product receipt. It is done

Product receipt journal - Voucher -

3187.J1.jpg

In the place of ledger account 135101 , I wants to update to ledger account 135018

To do this , I wrote in below class and method

Class - PurchPackingSlipJournalPost

Method - UpdateJournalLine

purchTables = PurchTable::find(purchTable.PurchId);

    if(purchTables.MiscPurchaseOrder == NoYes::Yes)
    {
        markupTables = MarkupTable::find(purchTables.ModuleType, purchTables.MarkupCode);

        if (PurchParameters::find().MiscPO== NoYes::Yes)
        {
            ledgerDimensionMerged = DimensionDefaultingService::serviceCreateLedgerDimension(markupTables.VendorLedgerDimension, purchTables.DefaultDimension);
        }
        else
        {
            ledgerDimensionMerged = DimensionDefaultingService::serviceCreateLedgerDimension(markupTables.VendorLedgerDimension);//, this.defaultDimension());
        }
    }
    else
    {
        ledgerDimensionMerged = DimensionDefaultingService::serviceCreateLedgerDimension(formletterProvider.ledgerDimensionLineAmount());//, this.defaultDimension());
    }

It is not showing the ledger account 135018 but in Markup table it is showing the ledger account 135018 and also I passed parameter

ledgerDimensionMerged = DimensionDefaultingService::serviceCreateLedgerDimension(markupTables.VendorLedgerDimension, purchTables.DefaultDimension);

Still it is showing ledger account 135101 after PO product receipt.

Is my above class , method and code is correct ?

Kindly let me know how to achieve this.

Please give me more shed on this.

thanks!

I have the same question (0)

All responses (14)

Answers (0)

Sort by

@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

can anyone help me on this please

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @rp@n,

I would recommend that you make a manual ledger adjustment for your account 135101.

Trying to manipulate the data by code might not only result in technical issues with the valuation and pricing of your item but also your auditors might make problems.

What stops you from posting a manual correction transaction e.g. in a GL journal?

Best regards,

Ludwig

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Sorry Ludwig, not understand.

Kindly elaborate please

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rp@n,

You cannot simply adjust and change a purchase price variance transaction this way.

This might create a mess in inventory valuation and accounting.

Please talk with your colleagues who recorded the transaction and ask them to correct it via the user interface, i.e. in the AX2012 R3 without applying any code.

Best regards,

Ludwig

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ludwig,

As you said "You cannot simply adjust and change a purchase price variance transaction this way".

You mean to say is it impossible?

Please give me more shed on this

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Is it impossible to do through code , which i am trying to achieve? Is it only possible through manual?

Kindly elaborate me please

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Kindly elaborate me please whether its possible or not through code.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Good morning @rp@n,

With making a code adjustment almost everything is possible.

Yet, I would consider this (a) as illegal from an accounting / auditing perspective and (b) risky, as it might mess up your inventory valuations and result in subsequent issues that require additional corrections.

Your accounting colleagues can make a manual correction in the AX client and I would recommend that you reach out to them and ask them to make this manual adjustment.

Best regards,

Ludwig

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ludwig for your quick response.

This is new requirement from customer . So, I am working on this.

Anyhow I have to do this.

As technical view, is my code is correct ? And the class and method? Which I mentioned above

Please give me more shed on this

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!
Ludwig,

I have also done code in

Class - InventoryMovement

Method - UpdateLedgerAdjust

if (this.mustBeBookedOperations()) { purchLine = buffer as PurchLine; purchTable = PurchTable::find(purchLine.PurchId); markupTable = MarkupTable::find(purchTable.ModuleType, purchTable.MarkupCode); if(purchTable.MiscPurchaseOrder == NoYes::Yes) { ledgerVoucherTransObject = LedgerVoucherTransObject::newTransactionAmountDefault( ledgerVoucherObject, this.postingOperations(), DimensionDefaultingService::serviceCreateLedgerDimension( markupTable.VendorLedgerDimension, (PurchParameters::find().MiscPO == NoYes::Yes && !PurchTable.IsLRCChargeCode(purchTable.HCLMarkupCode))? purchTable.DefaultDimension : this.defaultDimension()), CompanyInfo::standardCurrency(), -_costAmount, currencyExchHelper); } else { ledgerVoucherTransObject = LedgerVoucherTransObject::newTransactionAmountDefault( ledgerVoucherObject, this.postingOperations(), DimensionDefaultingService::serviceCreateLedgerDimension(this.accountOperations(),this.defaultDimension()), CompanyInfo::standardCurrency(), -_costAmount, currencyExchHelper); } }

Please give me more shed on this.

Was this reply helpful? Yes No