S2G 2/13/2025 2:40:11 PM

Inventory and Cogs won't populate for customized sales GL distribution

Hi folks,

Hopefully you can shed some light on an issue that i'm having

I've created a custom distribution for an ecommerce operation that we have, i'll show you what's is it about:

78-78-14-11050 > Receivable amount (What customer paid)
78-78-12-40200 > Sales: this is the revenue
78-78-00-25300 > Taxes, pretty straightforward (16% is the rate)
78-78-13-54004 > This is the marketplace commision for the sale
78-78-13-56255 > Freight




This is how the transaction was registered




Issue: When i post this transaction it won't calculate INV and COGS, therefore there's no cost registration, which is bad.

How can i make GP calculate INV and COGS?, i've noticed that the issue happened when i start adding the freight and the commission. I've tried to come up with the INV and COGS myself but it won't allow me to do it.

Cost in this case is 880.49



This transaction was made in functional currency.




Version: All
Section: .NET Development, Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3