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 ?
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.
Technical Support Engineer
**This posting is provided "AS IS" with no warranties and confers no rights.
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...
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.
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..
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13