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

G/L Purch. Prepayments Account does NOT import Posting Groups from item cards - Bug?

(5) Share

Report

Posted on by RM-01061504-0

In my environment, G/L accounts do not need fixed values for Posting Groups, rather those are imported from vendor cards and item cards (talking about purchsases here).

Now I've come across prepayments, where this useful principle is apparently broken:

When setting up a G/L Purch. Prepayments Account in the Posting Setup, postings will fail because the values for both Gen. Prod. Posting Group and VAT Prod. Posting Group are not being imported from the item cards in a PO. The postings will succeed only if I provide values for those Posting Groups within the setup for the G/L account.

Now, if one has to provide fixed values for Product Posting Groups in a G/L Purch. Prepayments Account, then this account will serve for only one Product Group / VAT-combination. Consequently, a plethora of different G/L Purch. Prepayment Accounts would be required, one for each combination of Product Group and VAT-rate (in case you want to inlcude it in prepayments).

That seems not a reasonable approach (and differs from how Bus. Posting Groups are being imported from vendor cards within prepayments).

Is this a bug?

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

Some images to illustrate the problem:

After setting up a Purch. Prepayments Account, first, the VAT Prod. Posting Group is reported missing

(or in other words, not being imported from the item card, where it has been defined);

note, that the VAT Bus. Posting Group (from the vendor card) has been imported...

if you put a value for the VAT Prod. Posting Group into the G/L Purch. Prepayments Account definition, then the Gen. Prod. Posting Group is missing...

A prepayment purchase posting will not succeed until the G/L Purch. Prepayments Account contains fixed values for both Product Posting Groups:

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

RM-01061504-0 34 on at

Like (2)

Report
I thought about some feasible way to address this gap...

while different VAT rates can't be circumvented, one could possibly avoid prepayments accounts for each Product Posting Group:

create a new Product Posting Group "PREPAY" - only for the purpose of prepayments

for each VAT rate in use, create one Purch. Prepayments Account in G/L

for each of the Purch. Prepayments Accounts

set its Gen. Prod. Posting Group value to PREPAY

set its VAT Prod. Posting Group to the respective VAT Posting Group values you want to cover

This would mean however, that the prepayments posting is done using the Prod. Posting Group PREPAY while the actual payments posting later on will use the Prod. Posting Group from the item card... could work however. I'll give it a try.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (1)

Report

There is no way to do this because your line type is G/L Account and you must set these two options before you can post.

And there is nothing wrong with your solution. Creating a virtual item is also a method.

Thanks.

ZHU

Was this reply helpful? Yes No
RM-01061504-0 34 on at

Like (1)

Report

>> There is no way to do this because your line type is G/L Account and you must set these two options before you can post.

What I see in my environment does not back up this generic assumption:

1. Item card information is being used for posting - but not in Prepayments

Only the G/L account defined for Purch. Prepayments does not take over Gen. Prod. Posting Group and VAT Prod. Posting Group from item cards during posting; rather, fixed pre-defined values are required within this specific G/L account definition.

2. Vendor card information is being used for posting - always

All G/L accounts (including the one defined for Purch. Prepayments) in the Posting Setup do take over values for Gen. Bus. Posting Group and VAT Bus. Posting Group during posting from the vendor card.

In summary:

Using G/L accounts in Posting Setups for purchases does work dynamically, using Posting Group information from item cards and vendor cards - with one exception: Prepayments do not use Posting Group information from item cards...

To me it appears as if someone missed a process step here.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (1)

Report

Hope this might be helpful:

The G/L Purch. Prepayments Account (when used as a G/L Account line type) cannot import Product Posting Groups from Item Cards; this is by design, not a bug.

You must set these posting groups directly in the G/L Prepayments Account setup.

Workaround: Create a "virtual item" (e.g., service type) for prepayments, set the product posting groups on it, and use this item on purchase lines.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
RM-01061504-0 34 on at

Like (0)

Report

Thx both for the confirmation of my observation-

To close the discussion, here's my view on this:

If a "design" can't be used reasonably other than by applying a workaround, then it's a rather poor design.

(and referring to "reasonably": without the workaround, each and every Product Group will need one separate G/L account per VAT rate if used in prepayments, e.g. 10 Product Groups and 3 VAT rates would lead to 30 different prepayments accounts in the G/L... to me, this simply doesn't look reasonable, given the fact that the G/L among other purposes should provide a comprehensible overview of the business situation for outside viewers like investors or finance authorities.)

Was this reply helpful? Yes No

Join the conversation

Community site session details

G/L Purch. Prepayments Account does NOT import Posting Groups from item cards - Bug?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

G/L Purch. Prepayments Account does NOT import Posting Groups from item cards - Bug?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates