web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Overriding Sales and C...
Business Central forum

Overriding Sales and COGS Account on Sales Invoice

(0) ShareShare
ReportReport
Posted on by SU-22040800-0 2,487

Is it possible to override the sales and cost-of-sales account (when selling an Item), on a Sales Invoice ?

Categories:
  • Verified answer
    Hannes Holst Profile Picture
    Hannes Holst 5,767 on at

    Hi,

    You must add the field "Gen. Bus. Posting Group" and "Gen. Prod. Posting Group" to the Sales Invoice line page.
    These posting groups define which Sales & COGS Account is used.

    Normally, the "Gen. Bus. Posting Group" comes from the Customer and "Gen. Prod. Posting Group" comes from the Item page.

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Thanks Hannes

    When i checked the personalization, i did not see those fields available.

    Am i missing something?

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    I went into DESIGN mode, and found the fields.

    Thanks

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at

    Make sure you have the lines selected.

    When the fields are not available, you have to add the fields using an Extension.

  • Community Member Profile Picture
    Community Member on at

    Hi Hannes, I am working on the above query with James Solomon.

    As he mentioned, he was able to add the Gen Prod Post Group to the Sales Invoice Lines using the Design function.

    However, while testing the above and making a change to the Gen Prod Post Group on the Sales Invoice Line it seems to recalc and remove any VAT amount for the line. Any ideas ?

    Regards,

    J-P Jooste

    Senior ERP Consultant

  • Community Member Profile Picture
    Community Member on at

    Hi Hannes, not to worry I discovered a solution for this. At the point of changing the Gen Prod Post Group, the VAT Prod Post Group needs to be reassigned to the line in order for VAT to the calculated.

    Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans