Small and medium business | Business Central, N...

Mapping Item Cards to G/L Accounts

(0) Share

Report

Posted on by Jk49

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

All responses (3)

Answers (0)

Shekhar Khatri 30 on at

Like (0)

Report

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 69 on at

Like (0)

Report

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 9,274 Moderator on at

Like (0)

Report

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