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

Posting the same item to different purchasing accounts

(0) Share

Report

Posted on by Mark Fried

Hi,

I am looking for a solution for a client, they are currently using multiple items for each product in order to direct the costs to different purchasing accounts for each item per department.

I am looking for a solution that will enable them to use one item per product. They do not want to use dimensions as a solution for this particular issue.

Does anyone know of a standard or custom solution for this?

Many thanks,

Mark

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

There is no standard solution for this scenario. And the use of dimensions are the obvious answer to this request.

A work around could be to have one vendor per department but that comes with some other perks as well i guess.

If they where my customer i think i would go another round with them and try to convince them of using some kind of dimension for this.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, how about use Item Variants?

More details: https://www.inecta.com/item-variant-sell-by-colors-in-microsoft-dynamics-nav-2015

And there is a Average Cost Calc. Type(Item, Variant, and Location) in the Inventory Setup.

https://docs.microsoft.com/en-us/dynamics-nav-app/design-details-average-cost#setting-up-average-cost-calculation

Hope this info helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Mark,

A little curious why a different purchasing account for an Item when the the Purchasing Account (Posting Group Setup) should be offset by the Direct Cost Applied account (General Posting Setup). The Item, on the Balance Sheet, when sold, will record the COGS to whatever is defined by the Gen. Prod. Posting Group and Ge. Bus. Posting Group combinations and that is the proper setup. If you are trying to expand Item reporting, then I always setup Dimensions for Product Lines/Types (for example).

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No