web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Mapping Item Cards to ...
Small and medium business | Business Central, N...
Suggested answer

Mapping Item Cards to G/L Accounts

(0) ShareShare
ReportReport
Posted on by Jk49 80

Good morning. 

We use Item Cards at my organisation; is there a way that i can run a report that shows which G/L accounts are posted against when an Item Card is used?  I am currently looking at the "gen production posting group", which seems to suggest I have to look at each item card individually, rather than being able to run off a master list?

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Shekhar Khatri Profile Picture
    Shekhar Khatri 30 on at
    RE: Mapping Item Cards to G/L Accounts

    Hi,

    You can personalise pages in Business Central to show/hide/arrange fields in the page. You can do the same with the Items list page to add Gen Prod Posting Group field to see the values in the master list.

  • Cbmag33 Profile Picture
    Cbmag33 69 on at
    RE: Mapping Item Cards to G/L Accounts

    Hi,

    Use a configuration Package to Export Items to an Excel Spreadsheet. Using Excel spreadsheet you can sort the Items to have the "like" G/L Accounts together. Using the Gen. Product Posting Group (GPPG) List you can enter the GPPG Code in the field (column) and copy to all Items with same G/L Account.

    Once all of the Items have the GPPG entered. Save the spreadsheet. Using the Configuration Package, import the Excel Spreadsheet to 365 BC.

    I hope this helps. If you need help with this, there are several good YouTube videos on using Configuration packages.

    Chris Ballard

    chris.ballard@bystronic.com

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,282 on at
    RE: Mapping Item Cards to G/L Accounts

    hi

    yes that's right

    or you should get an apersonalisation from your partner to build a report that does what you want it to do

    DAniele

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 2,856

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,681 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,342 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans