question

sairam123 avatar image
sairam123 asked

How to resolve the old vendor data for current year?

Hi, I have a scenario that a product has a vendor(vendorcode190241) between 7/1/2008to 3/25/2013 and the vendor(030549) has changed from 3/25/2013 to till date. Now I need to query for the old vendor in the current year(2014) but no data is retrieving since that data is available for the new vendor current year. So my requirement is I need to show the Last Year Net Sales and last year data in the current Year for old vendor.How to resolve this issue? Can you please help me? Thanks In Advance.
change-data-capturedumb vendors
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Squirrel avatar image Squirrel commented ·
how does your table(s) looks like and what is your required result ?
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.