71
For each customer (vendor), one card is usually defined within the system. Each customer/vendor card can be linked with a customer/vendor posting group which means with one receivables (payables) G/L account. It is a frequent case that receivables (payables) amounts of a customer (vendor) should be posted to different G/L accounts, depending on a business transaction type. e.g payables (receivables) due to current operations and paid deposits. It should be possible, to have such possibility and be able to change customer/vendor posting group per transaction.

Functionality allowing to use different customer/vendor posting groups when posting to one customer/vendor card was part of so called "EAST" regional layer for Eastern European countries for NAV versions 5.0 SP1 FP1 and 2009 (and in some cases later ones). A lot of Eastern Europe localizations still have such or similar functionality as it's deemed to be critically required by customers.

This worked that way that that is assigned to the customer (vendor) card was actually a default posting group and where copied to all documents. However, the user could change the group while entering a document, without changing a default customer (vendor) posting group in a relevant card. Possibility to change posting group was limited to list of possible "substitutes" of default posting groups, so it was easy to control, that change was done within allowed boundaries.
STATUS DETAILS
Completed
Ideas Administrator

Thank you for your valuable feedback. We have decided to deliver this idea and make it available with Business Central 2023 release wave 2.  

You can now use different G/L accounts for payables and receivables transactions.

Learn more about what's new and planned for Use different G/L accounts for payables and receivables transactions in the release plan here: https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave2/smb/dynamics365-business-central/use-different-general-ledger-accounts-payables-receivables

Your help was greatly appreciated,  
Business Central Team


Comments

T

I do not agree with this functionality. I would like to suggest that for specific Posting Groups (such Customer, Vendor, Banking, Inventory, Fixed Assets). Once a posting has been done, the system should block you when you are trying to post to another GL account. The problem could raise that your subledgers (example Customer Ledger Entries - AR Aging) doesn't match the GL accounts - Accounts Receivable.

I would suggest to have at least the option in the setup to choose that you want to avoid, to post to multiple posting groups on a customer, vendor, bank, inventory and fixed asset.

The "centralized" gl accounts should also been setup "Direct Posting = No"

In order to guarantee the data compliance

Category: Financial Management

T

This has been asked from me by 3 different Customers during past 4 months.
This is actually a requirement by law (for fixed assets purchases there is a requirement to show debt to vendor in another G/L account.

Adding Customer/Vendor posting group to Sales/Purchase invoice is easy (just Page extension needed) BUT posting to correct G/L Account when that invoice is paid or applied to is VERY BIG ..and currently unsolved work.

So when applying an invoice the system should look for Customer/Vendor posting group that WAS USED when an invoice was first posted.

Category: Financial Management