Revision 1b9948c2
Von Bernd Bleßmann vor mehr als 1 Jahr hinzugefügt
| SL/BackgroundJob/SetNumberRange.pm | ||
|---|---|---|
|
|
||
|
my $defaults = SL::DB::Default->get;
|
||
|
|
||
|
foreach (qw(invnumber cnnumber soinumber pqinumber sonumber ponumber sqnumber rfqnumber sdonumber pdonumber)) {
|
||
|
foreach (qw(invnumber cnnumber soinumber pqinumber sonumber ponumber pocnumber sqnumber rfqnumber sdonumber pdonumber)) {
|
||
|
my $current_number = SL::PrefixedNumber->new(number => $defaults->{$_});
|
||
|
$current_number->set_to($next_year * $multiplier);
|
||
|
$defaults->{$_} = $current_number->get_current;
|
||
| SL/DB/Helper/TransNumberGenerator.pm | ||
|---|---|---|
|
request_quotation => { number_column => 'quonumber', number_range_column => 'rfqnumber', scoping => \&oe_scoping, },
|
||
|
purchase_quotation_intake => { number_column => 'quonumber', number_range_column => 'pqinumber', scoping => \&oe_scoping, },
|
||
|
purchase_order => { number_column => 'ordnumber', number_range_column => 'ponumber', scoping => \&oe_scoping, },
|
||
|
purchase_order_confirmation => { number_column => 'ordnumber', number_range_column => 'pocnumber', scoping => \&oe_scoping, },
|
||
|
sales_delivery_order => { number_column => 'donumber', number_range_column => 'sdonumber', scoping => \&do_scoping, },
|
||
|
purchase_delivery_order => { number_column => 'donumber', number_range_column => 'pdonumber', scoping => \&do_scoping, },
|
||
|
supplier_delivery_order => { number_column => 'donumber', number_range_column => 'sudonumber', scoping => \&do_scoping, },
|
||
| SL/DB/Manager/Order.pm | ||
|---|---|---|
|
SALES_ORDER_TYPE(),
|
||
|
SALES_QUOTATION_TYPE(),
|
||
|
PURCHASE_ORDER_TYPE(),
|
||
|
PURCHASE_ORDER_CONFIRMATION_TYPE(),
|
||
|
REQUEST_QUOTATION_TYPE(),
|
||
|
PURCHASE_QUOTATION_INTAKE_TYPE(),
|
||
|
));
|
||
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
|
partsgroup_required => { type => 'boolean', default => 'false', not_null => 1 },
|
||
|
payments_changeable => { type => 'integer', default => '0', not_null => 1 },
|
||
|
pdonumber => { type => 'text' },
|
||
|
pocnumber => { type => 'text' },
|
||
|
ponumber => { type => 'text' },
|
||
|
pqinumber => { type => 'text' },
|
||
|
precision => { type => 'numeric', default => '0.01', not_null => 1, precision => 15, scale => 5 },
|
||
| SL/TransNumber.pm | ||
|---|---|---|
|
);
|
||
|
|
||
|
my @SUPPORTED_TYPES = (
|
||
|
qw(invoice invoice_for_advance_payment final_invoice credit_note customer vendor sales_delivery_order purchase_delivery_order sales_order_intake sales_order purchase_order sales_quotation request_quotation purchase_quotation_intake part service assembly assortment letter),
|
||
|
qw(invoice invoice_for_advance_payment final_invoice credit_note customer vendor sales_delivery_order purchase_delivery_order sales_order_intake sales_order purchase_order purchase_order_confirmation sales_quotation request_quotation purchase_quotation_intake part service assembly assortment letter),
|
||
|
@{ SL::DB::DeliveryOrder::TypeData::valid_types() },
|
||
|
);
|
||
|
|
||
| ... | ... | |
|
$filters{where} = 'NOT COALESCE(quotation, FALSE)';
|
||
|
$filters{where} .= $type =~ /^sales/ ? ' AND (customer_id IS NOT NULL)' : ' AND (vendor_id IS NOT NULL)';
|
||
|
|
||
|
} elsif ($type =~ /^purchase_order_confirmation$/) {
|
||
|
$filters{trans_number} = "ordnumber";
|
||
|
$filters{numberfield} = "pocnumber";
|
||
|
$filters{table} = "oe";
|
||
|
$filters{where} = 'record_type = ?';
|
||
|
$filters{values} = $type;
|
||
|
|
||
|
} elsif ($type =~ /_quotation$/) {
|
||
|
$filters{trans_number} = "quonumber";
|
||
|
$filters{numberfield} = $type eq 'sales_quotation' ? "sqnumber" : "rfqnumber";
|
||
| sql/Pg-upgrade2/oe_purchase_order_confirmation.sql | ||
|---|---|---|
|
-- @tag: oe_purchase_order_confirmation
|
||
|
-- @description: Neuer Einkaufsbeleg: Lieferantenauftragsbesätigung (purchase_order_confirmation)
|
||
|
-- @depends: release_3_8_0
|
||
|
|
||
|
ALTER TABLE defaults ADD pocnumber TEXT;
|
||
| templates/design40_webpages/client_config/_ranges_of_numbers.html | ||
|---|---|---|
|
<th>[% LxERP.t8('Purchase Order') %]</th>
|
||
|
<td>[% L.input_tag("defaults.ponumber", SELF.defaults.ponumber, size="15", class="wi-normal") %]</td>
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<th>[% LxERP.t8('Purchase Order Confirmation') %]</th>
|
||
|
<td>[% L.input_tag("defaults.pocnumber", SELF.defaults.pocnumber, size="15", class="wi-normal") %]</td>
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<th>[% LxERP.t8('Sales quotation') %]</th>
|
||
|
<td>[% L.input_tag("defaults.sqnumber", SELF.defaults.sqnumber, size="15", class="wi-normal") %]</td>
|
||
| templates/webpages/client_config/_ranges_of_numbers.html | ||
|---|---|---|
|
<td>[% L.input_tag("defaults.articlenumber", SELF.defaults.articlenumber, size="15") %]</td>
|
||
|
</tr>
|
||
|
|
||
|
<tr>
|
||
|
<td align="right" nowrap>[% LxERP.t8('Last Purchase Order Confirmation Number') %]</td>
|
||
|
<td>[% L.input_tag("defaults.pocnumber", SELF.defaults.pocnumber, size="15") %]</td>
|
||
|
</tr>
|
||
|
|
||
|
<tr>
|
||
|
<td align="right" nowrap>[% LxERP.t8('Last Sales Quotation Number') %]</td>
|
||
|
<td>[% L.input_tag("defaults.sqnumber", SELF.defaults.sqnumber, size="15") %]</td>
|
||
Auch abrufbar als: Unified diff
Lieferantenauftragsbestätigung: DB und Nummernkreis