Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Invoice Distribution

Posted on by 1,290

My company sells expensive equipment; the process of quoting the proper price includes negotiation and multiple factors, which include extended warranty, special provision for training, gain from installment sales and other factors. After taking into consideration all these factors a proper pricing is quoted to the customer.

The management wants to track components of pricing from the sales invoice, but the customer should not know about these internal components. In order to achieve this purpose, accountants enter a standard sales invoice with the equipment and price for the purpose of printing it to the customer, later and before posting, the accountants change the distribution manually to include the several sales accounts to reflect the components of the pricing.

For more clarification, the automatic distribution will be:
A/R        Sales
The distribution that we want to get is:
A/R        Gain from installment sales        
                Extended warranty sales
                Cash price sales
                Training sales
As you can see above, accountants breakdown the sales price to its components, and remember the customer should receive an invoice with only the name of the equipment and the price.

The best solution that fits our need is to enter all the details when preparing the invoice, in the same time showing only the equipment and the price to the customer regardless of the components.

How can we do this in GP?

Thank you for taking the time to help

*This post is locked for comments

  • SSunnergren Profile Picture
    SSunnergren 250 on at
    Re: Invoice Distribution

    Thanks!

    -Scot

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Invoice Distribution

    By using the Quick Print setup from the Sales Trx Entry Options menu you can set options, although that requires using the Quick Print functionality.   The other option is to record a macro to use for printing.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • SSunnergren Profile Picture
    SSunnergren 250 on at
    Re: Invoice Distribution

    Thanks Dan!

    Is there a way to tick that by default? We often print large batches of invoices at a time.

    thank you for your assistance,

    Scot

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Invoice Distribution

    When you print either the order, invoice, packing slip or picking ticket, there is a checkbox to select 'Include Kit Components'.   By checking the box, they are included, leaving it blank, they are excluded.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • SSunnergren Profile Picture
    SSunnergren 250 on at
    Re: Invoice Distribution

    Frank mentions above that "You can choose to have the Kit components display, or not display, on the order/invoice..."

    Where is this done? I would like to have components not show on my invoices but I cannot find where that is controlled.

    Thanks!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Invoice Distribution

    @Waleed

    Technically number of items does not make a difference, but dicussing the change you will need to perform cost/benefit analysis to evaluate do you really need to do this change or not, keeping in mind that adding new items with KIT type will not be a time consuming task and might be easily imported using integration manager.

    Another thing to keep in mind when evaluating this that the idea of having an ERP system is to collect as much information as you can for future analysis and reporting.

    Training your employees is a different pointview, you can manage a day session to all of your team to be aware of the change you made and how to use new functionality.

    For items with zero cost, it will not participate in journal creation.

    @Mona

    Components prices will not rollup, COSTS will rollup into the KIT cost, you still can use costs with markup or margines on your items.

  • mona kazzi Profile Picture
    mona kazzi 130 on at
    Re: Invoice Distribution

    Dear Frank,

    can you please show us where, on GP, could we roll up the component pricing to the kit item level?

    Thank you very much

  • Waleed Tibi Profile Picture
    Waleed Tibi 1,290 on at
    Re: Invoice Distribution

    Thank you Frank,

    I have two issues here, do you think the "kit" way will work taking into consideration:

    A - We have above than one thousand items in the stock, and tens of customer service employees who issue the invoices. Do we have to change the setting of the thousand item and train all these employees? will it worth it? or just keep it the way it is going now.

    B - If i go for the kit item as a solution, as you know, i will have items with zero cost, the purpose of these items is only for generating distribution, will this be ok in the GP?

    Is there a way other than the kit item to do it?

    Thank you

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Invoice Distribution

    Take a look at the 'Kit' Item Type in GP, Waleed.  With this, you could define the components of the sale as components of the Kit, and assign default distribution accounts to each component.  You can choose to have the Kit components display, or not display, on the order/invoice and have the component pricing roll up to the Kit Item level, concealing the individual component pricing from the customer.

    Hope this helps,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans