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 10: | Line 10: | ||
[[Image:PackOut_PT1.png|400px]] | [[Image:PackOut_PT1.png|400px]] | ||
+ | |||
+ | 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: | ||
+ | |||
+ | [[Image:PackOut_PT2.png]] | ||
+ | |||
+ | 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'; |
Revision as of 08:26, 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';