public static SalesInvoiceBuilder WithSalesExternalB2CInvoiceDefaults(this SalesInvoiceBuilder @this, Organisation internalOrganisation)
{
var faker = @this.Session.Faker();
var customer = internalOrganisation.ActiveCustomers.Where(v => v.GetType().Name == typeof(Person).Name).FirstOrDefault();
var salesInvoiceItem_Default = new SalesInvoiceItemBuilder(@this.Session).WithDefaults().Build();
var salesInvoiceItem_Product = new SalesInvoiceItemBuilder(@this.Session).WithProductItemDefaults().Build();
var salesInvoiceItem_Part = new SalesInvoiceItemBuilder(@this.Session).WithPartItemDefaults().Build();
var salesInvoiceType = new SalesInvoiceTypes(@this.Session).SalesInvoice;
var paymentMethod = faker.Random.ListItem(@this.Session.Extent <PaymentMethod>());
@this.WithCustomerReference(faker.Random.String(16).ToUpper(CultureInfo.CurrentCulture));
@this.WithBilledFrom(internalOrganisation);
@this.WithBilledFromContactPerson(internalOrganisation.CurrentContacts.FirstOrDefault());
@this.WithDescription(faker.Lorem.Sentence());
@this.WithComment(faker.Lorem.Sentence());
@this.WithInternalComment(faker.Lorem.Sentence());
@this.WithBillToCustomer(customer);
@this.WithShipToCustomer(customer);
@this.WithSalesInvoiceType(salesInvoiceType);
@this.WithTotalListPrice(faker.Random.Decimal());
@this.WithAssignedPaymentMethod(paymentMethod);
@this.WithSalesInvoiceItem(salesInvoiceItem_Default);
@this.WithSalesInvoiceItem(salesInvoiceItem_Product);
@this.WithSalesInvoiceItem(salesInvoiceItem_Part);
@this.WithAdvancePayment(faker.Random.Decimal());
@this.WithSalesTerm(new InvoiceTermBuilder(@this.Session).WithDefaultsForPaymentNetDays().Build());
@this.WithSalesTerm(new IncoTermBuilder(@this.Session).WithDefaults().Build());
@this.WithSalesTerm(new InvoiceTermBuilder(@this.Session).WithDefaults().Build());
@this.WithSalesTerm(new OrderTermBuilder(@this.Session).WithDefaults().Build());
return(@this);
}
public void GivenWeeklyRepeatingSalesInvoice_WhenDeriving_ThenDayOfWeekMustExist()
{
var customer = new OrganisationBuilder(this.Session).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.Session)
.WithAddress1("Haverwerf 15")
.WithLocality("Mechelen")
.WithCountry(new Countries(this.Session).FindBy(M.Country.IsoCode, "BE"))
.Build();
var homeAddress = new PostalAddressBuilder(this.Session)
.WithAddress1("Sint-Lambertuslaan 78")
.WithLocality("Muizen")
.WithCountry(new Countries(this.Session).FindBy(M.Country.IsoCode, "BE"))
.Build();
var billingAddress = new PartyContactMechanismBuilder(this.Session)
.WithContactMechanism(homeAddress)
.WithContactPurpose(new ContactMechanismPurposes(this.Session).BillingAddress)
.WithUseAsDefault(true)
.Build();
customer.AddPartyContactMechanism(billingAddress);
new CustomerRelationshipBuilder(this.Session).WithFromDate(this.Session.Now()).WithCustomer(customer).Build();
this.Session.Derive();
var invoice = new SalesInvoiceBuilder(this.Session)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithAssignedBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.Build();
var repeatingInvoice = new RepeatingSalesInvoiceBuilder(this.Session)
.WithSource(invoice)
.WithFrequency(new TimeFrequencies(this.Session).Week)
.WithNextExecutionDate(this.Session.Now().AddDays(1))
.Build();
var validation = this.Session.Derive(false);
Assert.True(validation.HasErrors);
Assert.Single(validation.Errors);
Assert.Contains(MetaRepeatingSalesInvoice.Instance.DayOfWeek, validation.Errors.First().RoleTypes);
Assert.False(this.Session.Derive(false).HasErrors);
var weekDay = repeatingInvoice.NextExecutionDate.DayOfWeek.ToString();
var daysOfWeek = new DaysOfWeek(this.Session).Extent();
daysOfWeek.Filter.AddEquals(M.Enumeration.Name, weekDay);
var dayOfWeek = daysOfWeek.First;
repeatingInvoice.DayOfWeek = dayOfWeek;
Assert.False(this.Session.Derive(false).HasErrors);
}
public void GivenWeeklyRepeatingSalesInvoice_WhenDayArrives_ThenNextInvoiceIsCreated()
{
var customer = new OrganisationBuilder(this.Session).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.Session)
.WithAddress1("Haverwerf 15")
.WithLocality("Mechelen")
.WithCountry(new Countries(this.Session).FindBy(M.Country.IsoCode, "BE"))
.Build();
var homeAddress = new PostalAddressBuilder(this.Session)
.WithAddress1("Sint-Lambertuslaan 78")
.WithLocality("Muizen")
.WithCountry(new Countries(this.Session).FindBy(M.Country.IsoCode, "BE"))
.Build();
var billingAddress = new PartyContactMechanismBuilder(this.Session)
.WithContactMechanism(homeAddress)
.WithContactPurpose(new ContactMechanismPurposes(this.Session).BillingAddress)
.WithUseAsDefault(true)
.Build();
customer.AddPartyContactMechanism(billingAddress);
new CustomerRelationshipBuilder(this.Session).WithFromDate(this.Session.Now()).WithCustomer(customer).Build();
this.Session.Derive();
var invoice = new SalesInvoiceBuilder(this.Session)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithAssignedBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.Build();
var mayFourteen2018 = new DateTime(2018, 5, 14, 12, 0, 0, DateTimeKind.Utc);
var timeShift = mayFourteen2018 - this.Session.Now();
this.TimeShift = timeShift;
var countBefore = new SalesInvoices(this.Session).Extent().Count;
var repeatingInvoice = new RepeatingSalesInvoiceBuilder(this.Session)
.WithSource(invoice)
.WithFrequency(new TimeFrequencies(this.Session).Week)
.WithDayOfWeek(new DaysOfWeek(this.Session).Monday)
.WithNextExecutionDate(mayFourteen2018)
.Build();
Assert.False(this.Session.Derive(false).HasErrors);
RepeatingSalesInvoices.Daily(this.Session);
Assert.Equal(countBefore + 1, new SalesInvoices(this.Session).Extent().Count);
Assert.Equal(new DateTime(2018, 5, 21), repeatingInvoice.NextExecutionDate.Date);
Assert.Single(repeatingInvoice.SalesInvoices);
}
public void GivenCustomerWithUnpaidInvoices_WhenDeriving_ThenAmountOverDueIsUpdated()
{
var mechelen = new CityBuilder(this.Session).WithName("Mechelen").Build();
var customer = new PersonBuilder(this.Session).WithLastName("customer").Build();
var customerRelationship = new CustomerRelationshipBuilder(this.Session).WithFromDate(DateTime.UtcNow.AddDays(-31)).WithCustomer(customer).Build();
Session.Derive();
var partyFinancial = customer.PartyFinancialRelationshipsWhereParty.First(v => Equals(v.InternalOrganisation, customerRelationship.InternalOrganisation));
var billToContactMechanism = new PostalAddressBuilder(this.Session).WithGeographicBoundary(mechelen).WithAddress1("Mechelen").Build();
var good = new Goods(this.Session).FindBy(M.Good.Name, "good1");
good.VatRate = new VatRateBuilder(this.Session).WithRate(0).Build();
this.Session.Derive();
var invoice1 = new SalesInvoiceBuilder(this.Session)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(billToContactMechanism)
.WithInvoiceDate(DateTime.UtcNow.AddDays(-30))
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.Session).WithProduct(good).WithQuantity(1).WithActualUnitPrice(100M).WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem).Build())
.Build();
this.Session.Derive();
var invoice2 = new SalesInvoiceBuilder(this.Session)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(billToContactMechanism)
.WithInvoiceDate(DateTime.UtcNow.AddDays(-5))
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.Session).WithProduct(good).WithQuantity(1).WithActualUnitPrice(200M).WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem).Build())
.Build();
this.Session.Derive();
Assert.Equal(100M, partyFinancial.AmountOverDue);
new ReceiptBuilder(this.Session)
.WithAmount(20)
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(invoice1.SalesInvoiceItems[0]).WithAmountApplied(20).Build())
.Build();
this.Session.Derive();
Assert.Equal(80, partyFinancial.AmountOverDue);
invoice2.InvoiceDate = DateTime.UtcNow.AddDays(-10);
this.Session.Derive();
Assert.Equal(280, partyFinancial.AmountOverDue);
}
public static SalesInvoiceBuilder WithSalesInternalInvoiceDefaults(this SalesInvoiceBuilder @this, Organisation internalOrganisation)
{
var faker = @this.Session.Faker();
var internalOrganisations = @this.Session.Extent <Organisation>();
var otherInternalOrganization = internalOrganisations.Except(new List <Organisation> {
internalOrganisation
}).FirstOrDefault();
var endCustomer = faker.Random.ListItem(internalOrganisation.ActiveCustomers);
var salesInvoiceItem_Default = new SalesInvoiceItemBuilder(@this.Session).WithDefaults().Build();
var salesInvoiceItem_Product = new SalesInvoiceItemBuilder(@this.Session).WithProductItemDefaults().Build();
var salesInvoiceItem_Part = new SalesInvoiceItemBuilder(@this.Session).WithPartItemDefaults().Build();
var salesInvoiceType = new SalesInvoiceTypes(@this.Session).SalesInvoice;
var paymentMethod = faker.Random.ListItem(@this.Session.Extent <PaymentMethod>());
@this.WithCustomerReference(faker.Random.String(16).ToUpper(CultureInfo.CurrentCulture));
@this.WithBilledFrom(internalOrganisation);
@this.WithBilledFromContactMechanism(internalOrganisation.CurrentPartyContactMechanisms.Select(v => v.ContactMechanism).FirstOrDefault());
@this.WithBilledFromContactPerson(internalOrganisation.CurrentContacts.FirstOrDefault());
@this.WithDescription(faker.Lorem.Sentence());
@this.WithComment(faker.Lorem.Sentence());
@this.WithInternalComment(faker.Lorem.Sentence());
@this.WithBillToCustomer(otherInternalOrganization.CurrentContacts.FirstOrDefault());
@this.WithBillToContactMechanism(otherInternalOrganization.CurrentPartyContactMechanisms.Select(v => v.ContactMechanism).FirstOrDefault());
@this.WithBillToContactPerson(otherInternalOrganization.CurrentContacts.FirstOrDefault());
@this.WithBillToEndCustomer(endCustomer);
@this.WithBillToEndCustomerContactMechanism(endCustomer.CurrentPartyContactMechanisms.Select(v => v.ContactMechanism).FirstOrDefault());
@this.WithBillToEndCustomerContactPerson(endCustomer.CurrentContacts.FirstOrDefault());
@this.WithShipToEndCustomer(endCustomer);
@this.WithShipToEndCustomerAddress(endCustomer.ShippingAddress);
@this.WithShipToEndCustomerContactPerson(endCustomer.CurrentContacts.FirstOrDefault());
@this.WithShipToCustomer(otherInternalOrganization);
@this.WithShipToAddress(otherInternalOrganization.ShippingAddress);
@this.WithShipToContactPerson(otherInternalOrganization.CurrentContacts.FirstOrDefault());
@this.WithSalesInvoiceType(salesInvoiceType);
@this.WithTotalListPrice(faker.Random.Decimal());
@this.WithPaymentMethod(paymentMethod);
@this.WithSalesInvoiceItem(salesInvoiceItem_Default);
@this.WithSalesInvoiceItem(salesInvoiceItem_Product);
@this.WithSalesInvoiceItem(salesInvoiceItem_Part);
@this.WithAdvancePayment(faker.Random.Decimal());
@this.WithPaymentDays(faker.Random.Int(7, 30));
@this.WithIsRepeatingInvoice(faker.Random.Bool());
@this.WithSalesTerm(new IncoTermBuilder(@this.Session).WithDefaults().Build());
@this.WithSalesTerm(new InvoiceTermBuilder(@this.Session).WithDefaults().Build());
@this.WithSalesTerm(new OrderTermBuilder(@this.Session).WithDefaults().Build());
return(@this);
}
public void AppsCreateSalesInvoice(PurchaseInvoiceCreateSalesInvoice method)
{
var derivation = new Derivation(this.Strategy.Session);
var salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithPurchaseInvoice(this)
.WithBilledFrom(this.BilledTo)
.WithBilledFromContactPerson(this.BilledToContactPerson)
.WithBillToCustomer(this.BillToEndCustomer)
.WithBillToContactMechanism(this.BillToEndCustomerContactMechanism)
.WithBillToContactPerson(this.BillToEndCustomerContactPerson)
.WithShipToCustomer(this.ShipToEndCustomer)
.WithShipToAddress(this.ShipToEndCustomerAddress)
.WithShipToContactPerson(this.ShipToEndCustomerContactPerson)
.WithDescription(this.Description)
.WithInvoiceDate(DateTime.UtcNow)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Strategy.Session).SalesInvoice)
.WithVatRegime(this.VatRegime)
.WithDiscountAdjustment(this.DiscountAdjustment)
.WithSurchargeAdjustment(this.SurchargeAdjustment)
.WithShippingAndHandlingCharge(this.ShippingAndHandlingCharge)
.WithFee(this.Fee)
.WithCustomerReference(this.CustomerReference)
.WithPaymentMethod(this.BillToCustomerPaymentMethod)
.WithComment(this.Comment)
.WithInternalComment(this.InternalComment)
.Build();
foreach (PurchaseInvoiceItem purchaseInvoiceItem in this.PurchaseInvoiceItems)
{
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithInvoiceItemType(purchaseInvoiceItem.InvoiceItemType)
.WithActualUnitPrice(purchaseInvoiceItem.ActualUnitPrice)
.WithProduct(purchaseInvoiceItem.Product)
.WithQuantity(purchaseInvoiceItem.Quantity)
.WithComment(purchaseInvoiceItem.Comment)
.WithInternalComment(purchaseInvoiceItem.InternalComment)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
}
var internalOrganisation = (InternalOrganisation)salesInvoice.BilledFrom;
if (!internalOrganisation.ActiveCustomers.Contains(salesInvoice.BillToCustomer))
{
new CustomerRelationshipBuilder(this.strategy.Session)
.WithCustomer(salesInvoice.BillToCustomer)
.WithInternalOrganisation(internalOrganisation)
.Build();
}
}
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 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_WhenDeriving_ThenAmountCanNotBeSmallerThenAmountApplied()
{
this.InstantiateObjects(this.Session);
var billToContactMechanism = new EmailAddressBuilder(this.Session).WithElectronicAddressString("*****@*****.**").Build();
var customer = new PersonBuilder(this.Session)
.WithLastName("customer")
.Build();
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(customer)
.Build();
var invoice = new SalesInvoiceBuilder(this.Session)
.WithBillToCustomer(customer)
.WithAssignedBillToContactMechanism(billToContactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.Session)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.WithProduct(this.good)
.WithQuantity(1)
.WithAssignedUnitPrice(100M)
.Build())
.Build();
this.Session.Derive();
var receipt = new ReceiptBuilder(this.Session)
.WithAmount(100)
.WithEffectiveDate(this.Session.Now())
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(invoice.SalesInvoiceItems[0]).WithAmountApplied(50).Build())
.Build();
Assert.False(this.Session.Derive(false).HasErrors);
receipt.AddPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(invoice.SalesInvoiceItems[0]).WithAmountApplied(50).Build());
Assert.False(this.Session.Derive(false).HasErrors);
receipt.AddPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(invoice.SalesInvoiceItems[0]).WithAmountApplied(1).Build());
var derivationLog = this.Session.Derive(false);
Assert.True(derivationLog.HasErrors);
Assert.Contains(M.PaymentApplication.AmountApplied, derivationLog.Errors[0].RoleTypes);
}
public async Task Importing_WithReadingInvoiceNotHavingSameTotalAndLineSums_ReturnsError()
{
var invoice = new SalesInvoiceBuilder()
.WithInvoiceTotal(24m)
.WithLine(new SalesInvoiceLineBuilder().WithName("petri.works").WithAmount(1).WithUnitNetPrice(100m).WithVatPercentage(24));
var format = new AccountingEntryFormatStubBuilder().Build();
var sut = new SalesInvoicePdfServiceBuilder()
.WithReader(new SalesInvoiceReaderStubBuilder().WithReadPdfOk(invoice).Build())
.WithFormat(format)
.Build();
var actual = await sut.ToImportFormat(Array.Empty <byte>());
Assert.IsFalse(actual.IsOk);
Assert.AreEqual("Can't create accounting entry when lines total sum is -100,00", actual.Error);
}
public void GivenInternalOrganisationWithInvoiceSequenceFiscalYear_WhenCreatingInvoice_ThenInvoiceNumberFromFiscalYearMustBeUsed()
{
var store = new StoreBuilder(this.DatabaseSession).WithName("store")
.WithDefaultFacility(new Warehouses(this.DatabaseSession).FindBy(Warehouses.Meta.Name, "facility"))
.WithOwner(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithDefaultShipmentMethod(new ShipmentMethods(this.DatabaseSession).Ground)
.WithDefaultCarrier(new Carriers(this.DatabaseSession).Fedex)
.Build();
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var invoice1 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithStore(store)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
Assert.IsFalse(store.ExistSalesInvoiceCounter);
Assert.AreEqual(DateTime.UtcNow.Year, store.FiscalYearInvoiceNumbers.First.FiscalYear);
Assert.AreEqual("1", invoice1.InvoiceNumber);
var invoice2 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithStore(store)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.Build();
Assert.IsFalse(store.ExistSalesInvoiceCounter);
Assert.AreEqual(DateTime.UtcNow.Year, store.FiscalYearInvoiceNumbers.First.FiscalYear);
Assert.AreEqual("2", invoice2.InvoiceNumber);
}
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);
}
private static SalesInvoice InvoiceThis(this WorkEffort @this)
{
var salesInvoice = new SalesInvoiceBuilder(@this.Strategy.Session)
.WithBilledFrom(@this.TakenBy)
.WithBillToCustomer(@this.Customer)
.WithBillToContactPerson(@this.ContactPerson)
.WithInvoiceDate(@this.Strategy.Session.Now())
.WithSalesInvoiceType(new SalesInvoiceTypes(@this.Strategy.Session).SalesInvoice)
.Build();
CreateInvoiceItems(@this, salesInvoice);
foreach (WorkEffort childWorkEffort in @this.Children)
{
CreateInvoiceItems(childWorkEffort, salesInvoice);
}
return(salesInvoice);
}
public void GivenBillToCustomerWithDifferentCurrency_WhenDerivingPrices_ThenCalculatePricesInPreferredCurrency()
{
var poundSterling = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "GBP");
const decimal conversionfactor = 0.8553M;
var euroToPoundStirling = new UnitOfMeasureConversionBuilder(this.DatabaseSession)
.WithConversionFactor(conversionfactor)
.WithToUnitOfMeasure(poundSterling)
.WithStartDate(DateTime.UtcNow)
.Build();
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
euro.AddUnitOfMeasureConversion(euroToPoundStirling);
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
this.InstantiateObjects(this.DatabaseSession);
Assert.AreEqual(euro, this.invoice.CustomerCurrency);
this.billToCustomer.PreferredCurrency = poundSterling;
var newInvoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBillToCustomer(this.billToCustomer)
.WithBilledFromInternalOrganisation(this.internalOrganisation)
.WithBillToContactMechanism(this.billToContactMechanismMechelen)
.Build();
const decimal quantity = 3;
var item1 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(this.good).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).WithQuantity(quantity).Build();
newInvoice.AddSalesInvoiceItem(item1);
this.DatabaseSession.Derive(true);
Assert.AreEqual(poundSterling, newInvoice.CustomerCurrency);
Assert.AreEqual(decimal.Round(item1.TotalBasePrice * conversionfactor, 2), item1.TotalBasePriceCustomerCurrency);
Assert.AreEqual(0, item1.TotalDiscount);
Assert.AreEqual(0, item1.TotalSurcharge);
Assert.AreEqual(decimal.Round(item1.TotalExVat * conversionfactor, 2), item1.TotalExVatCustomerCurrency);
}
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 async Task Importing_WithReadingPdfSuccessfully_CreatesCorrectAccountingEntry()
{
var invoice = new SalesInvoiceBuilder()
.WithInvoiceTotal(124m)
.WithLine(new SalesInvoiceLineBuilder().WithName("petri.works").WithAmount(1).WithUnitNetPrice(100m).WithVatPercentage(24));
var format = new AccountingEntryFormatStubBuilder().Build();
var sut = new SalesInvoicePdfServiceBuilder()
.WithReader(new SalesInvoiceReaderStubBuilder().WithReadPdfOk(invoice).Build())
.WithFormat(format)
.Build();
var actual = await sut.ToImportFormat(Array.Empty <byte>());
var expected = new List <AccountingEntryLine>()
{
new Debit(new(1700), new("Counter transaction"), 124m, null, VatType.Undefined),
new Credit(new(3000), new("petri.works"), 100m, new(24), VatType.Sale)
};
format.Received(1).Format(Arg.Is <AccountingEntry>(value =>
value.GetLines().SequenceEqual(expected)
));
}
public void SalesInvoice()
{
var customer = new OrganisationBuilder(this.Session).WithName("Org1").Build();
var contactMechanism = new PostalAddressBuilder(this.Session)
.WithAddress1("Haverwerf 15")
.WithLocality("Mechelen")
.WithCountry(new Countries(this.Session).FindBy(M.Country.IsoCode, "BE"))
.Build();
var internalOrganisation = new Organisations(this.Session).Extent().First(o => o.IsInternalOrganisation);
new CustomerRelationshipBuilder(this.Session).WithCustomer(customer).WithInternalOrganisation(internalOrganisation).Build();
var salesInvoice = new SalesInvoiceBuilder(this.Session).WithBillToCustomer(customer).WithAssignedBillToContactMechanism(contactMechanism).Build();
this.Session.Derive();
var employee = new Employments(this.Session).Extent().Select(v => v.Employee).First();
this.Session.SetUser(employee);
Assert.True(salesInvoice.Strategy.IsNewInSession);
var acl = new AccessControlLists(employee)[salesInvoice];
Assert.True(acl.CanRead(M.SalesInvoice.Description));
Assert.False(acl.CanWrite(M.SalesInvoice.Description));
this.Session.Commit();
Assert.False(salesInvoice.Strategy.IsNewInSession);
acl = new AccessControlLists(employee)[salesInvoice];
Assert.True(acl.CanRead(M.SalesInvoice.Description));
Assert.False(acl.CanWrite(M.SalesInvoice.Description));
}
public void GivenProductWithMultipleBasePrices_WhenDeriving_ThenLowestUnitPriceMustBeCalculated()
{
this.InstantiateObjects(this.DatabaseSession);
this.invoice.ShipToAddress = this.billToContactMechanismMechelen;
var item1 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(this.good).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).WithQuantity(3).Build();
this.invoice.AddSalesInvoiceItem(item1);
this.DatabaseSession.Derive(true);
Assert.AreEqual(this.currentBasePriceGeoBoundary.Price, item1.CalculatedUnitPrice);
var invoice2 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBilledFromInternalOrganisation(this.internalOrganisation)
.WithBillToCustomer(this.billToCustomer)
.WithBillToContactMechanism(this.billToContactMechanismMechelen)
.Build();
item1 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(this.good).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).WithQuantity(3).Build();
invoice2.AddSalesInvoiceItem(item1);
this.DatabaseSession.Derive(true);
Assert.AreEqual(this.currentGood1BasePrice.Price, item1.CalculatedUnitPrice);
}
public void GivenInvoiceItemWithoutVatRegime_WhenDeriving_ThenItemDerivedVatRateIsFromInvoiceVatRegime()
{
this.InstantiateObjects(this.DatabaseSession);
var vatRate0 = new VatRates(this.DatabaseSession).FindBy(VatRates.Meta.Rate, 0);
var salesInvoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBilledFromInternalOrganisation(this.internalOrganisation)
.WithBillToCustomer(this.billToCustomer)
.WithBillToContactMechanism(this.billToContactMechanismMechelen)
.WithVatRegime(new VatRegimes(this.DatabaseSession).Export)
.Build();
var invoiceItem = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(this.good).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).WithQuantity(1).Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
this.DatabaseSession.Derive(true);
Assert.AreEqual(salesInvoice.VatRegime, invoiceItem.VatRegime);
Assert.AreEqual(vatRate0, invoiceItem.DerivedVatRate);
}
public void GivenSalesInvoiceCreatedBySalesRep_WhenCurrentUserInSameSalesRepUserGroup_ThenAccessIsGranted()
{
var customer = new Organisations(this.DatabaseSession).FindBy(Organisations.Meta.Name, "customer");
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var salesRep2 = new PersonBuilder(this.DatabaseSession).WithUserName("salesRep2").WithLastName("salesRep2").Build();
new EmploymentBuilder(this.DatabaseSession)
.WithEmployee(salesRep2)
.WithEmployer(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithFromDate(DateTime.UtcNow)
.Build();
new SalesRepRelationshipBuilder(this.DatabaseSession)
.WithSalesRepresentative(salesRep2)
.WithCustomer(customer)
.WithFromDate(DateTime.UtcNow)
.Build();
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("salesRep", "Forms"), new string[0]);
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
var acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsTrue(acl.CanWrite(SalesInvoices.Meta.Comment));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.Comment));
Assert.IsTrue(acl.CanExecute(SalesInvoices.Meta.Send));
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("salesRep2", "Forms"), new string[0]);
acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsTrue(acl.CanWrite(SalesInvoices.Meta.Comment));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.Comment));
Assert.IsTrue(acl.CanExecute(SalesInvoices.Meta.Send));
}
public void GivenCustomerWithUnpaidInvoices_WhenDeriving_ThenAmountOverDueIsUpdated()
{
var mechelen = new CityBuilder(this.DatabaseSession).WithName("Mechelen").Build();
var customer = new PersonBuilder(this.DatabaseSession).WithLastName("customer").Build();
var customerRelationship = new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).Build();
var billToContactMechanism = new PostalAddressBuilder(this.DatabaseSession).WithGeographicBoundary(mechelen).WithAddress1("Mechelen").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 invoice1 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(billToContactMechanism)
.WithInvoiceDate(DateTime.UtcNow.AddDays(-30))
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(1).WithActualUnitPrice(100M).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build())
.Build();
this.DatabaseSession.Derive(true);
var invoice2 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(billToContactMechanism)
.WithInvoiceDate(DateTime.UtcNow.AddDays(-5))
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(1).WithActualUnitPrice(200M).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build())
.Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(100M, customerRelationship.AmountOverDue);
new ReceiptBuilder(this.DatabaseSession)
.WithAmount(20)
.WithPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(invoice1.SalesInvoiceItems[0]).WithAmountApplied(20).Build())
.Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(80, customerRelationship.AmountOverDue);
invoice2.InvoiceDate = DateTime.UtcNow.AddDays(-10);
this.DatabaseSession.Derive(true);
Assert.AreEqual(280, customerRelationship.AmountOverDue);
}
public void GivenSalesInvoiceCreatedBySalesRep_WhenCurrentUserIsSupplier_ThenAccessIsDenied()
{
var customer = new Organisations(this.DatabaseSession).FindBy(Organisations.Meta.Name, "customer");
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var supplierContact = new PersonBuilder(this.DatabaseSession).WithUserName("suppliercontact").WithLastName("suppliercontact").Build();
var supplier = new OrganisationBuilder(this.DatabaseSession).WithName("supplier").Build();
new SupplierRelationshipBuilder(this.DatabaseSession)
.WithSupplier(supplier)
.WithInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithFromDate(DateTime.UtcNow)
.Build();
new OrganisationContactRelationshipBuilder(this.DatabaseSession).WithContact(supplierContact).WithOrganisation(supplier).WithFromDate(DateTime.UtcNow).Build();
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("salesRep", "Forms"), new string[0]);
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("suppliercontact", "Forms"), new string[0]);
var acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsFalse(acl.HasReadOperation);
}
public void GivenSalesInvoiceWithShipToCustomerWithShippingAddress_WhenDeriving_ThenShipToAddressMustExist()
{
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var mechelen = new CityBuilder(this.DatabaseSession).WithName("Mechelen").Build();
ContactMechanism shipToContactMechanism = new PostalAddressBuilder(this.DatabaseSession).WithAddress1("Haverwerf 15").WithGeographicBoundary(mechelen).Build();
var shippingAddress = new PartyContactMechanismBuilder(this.DatabaseSession)
.WithContactMechanism(shipToContactMechanism)
.WithContactPurpose(new ContactMechanismPurposes(this.DatabaseSession).ShippingAddress)
.WithUseAsDefault(true)
.Build();
customer.AddPartyContactMechanism(shippingAddress);
this.DatabaseSession.Derive(true);
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBillToCustomer(customer)
.WithShipToCustomer(customer)
.WithBillToContactMechanism(shipToContactMechanism)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(shippingAddress.ContactMechanism, invoice.ShipToAddress);
}
public void GivenSalesInvoice_WhenGettingInvoiceNumberWithFormat_ThenFormattedInvoiceNumberShouldBeReturned()
{
var store = new StoreBuilder(this.DatabaseSession).WithName("store")
.WithDefaultFacility(new Warehouses(this.DatabaseSession).FindBy(Warehouses.Meta.Name, "facility"))
.WithOwner(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithSalesInvoiceNumberPrefix("the format is ")
.WithDefaultShipmentMethod(new ShipmentMethods(this.DatabaseSession).Ground)
.WithDefaultCarrier(new Carriers(this.DatabaseSession).Fedex)
.Build();
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithStore(store)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
Assert.AreEqual("the format is 1", invoice.InvoiceNumber);
}
public void GivenReceipt_WhenDeriving_ThenAmountCanNotBeSmallerThenAmountApplied()
{
this.InstantiateObjects(this.DatabaseSession);
var billToContactMechanism = new EmailAddressBuilder(this.DatabaseSession).WithElectronicAddressString("*****@*****.**").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(billToContactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession)
.WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem)
.WithProduct(this.good)
.WithQuantity(1)
.WithActualUnitPrice(100M)
.Build())
.Build();
this.DatabaseSession.Derive(true);
var receipt = new ReceiptBuilder(this.DatabaseSession)
.WithAmount(100)
.WithEffectiveDate(DateTime.UtcNow)
.WithPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(invoice.SalesInvoiceItems[0]).WithAmountApplied(50).Build())
.Build();
Assert.IsFalse(this.DatabaseSession.Derive().HasErrors);
receipt.AddPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(invoice.SalesInvoiceItems[0]).WithAmountApplied(50).Build());
Assert.IsFalse(this.DatabaseSession.Derive().HasErrors);
receipt.AddPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(invoice.SalesInvoiceItems[0]).WithAmountApplied(1).Build());
var derivationLog = this.DatabaseSession.Derive();
Assert.IsTrue(derivationLog.HasErrors);
Assert.Contains(Receipts.Meta.Amount, derivationLog.Errors[0].RoleTypes);
}
public void AppsOnDeriveInvoices(IDerivation derivation)
{
var invoiceByOrder = new Dictionary<Allors.Domain.SalesOrder, Allors.Domain.SalesInvoice>();
var costsInvoiced = false;
foreach (ShipmentItem shipmentItem in this.ShipmentItems)
{
foreach (OrderShipment orderShipment in shipmentItem.OrderShipmentsWhereShipmentItem)
{
var salesOrder = orderShipment.SalesOrderItem.SalesOrderWhereSalesOrderItem;
Allors.Domain.SalesInvoice salesInvoice;
if (!invoiceByOrder.TryGetValue(salesOrder, out salesInvoice))
{
salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithStore(salesOrder.Store)
.WithInvoiceDate(DateTime.UtcNow)
.WithSalesChannel(salesOrder.SalesChannel)
.WithSalesInvoiceType(new Allors.Domain.SalesInvoiceTypes(this.Strategy.Session).SalesInvoice)
.WithVatRegime(salesOrder.VatRegime)
.WithBilledFromContactMechanism(this.BillFromContactMechanism)
.WithBilledFromInternalOrganisation(this.BillFromInternalOrganisation)
.WithBillToContactMechanism(this.BillToContactMechanism)
.WithBillToCustomer(this.BillToParty)
.WithShipToCustomer(this.ShipToParty)
.WithShipToAddress(this.ShipToAddress)
.WithDiscountAdjustment(salesOrder.DiscountAdjustment)
.WithSurchargeAdjustment(salesOrder.SurchargeAdjustment)
.WithShippingAndHandlingCharge(salesOrder.ShippingAndHandlingCharge)
.WithFee(salesOrder.Fee)
.WithCustomerReference(salesOrder.CustomerReference)
.WithPaymentMethod(this.PaymentMethod)
.Build();
invoiceByOrder.Add(salesOrder, salesInvoice);
if (!costsInvoiced)
{
var costs = this.AppsOnDeriveShippingAndHandlingCharges(derivation);
if (costs > 0)
{
salesInvoice.ShippingAndHandlingCharge = new ShippingAndHandlingChargeBuilder(this.Strategy.Session).WithAmount(costs).Build();
costsInvoiced = true;
}
}
}
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithSalesInvoiceItemType(new Allors.Domain.SalesInvoiceItemTypes(this.Strategy.Session).ProductItem)
.WithProduct(orderShipment.SalesOrderItem.Product)
.WithQuantity(orderShipment.Quantity)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
shipmentItem.AddInvoiceItem(invoiceItem);
}
foreach (var keyValuePair in invoiceByOrder)
{
// TODO: put this in prepare
// keyValuePair.Value.Derive(x=>x.WithDerivation(derivation));
}
}
}
public SalesInvoice AppsCopy(SalesInvoiceCopy method)
{
var salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithPurchaseInvoice(this.PurchaseInvoice)
.WithBilledFrom(this.BilledFrom)
.WithBilledFromContactMechanism(this.BilledFromContactMechanism)
.WithBilledFromContactPerson(this.BilledFromContactPerson)
.WithBillToCustomer(this.BillToCustomer)
.WithBillToContactMechanism(this.BillToContactMechanism)
.WithBillToContactPerson(this.BillToContactPerson)
.WithBillToEndCustomer(this.BillToEndCustomer)
.WithBillToEndCustomerContactMechanism(this.BillToEndCustomerContactMechanism)
.WithBillToEndCustomerContactPerson(this.BillToEndCustomerContactPerson)
.WithShipToCustomer(this.ShipToCustomer)
.WithShipToAddress(this.ShipToAddress)
.WithShipToContactPerson(this.ShipToContactPerson)
.WithShipToEndCustomer(this.ShipToEndCustomer)
.WithShipToEndCustomerAddress(this.ShipToEndCustomerAddress)
.WithShipToEndCustomerContactPerson(this.ShipToEndCustomerContactPerson)
.WithDescription(this.Description)
.WithStore(this.Store)
.WithInvoiceDate(DateTime.UtcNow)
.WithSalesChannel(this.SalesChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Strategy.Session).SalesInvoice)
.WithVatRegime(this.VatRegime)
.WithDiscountAdjustment(this.DiscountAdjustment)
.WithSurchargeAdjustment(this.SurchargeAdjustment)
.WithShippingAndHandlingCharge(this.ShippingAndHandlingCharge)
.WithFee(this.Fee)
.WithCustomerReference(this.CustomerReference)
.WithPaymentMethod(this.PaymentMethod)
.WithComment(this.Comment)
.WithInternalComment(this.InternalComment)
.WithMessage(this.Message)
.WithBillingAccount(this.BillingAccount)
.Build();
foreach (SalesInvoiceItem salesInvoiceItem in this.SalesInvoiceItems)
{
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithInvoiceItemType(salesInvoiceItem.InvoiceItemType)
.WithActualUnitPrice(salesInvoiceItem.ActualUnitPrice)
.WithProduct(salesInvoiceItem.Product)
.WithProductFeature(salesInvoiceItem.ProductFeature)
.WithQuantity(salesInvoiceItem.Quantity)
.WithDescription(salesInvoiceItem.Description)
.WithSerialisedItem(salesInvoiceItem.SerialisedItem)
.WithComment(salesInvoiceItem.Comment)
.WithDetails(salesInvoiceItem.Details)
.WithInternalComment(salesInvoiceItem.InternalComment)
.WithMessage(salesInvoiceItem.Message)
.WithFacility(salesInvoiceItem.Facility)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
foreach (SalesTerm salesTerm in salesInvoiceItem.SalesTerms)
{
if (salesTerm.GetType().Name == typeof(IncoTerm).Name)
{
salesInvoiceItem.AddSalesTerm(new IncoTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(InvoiceTerm).Name)
{
salesInvoiceItem.AddSalesTerm(new InvoiceTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(OrderTerm).Name)
{
salesInvoiceItem.AddSalesTerm(new OrderTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
}
}
foreach (SalesTerm salesTerm in this.SalesTerms)
{
if (salesTerm.GetType().Name == typeof(IncoTerm).Name)
{
salesInvoice.AddSalesTerm(new IncoTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(InvoiceTerm).Name)
{
salesInvoice.AddSalesTerm(new InvoiceTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(OrderTerm).Name)
{
salesInvoice.AddSalesTerm(new OrderTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
}
return(salesInvoice);
}
public void GivenSalesInvoiceWithShippingAndHandlingPercentage_WhenDeriving_ThenSalesInvoiceTotalsMustIncludeShippingAndHandlingAmount()
{
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
var vatRate21 = new VatRateBuilder(this.DatabaseSession).WithRate(21).Build();
var adjustment = new ShippingAndHandlingChargeBuilder(this.DatabaseSession).WithPercentage(5).WithVatRate(vatRate21).Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var good = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(vatRate21)
.WithName("good")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.Build();
var internalOrganisation = new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation");
internalOrganisation.PreferredCurrency = euro;
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceNumber("1")
.WithBillToCustomer(new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build())
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithShippingAndHandlingCharge(adjustment)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(invoice.BillToCustomer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
var item1 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build();
invoice.AddSalesInvoiceItem(item1);
this.DatabaseSession.Derive(true);
Assert.AreEqual(45, invoice.TotalBasePrice);
Assert.AreEqual(0, invoice.TotalDiscount);
Assert.AreEqual(0, invoice.TotalSurcharge);
Assert.AreEqual(2.25, invoice.TotalShippingAndHandling);
Assert.AreEqual(0, invoice.TotalFee);
Assert.AreEqual(47.25, invoice.TotalExVat);
Assert.AreEqual(9.92, invoice.TotalVat);
Assert.AreEqual(57.17, invoice.TotalIncVat);
}
public void GivenSalesInvoiceBuilderWithoutBillToCustomer_WhenBuilding_ThenDerivedCurrencyIsInternalOrganisationsPreferredCurrency()
{
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
var internalOrganisation = new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation");
internalOrganisation.PreferredCurrency = euro;
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(internalOrganisation)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
Assert.AreEqual(euro, invoice.CustomerCurrency);
}
public void GivenSalesInvoice_WhenBuild_ThenPreviousObjectStateIsNull()
{
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
Assert.IsNull(invoice.PreviousObjectState);
}
public void GivenSalesInvoice_WhenBillToCustomerChangesValue_ThenAccessPreviousCustomerIsDenied()
{
var customer = new Organisations(this.DatabaseSession).FindBy(Organisations.Meta.Name, "customer");
var customer2 = new OrganisationBuilder(this.DatabaseSession).WithName("customer2").Build();
var customerContact = new PersonBuilder(this.DatabaseSession).WithUserName("customercontact").WithLastName("customercontact").Build();
var customerContact2 = new PersonBuilder(this.DatabaseSession).WithUserName("customercontact2").WithLastName("customercontact2").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession)
.WithCustomer(customer2)
.WithInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithFromDate(DateTime.UtcNow.Date)
.Build();
new OrganisationContactRelationshipBuilder(this.DatabaseSession).WithContact(customerContact).WithOrganisation(customer).WithFromDate(DateTime.UtcNow).Build();
new OrganisationContactRelationshipBuilder(this.DatabaseSession).WithContact(customerContact2).WithOrganisation(customer2).WithFromDate(DateTime.UtcNow).Build();
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("salesRep", "Forms"), new string[0]);
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.Build();
this.DatabaseSession.Derive(true);
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("customercontact", "Forms"), new string[0]);
var acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsFalse(acl.CanWrite(SalesInvoices.Meta.InvoiceDate));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.InvoiceDate));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.InvoiceNumber));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.TotalExVat));
Assert.IsFalse(acl.CanExecute(SalesInvoices.Meta.Send));
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("customercontact2", "Forms"), new string[0]);
acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsFalse(acl.HasReadOperation);
invoice.BillToCustomer = customer2;
this.DatabaseSession.Derive(true);
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("customercontact", "Forms"), new string[0]);
acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsFalse(acl.HasReadOperation);
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("customercontact2", "Forms"), new string[0]);
acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsFalse(acl.CanWrite(SalesInvoices.Meta.InvoiceDate));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.InvoiceDate));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.InvoiceNumber));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.TotalExVat));
Assert.IsFalse(acl.CanExecute(SalesInvoices.Meta.Send));
}
public void GivenSalesInvoiceCreatedBySalesRep_WhenCurrentUserInAnotherSalesRepUserGroup_ThenAccessIsDenied()
{
var salesRep2 = new PersonBuilder(this.DatabaseSession).WithUserName("salesRep2").WithLastName("salesRep2").Build();
var customer2 = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var belgium = new Countries(this.DatabaseSession).CountryByIsoCode["BE"];
var euro = belgium.Currency;
var mechelen = new CityBuilder(this.DatabaseSession).WithName("Mechelen").Build();
var mechelenAddress = new PostalAddressBuilder(this.DatabaseSession).WithGeographicBoundary(mechelen).WithAddress1("Haverwerf 15").Build();
var billToMechelen = new PartyContactMechanismBuilder(this.DatabaseSession)
.WithContactMechanism(mechelenAddress)
.WithContactPurpose(new ContactMechanismPurposes(this.DatabaseSession).BillingAddress)
.WithUseAsDefault(true)
.Build();
var bank = new BankBuilder(this.DatabaseSession).WithCountry(belgium).WithName("ING België").WithBic("BBRUBEBB").Build();
var ownBankAccount = new OwnBankAccountBuilder(this.DatabaseSession)
.WithDescription("BE23 3300 6167 6391")
.WithBankAccount(new BankAccountBuilder(this.DatabaseSession).WithBank(bank).WithCurrency(euro).WithIban("BE23 3300 6167 6391").WithNameOnAccount("Koen").Build())
.Build();
var internalOrganisation2 = new InternalOrganisationBuilder(this.DatabaseSession)
.WithName("internalOrganisation2")
.WithLocale(new Locales(this.DatabaseSession).EnglishGreatBritain)
.WithEmployeeRole(new Roles(this.DatabaseSession).Administrator)
.WithEmployeeRole(new Roles(this.DatabaseSession).Sales)
.WithDefaultPaymentMethod(ownBankAccount)
.WithPreferredCurrency(euro)
.WithPartyContactMechanism(billToMechelen)
.Build();
var facility = new WarehouseBuilder(this.DatabaseSession).WithName("facility").WithOwner(internalOrganisation2).Build();
internalOrganisation2.DefaultFacility = facility;
new StoreBuilder(this.DatabaseSession)
.WithName("store")
.WithDefaultFacility(facility)
.WithOwner(internalOrganisation2)
.WithDefaultShipmentMethod(new ShipmentMethods(this.DatabaseSession).Ground)
.WithDefaultCarrier(new Carriers(this.DatabaseSession).Fedex)
.WithCreditLimit(500)
.WithPaymentGracePeriod(10)
.Build();
new EmploymentBuilder(this.DatabaseSession).WithEmployee(salesRep2).WithEmployer(internalOrganisation2).WithFromDate(DateTime.UtcNow).Build();
new CustomerRelationshipBuilder(this.DatabaseSession)
.WithCustomer(customer2)
.WithInternalOrganisation(internalOrganisation2)
.WithFromDate(DateTime.UtcNow)
.Build();
new SalesRepRelationshipBuilder(this.DatabaseSession)
.WithSalesRepresentative(salesRep2)
.WithCustomer(customer2)
.WithInternalOrganisation(internalOrganisation2)
.WithFromDate(DateTime.UtcNow)
.Build();
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("salesRep2", "Forms"), new string[0]);
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBilledFromInternalOrganisation(internalOrganisation2)
.WithBillToCustomer(customer2)
.WithBillToContactMechanism(contactMechanism)
.Build();
this.DatabaseSession.Derive(true);
var acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsTrue(acl.CanWrite(SalesInvoices.Meta.Comment));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.Comment));
Assert.IsTrue(acl.CanExecute(SalesInvoices.Meta.Send));
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("salesRep", "Forms"), new string[0]);
acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsFalse(acl.HasReadOperation);
}
public void GivenSalesInvoice_WhenObjectStateIsPartiallyPaid_ThenCheckTransitions()
{
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var administrator = new PersonBuilder(this.DatabaseSession).WithFirstName("Koen").WithUserName("administrator").Build();
var administrators = new UserGroups(this.DatabaseSession).Administrators;
administrators.AddMember(administrator);
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);
this.DatabaseSession.Commit();
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("administrator", "Forms"), new string[0]);
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(1).WithActualUnitPrice(100M).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build())
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
new ReceiptBuilder(this.DatabaseSession)
.WithAmount(90)
.WithPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(invoice.SalesInvoiceItems[0]).WithAmountApplied(90).Build())
.Build();
this.DatabaseSession.Derive(true);
var acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsFalse(acl.CanExecute(SalesInvoices.Meta.Send));
Assert.IsTrue(acl.CanExecute(SalesInvoices.Meta.WriteOff));
Assert.IsFalse(acl.CanExecute(SalesInvoices.Meta.CancelInvoice));
}
public void BaseInvoice(CustomerShipmentInvoice method)
{
if (this.ShipmentState.Equals(new ShipmentStates(this.Strategy.Session).Shipped) &&
Equals(this.Store.BillingProcess, new BillingProcesses(this.Strategy.Session).BillingForShipmentItems))
{
var invoiceByOrder = new Dictionary <SalesOrder, SalesInvoice>();
var costsInvoiced = false;
foreach (ShipmentItem shipmentItem in this.ShipmentItems)
{
foreach (OrderShipment orderShipment in shipmentItem.OrderShipmentsWhereShipmentItem)
{
var salesOrder = orderShipment.OrderItem.OrderWhereValidOrderItem as SalesOrder;
if (!invoiceByOrder.TryGetValue(salesOrder, out var salesInvoice))
{
salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithStore(salesOrder.Store)
.WithBilledFrom(salesOrder.TakenBy)
.WithAssignedBilledFromContactMechanism(salesOrder.DerivedTakenByContactMechanism)
.WithBilledFromContactPerson(salesOrder.TakenByContactPerson)
.WithBillToCustomer(salesOrder.BillToCustomer)
.WithAssignedBillToContactMechanism(salesOrder.DerivedBillToContactMechanism)
.WithBillToContactPerson(salesOrder.BillToContactPerson)
.WithBillToEndCustomer(salesOrder.BillToEndCustomer)
.WithAssignedBillToEndCustomerContactMechanism(salesOrder.DerivedBillToEndCustomerContactMechanism)
.WithBillToEndCustomerContactPerson(salesOrder.BillToEndCustomerContactPerson)
.WithShipToCustomer(salesOrder.ShipToCustomer)
.WithAssignedShipToAddress(salesOrder.DerivedShipToAddress)
.WithShipToContactPerson(salesOrder.ShipToContactPerson)
.WithShipToEndCustomer(salesOrder.ShipToEndCustomer)
.WithAssignedShipToEndCustomerAddress(salesOrder.DerivedShipToEndCustomerAddress)
.WithShipToEndCustomerContactPerson(salesOrder.ShipToEndCustomerContactPerson)
.WithInvoiceDate(this.Session().Now())
.WithSalesChannel(salesOrder.SalesChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Strategy.Session).SalesInvoice)
.WithAssignedVatRegime(salesOrder.DerivedVatRegime)
.WithAssignedIrpfRegime(salesOrder.DerivedIrpfRegime)
.WithCustomerReference(salesOrder.CustomerReference)
.WithAssignedPaymentMethod(this.PaymentMethod)
.Build();
invoiceByOrder.Add(salesOrder, salesInvoice);
foreach (OrderAdjustment orderAdjustment in salesOrder.OrderAdjustments)
{
OrderAdjustment newAdjustment = null;
if (orderAdjustment.GetType().Name.Equals(typeof(DiscountAdjustment).Name))
{
newAdjustment = new DiscountAdjustmentBuilder(this.Session()).Build();
}
if (orderAdjustment.GetType().Name.Equals(typeof(SurchargeAdjustment).Name))
{
newAdjustment = new SurchargeAdjustmentBuilder(this.Session()).Build();
}
if (orderAdjustment.GetType().Name.Equals(typeof(Fee).Name))
{
newAdjustment = new FeeBuilder(this.Session()).Build();
}
if (orderAdjustment.GetType().Name.Equals(typeof(ShippingAndHandlingCharge).Name))
{
newAdjustment = new ShippingAndHandlingChargeBuilder(this.Session()).Build();
}
if (orderAdjustment.GetType().Name.Equals(typeof(MiscellaneousCharge).Name))
{
newAdjustment = new MiscellaneousChargeBuilder(this.Session()).Build();
}
newAdjustment.Amount ??= orderAdjustment.Amount;
newAdjustment.Percentage ??= orderAdjustment.Percentage;
salesInvoice.AddOrderAdjustment(newAdjustment);
}
if (!costsInvoiced)
{
var costs = this.BaseOnDeriveShippingAndHandlingCharges();
if (costs > 0)
{
salesInvoice.AddOrderAdjustment(new ShippingAndHandlingChargeBuilder(this.Strategy.Session).WithAmount(costs).Build());
costsInvoiced = true;
}
}
foreach (SalesTerm salesTerm in salesOrder.SalesTerms)
{
if (salesTerm.GetType().Name == typeof(IncoTerm).Name)
{
salesInvoice.AddSalesTerm(new IncoTermBuilder(this.Strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(InvoiceTerm).Name)
{
salesInvoice.AddSalesTerm(new InvoiceTermBuilder(this.Strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(OrderTerm).Name)
{
salesInvoice.AddSalesTerm(new OrderTermBuilder(this.Strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
}
}
var amountAlreadyInvoiced = shipmentItem.ShipmentItemBillingsWhereShipmentItem.Sum(v => v.Amount);
var leftToInvoice = (orderShipment.OrderItem.QuantityOrdered * orderShipment.OrderItem.AssignedUnitPrice) - amountAlreadyInvoiced;
if (leftToInvoice > 0)
{
if (orderShipment.OrderItem is SalesOrderItem salesOrderItem)
{
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithInvoiceItemType(new InvoiceItemTypes(this.Strategy.Session).ProductItem)
.WithProduct(salesOrderItem.Product)
.WithQuantity(orderShipment.Quantity)
.WithAssignedUnitPrice(salesOrderItem.UnitPrice)
.WithAssignedVatRegime(salesOrderItem.AssignedVatRegime)
.WithDescription(salesOrderItem.Description)
.WithInternalComment(salesOrderItem.InternalComment)
.WithMessage(salesOrderItem.Message)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
new ShipmentItemBillingBuilder(this.Strategy.Session)
.WithQuantity(shipmentItem.Quantity)
.WithAmount(leftToInvoice)
.WithShipmentItem(shipmentItem)
.WithInvoiceItem(invoiceItem)
.Build();
}
}
}
}
}
}
public SalesInvoice AppsCredit(SalesInvoiceCredit method)
{
var salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithPurchaseInvoice(this.PurchaseInvoice)
.WithBilledFrom(this.BilledFrom)
.WithBilledFromContactMechanism(this.BilledFromContactMechanism)
.WithBilledFromContactPerson(this.BilledFromContactPerson)
.WithBillToCustomer(this.BillToCustomer)
.WithBillToContactMechanism(this.BillToContactMechanism)
.WithBillToContactPerson(this.BillToContactPerson)
.WithBillToEndCustomer(this.BillToEndCustomer)
.WithBillToEndCustomerContactMechanism(this.BillToEndCustomerContactMechanism)
.WithBillToEndCustomerContactPerson(this.BillToEndCustomerContactPerson)
.WithShipToCustomer(this.ShipToCustomer)
.WithShipToAddress(this.ShipToAddress)
.WithShipToContactPerson(this.ShipToContactPerson)
.WithShipToEndCustomer(this.ShipToEndCustomer)
.WithShipToEndCustomerAddress(this.ShipToEndCustomerAddress)
.WithShipToEndCustomerContactPerson(this.ShipToEndCustomerContactPerson)
.WithDescription(this.Description)
.WithStore(this.Store)
.WithInvoiceDate(DateTime.UtcNow)
.WithSalesChannel(this.SalesChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Strategy.Session).CreditNote)
.WithVatRegime(this.VatRegime)
.WithDiscountAdjustment(this.DiscountAdjustment)
.WithSurchargeAdjustment(this.SurchargeAdjustment)
.WithShippingAndHandlingCharge(this.ShippingAndHandlingCharge)
.WithCustomerReference(this.CustomerReference)
.WithPaymentMethod(this.PaymentMethod)
.WithBillingAccount(this.BillingAccount)
.Build();
if (this.ExistDiscountAdjustment)
{
salesInvoice.DiscountAdjustment = new DiscountAdjustmentBuilder(this.strategy.Session).WithAmount(this.DiscountAdjustment.Amount * -1).Build();
}
if (this.ExistSurchargeAdjustment)
{
salesInvoice.SurchargeAdjustment = new SurchargeAdjustmentBuilder(this.strategy.Session).WithAmount(this.SurchargeAdjustment.Amount * -1).Build();
}
foreach (SalesInvoiceItem salesInvoiceItem in this.SalesInvoiceItems)
{
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithInvoiceItemType(salesInvoiceItem.InvoiceItemType)
.WithActualUnitPrice(salesInvoiceItem.ActualUnitPrice * -1)
.WithProduct(salesInvoiceItem.Product)
.WithProductFeature(salesInvoiceItem.ProductFeature)
.WithQuantity(salesInvoiceItem.Quantity)
.WithDescription(salesInvoiceItem.Description)
.WithSerialisedItem(salesInvoiceItem.SerialisedItem)
.WithComment(salesInvoiceItem.Comment)
.WithDetails(salesInvoiceItem.Details)
.WithInternalComment(salesInvoiceItem.InternalComment)
.WithFacility(salesInvoiceItem.Facility)
.WithAssignedVatRegime(salesInvoiceItem.AssignedVatRegime)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
}
return(salesInvoice);
}
public void GiveninvoiceItem_WhenCancelled_ThenInvoiceItemsAreCancelled()
{
var billToCustomer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.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);
this.DatabaseSession.Commit();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBillToCustomer(billToCustomer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(1).WithActualUnitPrice(100M).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build())
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(1).WithActualUnitPrice(100M).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build())
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(invoice.BillToCustomer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
invoice.CancelInvoice();
this.DatabaseSession.Derive(true);
Assert.AreEqual(new SalesInvoiceObjectStates(this.DatabaseSession).Cancelled, invoice.CurrentObjectState);
Assert.AreEqual(new SalesInvoiceItemObjectStates(this.DatabaseSession).Cancelled, invoice.SalesInvoiceItems[0].CurrentObjectState);
Assert.AreEqual(new SalesInvoiceItemObjectStates(this.DatabaseSession).Cancelled, invoice.SalesInvoiceItems[1].CurrentObjectState);
}
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 SetUp()
{
_mockedSalesInvoiceBuilder = new Mock <SalesInvoiceBuilder>();
_salesInvoiceBuilder = _mockedSalesInvoiceBuilder.Object;
}
public void GivenSalesInvoice_WhenShipToAndBillToAreSameCustomer_ThenDerivedCustomersIsSingleCustomer()
{
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithShipToCustomer(customer)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(1, invoice.Customers.Count);
Assert.AreEqual(customer, invoice.Customers.First);
}
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 AppsInvoiceThis(IDerivation derivation)
{
var invoiceByOrder = new Dictionary <SalesOrder, SalesInvoice>();
var costsInvoiced = false;
foreach (ShipmentItem shipmentItem in this.ShipmentItems)
{
foreach (OrderShipment orderShipment in shipmentItem.OrderShipmentsWhereShipmentItem)
{
var salesOrder = orderShipment.OrderItem.OrderWhereValidOrderItem as SalesOrder;
var salesOrderItem = orderShipment.OrderItem as SalesOrderItem;
if (!invoiceByOrder.TryGetValue(salesOrder, out var salesInvoice))
{
salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithStore(salesOrder.Store)
.WithBilledFrom(salesOrder.TakenBy)
.WithBilledFromContactMechanism(salesOrder.TakenByContactMechanism)
.WithBilledFromContactPerson(salesOrder.TakenByContactPerson)
.WithBillToCustomer(salesOrder.BillToCustomer)
.WithBillToContactMechanism(salesOrder.BillToContactMechanism)
.WithBillToContactPerson(salesOrder.BillToContactPerson)
.WithBillToEndCustomer(salesOrder.BillToEndCustomer)
.WithBillToEndCustomerContactMechanism(salesOrder.BillToEndCustomerContactMechanism)
.WithBillToEndCustomerContactPerson(salesOrder.BillToEndCustomerContactPerson)
.WithShipToCustomer(salesOrder.ShipToCustomer)
.WithShipToAddress(salesOrder.ShipToAddress)
.WithShipToContactPerson(salesOrder.ShipToContactPerson)
.WithShipToEndCustomer(salesOrder.ShipToEndCustomer)
.WithShipToEndCustomerAddress(salesOrder.ShipToEndCustomerAddress)
.WithShipToEndCustomerContactPerson(salesOrder.ShipToEndCustomerContactPerson)
.WithInvoiceDate(DateTime.UtcNow)
.WithSalesChannel(salesOrder.SalesChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Strategy.Session).SalesInvoice)
.WithVatRegime(salesOrder.VatRegime)
.WithDiscountAdjustment(salesOrder.DiscountAdjustment)
.WithSurchargeAdjustment(salesOrder.SurchargeAdjustment)
.WithShippingAndHandlingCharge(salesOrder.ShippingAndHandlingCharge)
.WithFee(salesOrder.Fee)
.WithCustomerReference(salesOrder.CustomerReference)
.WithPaymentMethod(this.PaymentMethod)
.Build();
invoiceByOrder.Add(salesOrder, salesInvoice);
if (!costsInvoiced)
{
var costs = this.AppsOnDeriveShippingAndHandlingCharges(derivation);
if (costs > 0)
{
salesInvoice.ShippingAndHandlingCharge = new ShippingAndHandlingChargeBuilder(this.Strategy.Session).WithAmount(costs).Build();
costsInvoiced = true;
}
}
foreach (SalesTerm salesTerm in salesOrder.SalesTerms)
{
if (salesTerm.GetType().Name == typeof(IncoTerm).Name)
{
salesInvoice.AddSalesTerm(new IncoTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(InvoiceTerm).Name)
{
salesInvoice.AddSalesTerm(new InvoiceTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(OrderTerm).Name)
{
salesInvoice.AddSalesTerm(new OrderTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
}
}
var amountAlreadyInvoiced = shipmentItem.ShipmentItemBillingsWhereShipmentItem.Sum(v => v.Amount);
var leftToInvoice = (orderShipment.OrderItem.QuantityOrdered * orderShipment.OrderItem.ActualUnitPrice) - amountAlreadyInvoiced;
if (leftToInvoice > 0)
{
if (salesOrderItem != null)
{
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithInvoiceItemType(new InvoiceItemTypes(this.Strategy.Session).ProductItem)
.WithProduct(salesOrderItem.Product)
.WithQuantity(orderShipment.Quantity)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
new ShipmentItemBillingBuilder(this.strategy.Session)
.WithQuantity(shipmentItem.Quantity)
.WithAmount(leftToInvoice)
.WithShipmentItem(shipmentItem)
.WithInvoiceItem(invoiceItem)
.Build();
}
}
}
}
}
private void AppsInvoiceThis(IDerivation derivation)
{
var salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithBilledFrom(this.TakenBy)
.WithBilledFromContactMechanism(this.TakenByContactMechanism)
.WithBilledFromContactPerson(this.TakenByContactPerson)
.WithBillToCustomer(this.BillToCustomer)
.WithBillToContactMechanism(this.BillToContactMechanism)
.WithBillToContactPerson(this.BillToContactPerson)
.WithBillToEndCustomer(this.BillToEndCustomer)
.WithBillToEndCustomerContactMechanism(this.BillToEndCustomerContactMechanism)
.WithBillToEndCustomerContactPerson(this.BillToEndCustomerContactPerson)
.WithShipToCustomer(this.ShipToCustomer)
.WithShipToAddress(this.ShipToAddress)
.WithShipToContactPerson(this.ShipToContactPerson)
.WithShipToEndCustomer(this.ShipToEndCustomer)
.WithShipToEndCustomerAddress(this.ShipToEndCustomerAddress)
.WithShipToEndCustomerContactPerson(this.ShipToEndCustomerContactPerson)
.WithDescription(this.Description)
.WithStore(this.Store)
.WithInvoiceDate(DateTime.UtcNow)
.WithSalesChannel(this.SalesChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Strategy.Session).SalesInvoice)
.WithVatRegime(this.VatRegime)
.WithDiscountAdjustment(this.DiscountAdjustment)
.WithSurchargeAdjustment(this.SurchargeAdjustment)
.WithShippingAndHandlingCharge(this.ShippingAndHandlingCharge)
.WithFee(this.Fee)
.WithCustomerReference(this.CustomerReference)
.WithPaymentMethod(this.PaymentMethod)
.Build();
foreach (SalesOrderItem orderItem in this.ValidOrderItems)
{
var amountAlreadyInvoiced = orderItem.OrderItemBillingsWhereOrderItem.Sum(v => v.Amount);
var leftToInvoice = (orderItem.QuantityOrdered * orderItem.ActualUnitPrice) - amountAlreadyInvoiced;
if (leftToInvoice > 0)
{
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithInvoiceItemType(orderItem.InvoiceItemType)
.WithActualUnitPrice(orderItem.ActualUnitPrice)
.WithProduct(orderItem.Product)
.WithQuantity(orderItem.QuantityOrdered)
.WithDetails(orderItem.Details)
.WithDescription(orderItem.Description)
.WithInternalComment(orderItem.InternalComment)
.WithMessage(orderItem.Message)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
new OrderItemBillingBuilder(this.strategy.Session)
.WithQuantity(orderItem.QuantityOrdered)
.WithAmount(leftToInvoice)
.WithOrderItem(orderItem)
.WithInvoiceItem(invoiceItem)
.Build();
}
}
foreach (SalesTerm salesTerm in this.SalesTerms)
{
if (salesTerm.GetType().Name == typeof(IncoTerm).Name)
{
salesInvoice.AddSalesTerm(new IncoTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(InvoiceTerm).Name)
{
salesInvoice.AddSalesTerm(new InvoiceTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(OrderTerm).Name)
{
salesInvoice.AddSalesTerm(new OrderTermBuilder(this.strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
}
}
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 GivenSalesInvoice_WhenWrittenOff_ThenRevenueIsUpdated()
{
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
var vatRate21 = new VatRateBuilder(this.DatabaseSession).WithRate(21).Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var good = new GoodBuilder(this.DatabaseSession)
.WithSku("10101")
.WithVatRate(vatRate21)
.WithName("good")
.WithInventoryItemKind(new InventoryItemKinds(this.DatabaseSession).NonSerialized)
.WithUnitOfMeasure(new UnitsOfMeasure(this.DatabaseSession).Piece)
.Build();
var internalOrganisation = new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation");
internalOrganisation.PreferredCurrency = euro;
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var invoice1 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTimeFactory.CreateDate(2010, 01, 01))
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesChannel(new SalesChannels(this.DatabaseSession).WebChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
var item1 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(3).WithActualUnitPrice(15).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build();
invoice1.AddSalesInvoiceItem(item1);
this.DatabaseSession.Derive(true);
invoice1.Send();
this.DatabaseSession.Derive(true);
var invoice2 = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceDate(DateTimeFactory.CreateDate(2010, 01, 01))
.WithInvoiceNumber("2")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesChannel(new SalesChannels(this.DatabaseSession).WebChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.Build();
var item2 = new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(1).WithActualUnitPrice(15).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build();
invoice2.AddSalesInvoiceItem(item2);
this.DatabaseSession.Derive(true);
var internalOrganisationRevenue = internalOrganisation.InternalOrganisationRevenuesWhereInternalOrganisation[0];
var storeRevenue = invoice1.Store.StoreRevenuesWhereStore[0];
var salesChannelRevenue = invoice1.SalesChannel.SalesChannelRevenuesWhereSalesChannel[0];
var productRevenue = good.ProductRevenuesWhereProduct[0];
var partyRevenue = customer.PartyRevenuesWhereParty[0];
var partypPrductRevenue = customer.PartyProductRevenuesWhereParty[0];
Assert.AreEqual(60, internalOrganisationRevenue.Revenue);
Assert.AreEqual(2010, internalOrganisationRevenue.Year);
Assert.AreEqual(60, storeRevenue.Revenue);
Assert.AreEqual(2010, storeRevenue.Year);
Assert.AreEqual(60, salesChannelRevenue.Revenue);
Assert.AreEqual(2010, salesChannelRevenue.Year);
Assert.AreEqual(60, productRevenue.Revenue);
Assert.AreEqual(2010, productRevenue.Year);
Assert.AreEqual(60, partyRevenue.Revenue);
Assert.AreEqual(2010, partyRevenue.Year);
Assert.AreEqual(60, partypPrductRevenue.Revenue);
Assert.AreEqual(2010, partypPrductRevenue.Year);
invoice2.WriteOff();
this.DatabaseSession.Derive(true);
internalOrganisationRevenue = internalOrganisation.InternalOrganisationRevenuesWhereInternalOrganisation[0];
storeRevenue = invoice1.Store.StoreRevenuesWhereStore[0];
salesChannelRevenue = invoice1.SalesChannel.SalesChannelRevenuesWhereSalesChannel[0];
productRevenue = good.ProductRevenuesWhereProduct[0];
partyRevenue = customer.PartyRevenuesWhereParty[0];
partypPrductRevenue = customer.PartyProductRevenuesWhereParty[0];
Assert.AreEqual(45, internalOrganisationRevenue.Revenue);
Assert.AreEqual(2010, internalOrganisationRevenue.Year);
Assert.AreEqual(45, storeRevenue.Revenue);
Assert.AreEqual(2010, storeRevenue.Year);
Assert.AreEqual(45, salesChannelRevenue.Revenue);
Assert.AreEqual(2010, salesChannelRevenue.Year);
Assert.AreEqual(45, productRevenue.Revenue);
Assert.AreEqual(2010, productRevenue.Year);
Assert.AreEqual(45, partyRevenue.Revenue);
Assert.AreEqual(2010, partyRevenue.Year);
Assert.AreEqual(45, partypPrductRevenue.Revenue);
Assert.AreEqual(2010, partypPrductRevenue.Year);
}
public void GivenSalesInvoice_WhenPaid_ThenCurrentInvoiceStatusMustBeDerived()
{
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.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();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.DatabaseSession).WithProduct(good).WithQuantity(1).WithActualUnitPrice(100M).WithSalesInvoiceItemType(new SalesInvoiceItemTypes(this.DatabaseSession).ProductItem).Build())
.Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(1, invoice.InvoiceStatuses.Count);
Assert.AreEqual(new SalesInvoiceObjectStates(this.DatabaseSession).ReadyForPosting, invoice.CurrentInvoiceStatus.SalesInvoiceObjectState);
this.DatabaseSession.Derive(true);
new ReceiptBuilder(this.DatabaseSession)
.WithAmount(100)
.WithPaymentApplication(new PaymentApplicationBuilder(this.DatabaseSession).WithInvoiceItem(invoice.SalesInvoiceItems[0]).WithAmountApplied(100).Build())
.Build();
this.DatabaseSession.Derive(true);
Assert.AreEqual(2, invoice.InvoiceStatuses.Count);
Assert.AreEqual(new SalesInvoiceObjectStates(this.DatabaseSession).Paid, invoice.CurrentInvoiceStatus.SalesInvoiceObjectState);
}
public void GivenSalesInvoiceBuilderWithBillToCustomerWithPreferredCurrency_WhenBuilding_ThenDerivedCurrencyIsCustomersPreferredCurrency()
{
var euro = new Currencies(this.DatabaseSession).FindBy(Currencies.Meta.IsoCode, "EUR");
var customer = new OrganisationBuilder(this.DatabaseSession)
.WithName("customer")
.WithPreferredCurrency(euro)
.Build();
var billToContactMechanismMechelen = new PostalAddressBuilder(this.DatabaseSession).WithAddress1("Mechelen").Build();
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithBillToCustomer(customer)
.WithBillToContactMechanism(billToContactMechanismMechelen)
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
Assert.AreEqual(euro, invoice.CustomerCurrency);
}
public void Execute()
{
var singleton = this.Session.GetSingleton();
var dutchLocale = new Locales(this.Session).DutchNetherlands;
singleton.AddAdditionalLocale(dutchLocale);
var euro = new Currencies(this.Session).FindBy(M.Currency.IsoCode, "EUR");
var be = new Countries(this.Session).FindBy(M.Country.IsoCode, "BE");
var us = new Countries(this.Session).FindBy(M.Country.IsoCode, "US");
var email2 = new EmailAddressBuilder(this.Session)
.WithElectronicAddressString("*****@*****.**")
.Build();
var allorsLogo = this.DataPath + @"\www\admin\images\logo.png";
var allors = Organisations.CreateInternalOrganisation(
session: this.Session,
name: "Allors BVBA",
address: "Kleine Nieuwedijkstraat 4",
postalCode: "2800",
locality: "Mechelen",
country: be,
phone1CountryCode: "+32",
phone1: "2 335 2335",
phone1Purpose: new ContactMechanismPurposes(this.Session).GeneralPhoneNumber,
phone2CountryCode: string.Empty,
phone2: string.Empty,
phone2Purpose: null,
emailAddress: "*****@*****.**",
websiteAddress: "www.allors.com",
taxNumber: "BE 0476967014",
bankName: "ING",
facilityName: "Allors warehouse 1",
bic: "BBRUBEBB",
iban: "BE89 3200 1467 7685",
currency: euro,
logo: allorsLogo,
storeName: "Allors Store",
billingProcess: new BillingProcesses(this.Session).BillingForOrderItems,
outgoingShipmentNumberPrefix: "a-CS",
salesInvoiceNumberPrefix: "a-SI",
salesOrderNumberPrefix: "a-SO",
requestNumberPrefix: "a-RFQ",
quoteNumberPrefix: "a-Q",
productNumberPrefix: "A-",
requestCounterValue: 1,
quoteCounterValue: 1,
orderCounterValue: 1,
invoiceCounterValue: 1);
var dipu = Organisations.CreateInternalOrganisation(
session: this.Session,
name: "Dipu BVBA",
address: "Kleine Nieuwedijkstraat 2",
postalCode: "2800",
locality: "Mechelen",
country: be,
phone1CountryCode: "+32",
phone1: "2 15 49 49 49",
phone1Purpose: new ContactMechanismPurposes(this.Session).GeneralPhoneNumber,
phone2CountryCode: string.Empty,
phone2: string.Empty,
phone2Purpose: null,
emailAddress: "*****@*****.**",
websiteAddress: "www.dipu.com",
taxNumber: "BE 0445366489",
bankName: "ING",
facilityName: "Dipu Facility",
bic: "BBRUBEBB",
iban: "BE23 3300 6167 6391",
currency: euro,
logo: allorsLogo,
storeName: "Dipu Store",
billingProcess: new BillingProcesses(this.Session).BillingForOrderItems,
outgoingShipmentNumberPrefix: "d-CS",
salesInvoiceNumberPrefix: "d-SI",
salesOrderNumberPrefix: "d-SO",
requestNumberPrefix: "d-RFQ",
quoteNumberPrefix: "d-Q",
productNumberPrefix: "D-",
requestCounterValue: 1,
quoteCounterValue: 1,
orderCounterValue: 1,
invoiceCounterValue: 1);
singleton.Settings.DefaultFacility = allors.FacilitiesWhereOwner.First;
this.SetupUser(allors, "*****@*****.**", "first", "allors employee", "letmein");
this.SetupUser(allors, "*****@*****.**", "second", "allors employee", "letmein");
this.SetupUser(dipu, "*****@*****.**", "first", "dipu employee", "letmein");
new FacilityBuilder(this.Session)
.WithName("Allors warehouse 2")
.WithFacilityType(new FacilityTypes(this.Session).Warehouse)
.WithOwner(allors)
.Build();
var manufacturer = new OrganisationBuilder(this.Session).WithName("Gizmo inc.").WithIsManufacturer(true).Build();
var productType = new ProductTypeBuilder(this.Session)
.WithName($"Gizmo Serialized")
.WithSerialisedItemCharacteristicType(new SerialisedItemCharacteristicTypeBuilder(this.Session)
.WithName("Size")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Afmeting").WithLocale(dutchLocale).Build())
.Build())
.WithSerialisedItemCharacteristicType(new SerialisedItemCharacteristicTypeBuilder(this.Session)
.WithName("Weight")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Gewicht").WithLocale(dutchLocale).Build())
.WithUnitOfMeasure(new UnitsOfMeasure(this.Session).Kilogram)
.Build())
.Build();
var vatRate = new VatRateBuilder(this.Session).WithRate(21).Build();
var brand = new BrandBuilder(this.Session)
.WithName("brand1")
.WithModel(new ModelBuilder(this.Session).WithName("model1").Build())
.Build();
var finishedGood = new NonUnifiedPartBuilder(this.Session)
.WithProductIdentification(new SkuIdentificationBuilder(this.Session)
.WithIdentification("10101")
.WithProductIdentificationType(new ProductIdentificationTypes(this.Session).Sku).Build())
.WithName("finished good")
.WithBrand(brand)
.WithModel(brand.Models[0])
.WithManufacturedBy(manufacturer)
.WithInventoryItemKind(new InventoryItemKinds(this.Session).NonSerialised)
.Build();
var good1 = new NonUnifiedGoodBuilder(this.Session)
.WithName("Tiny blue round gizmo")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Zeer kleine blauwe ronde gizmo").WithLocale(dutchLocale).Build())
.WithDescription("Perfect blue with nice curves")
.WithLocalisedDescription(new LocalisedTextBuilder(this.Session).WithText("Perfect blauw met mooie rondingen").WithLocale(dutchLocale).Build())
.WithVatRate(vatRate)
.WithPart(finishedGood)
.Build();
new InventoryItemTransactionBuilder(this.Session).WithPart(finishedGood).WithQuantity(100).WithReason(new InventoryTransactionReasons(this.Session).Unknown).Build();
var finishedGood2 = new NonUnifiedPartBuilder(this.Session)
.WithName("finished good2")
.WithInventoryItemKind(new InventoryItemKinds(this.Session).Serialised)
.WithProductType(productType)
.WithProductIdentification(new SkuIdentificationBuilder(this.Session)
.WithIdentification("10102")
.WithProductIdentificationType(new ProductIdentificationTypes(this.Session).Sku).Build())
.WithManufacturedBy(manufacturer)
.Build();
var good2 = new NonUnifiedGoodBuilder(this.Session)
.WithName("Tiny red round gizmo")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Zeer kleine rode ronde gizmo").WithLocale(dutchLocale).Build())
.WithDescription("Perfect red with nice curves")
.WithLocalisedDescription(new LocalisedTextBuilder(this.Session).WithText("Perfect rood met mooie rondingen").WithLocale(dutchLocale).Build())
.WithVatRate(vatRate)
.WithPart(finishedGood2)
.Build();
var serialisedItem = new SerialisedItemBuilder(this.Session).WithSerialNumber("1").Build();
finishedGood2.AddSerialisedItem(serialisedItem);
new SerialisedInventoryItemBuilder(this.Session).WithPart(finishedGood2).WithSerialisedItem(serialisedItem).WithFacility(allors.StoresWhereInternalOrganisation.First.DefaultFacility).Build();
var finishedGood3 = new NonUnifiedPartBuilder(this.Session)
.WithProductIdentification(new SkuIdentificationBuilder(this.Session)
.WithIdentification("10103")
.WithProductIdentificationType(new ProductIdentificationTypes(this.Session).Sku).Build())
.WithName("finished good3")
.WithInventoryItemKind(new InventoryItemKinds(this.Session).NonSerialised)
.WithManufacturedBy(manufacturer)
.Build();
var good3 = new NonUnifiedGoodBuilder(this.Session)
.WithName("Tiny green round gizmo")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Zeer kleine groene ronde gizmo").WithLocale(dutchLocale).Build())
.WithDescription("Perfect red with nice curves")
.WithLocalisedDescription(new LocalisedTextBuilder(this.Session).WithText("Perfect groen met mooie rondingen").WithLocale(dutchLocale).Build())
.WithVatRate(vatRate)
.WithPart(finishedGood3)
.Build();
var productCategory1 = new ProductCategoryBuilder(this.Session)
.WithInternalOrganisation(allors)
.WithName("Best selling gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Meest verkochte gizmo's").WithLocale(dutchLocale).Build())
.Build();
var productCategory2 = new ProductCategoryBuilder(this.Session)
.WithInternalOrganisation(allors)
.WithName("Big Gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Grote Gizmo's").WithLocale(dutchLocale).Build())
.Build();
var productCategory3 = new ProductCategoryBuilder(this.Session)
.WithInternalOrganisation(allors)
.WithName("Small gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Kleine gizmo's").WithLocale(dutchLocale).Build())
.WithProduct(good1)
.WithProduct(good2)
.WithProduct(good3)
.Build();
new CatalogueBuilder(this.Session)
.WithInternalOrganisation(allors)
.WithName("New gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(this.Session).WithText("Nieuwe gizmo's").WithLocale(dutchLocale).Build())
.WithDescription("Latest in the world of Gizmo's")
.WithLocalisedDescription(new LocalisedTextBuilder(this.Session).WithText("Laatste in de wereld van Gizmo's").WithLocale(dutchLocale).Build())
.WithProductCategory(productCategory1)
.Build();
this.Session.Derive();
for (int i = 0; i < 1; i++)
{
var acmePostalAddress = new PostalAddressBuilder(this.Session)
.WithAddress1($"Acme{i} address 1")
.WithPostalBoundary(new PostalBoundaryBuilder(this.Session).WithLocality($"Acme{i} city").WithPostalCode("1111").WithCountry(us).Build())
.Build();
var acmeBillingAddress = new PartyContactMechanismBuilder(this.Session)
.WithContactMechanism(acmePostalAddress)
.WithContactPurpose(new ContactMechanismPurposes(this.Session).GeneralCorrespondence)
.WithUseAsDefault(true)
.Build();
var acmeInquiries = new PartyContactMechanismBuilder(this.Session)
.WithContactMechanism(new TelecommunicationsNumberBuilder(this.Session).WithCountryCode("+1").WithContactNumber("111 222 333").Build())
.WithContactPurpose(new ContactMechanismPurposes(this.Session).GeneralPhoneNumber)
.WithContactPurpose(new ContactMechanismPurposes(this.Session).OrderInquiriesPhone)
.WithUseAsDefault(true)
.Build();
var acme = new OrganisationBuilder(this.Session)
.WithName($"Acme{i}")
.WithLocale(new Locales(this.Session).EnglishUnitedStates)
.WithPartyContactMechanism(acmeBillingAddress)
.WithPartyContactMechanism(acmeInquiries)
.Build();
var contact1Email = new PartyContactMechanismBuilder(this.Session)
.WithContactMechanism(new EmailAddressBuilder(this.Session).WithElectronicAddressString($"employee1@acme{i}.com").Build())
.WithContactPurpose(new ContactMechanismPurposes(this.Session).PersonalEmailAddress)
.WithUseAsDefault(true)
.Build();
var contact2PhoneNumber = new PartyContactMechanismBuilder(this.Session)
.WithContactMechanism(new TelecommunicationsNumberBuilder(this.Session).WithCountryCode("+1").WithAreaCode("123").WithContactNumber("456").Build())
.WithContactPurpose(new ContactMechanismPurposes(this.Session).GeneralPhoneNumber)
.WithUseAsDefault(true)
.Build();
var contact1 = new PersonBuilder(this.Session)
.WithFirstName($"John{i}")
.WithLastName($"Doe{i}")
.WithGender(new GenderTypes(this.Session).Male)
.WithLocale(new Locales(this.Session).EnglishUnitedStates)
.WithPartyContactMechanism(contact1Email)
.Build();
var contact2 = new PersonBuilder(this.Session)
.WithFirstName($"Jane{i}")
.WithLastName($"Doe{i}")
.WithGender(new GenderTypes(this.Session).Male)
.WithLocale(new Locales(this.Session).EnglishUnitedStates)
.WithPartyContactMechanism(contact2PhoneNumber)
.Build();
new CustomerRelationshipBuilder(this.Session)
.WithCustomer(acme)
.WithInternalOrganisation(allors)
.WithFromDate(DateTime.UtcNow)
.Build();
new SupplierRelationshipBuilder(this.Session)
.WithSupplier(acme)
.WithInternalOrganisation(allors)
.WithFromDate(DateTime.UtcNow)
.Build();
new OrganisationContactRelationshipBuilder(this.Session)
.WithOrganisation(acme)
.WithContact(contact1)
.WithContactKind(new OrganisationContactKinds(this.Session).FindBy(M.OrganisationContactKind.Description, "General contact"))
.WithFromDate(DateTime.UtcNow)
.Build();
new OrganisationContactRelationshipBuilder(this.Session)
.WithOrganisation(acme)
.WithContact(contact2)
.WithContactKind(new OrganisationContactKinds(this.Session).FindBy(M.OrganisationContactKind.Description, "General contact"))
.WithFromDate(DateTime.UtcNow)
.Build();
var administrator = (Person) new UserGroups(this.Session).Administrators.Members.First;
new FaceToFaceCommunicationBuilder(this.Session)
.WithDescription($"Meeting {i}")
.WithSubject($"meeting {i}")
.WithEventPurpose(new CommunicationEventPurposes(this.Session).Meeting)
.WithFromParty(contact1)
.WithToParty(contact2)
.WithOwner(administrator)
.WithActualStart(DateTime.UtcNow)
.Build();
new EmailCommunicationBuilder(this.Session)
.WithDescription($"Email {i}")
.WithSubject($"email {i}")
.WithFromEmail(email2)
.WithToEmail(email2)
.WithEventPurpose(new CommunicationEventPurposes(this.Session).Meeting)
.WithOwner(administrator)
.WithActualStart(DateTime.UtcNow)
.Build();
new LetterCorrespondenceBuilder(this.Session)
.WithDescription($"Letter {i}")
.WithSubject($"letter {i}")
.WithFromParty(administrator)
.WithToParty(contact1)
.WithEventPurpose(new CommunicationEventPurposes(this.Session).Meeting)
.WithOwner(administrator)
.WithActualStart(DateTime.UtcNow)
.Build();
new PhoneCommunicationBuilder(this.Session)
.WithDescription($"Phone {i}")
.WithSubject($"phone {i}")
.WithFromParty(administrator)
.WithToParty(contact1)
.WithEventPurpose(new CommunicationEventPurposes(this.Session).Meeting)
.WithOwner(administrator)
.WithActualStart(DateTime.UtcNow)
.Build();
var salesOrderItem1 = new SalesOrderItemBuilder(this.Session)
.WithDescription("first item")
.WithProduct(good1)
.WithActualUnitPrice(3000)
.WithQuantityOrdered(1)
.WithMessage(@"line1
line2")
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.Build();
var salesOrderItem2 = new SalesOrderItemBuilder(this.Session)
.WithDescription("second item")
.WithActualUnitPrice(2000)
.WithQuantityOrdered(2)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.Build();
var salesOrderItem3 = new SalesOrderItemBuilder(this.Session)
.WithDescription("Fee")
.WithActualUnitPrice(100)
.WithQuantityOrdered(1)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).Fee)
.Build();
var order = new SalesOrderBuilder(this.Session)
.WithTakenBy(allors)
.WithBillToCustomer(acme)
.WithBillToEndCustomerContactMechanism(acmeBillingAddress.ContactMechanism)
.WithSalesOrderItem(salesOrderItem1)
.WithSalesOrderItem(salesOrderItem2)
.WithSalesOrderItem(salesOrderItem3)
.WithCustomerReference("a reference number")
.WithDescription("Sale of 1 used Aircraft Towbar")
.WithVatRegime(new VatRegimes(this.Session).Assessable)
.Build();
var salesInvoiceItem1 = new SalesInvoiceItemBuilder(this.Session)
.WithDescription("first item")
.WithProduct(good1)
.WithActualUnitPrice(3000)
.WithQuantity(1)
.WithMessage(@"line1
line2")
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.Build();
var salesInvoiceItem2 = new SalesInvoiceItemBuilder(this.Session)
.WithDescription("second item")
.WithActualUnitPrice(2000)
.WithQuantity(2)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.Build();
var salesInvoiceItem3 = new SalesInvoiceItemBuilder(this.Session)
.WithDescription("Fee")
.WithActualUnitPrice(100)
.WithQuantity(1)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).Fee)
.Build();
var salesInvoice = new SalesInvoiceBuilder(this.Session)
.WithBilledFrom(allors)
.WithInvoiceNumber("1")
.WithBillToCustomer(acme)
.WithBillToContactMechanism(acme.PartyContactMechanisms[0].ContactMechanism)
.WithBillToEndCustomerContactMechanism(acmeBillingAddress.ContactMechanism)
.WithSalesInvoiceItem(salesInvoiceItem1)
.WithSalesInvoiceItem(salesInvoiceItem2)
.WithSalesInvoiceItem(salesInvoiceItem3)
.WithCustomerReference("a reference number")
.WithDescription("Sale of 1 used Aircraft Towbar")
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.WithVatRegime(new VatRegimes(this.Session).Assessable)
.Build();
var purchaseInvoiceItem1 = new PurchaseInvoiceItemBuilder(this.Session)
.WithDescription("first item")
.WithProduct(good1)
.WithActualUnitPrice(3000)
.WithQuantity(1)
.WithMessage(@"line1
line2")
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.Build();
var purchaseInvoiceItem2 = new PurchaseInvoiceItemBuilder(this.Session)
.WithDescription("second item")
.WithActualUnitPrice(2000)
.WithQuantity(2)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem)
.Build();
var purchaseInvoiceItem3 = new PurchaseInvoiceItemBuilder(this.Session)
.WithDescription("Fee")
.WithActualUnitPrice(100)
.WithQuantity(1)
.WithInvoiceItemType(new InvoiceItemTypes(this.Session).Fee)
.Build();
var purchaseInvoice = new PurchaseInvoiceBuilder(this.Session)
.WithBilledTo(allors)
.WithInvoiceNumber("1")
.WithBilledFrom(acme)
.WithPurchaseInvoiceItem(purchaseInvoiceItem1)
.WithPurchaseInvoiceItem(purchaseInvoiceItem2)
.WithPurchaseInvoiceItem(purchaseInvoiceItem3)
.WithCustomerReference("a reference number")
.WithDescription("Purchase of 1 used Aircraft Towbar")
.WithPurchaseInvoiceType(new PurchaseInvoiceTypes(this.Session).PurchaseInvoice)
.WithVatRegime(new VatRegimes(this.Session).Assessable)
.Build();
}
this.Session.Derive();
}
public void GivenSalesInvoiceCreatedBySalesRep_WhenCurrentUserInAdministratorRole_ThenAccessIsGranted()
{
var customer = new Organisations(this.DatabaseSession).FindBy(Organisations.Meta.Name, "customer");
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var administrator = new PersonBuilder(this.DatabaseSession).WithFirstName("Koen").WithUserName("admin").Build();
var administrators = new UserGroups(this.DatabaseSession).Administrators;
administrators.AddMember(administrator);
this.DatabaseSession.Derive(true);
var supplierContact = new PersonBuilder(this.DatabaseSession).WithUserName("suppliercontact").WithLastName("suppliercontact").Build();
var supplier = new OrganisationBuilder(this.DatabaseSession).WithName("supplier").Build();
new SupplierRelationshipBuilder(this.DatabaseSession)
.WithSupplier(supplier)
.WithInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.WithFromDate(DateTime.UtcNow)
.Build();
new OrganisationContactRelationshipBuilder(this.DatabaseSession).WithContact(supplierContact).WithOrganisation(supplier).WithFromDate(DateTime.UtcNow).Build();
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("salesRep", "Forms"), new string[0]);
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
this.DatabaseSession.Derive(true);
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("admin", "Forms"), new string[0]);
var acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsTrue(acl.CanWrite(SalesInvoices.Meta.Comment));
Assert.IsTrue(acl.CanRead(SalesInvoices.Meta.Comment));
Assert.IsTrue(acl.CanExecute(SalesInvoices.Meta.Send));
}
public void GivenCustomerWithUnpaidInvoices_WhenDeriving_ThenAmountDueIsUpdated()
{
var mechelen = new CityBuilder(this.Session).WithName("Mechelen").Build();
var customer = new OrganisationBuilder(this.Session).WithName("customer").Build();
var customerRelationship = new CustomerRelationshipBuilder(this.Session).WithFromDate(this.Session.Now()).WithCustomer(customer).Build();
this.Session.Derive();
var partyFinancial = customer.PartyFinancialRelationshipsWhereParty.First(v => Equals(v.InternalOrganisation, customerRelationship.InternalOrganisation));
var billToContactMechanism = new PostalAddressBuilder(this.Session).WithPostalAddressBoundary(mechelen).WithAddress1("Mechelen").Build();
var good = new Goods(this.Session).FindBy(M.Good.Name, "good1");
good.VatRegime = new VatRegimes(this.Session).ZeroRated;
this.Session.Derive();
var invoice1 = new SalesInvoiceBuilder(this.Session)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.WithBillToCustomer(customer)
.WithAssignedBillToContactMechanism(billToContactMechanism)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.Session).WithProduct(good).WithQuantity(1).WithAssignedUnitPrice(100M).WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem).Build())
.Build();
this.Session.Derive();
var invoice2 = new SalesInvoiceBuilder(this.Session)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.WithBillToCustomer(customer)
.WithAssignedBillToContactMechanism(billToContactMechanism)
.WithSalesInvoiceItem(new SalesInvoiceItemBuilder(this.Session).WithProduct(good).WithQuantity(1).WithAssignedUnitPrice(200M).WithInvoiceItemType(new InvoiceItemTypes(this.Session).ProductItem).Build())
.Build();
this.Session.Derive();
Assert.Equal(300M, partyFinancial.AmountDue);
new ReceiptBuilder(this.Session)
.WithAmount(50)
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(invoice1.SalesInvoiceItems[0]).WithAmountApplied(50).Build())
.Build();
this.Session.Derive();
Assert.Equal(250, partyFinancial.AmountDue);
new ReceiptBuilder(this.Session)
.WithAmount(200)
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(invoice2.SalesInvoiceItems[0]).WithAmountApplied(200).Build())
.Build();
this.Session.Derive();
Assert.Equal(50, partyFinancial.AmountDue);
new ReceiptBuilder(this.Session)
.WithAmount(50)
.WithPaymentApplication(new PaymentApplicationBuilder(this.Session).WithInvoiceItem(invoice1.SalesInvoiceItems[0]).WithAmountApplied(50).Build())
.Build();
this.Session.Derive();
Assert.Equal(0, partyFinancial.AmountDue);
}
public static void BaseMonthly(ISession session)
{
var customers = new Parties(session).Extent();
customers.Filter.AddEquals(M.Party.CollectiveWorkEffortInvoice, true);
var workTasks = new WorkTasks(session).Extent();
workTasks.Filter.AddEquals(M.WorkEffort.WorkEffortState, new WorkEffortStates(session).Completed);
workTasks.Filter.AddContainedIn(M.WorkEffort.Customer, (Extent)customers);
var workTasksByCustomer = workTasks.Select(v => v.Customer).Distinct()
.ToDictionary(v => v, v => v.WorkEffortsWhereCustomer.Where(w => w.WorkEffortState.Equals(new WorkEffortStates(session).Completed)).ToArray());
SalesInvoice salesInvoice = null;
foreach (var customerWorkTasks in workTasksByCustomer)
{
var customer = customerWorkTasks.Key;
var customerWorkTasksByInternalOrganisation = customerWorkTasks.Value
.GroupBy(v => v.TakenBy)
.Select(v => v)
.ToArray();
if (customerWorkTasks.Value.Any(v => v.CanInvoice))
{
foreach (var group in customerWorkTasksByInternalOrganisation)
{
if (group.Any(v => v.CanInvoice))
{
salesInvoice = new SalesInvoiceBuilder(session)
.WithBilledFrom(group.Key)
.WithBillToCustomer(customer)
.WithInvoiceDate(session.Now())
.WithSalesInvoiceType(new SalesInvoiceTypes(session).SalesInvoice)
.Build();
}
var timeEntriesByBillingRate = group.SelectMany(v => v.ServiceEntriesWhereWorkEffort.OfType <TimeEntry>())
.Where(v => (v.IsBillable && !v.BillableAmountOfTime.HasValue && v.AmountOfTime.HasValue) || v.BillableAmountOfTime.HasValue)
.GroupBy(v => v.BillingRate)
.Select(v => v)
.ToArray();
foreach (var rateGroup in timeEntriesByBillingRate)
{
var timeEntries = rateGroup.ToArray();
var invoiceItem = new SalesInvoiceItemBuilder(session)
.WithInvoiceItemType(new InvoiceItemTypes(session).Service)
.WithAssignedUnitPrice(rateGroup.Key)
.WithQuantity(timeEntries.Sum(v => v.BillableAmountOfTime ?? v.AmountOfTime ?? 0.0m))
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
foreach (var billableEntry in timeEntries)
{
new TimeEntryBillingBuilder(session)
.WithTimeEntry(billableEntry)
.WithInvoiceItem(invoiceItem)
.Build();
}
}
foreach (var workEffort in group)
{
if (workEffort.CanInvoice)
{
if (string.IsNullOrEmpty(salesInvoice.CustomerReference))
{
salesInvoice.CustomerReference = $"WorkOrder(s): {workEffort.WorkEffortNumber}";
}
else
{
salesInvoice.CustomerReference += $", {workEffort.WorkEffortNumber}";
}
foreach (WorkEffortInventoryAssignment inventoryAssignment in workEffort.WorkEffortInventoryAssignmentsWhereAssignment)
{
var part = inventoryAssignment.InventoryItem.Part;
var invoiceItem = new SalesInvoiceItemBuilder(session)
.WithInvoiceItemType(new InvoiceItemTypes(session).PartItem)
.WithPart(part)
.WithAssignedUnitPrice(inventoryAssignment.UnitSellingPrice)
.WithQuantity(inventoryAssignment.DerivedBillableQuantity)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
new WorkEffortBillingBuilder(session)
.WithWorkEffort(workEffort)
.WithInvoiceItem(invoiceItem)
.Build();
}
foreach (WorkEffortPurchaseOrderItemAssignment purchaseOrderItemAssignment in workEffort.WorkEffortPurchaseOrderItemAssignmentsWhereAssignment)
{
var invoiceItem = new SalesInvoiceItemBuilder(session)
.WithInvoiceItemType(new InvoiceItemTypes(session).Service)
.WithAssignedUnitPrice(purchaseOrderItemAssignment.UnitSellingPrice)
.WithQuantity(purchaseOrderItemAssignment.Quantity)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
new WorkEffortBillingBuilder(session)
.WithWorkEffort(workEffort)
.WithInvoiceItem(invoiceItem)
.Build();
}
workEffort.WorkEffortState = new WorkEffortStates(session).Finished;
}
}
}
}
}
}
public void BaseInvoice(SalesOrderInvoice method)
{
if (this.CanInvoice)
{
var salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithBilledFrom(this.TakenBy)
.WithBilledFromContactMechanism(this.TakenByContactMechanism)
.WithBilledFromContactPerson(this.TakenByContactPerson)
.WithBillToCustomer(this.BillToCustomer)
.WithBillToContactMechanism(this.BillToContactMechanism)
.WithBillToContactPerson(this.BillToContactPerson)
.WithBillToEndCustomer(this.BillToEndCustomer)
.WithBillToEndCustomerContactMechanism(this.BillToEndCustomerContactMechanism)
.WithBillToEndCustomerContactPerson(this.BillToEndCustomerContactPerson)
.WithShipToCustomer(this.ShipToCustomer)
.WithShipToAddress(this.ShipToAddress)
.WithShipToContactPerson(this.ShipToContactPerson)
.WithShipToEndCustomer(this.ShipToEndCustomer)
.WithShipToEndCustomerAddress(this.ShipToEndCustomerAddress)
.WithShipToEndCustomerContactPerson(this.ShipToEndCustomerContactPerson)
.WithDescription(this.Description)
.WithStore(this.Store)
.WithInvoiceDate(this.Session().Now())
.WithSalesChannel(this.SalesChannel)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Strategy.Session).SalesInvoice)
.WithVatRegime(this.VatRegime)
.WithAssignedVatClause(this.DerivedVatClause)
.WithDiscountAdjustment(this.DiscountAdjustment)
.WithSurchargeAdjustment(this.SurchargeAdjustment)
.WithShippingAndHandlingCharge(this.ShippingAndHandlingCharge)
.WithFee(this.Fee)
.WithCustomerReference(this.CustomerReference)
.WithPaymentMethod(this.PaymentMethod)
.WithCurrency(this.Currency)
.Build();
foreach (SalesOrderItem orderItem in this.ValidOrderItems)
{
var amountAlreadyInvoiced = orderItem.OrderItemBillingsWhereOrderItem.Sum(v => v.Amount);
var leftToInvoice = (orderItem.QuantityOrdered * orderItem.UnitPrice) - amountAlreadyInvoiced;
if (leftToInvoice > 0)
{
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithInvoiceItemType(orderItem.InvoiceItemType)
.WithAssignedUnitPrice(orderItem.UnitPrice)
.WithProduct(orderItem.Product)
.WithQuantity(orderItem.CostOfGoodsSold)
.WithCostOfGoodsSold(orderItem.QuantityOrdered)
.WithAssignedVatRegime(orderItem.AssignedVatRegime)
.WithDescription(orderItem.Description)
.WithInternalComment(orderItem.InternalComment)
.WithMessage(orderItem.Message)
.Build();
if (orderItem.ExistSerialisedItem)
{
invoiceItem.SerialisedItem = orderItem.SerialisedItem;
}
salesInvoice.AddSalesInvoiceItem(invoiceItem);
new OrderItemBillingBuilder(this.Strategy.Session)
.WithQuantity(orderItem.QuantityOrdered)
.WithAmount(leftToInvoice)
.WithOrderItem(orderItem)
.WithInvoiceItem(invoiceItem)
.Build();
}
}
foreach (SalesTerm salesTerm in this.SalesTerms)
{
if (salesTerm.GetType().Name == typeof(IncoTerm).Name)
{
salesInvoice.AddSalesTerm(new IncoTermBuilder(this.Strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(InvoiceTerm).Name)
{
salesInvoice.AddSalesTerm(new InvoiceTermBuilder(this.Strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
if (salesTerm.GetType().Name == typeof(OrderTerm).Name)
{
salesInvoice.AddSalesTerm(new OrderTermBuilder(this.Strategy.Session)
.WithTermType(salesTerm.TermType)
.WithTermValue(salesTerm.TermValue)
.WithDescription(salesTerm.Description)
.Build());
}
}
}
}
public void BaseCreateSalesInvoice(PurchaseInvoiceCreateSalesInvoice method)
{
var salesInvoice = new SalesInvoiceBuilder(this.Strategy.Session)
.WithPurchaseInvoice(this)
.WithBilledFrom(this.BilledTo)
.WithBilledFromContactPerson(this.BilledToContactPerson)
.WithBillToCustomer(this.BillToEndCustomer)
.WithAssignedBillToContactMechanism(this.DerivedBillToEndCustomerContactMechanism)
.WithBillToContactPerson(this.BillToEndCustomerContactPerson)
.WithShipToCustomer(this.ShipToEndCustomer)
.WithAssignedShipToAddress(this.DerivedShipToEndCustomerAddress)
.WithShipToContactPerson(this.ShipToEndCustomerContactPerson)
.WithDescription(this.Description)
.WithInvoiceDate(this.Session().Now())
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Strategy.Session).SalesInvoice)
.WithCustomerReference(this.CustomerReference)
.WithAssignedPaymentMethod(this.DerivedBillToCustomerPaymentMethod)
.WithComment(this.Comment)
.WithInternalComment(this.InternalComment)
.Build();
foreach (OrderAdjustment orderAdjustment in this.OrderAdjustments)
{
OrderAdjustment newAdjustment = null;
if (orderAdjustment.GetType().Name.Equals(typeof(DiscountAdjustment).Name))
{
newAdjustment = new DiscountAdjustmentBuilder(this.Session()).Build();
}
if (orderAdjustment.GetType().Name.Equals(typeof(SurchargeAdjustment).Name))
{
newAdjustment = new SurchargeAdjustmentBuilder(this.Session()).Build();
}
if (orderAdjustment.GetType().Name.Equals(typeof(Fee).Name))
{
newAdjustment = new FeeBuilder(this.Session()).Build();
}
if (orderAdjustment.GetType().Name.Equals(typeof(ShippingAndHandlingCharge).Name))
{
newAdjustment = new ShippingAndHandlingChargeBuilder(this.Session()).Build();
}
if (orderAdjustment.GetType().Name.Equals(typeof(MiscellaneousCharge).Name))
{
newAdjustment = new MiscellaneousChargeBuilder(this.Session()).Build();
}
newAdjustment.Amount ??= orderAdjustment.Amount;
newAdjustment.Percentage ??= orderAdjustment.Percentage;
salesInvoice.AddOrderAdjustment(newAdjustment);
}
foreach (PurchaseInvoiceItem purchaseInvoiceItem in this.PurchaseInvoiceItems)
{
var invoiceItem = new SalesInvoiceItemBuilder(this.Strategy.Session)
.WithInvoiceItemType(purchaseInvoiceItem.InvoiceItemType)
.WithAssignedUnitPrice(purchaseInvoiceItem.AssignedUnitPrice)
.WithProduct(purchaseInvoiceItem.Part as UnifiedGood)
.WithSerialisedItem(purchaseInvoiceItem.SerialisedItem)
.WithNextSerialisedItemAvailability(new SerialisedItemAvailabilities(this.Session()).Sold)
.WithQuantity(purchaseInvoiceItem.Quantity)
.WithComment(purchaseInvoiceItem.Comment)
.WithInternalComment(purchaseInvoiceItem.InternalComment)
.Build();
salesInvoice.AddSalesInvoiceItem(invoiceItem);
}
var internalOrganisation = (InternalOrganisation)salesInvoice.BilledFrom;
if (!internalOrganisation.ActiveCustomers.Contains(salesInvoice.BillToCustomer))
{
new CustomerRelationshipBuilder(this.Strategy.Session)
.WithCustomer(salesInvoice.BillToCustomer)
.WithInternalOrganisation(internalOrganisation)
.Build();
}
this.AddDeniedPermission(new Permissions(this.Strategy.Session).Get(this.Meta.ObjectType, this.Meta.CreateSalesInvoice, Operations.Execute));
}
public static void Full(this Singleton @this, DirectoryInfo dataPath, Faker faker)
{
var dutchLocale = new Locales(@this.Session()).DutchNetherlands;
@this.AddAdditionalLocale(dutchLocale);
var administrator = new PersonBuilder(@this.Session()).WithUserName("administrator").Build();
new UserGroups(@this.Session()).Administrators.AddMember(administrator);
new UserGroups(@this.Session()).Creators.AddMember(administrator);
@this.Session().Derive();
var euro = new Currencies(@this.Session()).FindBy(M.Currency.IsoCode, "EUR");
var be = new Countries(@this.Session()).FindBy(M.Country.IsoCode, "BE");
var us = new Countries(@this.Session()).FindBy(M.Country.IsoCode, "US");
var allorsLogo = dataPath + @"\www\admin\images\logo.png";
var allors = Organisations.CreateInternalOrganisation(
session: @this.Session(),
name: "Allors BVBA",
address: "Kleine Nieuwedijkstraat 4",
postalCode: "2800",
locality: "Mechelen",
country: be,
phone1CountryCode: "+32",
phone1: "2 335 2335",
phone1Purpose: new ContactMechanismPurposes(@this.Session()).GeneralPhoneNumber,
phone2CountryCode: string.Empty,
phone2: string.Empty,
phone2Purpose: null,
emailAddress: "*****@*****.**",
websiteAddress: "www.allors.com",
taxNumber: "BE 0476967014",
bankName: "ING",
facilityName: "Allors Warehouse 1",
bic: "BBRUBEBB",
iban: "BE89 3200 1467 7685",
currency: euro,
logo: allorsLogo,
storeName: "Allors Store",
billingProcess: new BillingProcesses(@this.Session()).BillingForOrderItems,
outgoingShipmentNumberPrefix: "a-CS",
salesInvoiceNumberPrefix: "a-SI",
salesOrderNumberPrefix: "a-SO",
purchaseOrderNumberPrefix: "a-PO",
purchaseInvoiceNumberPrefix: "a-PI",
requestNumberPrefix: "a-RFQ",
quoteNumberPrefix: "a-Q",
productNumberPrefix: "A-",
workEffortPrefix: "a-WO-",
creditNoteNumberPrefix: "a-CN-",
isImmediatelyPicked: true,
autoGenerateShipmentPackage: true,
isImmediatelyPacked: true,
isAutomaticallyShipped: true,
autoGenerateCustomerShipment: true,
isAutomaticallyReceived: false,
autoGeneratePurchaseShipment: false,
useCreditNoteSequence: true,
requestCounterValue: 1,
quoteCounterValue: 1,
orderCounterValue: 1,
purchaseOrderCounterValue: 1,
invoiceCounterValue: 1,
purchaseInvoiceCounterValue: 1,
purchaseOrderNeedsApproval: true,
purchaseOrderApprovalThresholdLevel1: 1000M,
purchaseOrderApprovalThresholdLevel2: 5000M,
serialisedItemSoldOn: new SerialisedItemSoldOns(@this.Session()).CustomerShipmentShip,
collectiveWorkEffortInvoice: true);
var dipu = Organisations.CreateInternalOrganisation(
session: @this.Session(),
name: "Dipu BVBA",
address: "Kleine Nieuwedijkstraat 2",
postalCode: "2800",
locality: "Mechelen",
country: be,
phone1CountryCode: "+32",
phone1: "2 15 49 49 49",
phone1Purpose: new ContactMechanismPurposes(@this.Session()).GeneralPhoneNumber,
phone2CountryCode: string.Empty,
phone2: string.Empty,
phone2Purpose: null,
emailAddress: "*****@*****.**",
websiteAddress: "www.dipu.com",
taxNumber: "BE 0445366489",
bankName: "ING",
facilityName: "Dipu Facility",
bic: "BBRUBEBB",
iban: "BE23 3300 6167 6391",
currency: euro,
logo: allorsLogo,
storeName: "Dipu Store",
billingProcess: new BillingProcesses(@this.Session()).BillingForOrderItems,
outgoingShipmentNumberPrefix: "d-CS",
salesInvoiceNumberPrefix: "d-SI",
salesOrderNumberPrefix: "d-SO",
purchaseOrderNumberPrefix: "d-PO",
purchaseInvoiceNumberPrefix: "d-PI",
requestNumberPrefix: "d-RFQ",
quoteNumberPrefix: "d-Q",
productNumberPrefix: "D-",
workEffortPrefix: "a-WO-",
creditNoteNumberPrefix: "d-CN-",
isImmediatelyPicked: true,
autoGenerateShipmentPackage: true,
isImmediatelyPacked: true,
isAutomaticallyShipped: true,
autoGenerateCustomerShipment: true,
isAutomaticallyReceived: false,
autoGeneratePurchaseShipment: false,
useCreditNoteSequence: true,
requestCounterValue: 1,
quoteCounterValue: 1,
orderCounterValue: 1,
purchaseOrderCounterValue: 1,
purchaseInvoiceCounterValue: 1,
invoiceCounterValue: 1,
purchaseOrderNeedsApproval: false,
purchaseOrderApprovalThresholdLevel1: null,
purchaseOrderApprovalThresholdLevel2: null,
serialisedItemSoldOn: new SerialisedItemSoldOns(@this.Session()).CustomerShipmentShip,
collectiveWorkEffortInvoice: true);
// Give Administrator access
new EmploymentBuilder(@this.Session()).WithEmployee(administrator).WithEmployer(allors).Build();
@this.Settings.DefaultFacility = allors.FacilitiesWhereOwner.First;
var allorsEmployee1 = allors.CreateEmployee("letmein", faker);
var allorsEmployee2 = allors.CreateEmployee("letmein", faker);
var allorsProductQuoteApprover = allors.CreateEmployee("letmein", faker);
var allorsPurchaseInvoiceApprover = allors.CreateEmployee("letmein", faker);
var allorsPurchaseOrderApproverLevel1 = allors.CreateEmployee("letmein", faker);
var allorsPurchaseOrderApproverLevel2 = allors.CreateEmployee("letmein", faker);
var dipuEmployee = dipu.CreateEmployee("letmein", faker);
var dipuProductQuoteApprover = dipu.CreateEmployee("letmein", faker);
var dipuPurchaseInvoiceApprover = dipu.CreateEmployee("letmein", faker);
new FacilityBuilder(@this.Session())
.WithName("Allors warehouse 2")
.WithFacilityType(new FacilityTypes(@this.Session()).Warehouse)
.WithOwner(allors)
.Build();
var vatRate = new VatRateBuilder(@this.Session()).WithRate(21).Build();
var manufacturer = new OrganisationBuilder(@this.Session()).WithManufacturerDefaults(faker).Build();
allors.CreateSupplier(faker);
allors.CreateSupplier(faker);
allors.CreateSubContractor(faker);
allors.CreateSubContractor(faker);
@this.Session().Derive();
var nonSerialisedPart1 = allors.CreateNonSerialisedNonUnifiedPart(faker);
var nonSerialisedPart2 = allors.CreateNonSerialisedNonUnifiedPart(faker);
var serialisedPart1 = allors.CreateSerialisedNonUnifiedPart(faker);
var serialisedPart2 = allors.CreateSerialisedNonUnifiedPart(faker);
var good1 = new NonUnifiedGoodBuilder(@this.Session()).WithNonSerialisedPartDefaults(allors).Build();
var good2 = new NonUnifiedGoodBuilder(@this.Session()).WithSerialisedPartDefaults(allors).Build();
var serialisedItem = new SerialisedItemBuilder(@this.Session()).WithDefaults(allors).Build();
serialisedPart1.AddSerialisedItem(serialisedItem);
new InventoryItemTransactionBuilder(@this.Session())
.WithSerialisedItem(serialisedItem)
.WithFacility(allors.FacilitiesWhereOwner.First)
.WithQuantity(1)
.WithReason(new InventoryTransactionReasons(@this.Session()).IncomingShipment)
.WithSerialisedInventoryItemState(new SerialisedInventoryItemStates(@this.Session()).Good)
.Build();
var good3 = new NonUnifiedGoodBuilder(@this.Session()).WithNonSerialisedPartDefaults(allors).Build();
var good4 = new NonUnifiedGoodBuilder(@this.Session()).WithSerialisedPartDefaults(allors).Build();
var productCategory1 = new ProductCategoryBuilder(@this.Session())
.WithInternalOrganisation(allors)
.WithName("Best selling gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(@this.Session()).WithText("Meest verkochte gizmo's").WithLocale(dutchLocale).Build())
.Build();
var productCategory2 = new ProductCategoryBuilder(@this.Session())
.WithInternalOrganisation(allors)
.WithName("Big Gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(@this.Session()).WithText("Grote Gizmo's").WithLocale(dutchLocale).Build())
.Build();
var productCategory3 = new ProductCategoryBuilder(@this.Session())
.WithInternalOrganisation(allors)
.WithName("Small gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(@this.Session()).WithText("Kleine gizmo's").WithLocale(dutchLocale).Build())
.WithProduct(good1)
.WithProduct(good2)
.WithProduct(good3)
.WithProduct(good4)
.Build();
new CatalogueBuilder(@this.Session())
.WithInternalOrganisation(allors)
.WithName("New gizmo's")
.WithLocalisedName(new LocalisedTextBuilder(@this.Session()).WithText("Nieuwe gizmo's").WithLocale(dutchLocale).Build())
.WithDescription("Latest in the world of Gizmo's")
.WithLocalisedDescription(new LocalisedTextBuilder(@this.Session()).WithText("Laatste in de wereld van Gizmo's").WithLocale(dutchLocale).Build())
.WithProductCategory(productCategory1)
.Build();
@this.Session().Derive();
var email2 = new EmailAddressBuilder(@this.Session())
.WithElectronicAddressString("*****@*****.**")
.Build();
for (var i = 0; i < 10; i++)
{
var b2BCustomer = allors.CreateB2BCustomer(faker);
@this.Session().Derive();
new FaceToFaceCommunicationBuilder(@this.Session())
.WithDescription($"Meeting {i}")
.WithSubject($"meeting {i}")
.WithEventPurpose(new CommunicationEventPurposes(@this.Session()).Meeting)
.WithFromParty(allors.CurrentContacts.First)
.WithToParty(b2BCustomer.CurrentContacts.First)
.WithOwner(administrator)
.WithActualStart(@this.Session().Now())
.Build();
new EmailCommunicationBuilder(@this.Session())
.WithDescription($"Email {i}")
.WithSubject($"email {i}")
.WithFromParty(allors.CurrentContacts.First)
.WithToParty(b2BCustomer.CurrentContacts.First)
.WithFromEmail(allors.GeneralEmail)
.WithToEmail(email2)
.WithEventPurpose(new CommunicationEventPurposes(@this.Session()).Meeting)
.WithOwner(administrator)
.WithActualStart(@this.Session().Now())
.Build();
new LetterCorrespondenceBuilder(@this.Session())
.WithDescription($"Letter {i}")
.WithSubject($"letter {i}")
.WithFromParty(administrator)
.WithToParty(b2BCustomer.CurrentContacts.First)
.WithEventPurpose(new CommunicationEventPurposes(@this.Session()).Meeting)
.WithOwner(administrator)
.WithActualStart(@this.Session().Now())
.Build();
new PhoneCommunicationBuilder(@this.Session())
.WithDescription($"Phone {i}")
.WithSubject($"phone {i}")
.WithFromParty(administrator)
.WithToParty(b2BCustomer.CurrentContacts.First)
.WithEventPurpose(new CommunicationEventPurposes(@this.Session()).Meeting)
.WithOwner(administrator)
.WithActualStart(@this.Session().Now())
.Build();
var requestForQuote = new RequestForQuoteBuilder(@this.Session())
.WithEmailAddress($"customer{i}@acme.com")
.WithTelephoneNumber("+1 234 56789")
.WithRecipient(allors)
.Build();
var requestItem = new RequestItemBuilder(@this.Session())
.WithSerialisedItem(serialisedItem)
.WithProduct(serialisedItem.PartWhereSerialisedItem.NonUnifiedGoodsWherePart.FirstOrDefault())
.WithComment($"Comment {i}")
.WithQuantity(1)
.Build();
requestForQuote.AddRequestItem(requestItem);
var quote = new ProductQuoteBuilder(@this.Session()).WithSerializedDefaults(allors).Build();
var salesOrderItem1 = new SalesOrderItemBuilder(@this.Session())
.WithDescription("first item")
.WithProduct(good1)
.WithAssignedUnitPrice(3000)
.WithQuantityOrdered(1)
.WithMessage(@"line1
line2")
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).ProductItem)
.Build();
var salesOrderItem2 = new SalesOrderItemBuilder(@this.Session())
.WithDescription("second item")
.WithAssignedUnitPrice(2000)
.WithQuantityOrdered(2)
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).ProductItem)
.Build();
var salesOrderItem3 = new SalesOrderItemBuilder(@this.Session())
.WithDescription("Fee")
.WithAssignedUnitPrice(100)
.WithQuantityOrdered(1)
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).Fee)
.Build();
var order = new SalesOrderBuilder(@this.Session())
.WithTakenBy(allors)
.WithBillToCustomer(b2BCustomer)
.WithBillToEndCustomerContactMechanism(b2BCustomer.BillingAddress)
.WithSalesOrderItem(salesOrderItem1)
.WithSalesOrderItem(salesOrderItem2)
.WithSalesOrderItem(salesOrderItem3)
.WithCustomerReference("a reference number")
.WithDescription("Sale of 1 used Aircraft Towbar")
.WithVatRegime(new VatRegimes(@this.Session()).Assessable)
.Build();
var salesInvoiceItem1 = new SalesInvoiceItemBuilder(@this.Session())
.WithDescription("first item")
.WithProduct(good1)
.WithAssignedUnitPrice(3000)
.WithQuantity(1)
.WithMessage(@"line1
line2")
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).ProductItem)
.Build();
var salesInvoiceItem2 = new SalesInvoiceItemBuilder(@this.Session())
.WithDescription("second item")
.WithAssignedUnitPrice(2000)
.WithQuantity(2)
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).ProductItem)
.Build();
var salesInvoiceItem3 = new SalesInvoiceItemBuilder(@this.Session())
.WithDescription("Fee")
.WithAssignedUnitPrice(100)
.WithQuantity(1)
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).Fee)
.Build();
var exw = new IncoTermTypes(@this.Session()).Exw;
var incoTerm = new IncoTermBuilder(@this.Session()).WithTermType(exw).WithTermValue("XW").Build();
var salesInvoice = new SalesInvoiceBuilder(@this.Session())
.WithBilledFrom(allors)
.WithBillToCustomer(b2BCustomer)
.WithBillToContactPerson(b2BCustomer.CurrentContacts.First)
.WithBillToContactMechanism(b2BCustomer.BillingAddress)
.WithSalesInvoiceItem(salesInvoiceItem1)
.WithSalesInvoiceItem(salesInvoiceItem2)
.WithSalesInvoiceItem(salesInvoiceItem3)
.WithCustomerReference("a reference number")
.WithDescription("Sale of 1 used Aircraft Towbar")
.WithSalesInvoiceType(new SalesInvoiceTypes(@this.Session()).SalesInvoice)
.WithSalesTerm(incoTerm)
.WithVatRegime(new VatRegimes(@this.Session()).Assessable)
.Build();
for (var j = 0; j < 3; j++)
{
var salesInvoiceItem = new SalesInvoiceItemBuilder(@this.Session())
.WithDescription("Extra Charge")
.WithAssignedUnitPrice(100 + j)
.WithQuantity(j)
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).MiscCharge)
.Build();
salesInvoice.AddSalesInvoiceItem(salesInvoiceItem);
}
}
@this.Session().Derive();
for (var i = 0; i < 4; i++)
{
var supplier = faker.Random.ListItem(allors.CurrentSuppliers);
var purchaseInvoiceItem1 = new PurchaseInvoiceItemBuilder(@this.Session())
.WithDescription("first item")
.WithPart(nonSerialisedPart1)
.WithAssignedUnitPrice(3000)
.WithQuantity(1)
.WithMessage(@"line1
line2")
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).PartItem)
.Build();
var purchaseInvoiceItem2 = new PurchaseInvoiceItemBuilder(@this.Session())
.WithDescription("second item")
.WithAssignedUnitPrice(2000)
.WithQuantity(2)
.WithPart(nonSerialisedPart2)
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).PartItem)
.Build();
var purchaseInvoiceItem3 = new PurchaseInvoiceItemBuilder(@this.Session())
.WithDescription("Fee")
.WithAssignedUnitPrice(100)
.WithQuantity(1)
.WithInvoiceItemType(new InvoiceItemTypes(@this.Session()).Fee)
.Build();
var purchaseInvoice = new PurchaseInvoiceBuilder(@this.Session())
.WithBilledTo(allors)
.WithBilledFrom(supplier)
.WithPurchaseInvoiceItem(purchaseInvoiceItem1)
.WithPurchaseInvoiceItem(purchaseInvoiceItem2)
.WithPurchaseInvoiceItem(purchaseInvoiceItem3)
.WithCustomerReference("a reference number")
.WithDescription("Purchase of 1 used Aircraft Towbar")
.WithPurchaseInvoiceType(new PurchaseInvoiceTypes(@this.Session()).PurchaseInvoice)
.WithVatRegime(new VatRegimes(@this.Session()).Assessable)
.Build();
var purchaseOrderItem1 = new PurchaseOrderItemBuilder(@this.Session())
.WithDescription("first purchase order item")
.WithPart(nonSerialisedPart1)
.WithQuantityOrdered(1)
.Build();
var purchaseOrder = new PurchaseOrderBuilder(@this.Session())
.WithOrderedBy(allors)
.WithTakenViaSupplier(supplier)
.WithPurchaseOrderItem(purchaseOrderItem1)
.WithCustomerReference("reference " + i)
.Build();
}
var anOrganisation = new Organisations(@this.Session()).FindBy(M.Organisation.IsInternalOrganisation, false);
var item = new SerialisedItemBuilder(@this.Session())
.WithSerialNumber("112")
.WithSerialisedItemAvailability(new SerialisedItemAvailabilities(@this.Session()).Sold)
.WithAvailableForSale(false)
.WithOwnedBy(anOrganisation)
.Build();
nonSerialisedPart2.AddSerialisedItem(item);
var workTask = new WorkTaskBuilder(@this.Session())
.WithTakenBy(allors)
.WithCustomer(anOrganisation)
.WithName("maintenance")
.Build();
new WorkEffortFixedAssetAssignmentBuilder(@this.Session())
.WithFixedAsset(item)
.WithAssignment(workTask)
.Build();
var workOrderPart1 = allors.CreateNonSerialisedNonUnifiedPart(faker);
var workOrderPart2 = allors.CreateNonSerialisedNonUnifiedPart(faker);
var workOrderPart3 = allors.CreateNonSerialisedNonUnifiedPart(faker);
@this.Session().Derive();
var workOrder = new WorkTaskBuilder(@this.Session())
.WithName("Task")
.WithTakenBy(allors)
.WithFacility(new Facilities(@this.Session()).Extent().First)
.WithCustomer(anOrganisation)
.WithWorkEffortPurpose(new WorkEffortPurposes(@this.Session()).Maintenance)
.WithSpecialTerms("Net 45 Days")
.Build();
new WorkEffortFixedAssetAssignmentBuilder(@this.Session())
.WithFixedAsset(item)
.WithAssignment(workOrder)
.WithComment("Busted tailpipe")
.Build();
workOrder.CreateInventoryAssignment(workOrderPart1, 11);
workOrder.CreateInventoryAssignment(workOrderPart2, 12);
workOrder.CreateInventoryAssignment(workOrderPart3, 13);
//// Work Effort Time Entries
var yesterday = DateTimeFactory.CreateDateTime(@this.Session().Now().AddDays(-1));
var laterYesterday = DateTimeFactory.CreateDateTime(yesterday.AddHours(3));
var today = DateTimeFactory.CreateDateTime(@this.Session().Now());
var laterToday = DateTimeFactory.CreateDateTime(today.AddHours(4));
var tomorrow = DateTimeFactory.CreateDateTime(@this.Session().Now().AddDays(1));
var laterTomorrow = DateTimeFactory.CreateDateTime(tomorrow.AddHours(6));
var standardRate = new RateTypes(@this.Session()).StandardRate;
var overtimeRate = new RateTypes(@this.Session()).OvertimeRate;
var frequencies = new TimeFrequencies(@this.Session());
var timeEntryYesterday1 = workOrder.CreateTimeEntry(yesterday, laterYesterday, frequencies.Day, standardRate);
var timeEntryToday1 = workOrder.CreateTimeEntry(today, laterToday, frequencies.Hour, standardRate);
var timeEntryTomorrow1 = workOrder.CreateTimeEntry(tomorrow, laterTomorrow, frequencies.Minute, overtimeRate);
allorsEmployee1.TimeSheetWhereWorker.AddTimeEntry(timeEntryYesterday1);
allorsEmployee1.TimeSheetWhereWorker.AddTimeEntry(timeEntryToday1);
allorsEmployee1.TimeSheetWhereWorker.AddTimeEntry(timeEntryTomorrow1);
var timeEntryYesterday2 = workOrder.CreateTimeEntry(yesterday, laterYesterday, frequencies.Day, standardRate);
var timeEntryToday2 = workOrder.CreateTimeEntry(today, laterToday, frequencies.Hour, standardRate);
var timeEntryTomorrow2 = workOrder.CreateTimeEntry(tomorrow, laterTomorrow, frequencies.Minute, overtimeRate);
allorsEmployee2.TimeSheetWhereWorker.AddTimeEntry(timeEntryYesterday2);
allorsEmployee2.TimeSheetWhereWorker.AddTimeEntry(timeEntryToday2);
allorsEmployee2.TimeSheetWhereWorker.AddTimeEntry(timeEntryTomorrow2);
var po = new PurchaseOrders(@this.Session()).Extent().First;
foreach (PurchaseOrderItem purchaseOrderItem in po.PurchaseOrderItems)
{
new WorkEffortPurchaseOrderItemAssignmentBuilder(@this.Session())
.WithPurchaseOrderItem(purchaseOrderItem)
.WithAssignment(workOrder)
.WithQuantity(1)
.Build();
}
@this.Session().Derive();
}
public void GivenSalesInvoice_WhenObjectStateIsWrittenOff_ThenCheckTransitions()
{
var customer = new OrganisationBuilder(this.DatabaseSession).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.DatabaseSession)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.DatabaseSession)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.DatabaseSession).FindBy(Countries.Meta.IsoCode, "BE"))
.Build())
.Build();
var administrator = new PersonBuilder(this.DatabaseSession).WithFirstName("Koen").WithUserName("administrator").Build();
var administrators = new UserGroups(this.DatabaseSession).Administrators;
administrators.AddMember(administrator);
this.DatabaseSession.Derive(true);
this.DatabaseSession.Commit();
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("administrator", "Forms"), new string[0]);
var invoice = new SalesInvoiceBuilder(this.DatabaseSession)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.DatabaseSession).SalesInvoice)
.WithBilledFromInternalOrganisation(new InternalOrganisations(this.DatabaseSession).FindBy(InternalOrganisations.Meta.Name, "internalOrganisation"))
.Build();
new CustomerRelationshipBuilder(this.DatabaseSession).WithFromDate(DateTime.UtcNow).WithCustomer(customer).WithInternalOrganisation(Singleton.Instance(this.DatabaseSession).DefaultInternalOrganisation).Build();
invoice.Send();
invoice.WriteOff();
this.DatabaseSession.Derive(true);
var acl = new AccessControlList(invoice, new Users(this.DatabaseSession).GetCurrentUser());
Assert.IsFalse(acl.CanExecute(SalesInvoices.Meta.Send));
Assert.IsFalse(acl.CanExecute(SalesInvoices.Meta.WriteOff));
Assert.IsFalse(acl.CanExecute(SalesInvoices.Meta.CancelInvoice));
}
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 GivenWeeklyRepeatingSalesInvoice_WhenRepeating_ThenRepeatStopReachingLastExecutionDate()
{
var customer = new OrganisationBuilder(this.Session).WithName("customer").Build();
var contactMechanism = new PostalAddressBuilder(this.Session)
.WithAddress1("Haverwerf 15")
.WithPostalBoundary(new PostalBoundaryBuilder(this.Session)
.WithLocality("Mechelen")
.WithCountry(new Countries(this.Session).FindBy(M.Country.IsoCode, "BE"))
.Build())
.Build();
var homeAddress = new PostalAddressBuilder(this.Session)
.WithAddress1("Sint-Lambertuslaan 78")
.WithPostalBoundary(new PostalBoundaryBuilder(this.Session)
.WithLocality("Muizen")
.WithCountry(new Countries(this.Session).FindBy(M.Country.IsoCode, "BE"))
.Build())
.Build();
var billingAddress = new PartyContactMechanismBuilder(this.Session)
.WithContactMechanism(homeAddress)
.WithContactPurpose(new ContactMechanismPurposes(this.Session).BillingAddress)
.WithUseAsDefault(true)
.Build();
customer.AddPartyContactMechanism(billingAddress);
new CustomerRelationshipBuilder(this.Session).WithFromDate(this.Session.Now()).WithCustomer(customer).Build();
this.Session.Derive();
var invoice = new SalesInvoiceBuilder(this.Session)
.WithInvoiceNumber("1")
.WithBillToCustomer(customer)
.WithBillToContactMechanism(contactMechanism)
.WithSalesInvoiceType(new SalesInvoiceTypes(this.Session).SalesInvoice)
.Build();
var mayFourteen2018 = new DateTime(2018, 5, 14, 12, 0, 0, DateTimeKind.Utc);
var timeShift = mayFourteen2018 - DateTime.UtcNow;
this.TimeShift = timeShift;
var countBefore = new SalesInvoices(this.Session).Extent().Count;
var repeatingInvoice = new RepeatingSalesInvoiceBuilder(this.Session)
.WithSource(invoice)
.WithFrequency(new TimeFrequencies(this.Session).Week)
.WithDayOfWeek(new DaysOfWeek(this.Session).Monday)
.WithNextExecutionDate(mayFourteen2018)
.WithFinalExecutionDate(mayFourteen2018.AddDays(21))
.Build();
Assert.False(this.Session.Derive(false).HasErrors);
RepeatingSalesInvoices.Daily(this.Session);
Assert.Equal(countBefore + 1, new SalesInvoices(this.Session).Extent().Count);
Assert.Equal(new DateTime(2018, 5, 21), repeatingInvoice.NextExecutionDate.Date);
Assert.Equal(new DateTime(2018, 5, 14), repeatingInvoice.PreviousExecutionDate.Value.Date);
Assert.Single(repeatingInvoice.SalesInvoices);
var mayTwentyOne2018 = new DateTime(2018, 5, 21, 12, 0, 0, DateTimeKind.Utc);
timeShift = mayTwentyOne2018 - DateTime.UtcNow;
this.TimeShift = timeShift;
Assert.False(this.Session.Derive(false).HasErrors);
RepeatingSalesInvoices.Daily(this.Session);
Assert.Equal(countBefore + 2, new SalesInvoices(this.Session).Extent().Count);
Assert.Equal(new DateTime(2018, 5, 28), repeatingInvoice.NextExecutionDate.Date);
Assert.Equal(2, repeatingInvoice.SalesInvoices.Count);
var mayTwentyEight2018 = new DateTime(2018, 5, 28, 12, 0, 0, DateTimeKind.Utc);
timeShift = mayTwentyEight2018 - DateTime.UtcNow;
this.TimeShift = timeShift;
Assert.False(this.Session.Derive(false).HasErrors);
RepeatingSalesInvoices.Daily(this.Session);
Assert.Equal(countBefore + 3, new SalesInvoices(this.Session).Extent().Count);
Assert.Equal(new DateTime(2018, 6, 4), repeatingInvoice.NextExecutionDate.Date);
Assert.Equal(new DateTime(2018, 5, 28), repeatingInvoice.PreviousExecutionDate.Value.Date);
Assert.Equal(3, repeatingInvoice.SalesInvoices.Count);
var juneFour2018 = new DateTime(2018, 6, 4, 12, 0, 0, DateTimeKind.Utc);
timeShift = juneFour2018 - DateTime.UtcNow;
this.TimeShift = timeShift;
Assert.False(this.Session.Derive(false).HasErrors);
RepeatingSalesInvoices.Daily(this.Session);
Assert.Equal(countBefore + 4, new SalesInvoices(this.Session).Extent().Count);
Assert.Equal(new DateTime(2018, 6, 4), repeatingInvoice.NextExecutionDate.Date);
Assert.Equal(new DateTime(2018, 6, 4), repeatingInvoice.PreviousExecutionDate.Value.Date);
Assert.Equal(4, repeatingInvoice.SalesInvoices.Count);
var juneEleven2018 = new DateTime(2018, 6, 11, 12, 0, 0, DateTimeKind.Utc);
timeShift = juneEleven2018 - DateTime.UtcNow;
this.TimeShift = timeShift;
Assert.False(this.Session.Derive(false).HasErrors);
RepeatingSalesInvoices.Daily(this.Session);
Assert.Equal(countBefore + 4, new SalesInvoices(this.Session).Extent().Count);
Assert.Equal(new DateTime(2018, 6, 4), repeatingInvoice.NextExecutionDate.Date);
Assert.Equal(new DateTime(2018, 6, 4), repeatingInvoice.PreviousExecutionDate.Value.Date);
Assert.Equal(4, repeatingInvoice.SalesInvoices.Count);
}
