Difference between revisions of "PackOut PaymentTerm Export"
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
(→Example of exporting Payment Terms with 2Pack) |
(→Example of exporting Payment Terms with 2Pack) |
||
| Line 16: | Line 16: | ||
Select Tab "Package Details" and fill required fields as on picture: | Select Tab "Package Details" and fill required fields as on picture: | ||
| − | [[Image:PackOut_PT2.png]] | + | [[Image:PackOut_PT2.png|400px]] |
Here You have to select/input: | Here You have to select/input: | ||
| Line 25: | Line 25: | ||
fixmonthday,fixmonthoffset,discountdays,discount,discountdays2,discount2,isnextbusinessday,isdefault, | fixmonthday,fixmonthoffset,discountdays,discount,discountdays2,discount2,isnextbusinessday,isdefault, | ||
value,netday,isvalid,processing FROM c_paymentterm WHERE ad_client_id='1000001'; | value,netday,isvalid,processing FROM c_paymentterm WHERE ad_client_id='1000001'; | ||
| + | |||
| + | You can add more lines if You want to. | ||
| + | |||
| + | Save, return to main Tab and press Package Export. | ||
Revision as of 08:27, 21 February 2008
Example of exporting Payment Terms with 2Pack
Before You can export as clientAdmin You have to make PackOut accesible to Admin user like Bojana explained here: https://sourceforge.net/forum/message.php?msg_id=4791865
Then select Menu item as on picture:
In window You fill all required fields:
Creation directory is path to the disk space You want package to be exported to.
Select Tab "Package Details" and fill required fields as on picture:
Here You have to select/input:
Type: Data Table: C_PaymentTerm SQL: SELECT isactive,name,description,documentnote,afterdelivery,isduefixed,netdays,gracedays,fixmonthcutoff, fixmonthday,fixmonthoffset,discountdays,discount,discountdays2,discount2,isnextbusinessday,isdefault, value,netday,isvalid,processing FROM c_paymentterm WHERE ad_client_id='1000001';
You can add more lines if You want to.
Save, return to main Tab and press Package Export.
