Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

How to get item posting ledger account based on stocked or not (Item model group) ?

(0) ShareShare
ReportReport
Posted on by 516
Hi guys,
 
I'm looking on a way to get item posting's ledger account. Based on my research, I'm trying to use this function :
 
 
               LedgerDimensionAccount  ledgerDimensionAccount;
               InventPosting           inventPosting;
               InventPostingItemLedgerDimensionParameters searchParameter;
               InventTable   inventTable = InventTable::findByProduct('xyz');            
 
               while select inventPosting group by InventAccountType
               {                 {
                    searchParameter         =  InventPostingItemLedgerDimensionParameters::newFromParameters(inventPosting.InventAccountType, inventTable.ItemId);
                    ledgerDimensionAccount  = InventPosting::itemLedgerDimensionFromParameter(searchParameter);
 
                    .
                    .
                }
 
 
Looking at the searchParameters, especially from the function /InventPostingItemLedgerDimensionParameters::newFromParameters(inventPosting.InventAccountType, inventTable.ItemId)/, I realized there is something missing for the parameter or mybe in the next function /InventPosting::itemLedgerDimensionFromParameter(searchParameter)/.
 
That in that function, we cannot differentiate or retrieve the correct ledgerDimensionAccount based on whether it is Stocked item or non stocked item. Since the parameters for the 1st statement only have these :
 
whereby Stocked or non stocked is handled in Item Model Group.
 
Meaning if my item posting have setup both posting account type of /Purchase expenditure for product/ and /Purchase expenditure for expense/, it can be wrongly retrieve incorrect ledger account. Unless I have to do some manual condition addition in my code.
 
Is there any other function for that /Search parameter/ or something else to use that looking at the item is stocked or not to correctly get the ledger account ?
 
Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans