Revision 531e1a51
Von Bernd Bleßmann vor etwa 10 Jahren hinzugefügt
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
|
ir_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
||
|
is_changeable => { type => 'integer', default => 2, not_null => 1 },
|
||
|
is_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
||
|
is_transfer_out => { type => 'boolean', default => 'false', not_null => 1 },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
language_id => { type => 'integer' },
|
||
|
max_future_booking_interval => { type => 'integer', default => 360 },
|
||
| SL/DB/MetaSetup/Inventory.pm | ||
|---|---|---|
|
delivery_order_items_stock_id => { type => 'integer' },
|
||
|
employee_id => { type => 'integer', not_null => 1 },
|
||
|
id => { type => 'serial', not_null => 1 },
|
||
|
invoice_id => { type => 'integer' },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
mtime => { type => 'timestamp' },
|
||
|
oe_id => { type => 'integer' },
|
||
| ... | ... | |
|
key_columns => { employee_id => 'id' },
|
||
|
},
|
||
|
|
||
|
invoice => {
|
||
|
class => 'SL::DB::InvoiceItem',
|
||
|
key_columns => { invoice_id => 'id' },
|
||
|
},
|
||
|
|
||
|
oe => {
|
||
|
class => 'SL::DB::DeliveryOrder',
|
||
|
key_columns => { oe_id => 'id' },
|
||
| sql/Pg-upgrade2/transfer_out_sales_invoice.sql | ||
|---|---|---|
|
-- @tag: transfer_out_sales_invoice
|
||
|
-- @description: Felder für das Feature "Auslagern beim Buchen von Verkaufsrechnungen".
|
||
|
-- @depends: warehouse_add_delivery_order_items_stock_id
|
||
|
-- @encoding: utf-8
|
||
|
|
||
|
ALTER TABLE inventory ADD COLUMN invoice_id INTEGER REFERENCES invoice(id);
|
||
|
ALTER TABLE defaults ADD COLUMN is_transfer_out BOOLEAN NOT NULL DEFAULT FALSE;
|
||
| templates/webpages/client_config/_warehouse.html | ||
|---|---|---|
|
<td align="right" nowrap="true">[% LxERP.t8('Default Bin with ignoring onhand') %]</td>
|
||
|
<td>[% L.select_tag('defaults.bin_id_ignore_onhand', [], id='bin_id_ignore_onhand', with_empty=1) %]</td>
|
||
|
</tr>
|
||
|
|
||
|
<tr><td colspan="3"><hr /></td></tr>
|
||
|
<tr>
|
||
|
<td align="right">[% LxERP.t8('Transfer out on posting sales invoices?') %]</td>
|
||
|
<td>
|
||
|
[% L.yes_no_tag('defaults.is_transfer_out', SELF.defaults.is_transfer_out) %]
|
||
|
</td>
|
||
|
<td>
|
||
|
[% LxERP.t8('Transfer out all items of a sales invoice when posting it. Items are transfered out acording to the settings above.') %]
|
||
|
</td>
|
||
|
</tr>
|
||
|
|
||
|
<tr><td colspan="3"><hr /></td></tr>
|
||
|
<tr>
|
||
|
<tr>
|
||
| ... | ... | |
|
</td>
|
||
|
</tr>
|
||
|
<tr><td colspan="3"><hr /></td></tr>
|
||
|
<tr>
|
||
|
<tr>
|
||
|
<td align="right">[% LxERP.t8('Show Value of Goods for Delivery Plan') %]</td>
|
||
|
<td>
|
||
|
[% L.yes_no_tag('defaults.delivery_plan_show_value_of_goods', SELF.defaults.delivery_plan_show_value_of_goods) %]
|
||
| ... | ... | |
|
[% LxERP.t8('The default delivery plan only checks if all delivery orders have been created not if the goods are transferred. This feature will check if all the goods are transferred. Caveat: Only the state of the delivery orders are checked not partial transferred delivery orders (in technical terms: the table inventory is not checked') %]
|
||
|
</td>
|
||
|
</tr>
|
||
|
|
||
|
</table>
|
||
|
</div>
|
||
Auch abrufbar als: Unified diff
Auslagern in VK-Rechnung: Neue Datenbank-Felder, Rose u. Mandantenkonfiguration