Revision 531e1a51
Von Bernd Bleßmann vor fast 10 Jahren hinzugefügt
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
| 61 | 61 |
ir_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
| 62 | 62 |
is_changeable => { type => 'integer', default => 2, not_null => 1 },
|
| 63 | 63 |
is_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
| 64 |
is_transfer_out => { type => 'boolean', default => 'false', not_null => 1 },
|
|
| 64 | 65 |
itime => { type => 'timestamp', default => 'now()' },
|
| 65 | 66 |
language_id => { type => 'integer' },
|
| 66 | 67 |
max_future_booking_interval => { type => 'integer', default => 360 },
|
| SL/DB/MetaSetup/Inventory.pm | ||
|---|---|---|
| 16 | 16 |
delivery_order_items_stock_id => { type => 'integer' },
|
| 17 | 17 |
employee_id => { type => 'integer', not_null => 1 },
|
| 18 | 18 |
id => { type => 'serial', not_null => 1 },
|
| 19 |
invoice_id => { type => 'integer' },
|
|
| 19 | 20 |
itime => { type => 'timestamp', default => 'now()' },
|
| 20 | 21 |
mtime => { type => 'timestamp' },
|
| 21 | 22 |
oe_id => { type => 'integer' },
|
| ... | ... | |
| 48 | 49 |
key_columns => { employee_id => 'id' },
|
| 49 | 50 |
}, |
| 50 | 51 |
|
| 52 |
invoice => {
|
|
| 53 |
class => 'SL::DB::InvoiceItem', |
|
| 54 |
key_columns => { invoice_id => 'id' },
|
|
| 55 |
}, |
|
| 56 |
|
|
| 51 | 57 |
oe => {
|
| 52 | 58 |
class => 'SL::DB::DeliveryOrder', |
| 53 | 59 |
key_columns => { oe_id => 'id' },
|
| sql/Pg-upgrade2/transfer_out_sales_invoice.sql | ||
|---|---|---|
| 1 |
-- @tag: transfer_out_sales_invoice |
|
| 2 |
-- @description: Felder für das Feature "Auslagern beim Buchen von Verkaufsrechnungen". |
|
| 3 |
-- @depends: warehouse_add_delivery_order_items_stock_id |
|
| 4 |
-- @encoding: utf-8 |
|
| 5 |
|
|
| 6 |
ALTER TABLE inventory ADD COLUMN invoice_id INTEGER REFERENCES invoice(id); |
|
| 7 |
ALTER TABLE defaults ADD COLUMN is_transfer_out BOOLEAN NOT NULL DEFAULT FALSE; |
|
| templates/webpages/client_config/_warehouse.html | ||
|---|---|---|
| 70 | 70 |
<td align="right" nowrap="true">[% LxERP.t8('Default Bin with ignoring onhand') %]</td>
|
| 71 | 71 |
<td>[% L.select_tag('defaults.bin_id_ignore_onhand', [], id='bin_id_ignore_onhand', with_empty=1) %]</td>
|
| 72 | 72 |
</tr> |
| 73 |
|
|
| 74 |
<tr><td colspan="3"><hr /></td></tr> |
|
| 75 |
<tr> |
|
| 76 |
<td align="right">[% LxERP.t8('Transfer out on posting sales invoices?') %]</td>
|
|
| 77 |
<td> |
|
| 78 |
[% L.yes_no_tag('defaults.is_transfer_out', SELF.defaults.is_transfer_out) %]
|
|
| 79 |
</td> |
|
| 80 |
<td> |
|
| 81 |
[% LxERP.t8('Transfer out all items of a sales invoice when posting it. Items are transfered out acording to the settings above.') %]
|
|
| 82 |
</td> |
|
| 83 |
</tr> |
|
| 84 |
|
|
| 73 | 85 |
<tr><td colspan="3"><hr /></td></tr> |
| 74 | 86 |
<tr> |
| 75 | 87 |
<tr> |
| ... | ... | |
| 88 | 100 |
</td> |
| 89 | 101 |
</tr> |
| 90 | 102 |
<tr><td colspan="3"><hr /></td></tr> |
| 91 |
<tr> |
|
| 103 |
<tr>
|
|
| 92 | 104 |
<td align="right">[% LxERP.t8('Show Value of Goods for Delivery Plan') %]</td>
|
| 93 | 105 |
<td> |
| 94 | 106 |
[% L.yes_no_tag('defaults.delivery_plan_show_value_of_goods', SELF.defaults.delivery_plan_show_value_of_goods) %]
|
| ... | ... | |
| 106 | 118 |
[% 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') %]
|
| 107 | 119 |
</td> |
| 108 | 120 |
</tr> |
| 121 |
|
|
| 109 | 122 |
</table> |
| 110 | 123 |
</div> |
Auch abrufbar als: Unified diff
Auslagern in VK-Rechnung: Neue Datenbank-Felder, Rose u. Mandantenkonfiguration