item, Item groups and Main Accounts used for Posting

(0) Share

Report

Posted on by Community Member

I would like to get a list from the system that will tell me which main account each item gets posted to at the Purchase Order level. I have tried going into the AOT and using InventPosting but it doesn't really give me what I want.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

André Arnaud de Cal... 305,849 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kchung,

Can you explain what you really are looking for? What was not useful for you?

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

I just want a list by item of what main account it is posted too when creating Purchase Orders. So for instance, item 7777777 gets posted to Main acct 1234.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kchung, You can check this e.g. by opening the released product page, selecting "manage cost" tab and then "posting". Hope it helps, Ludwig

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Yes I know of that one but I was hoping to not look up per item and would just like a list.

Thanks!

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Kchung,

You can check the item group window or the inventory posting form(inventory-setup-posting-posting) as an alternative. Yet, both forms look similar and do not provide you the Information in form of a list.

All the best,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,650 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

You can invoke "ledgerAccount" to ... \ DataDictionary \ PurchLine

indeed "ledgerAccount" is an INVENTPOSTING table column named LEDGERDIMENSION.

and after to access the MainAccount name, you can use ... \DataDictionary\Tables\InventPosting\Methods\accountItemLedgerDimension or below query;

--------------------

select main.* from DIMENSIONATTRIBUTEVALUECOMBINATION comb inner join MAINACCOUNT main on main.recid= comb.MAINACCOUNT

inner join INVENTPOSTING on INVENTPOSTING.LEDGERDIMENSION = comb.RECID where INVENTPOSTING.LEDGERDIMENSION ="ledgerAccount"

Was this reply helpful? Yes No