Help! Reconsolidate Sales Invoices and Cust. Ledger Entry

RoddyMcLean

We have a request from a client which is unusual and they are intent on getting it in exactly the way described: -

They are producing sales invoices in the usual manner. However, they want to print sales invoices with a different consolidation level, that is by Customer, by VAT Product Posting Group.

So we have 3 Sales invoices: -

Sales Invoice 1, Customer ABC Ltd
=================================
Sales Invoice 1 Line 1, VAT Product Posting Group 1
Sales Invoice 1 Line 2, VAT Product Posting Group 2

Sales Invoice 2, Customer ABC Ltd
=================================
Sales Invoice 2 Line 1, VAT Product Posting Group 1
Sales Invoice 2 Line 2, VAT Product Posting Group 2
Sales Invoice 2 Line 3, VAT Product Posting Group 1

Sales Invoice 3, Customer XYZ Ltd
=================================
Sales Invoice 3 Line 1, VAT Product Posting Group 1


They wish to produce a sales invoice which consolidates by Customer and also by VAT Product Posting Group. So we now have, the lines switch over as shown below (the original sales invoice line description has been maintained). Now, I can see a solution to this which involves maintaining a new no. series and changes to posting routines etc. However, they are now talking in terms of keeping existing consolidation as shown above for the sales invoice document but producing the cust. ledger entry as shown below as well as the reporting changes.

I think this may be very difficult. Can any of the Navision superstars out there give me a bit of guidance as I am out of my depth here. There may be all sorts of consequences with Navigate, Dimensions, Gen. Ledger Entry etc.


Sales Invoice 1, Customer ABC Ltd
=================================
Sales Invoice 1 Line 1, VAT Product Posting Group 1
Sales Invoice 2 Line 1, VAT Product Posting Group 1
Sales Invoice 2 Line 3, VAT Product Posting Group 1

Sales Invoice 2, Customer ABC Ltd
=================================
Sales Invoice 2 Line 2, VAT Product Posting Group 2
Sales Invoice 1 Line 2, VAT Product Posting Group 2

Sales Invoice 3, Customer XYZ Ltd
=================================
Sales Invoice 3 Line 1, VAT Product Posting Group 1

Many thanks Roddy

RoddyMcLean

Hi thanks for replying ,

The invoices are not posted to begin with. I am starting with sales orders (not invoices) and they are to be posted in batches. However, the consolidation is to be kept as per standard navision for the production of the posted sales invoice document.

It is only the printed sales invoice that is to be consolidated by customer by vat product posting group. The customer ledger entry is to be consolidated also in this manner (a later request).

To me its seem very strange ](*,) , but then the client is insistent and so I must investigate the practicalities!

RoddyMcLean

I am actually based in Livingston UK. Who is your reseller?

RoddyMcLean

Hi Alexei,

Just looked at your profile.

Roddy

RoddyMcLean

Thats alexey.

RoddyMcLean

Yes,

Thanks for your input Alexey ,

I agree it looks moronic . The request evolved from a reporting requirement (I got a report layout) and discovered the fields in the report demanded new processing requirement. There is no real spec. as yet.

So yes, I have already killed several people in my mind!!! :twisted:

Anyway, I have a meeting on Monday so I am trying to collect the input of Navision developers. If we are going to have to consolidate differently, then in my mind this MUST occur before the posted sales invoice is created (the invoices are being created from sales orders) otherwise I could be working on this for months! Which is not a problem in fact I hope they need it done this way so I can put my 100 day estimate in

Regards
Roddy

RoddyMcLean

Which is not a problem in fact I hope they need it done this way so I can put my 100 day estimate in.

That is consolidate posted sales invoices - How, What, Where, Why. They can't want this I must have picked this up wrongly!

Roddy