Microsoft Dynamics SL

How does COnsolidated Invoice assign invoice number into several Shipper ID if there is no aggregation level configured?

Home » Microsoft Dynamics SL » Microsoft Dynamics SL Forum » How does COnsolidated Invoice assign invoice number into several Shipper ID if there is no aggregation level configured?
Related Search Results

Quick Send for OM Consolidated Invoices

by
on 11 Jan 2013
  • Not Answered

Consolidate Shippers

by
on 10 Mar 2010
  • Not Answered

Dynamics SL-Many Ways to Bill Customers

by
on 4 Aug 2011
  • 0 comments

How does COnsolidated Invoice assign invoice number into several Shipper ID if there is no aggregation level configured?

This question is not answered
Agnes Priscilla
Posted by
on 17 Jul 2012 9:15 AM

As for settings : only checked Consolidated Invoice flag on SO Setup and Customer maintenance and aggregation level is not configured for both SO Setup and Customer maintenance.

 I have more/less 200 shipper ID . Those shippers are for the same Customer ID and same Currency ID.and when run that Consolidated Invoice report, system will automatically grouped those shippers into 2 different Invoice number instead of 1 number only.

What is the rule for grouping and assigning invoice number if no aggregation level configured ?

 

Thanks.
All Replies
  • Carolyn Kolpien
    Posted by
    on 19 Jul 2012 8:06 PM

    Hello Agnes,

    We had a problem with the Delete All process not deleting all the invoices properly which leads to the numbers being retained and not consolidated correctly on the next invoice run.  Can you look at the Help | About Microsoft Dynamics SL screen and let me know your full version information?  Thanks.

    Carolyn

    Technical Support Engineer

    **This posting is provided "AS IS" with no warranties and confers no rights.
  • Agnes Priscilla
    Posted by
    on 20 Jul 2012 1:48 AM

    Hi Carolyn,

    Thanks for your reply.

    We're using 65 Sp3.  (6.50.4027)

    Currently what I'm doing is update soshipheader.perpost and soshipheader.invcnbr become ''  and delete refnbr table for particular invcnbr manually. And then re-run the Consolidate Invoice so it will assign proper invoice grouping.

    I can't find related hotfix for this issue as I already applied all OM related hotfixes...

    THanks,
  • Carolyn Kolpien
    Posted by
    on 20 Jul 2012 2:18 PM

    Hi Agnes,

    Unfortunately I can't continue to help with this issue while you are using 6.5 as it is no longer supported by Microsoft.  Perhaps someone else will respond with some help.  I believe that the other user running into this error upgraded to the latest version of 7.0, which is 7.0 SP4.

    Carolyn

    Technical Support Engineer

    **This posting is provided "AS IS" with no warranties and confers no rights.
  • Agnes Priscilla
    Posted by
    on 22 Jul 2012 9:54 PM

    Hi Carolyn...

    Yes, I understand that 6.5 is no longer supported.

    Currently we're modified  store procdure for Handling Delete All on Consolidate Invoice  : ADG_SOShipHeader_UpdateInvoice2,

    on the line 21,

    from this : ELSE  coalesce(@PerPost, PerPost)

    to this : ELSE  coalesce(@PerPost, '') -- PerPost)

    and delete refnbr table.

    Does anyone have on support user for this oldies version. Will appreciate if have another advice or alternatives.

    Thanks a lot..