public void GivenReceipt_WhenApplied_ThenInvoiceItemAmountPaidIsUpdated()
{
this.InstantiateObjects(this.DatabaseSession);
var productItem = new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem;
var contactMechanism = new ContactMechanisms(this.DatabaseSession).Extent().First;
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBillToCustomer(this.billToCustomer)
.WithBillToContactMechanism(contactMechanism)
.Build();
var item1 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(this.good).WithQuantity(1).WithActualUnitPrice(100M).WithSalesInvoiceItemType(productItem).Build();
var item2 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(this.good).WithQuantity(1).WithActualUnitPrice(200M).WithSalesInvoiceItemType(productItem).Build();
var item3 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(this.good).WithQuantity(1).WithActualUnitPrice(300M).WithSalesInvoiceItemType(productItem).Build();
invoice.AddSalesInvoiceItem(item1);
invoice.AddSalesInvoiceItem(item2);
invoice.AddSalesInvoiceItem(item3);
this.DatabaseSession.Derive(true);
new ReceiptBuilder(this.DatabaseSession)
.WithAmount(50)
.WithPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(item2).WithAmountApplied(50).Build())
.WithEffectiveDate(DateTime.UtcNow)
.Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(0, item1.AmountPaid);
Assert.AreEqual(50, item2.AmountPaid);
Assert.AreEqual(0, item3.AmountPaid);
new ReceiptBuilder(this.DatabaseSession)
.WithAmount(350)
.WithPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(item1).WithAmountApplied(100).Build())
.WithPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(item2).WithAmountApplied(150).Build())
.WithPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(item3).WithAmountApplied(100).Build())
.WithEffectiveDate(DateTime.UtcNow)
.Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(100, item1.AmountPaid);
Assert.AreEqual(200, item2.AmountPaid);
Assert.AreEqual(100, item3.AmountPaid);
}
public void GivenReceipt_WhenApplied_ThenInvoiceItemAmountPaidIsUpdated()
{
this.InstantiateObjects(this.Session);
var productItem = new InvoiceItemTypes(this.Session).ProductItem;
var contactMechanism = new ContactMechanisms(this.Session).Extent().First;
var invoice = new SalesInvoiceBuilder(this.Session)
.WithBillToCustomer(this.billToCustomer)
.WithAssignedBillToContactMechanism(contactMechanism)
.Build();
var item1 = new SalesInvoiceItemBuilder(this.Session).WithProduct(this.good).WithQuantity(1).WithAssignedUnitPrice(100M).WithInvoiceItemType(productItem).Build();
var item2 = new SalesInvoiceItemBuilder(this.Session).WithProduct(this.good).WithQuantity(1).WithAssignedUnitPrice(200M).WithInvoiceItemType(productItem).Build();
var item3 = new SalesInvoiceItemBuilder(this.Session).WithProduct(this.good).WithQuantity(1).WithAssignedUnitPrice(300M).WithInvoiceItemType(productItem).Build();
invoice.AddSalesInvoiceItem(item1);
invoice.AddSalesInvoiceItem(item2);
invoice.AddSalesInvoiceItem(item3);
this.Session.Derive();
new ReceiptBuilder(this.Session)
.WithAmount(50)
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(item2).WithAmountApplied(50).Build())
.WithEffectiveDate(this.Session.Now())
.Build();
this.Session.Derive();
Assert.Equal(0, item1.AmountPaid);
Assert.Equal(50, item2.AmountPaid);
Assert.Equal(0, item3.AmountPaid);
new ReceiptBuilder(this.Session)
.WithAmount(350)
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(item1).WithAmountApplied(100).Build())
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(item2).WithAmountApplied(150).Build())
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(item3).WithAmountApplied(100).Build())
.WithEffectiveDate(this.Session.Now())
.Build();
this.Session.Derive();
Assert.Equal(100, item1.AmountPaid);
Assert.Equal(200, item2.AmountPaid);
Assert.Equal(100, item3.AmountPaid);
}
public void GivenPaymentApplication_WhenDeriving_ThenAmountAppliedCannotBeLargerThenAmountReceived()
{
var contactMechanism = new ContactMechanisms(this.DatabaseSession).Extent().First;
var good = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(new VatRateBuilder(this.DatabaseSession).WithRate(0).Build())
.WithName("good")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.Build();
var customer = new PersonBuilder(this.DatabaseSession).WithLastName("customer").Build();
new CustomerRelationshipBuilder(this.DatabaseSession)
.WithCustomer(customer)
.WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation)
.Build();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(1).WithActualUnitPrice(1000M).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build())
.Build();
this.DatabaseSession.Derive(true);
var receipt = new ReceiptBuilder(this.DatabaseSession)
.WithAmount(100)
.WithEffectiveDate(DateTime.UtcNow)
.Build();
var paymentApplication = new PaymentApplicationBuilder(this.DatabaseSession)
.WithAmountApplied(200)
.WithInvoiceItem(invoice.InvoiceItems[0])
.Build();
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
receipt.AddPaymentApplication(paymentApplication);
var derivationLog = this.DatabaseSession.Derive();
Assert.IsTrue(derivationLog.HasErrors);
Assert.Contains(PaymentApplications.Meta.AmountApplied, derivationLog.Errors[0].RoleTypes);
}
public void GivenPaymentApplication_WhenDeriving_ThenAmountAppliedCannotBeLargerThenAmountReceived()
{
var contactMechanism = new ContactMechanisms(this.Session).Extent().First;
var good = new Goods(this.Session).FindBy(M.Good.Name, "good1");
var customer = new PersonBuilder(this.Session).WithLastName("customer").Build();
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(customer)
.Build();
var invoice = new SalesInvoiceBuilder(this.Session)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.Session).WithProduct(good).WithQuantity(1).WithAssignedUnitPrice(1000M).WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem).Build())
.Build();
this.Session.Derive();
var receipt = new ReceiptBuilder(this.Session)
.WithAmount(100)
.WithEffectiveDate(this.Session.Now())
.Build();
var paymentApplication = new PaymentApplicationBuilder(this.Session)
.WithAmountApplied(200)
.WithInvoiceItem(invoice.InvoiceItems[0])
.Build();
this.Session.Derive();
this.Session.Commit();
receipt.AddPaymentApplication(paymentApplication);
var derivationLog = this.Session.Derive(false);
Assert.True(derivationLog.HasErrors);
Assert.Contains(M.PaymentApplication.AmountApplied, derivationLog.Errors[0].RoleTypes);
}
public void DeriveHistory()
{
var productItem = new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem;
var contactMechanism = new ContactMechanisms(this.DatabaseSession).Extent().First;
var customer1 = new OrganisationBuilder(this.DatabaseSession).WithName("customer1").Build();
var customer2 = new OrganisationBuilder(this.DatabaseSession).WithName("customer2").Build();
var salesRep1 = new PersonBuilder(this.DatabaseSession).WithLastName("salesRep1").Build();
var salesRep2 = new PersonBuilder(this.DatabaseSession).WithLastName("salesRep2").Build();
var package1 = new PackageBuilder(this.DatabaseSession).WithName("package1").Build();
var package2 = new PackageBuilder(this.DatabaseSession).WithName("package2").Build();
var salesChannel1 = new SalesChannels(this.DatabaseSession).WebChannel;
var salesChannel2 = new SalesChannels(this.DatabaseSession).NoChannel;
var catMain = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("main cat").Build();
var cat1 = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("cat for good1").WithParent(catMain).WithPackage(package1).Build();
var cat2 = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("cat for good2").WithParent(catMain).WithPackage(package2).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer1).WithProductCategory(cat1).WithSalesRepresentative(salesRep1).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer1).WithProductCategory(cat2).WithSalesRepresentative(salesRep2).Build();
this.DatabaseSession.Derive(true);
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer2).WithProductCategory(cat1).WithSalesRepresentative(salesRep1).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer2).WithProductCategory(cat2).WithSalesRepresentative(salesRep2).Build();
this.DatabaseSession.Derive(true);
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
var vatRate21 = new VatRateBuilder(this.DatabaseSession).WithRate(21).Build();
var good1 = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(vatRate21)
.WithName("good1")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.WithPrimaryProductCategory(cat1)
.Build();
var good2 = new GoodBuilder(this.DatabaseSession)
.WithSku("10102")
.WithVatRate(vatRate21)
.WithName("good2")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.WithPrimaryProductCategory(cat2)
.Build();
var internalOrganisation = new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation");
internalOrganisation.PreferredCurrency = euro;
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer1).WithInternalOrganisation(internalOrganisation).Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer2).WithInternalOrganisation(internalOrganisation).Build();
this.DatabaseSession.Derive(true);
var invoice1 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTime.UtcNow.AddMonths(-1))
.WithInvoiceNumber("1")
.WithBillToCustomer(customer1)
.WithBillToContactMechanism(contactMechanism)
.WithSalesChannel(salesChannel1)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
var item1a = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item1a);
var item1b = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item1b);
var item1c = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good2).WithQuantity(5).WithActualUnitPrice(10).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item1c);
this.DatabaseSession.Derive(true);
var invoice2 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTime.UtcNow)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer1)
.WithBillToContactMechanism(contactMechanism)
.WithSalesChannel(salesChannel1)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
var item2a = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice2.AddSalesInvoiceItem(item2a);
var item2b = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice2.AddSalesInvoiceItem(item2b);
var item2c = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good2).WithQuantity(5).WithActualUnitPrice(10).WithSalesInvoiceItemType(productItem).Build();
invoice2.AddSalesInvoiceItem(item2c);
this.DatabaseSession.Derive(true);
Singleton.Instance(this.DatabaseSession).DeriveRevenues();
var salesRep1RevenueHistory = salesRep1.SalesRepRevenueHistoriesWhereSalesRep.First;
Assert.AreEqual(90, salesRep1RevenueHistory.Revenue);
var salesRep2RevenueHistory = salesRep2.SalesRepRevenueHistoriesWhereSalesRep.First;
Assert.AreEqual(50, salesRep2RevenueHistory.Revenue);
var invoice3 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTime.UtcNow)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer2)
.WithBillToContactMechanism(contactMechanism)
.WithSalesChannel(salesChannel2)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
var item3a = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(1).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice3.AddSalesInvoiceItem(item3a);
var item3b = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good2).WithQuantity(1).WithActualUnitPrice(10).WithSalesInvoiceItemType(productItem).Build();
invoice3.AddSalesInvoiceItem(item3b);
this.DatabaseSession.Derive(true);
Singleton.Instance(this.DatabaseSession).DeriveRevenues();
Assert.AreEqual(105, salesRep1RevenueHistory.Revenue);
Assert.AreEqual(60, salesRep2RevenueHistory.Revenue);
}
public void GivenSalesInvoice_WhenDerived_ThenTotalExVatIsAddedToPartyPackageRevenueHistory()
{
var productItem = new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem;
var contactMechanism = new ContactMechanisms(this.DatabaseSession).Extent().First;
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
var vatRate21 = new VatRateBuilder(this.DatabaseSession).WithRate(21).Build();
var package1 = new PackageBuilder(this.DatabaseSession).WithName("package1").Build();
var cat1 = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("cat for good1").WithPackage(package1).Build();
var good1 = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(vatRate21)
.WithName("good1")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.WithPrimaryProductCategory(cat1)
.Build();
var customer = new Organisations(this.DatabaseSession).FindBy(Organisations.Meta.Name, "customer");
var internalOrganisation = new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation");
internalOrganisation.PreferredCurrency = euro;
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
var date = DateTime.UtcNow.AddYears(-1).AddMonths(-1);
decimal revenuePastTwelveMonths = 0;
for (var i = 1; i <= 13; i++)
{
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(date)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesChannel(new SalesChannels(this.DatabaseSession).WebChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
var item = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(1).WithActualUnitPrice(i * 10M).WithSalesInvoiceItemType(productItem).Build();
invoice.AddSalesInvoiceItem(item);
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
var history = customer.PartyPackageRevenueHistoriesWhereParty.First;
//// first iteration is too old
if (i > 1)
{
revenuePastTwelveMonths += i * 10M;
}
////date in first iteration is too old, no history yet.
if (history != null)
{
Assert.AreEqual(revenuePastTwelveMonths, history.Revenue);
}
date = date.AddMonths(1);
}
}
public void DeriveRevenues()
{
var productItem = new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem;
var contactMechanism = new ContactMechanisms(this.DatabaseSession).Extent().First;
var customer1 = new OrganisationBuilder(this.DatabaseSession).WithName("customer1").Build();
var customer2 = new OrganisationBuilder(this.DatabaseSession).WithName("customer2").Build();
var salesRep1 = new PersonBuilder(this.DatabaseSession).WithLastName("salesRep1").Build();
var salesRep2 = new PersonBuilder(this.DatabaseSession).WithLastName("salesRep2").Build();
var catMain = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("main cat").Build();
var cat1 = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("cat for good1").WithParent(catMain).Build();
var cat2 = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("cat for good2").WithParent(catMain).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer1).WithProductCategory(cat1).WithSalesRepresentative(salesRep1).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer1).WithProductCategory(cat2).WithSalesRepresentative(salesRep2).Build();
this.DatabaseSession.Derive(true);
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer2).WithProductCategory(cat1).WithSalesRepresentative(salesRep1).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer2).WithProductCategory(cat2).WithSalesRepresentative(salesRep2).Build();
this.DatabaseSession.Derive(true);
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
var vatRate21 = new VatRateBuilder(this.DatabaseSession).WithRate(21).Build();
var good1 = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(vatRate21)
.WithName("good1")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.WithPrimaryProductCategory(cat1)
.Build();
var good2 = new GoodBuilder(this.DatabaseSession)
.WithSku("10102")
.WithVatRate(vatRate21)
.WithName("good2")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.WithPrimaryProductCategory(cat2)
.Build();
var internalOrganisation = new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation");
internalOrganisation.PreferredCurrency = euro;
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer1).WithInternalOrganisation(internalOrganisation).Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer2).WithInternalOrganisation(internalOrganisation).Build();
this.DatabaseSession.Derive(true);
var invoice1 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTime.UtcNow)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer1)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
var item1 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item1);
var item2 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item2);
var item3 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good2).WithQuantity(5).WithActualUnitPrice(10).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item3);
this.DatabaseSession.Derive(true);
Singleton.Instance(this.DatabaseSession).DeriveRevenues();
var customer1ProductRevenues = customer1.PartyProductRevenuesWhereParty;
Assert.AreEqual(2, customer1ProductRevenues.Count);
customer1ProductRevenues = customer1.PartyProductRevenuesWhereParty;
customer1ProductRevenues.Filter.AddEquals(PartyProductRevenues.Meta.Product, good1);
var customer1Good1Revenue = customer1ProductRevenues.First;
customer1ProductRevenues = customer1.PartyProductRevenuesWhereParty;
customer1ProductRevenues.Filter.AddEquals(PartyProductRevenues.Meta.Product, good2);
var customer1Good2Revenue = customer1ProductRevenues.First;
Assert.AreEqual(90, customer1Good1Revenue.Revenue);
Assert.AreEqual(6, customer1Good1Revenue.Quantity);
Assert.AreEqual(50, customer1Good2Revenue.Revenue);
Assert.AreEqual(5, customer1Good2Revenue.Quantity);
var invoice2 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTime.UtcNow)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer2)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
var item4 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(1).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice2.AddSalesInvoiceItem(item4);
this.DatabaseSession.Derive(true);
var item5 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good2).WithQuantity(1).WithActualUnitPrice(10).WithSalesInvoiceItemType(productItem).Build();
invoice2.AddSalesInvoiceItem(item5);
this.DatabaseSession.Derive(true);
Singleton.Instance(this.DatabaseSession).DeriveRevenues();
var customer2ProductRevenues = customer2.PartyProductRevenuesWhereParty;
Assert.AreEqual(2, customer2ProductRevenues.Count);
customer2ProductRevenues.Filter.AddEquals(PartyProductRevenues.Meta.Product, good1);
var customer2Good1Revenue = customer2ProductRevenues.First;
customer2ProductRevenues = customer2.PartyProductRevenuesWhereParty;
customer2ProductRevenues.Filter.AddEquals(PartyProductRevenues.Meta.Product, good2);
var customer2Good2Revenue = customer2ProductRevenues.First;
Assert.AreEqual(15, customer2Good1Revenue.Revenue);
Assert.AreEqual(1, customer2Good1Revenue.Quantity);
Assert.AreEqual(10, customer2Good2Revenue.Revenue);
Assert.AreEqual(1, customer2Good2Revenue.Quantity);
}
public void GivenSalesOrderForCustomerExceedingCreditLimit_WhenOrderIsConfirmed_ThenOrderRequestsApproval()
{
var productItem = new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem;
var contactMechanism = new ContactMechanisms(this.DatabaseSession).Extent().First;
var assessable = new VatRegimes(this.DatabaseSession).Assessable;
var vatRate0 = new VatRateBuilder(this.DatabaseSession).WithRate(0).Build();
assessable.VatRate = vatRate0;
var good = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(vatRate0)
.WithName("good1")
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.Build();
var inventoryItem = new NonSerializedInventoryItemBuilder(this.DatabaseSession).WithGood(good).Build();
inventoryItem.AddInventoryItemVariance(new InventoryItemVarianceBuilder(this.DatabaseSession).WithQuantity(100).WithReason(new VarianceReasons(this.DatabaseSession).Unknown).Build());
this.DatabaseSession.Derive(true);
var mechelen = new CityBuilder(this.DatabaseSession).WithName("Mechelen").Build();
var mechelenAddress = new PostalAddressBuilder(this.DatabaseSession).WithGeographicBoundary(mechelen).WithAddress1("Haverwerf 15").Build();
var shipToMechelen = new PartyContactMechanismBuilder(this.DatabaseSession)
.WithContactMechanism(mechelenAddress)
.WithContactPurpose(new ContactMechanismPurposes(this.DatabaseSession).ShippingAddress)
.WithUseAsDefault(true)
.Build();
var customer = new PersonBuilder(this.DatabaseSession).WithLastName("customer").WithPartyContactMechanism(shipToMechelen).Build();
new CustomerRelationshipBuilder(this.DatabaseSession)
.WithCustomer(customer)
.WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation)
.WithCreditLimit(100M)
.Build();
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithInvoiceDate(DateTime.UtcNow.AddYears(-1))
.Build();
var invoiceItem = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(10).WithActualUnitPrice(11).WithSalesInvoiceItemType(productItem).Build();
invoice.AddSalesInvoiceItem(invoiceItem);
this.DatabaseSession.Derive(true);
var order = new SalesOrderBuilder(this.DatabaseSession)
.WithBillToCustomer(customer)
.WithShipToCustomer(customer)
.WithVatRegime(assessable)
.WithShipToAddress(new PostalAddressBuilder(this.DatabaseSession).WithGeographicBoundary(mechelen).WithAddress1("Haverwerf 15").Build())
.Build();
var item = new SalesOrderItemBuilder(this.DatabaseSession)
.WithProduct(good)
.WithQuantityOrdered(10)
.WithActualUnitPrice(5)
.Build();
order.AddSalesOrderItem(item);
this.DatabaseSession.Derive(true);
order.Confirm();
this.DatabaseSession.Derive(true);
Assert.AreEqual(new SalesOrderObjectStates(this.DatabaseSession).RequestsApproval, order.CurrentObjectState);
Assert.AreEqual(0, item.QuantityReserved);
Assert.AreEqual(0, item.QuantityPendingShipment);
Assert.AreEqual(0, item.QuantityRequestsShipping);
Assert.AreEqual(0, item.QuantityShortFalled);
order.Approve();
this.DatabaseSession.Derive(true);
Assert.AreEqual(new SalesOrderObjectStates(this.DatabaseSession).InProcess, order.CurrentObjectState);
Assert.AreEqual(10, item.QuantityReserved);
Assert.AreEqual(10, item.QuantityPendingShipment);
Assert.AreEqual(0, item.QuantityRequestsShipping);
Assert.AreEqual(0, item.QuantityShortFalled);
}
public void GivenPartyWithRevenue_WhenDeriving_ThenTotalRevenuesAreUpdated()
{
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var internalOrganisation = new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation");
var productItem = new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem;
var contactMechanism = new ContactMechanisms(this.DatabaseSession).Extent().First;
new CustomerRelationshipBuilder(this.DatabaseSession).WithCustomer(customer).WithInternalOrganisation(internalOrganisation).Build();
var good = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(new VatRateBuilder(this.DatabaseSession).WithRate(0).Build())
.WithName("good")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.Build();
this.DatabaseSession.Derive(true);
var date1 = DateTimeFactory.CreateDate(DateTime.UtcNow.AddYears(-1).Year, 1, 1);
var date2 = DateTimeFactory.CreateDate(DateTime.UtcNow.Year, 1, 1);
var date3 = DateTimeFactory.CreateDate(DateTime.UtcNow.Year, 2, 1);
new SalesInvoiceBuilder(this.DatabaseSession)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBillToCustomer(customer)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithActualUnitPrice(10M).WithQuantity(1).WithSalesInvoiceItemType(productItem).Build())
.WithInvoiceDate(date1)
.WithBillToContactMechanism(contactMechanism)
.WithComment("invoice1")
.Build();
new SalesInvoiceBuilder(this.DatabaseSession)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBillToCustomer(customer)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithActualUnitPrice(100M).WithQuantity(1).WithSalesInvoiceItemType(productItem).Build())
.WithInvoiceDate(date2)
.WithBillToContactMechanism(contactMechanism)
.WithComment("invoice2")
.Build();
new SalesInvoiceBuilder(this.DatabaseSession)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBillToCustomer(customer)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithActualUnitPrice(100M).WithQuantity(1).WithSalesInvoiceItemType(productItem).Build())
.WithInvoiceDate(date3)
.WithBillToContactMechanism(contactMechanism)
.WithComment("invoice3")
.Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(10M, customer.LastYearsRevenue);
Assert.AreEqual(200M, customer.YTDRevenue);
}
public void GivenSalesInvoice_WhenDeriving_ThenRevenuesAreCreatedAndUpdated()
{
var productItem = new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem;
var contactMechanism = new ContactMechanisms(this.DatabaseSession).Extent().First;
var customer1 = new OrganisationBuilder(this.DatabaseSession).WithName("customer1").Build();
var customer2 = new OrganisationBuilder(this.DatabaseSession).WithName("customer2").Build();
var salesRep1 = new PersonBuilder(this.DatabaseSession).WithLastName("salesRep1").Build();
var salesRep2 = new PersonBuilder(this.DatabaseSession).WithLastName("salesRep2").Build();
var catMain = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("main cat").Build();
var cat1 = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("cat for good1").WithParent(catMain).Build();
var cat2 = new ProductCategoryBuilder(this.DatabaseSession).WithDescription("cat for good2").WithParent(catMain).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer1).WithProductCategory(cat1).WithSalesRepresentative(salesRep1).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer1).WithProductCategory(cat2).WithSalesRepresentative(salesRep2).Build();
this.DatabaseSession.Derive(true);
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer2).WithProductCategory(cat1).WithSalesRepresentative(salesRep1).Build();
new SalesRepRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer2).WithProductCategory(cat2).WithSalesRepresentative(salesRep2).Build();
this.DatabaseSession.Derive(true);
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
var vatRate21 = new VatRateBuilder(this.DatabaseSession).WithRate(21).Build();
var good1 = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(vatRate21)
.WithName("good1")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.WithPrimaryProductCategory(cat1)
.Build();
var good2 = new GoodBuilder(this.DatabaseSession)
.WithSku("10102")
.WithVatRate(vatRate21)
.WithName("good2")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.WithPrimaryProductCategory(cat2)
.Build();
var internalOrganisation = new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation");
internalOrganisation.PreferredCurrency = euro;
var invoice1 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTime.UtcNow)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer1)
.WithBillToContactMechanism(contactMechanism)
.WithSalesChannel(new SalesChannels(this.DatabaseSession).WebChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(invoice1.BillToCustomer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
var item1 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item1);
var item2 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item2);
var item3 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good2).WithQuantity(5).WithActualUnitPrice(10).WithSalesInvoiceItemType(productItem).Build();
invoice1.AddSalesInvoiceItem(item3);
this.DatabaseSession.Derive(true);
var customer1Revenue = customer1.PartyRevenuesWhereParty[0];
var internalOrganisationRevenue = internalOrganisation.InternalOrganisationRevenuesWhereInternalOrganisation[0];
var storeRevenue = invoice1.Store.StoreRevenuesWhereStore[0];
var salesChannelRevenue = invoice1.SalesChannel.SalesChannelRevenuesWhereSalesChannel[0];
var salesRep1Revenue = salesRep1.SalesRepRevenuesWhereSalesRep[0];
var salesRep2Revenue = salesRep2.SalesRepRevenuesWhereSalesRep[0];
var good1Revenue = good1.ProductRevenuesWhereProduct[0];
var good2Revenue = good2.ProductRevenuesWhereProduct[0];
var cat1Revenue = cat1.ProductCategoryRevenuesWhereProductCategory[0];
var cat2Revenue = cat2.ProductCategoryRevenuesWhereProductCategory[0];
var catMainRevenue = catMain.ProductCategoryRevenuesWhereProductCategory[0];
var customer1ProductRevenues = customer1.PartyProductRevenuesWhereParty;
Assert.AreEqual(2, customer1ProductRevenues.Count);
customer1ProductRevenues = customer1.PartyProductRevenuesWhereParty;
customer1ProductRevenues.Filter.AddEquals(PartyProductRevenues.Meta.Product, good1);
var customer1Good1Revenue = customer1ProductRevenues.First;
customer1ProductRevenues = customer1.PartyProductRevenuesWhereParty;
customer1ProductRevenues.Filter.AddEquals(PartyProductRevenues.Meta.Product, good2);
var customer1Good2Revenue = customer1ProductRevenues.First;
var customer1ProductCategoryRevenues = customer1.PartyProductCategoryRevenuesWhereParty;
Assert.AreEqual(3, customer1ProductCategoryRevenues.Count);
customer1ProductCategoryRevenues.Filter.AddEquals(PartyProductCategoryRevenues.Meta.ProductCategory, cat1);
var customer1Cat1Revenue = customer1ProductCategoryRevenues.First;
customer1ProductCategoryRevenues = customer1.PartyProductCategoryRevenuesWhereParty;
customer1ProductCategoryRevenues.Filter.AddEquals(PartyProductCategoryRevenues.Meta.ProductCategory, cat2);
var customer1Cat2Revenue = customer1ProductCategoryRevenues.First;
customer1ProductCategoryRevenues = customer1.PartyProductCategoryRevenuesWhereParty;
customer1ProductCategoryRevenues.Filter.AddEquals(PartyProductCategoryRevenues.Meta.ProductCategory, catMain);
var customer1CatMainRevenue = customer1ProductCategoryRevenues.First;
var salesRep1Customer1Revenues = salesRep1.SalesRepPartyRevenuesWhereSalesRep;
salesRep1Customer1Revenues.Filter.AddEquals(SalesRepPartyRevenues.Meta.Party, customer1);
var salesRep1Customer1Revenue = salesRep1Customer1Revenues.First;
var salesRep2Customer1Revenues = salesRep2.SalesRepPartyRevenuesWhereSalesRep;
salesRep2Customer1Revenues.Filter.AddEquals(SalesRepPartyRevenues.Meta.Party, customer1);
var salesRep2Customer1Revenue = salesRep2Customer1Revenues.First;
var salesRep1Customer1ProductCategoryRevenues = salesRep1.SalesRepPartyProductCategoryRevenuesWhereSalesRep;
Assert.AreEqual(2, salesRep1Customer1ProductCategoryRevenues.Count);
salesRep1Customer1ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.ProductCategory, cat1);
salesRep1Customer1ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer1);
var salesRep1Customer1Cat1Revenue = salesRep1Customer1ProductCategoryRevenues.First;
salesRep1Customer1ProductCategoryRevenues = salesRep1.SalesRepPartyProductCategoryRevenuesWhereSalesRep;
salesRep1Customer1ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.ProductCategory, catMain);
salesRep1Customer1ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer1);
var salesRep1Customer1CatMainRevenue = salesRep1Customer1ProductCategoryRevenues.First;
var salesRep2Customer1ProductCategoryRevenues = salesRep2.SalesRepPartyProductCategoryRevenuesWhereSalesRep;
Assert.AreEqual(2, salesRep2Customer1ProductCategoryRevenues.Count);
salesRep2Customer1ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.ProductCategory, cat2);
salesRep2Customer1ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer1);
var salesRep2Customer1Cat2Revenue = salesRep2Customer1ProductCategoryRevenues.First;
salesRep2Customer1ProductCategoryRevenues = salesRep2.SalesRepPartyProductCategoryRevenuesWhereSalesRep;
salesRep2Customer1ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer1);
salesRep2Customer1ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.ProductCategory, catMain);
var salesRep2Customer1CatMainRevenue = salesRep2Customer1ProductCategoryRevenues.First;
var salesRep1ProductCategoryRevenues = salesRep1.SalesRepProductCategoryRevenuesWhereSalesRep;
Assert.AreEqual(2, salesRep1ProductCategoryRevenues.Count);
salesRep1ProductCategoryRevenues.Filter.AddEquals(SalesRepProductCategoryRevenues.Meta.ProductCategory, cat1);
var salesRep1Cat1Revenue = salesRep1ProductCategoryRevenues.First;
salesRep1ProductCategoryRevenues = salesRep1.SalesRepProductCategoryRevenuesWhereSalesRep;
salesRep1ProductCategoryRevenues.Filter.AddEquals(SalesRepProductCategoryRevenues.Meta.ProductCategory, catMain);
var salesRep1CatMainRevenue = salesRep1ProductCategoryRevenues.First;
var salesRep2ProductCategoryRevenues = salesRep2.SalesRepProductCategoryRevenuesWhereSalesRep;
Assert.AreEqual(2, salesRep2ProductCategoryRevenues.Count);
salesRep2ProductCategoryRevenues.Filter.AddEquals(SalesRepProductCategoryRevenues.Meta.ProductCategory, cat2);
var salesRep2Cat2Revenue = salesRep2ProductCategoryRevenues.First;
salesRep2ProductCategoryRevenues = salesRep2.SalesRepProductCategoryRevenuesWhereSalesRep;
salesRep2ProductCategoryRevenues.Filter.AddEquals(SalesRepProductCategoryRevenues.Meta.ProductCategory, catMain);
var salesRep2CatMainRevenue = salesRep2ProductCategoryRevenues.First;
this.DatabaseSession.Derive(true);
Assert.AreEqual(140, internalOrganisationRevenue.Revenue);
Assert.AreEqual(140, storeRevenue.Revenue);
Assert.AreEqual(140, salesChannelRevenue.Revenue);
Assert.AreEqual(90, salesRep1Revenue.Revenue);
Assert.AreEqual(50, salesRep2Revenue.Revenue);
Assert.AreEqual(90, salesRep1Customer1Revenue.Revenue);
Assert.AreEqual(50, salesRep2Customer1Revenue.Revenue);
Assert.AreEqual(90, good1Revenue.Revenue);
Assert.AreEqual(50, good2Revenue.Revenue);
Assert.AreEqual(90, cat1Revenue.Revenue);
Assert.AreEqual(50, cat2Revenue.Revenue);
Assert.AreEqual(140, catMainRevenue.Revenue);
Assert.AreEqual(90, customer1Cat1Revenue.Revenue);
Assert.AreEqual(50, customer1Cat2Revenue.Revenue);
Assert.AreEqual(140, customer1CatMainRevenue.Revenue);
Assert.AreEqual(90, salesRep1Cat1Revenue.Revenue);
Assert.AreEqual(90, salesRep1CatMainRevenue.Revenue);
Assert.AreEqual(50, salesRep2Cat2Revenue.Revenue);
Assert.AreEqual(50, salesRep2CatMainRevenue.Revenue);
Assert.AreEqual(90, salesRep1Customer1Cat1Revenue.Revenue);
Assert.AreEqual(90, salesRep1Customer1CatMainRevenue.Revenue);
Assert.AreEqual(50, salesRep2Customer1Cat2Revenue.Revenue);
Assert.AreEqual(50, salesRep2Customer1CatMainRevenue.Revenue);
Assert.AreEqual(140, customer1Revenue.Revenue);
Assert.AreEqual(90, customer1Good1Revenue.Revenue);
Assert.AreEqual(50, customer1Good2Revenue.Revenue);
var invoice2 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTime.UtcNow)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer2)
.WithBillToContactMechanism(contactMechanism)
.WithSalesChannel(new SalesChannels(this.DatabaseSession).WebChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(invoice2.BillToCustomer).WithInternalOrganisation(invoice2.BilledFromInternalOrganisation).Build();
var item4 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good1).WithQuantity(1).WithActualUnitPrice(15).WithSalesInvoiceItemType(productItem).Build();
invoice2.AddSalesInvoiceItem(item4);
this.DatabaseSession.Derive(true);
var item5 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good2).WithQuantity(1).WithActualUnitPrice(10).WithSalesInvoiceItemType(productItem).Build();
invoice2.AddSalesInvoiceItem(item5);
this.DatabaseSession.Derive(true);
var customer2Revenue = customer2.PartyRevenuesWhereParty[0];
var customer2ProductRevenues = customer2.PartyProductRevenuesWhereParty;
Assert.AreEqual(2, customer2ProductRevenues.Count);
customer2ProductRevenues.Filter.AddEquals(PartyProductRevenues.Meta.Product, good1);
var customer2Good1Revenue = customer2ProductRevenues.First;
customer2ProductRevenues = customer2.PartyProductRevenuesWhereParty;
customer2ProductRevenues.Filter.AddEquals(PartyProductRevenues.Meta.Product, good2);
var customer2Good2Revenue = customer2ProductRevenues.First;
var customer2ProductCategoryRevenues = customer2.PartyProductCategoryRevenuesWhereParty;
Assert.AreEqual(3, customer2ProductCategoryRevenues.Count);
customer2ProductCategoryRevenues.Filter.AddEquals(PartyProductCategoryRevenues.Meta.ProductCategory, cat1);
var customer2Cat1Revenue = customer2ProductCategoryRevenues.First;
customer2ProductCategoryRevenues = customer2.PartyProductCategoryRevenuesWhereParty;
customer2ProductCategoryRevenues.Filter.AddEquals(PartyProductCategoryRevenues.Meta.ProductCategory, cat2);
var customer2Cat2Revenue = customer2ProductCategoryRevenues.First;
customer2ProductCategoryRevenues = customer2.PartyProductCategoryRevenuesWhereParty;
customer2ProductCategoryRevenues.Filter.AddEquals(PartyProductCategoryRevenues.Meta.ProductCategory, catMain);
var customer2CatMainRevenue = customer2ProductCategoryRevenues.First;
var salesRep1Customer2Revenues = salesRep1.SalesRepPartyRevenuesWhereSalesRep;
salesRep1Customer2Revenues.Filter.AddEquals(SalesRepPartyRevenues.Meta.Party, customer2);
var salesRep1Customer2Revenue = salesRep1Customer2Revenues.First;
var salesRep2Customer2Revenues = salesRep2.SalesRepPartyRevenuesWhereSalesRep;
salesRep2Customer2Revenues.Filter.AddEquals(SalesRepPartyRevenues.Meta.Party, customer2);
var salesRep2Customer2Revenue = salesRep2Customer2Revenues.First;
var salesRep1Customer2ProductCategoryRevenues = salesRep1.SalesRepPartyProductCategoryRevenuesWhereSalesRep;
salesRep1Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer2);
Assert.AreEqual(2, salesRep1Customer2ProductCategoryRevenues.Count);
salesRep1Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.ProductCategory, cat1);
salesRep1Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer2);
var salesRep1Customer2Cat1Revenue = salesRep1Customer2ProductCategoryRevenues.First;
salesRep1Customer2ProductCategoryRevenues = salesRep1.SalesRepPartyProductCategoryRevenuesWhereSalesRep;
salesRep1Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.ProductCategory, catMain);
salesRep1Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer2);
var salesRep1Customer2CatMainRevenue = salesRep1Customer2ProductCategoryRevenues.First;
var salesRep2Customer2ProductCategoryRevenues = salesRep2.SalesRepPartyProductCategoryRevenuesWhereSalesRep;
salesRep2Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer2);
Assert.AreEqual(2, salesRep2Customer2ProductCategoryRevenues.Count);
salesRep2Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.ProductCategory, cat2);
salesRep2Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer2);
var salesRep2Customer2Cat2Revenue = salesRep2Customer2ProductCategoryRevenues.First;
salesRep2Customer2ProductCategoryRevenues = salesRep2.SalesRepPartyProductCategoryRevenuesWhereSalesRep;
salesRep2Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.Party, customer2);
salesRep2Customer2ProductCategoryRevenues.Filter.AddEquals(SalesRepPartyProductCategoryRevenues.Meta.ProductCategory, catMain);
var salesRep2Customer2CatMainRevenue = salesRep2Customer2ProductCategoryRevenues.First;
Assert.AreEqual(165, internalOrganisationRevenue.Revenue);
Assert.AreEqual(165, storeRevenue.Revenue);
Assert.AreEqual(165, salesChannelRevenue.Revenue);
Assert.AreEqual(105, salesRep1Revenue.Revenue);
Assert.AreEqual(60, salesRep2Revenue.Revenue);
Assert.AreEqual(15, salesRep1Customer2Revenue.Revenue);
Assert.AreEqual(10, salesRep2Customer2Revenue.Revenue);
Assert.AreEqual(105, cat1Revenue.Revenue);
Assert.AreEqual(60, cat2Revenue.Revenue);
Assert.AreEqual(165, catMainRevenue.Revenue);
Assert.AreEqual(15, customer2Cat1Revenue.Revenue);
Assert.AreEqual(10, customer2Cat2Revenue.Revenue);
Assert.AreEqual(25, customer2CatMainRevenue.Revenue);
Assert.AreEqual(105, salesRep1Cat1Revenue.Revenue);
Assert.AreEqual(105, salesRep1CatMainRevenue.Revenue);
Assert.AreEqual(60, salesRep2Cat2Revenue.Revenue);
Assert.AreEqual(60, salesRep2CatMainRevenue.Revenue);
Assert.AreEqual(15, salesRep1Customer2Cat1Revenue.Revenue);
Assert.AreEqual(15, salesRep1Customer2CatMainRevenue.Revenue);
Assert.AreEqual(10, salesRep2Customer2Cat2Revenue.Revenue);
Assert.AreEqual(10, salesRep2Customer2CatMainRevenue.Revenue);
Assert.AreEqual(105, good1Revenue.Revenue);
Assert.AreEqual(60, good2Revenue.Revenue);
Assert.AreEqual(25, customer2Revenue.Revenue);
Assert.AreEqual(15, customer2Good1Revenue.Revenue);
Assert.AreEqual(10, customer2Good2Revenue.Revenue);
}