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

Notifications

Announcements

No record found.

News and Announcements icon
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)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    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

  • Cbmag33 Profile Picture
    Cbmag33 69 on at

    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

  • Shekhar Khatri Profile Picture
    Shekhar Khatri 30 on at

    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.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans