cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Design Advice: Accounting Consolidations Best Practices

After you have done the combine, you could simply do a "remove duplicates" based on a unique column.  This would then give you a concise list of suppliers, if that suits what you are attempting to do.  It makes sense to me.

 

As for your Supplier Ledger Fact table, if you have any unique identifers you are creating then yes you'll need them in all tables you want to link using that value.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Highlighted
THEG72 Member
Member

Re: Design Advice: Accounting Consolidations Best Practices

 

 

Thanks Ross I will give that a go cheers for your advice again!