Replies posted by arwid

3 Replies

M
Do Gooder (Customer)
M_P_SDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Having dynamic filename in migration jobs

Old question but for information it is possible to dynamically name the created file in these ways: &DATF Date in same dateformat as migration header &DATE Date in format YYYYMMDD &USER The User name of the current user &GUID Guid &TIME Time in format hh24iss &SEQN Sequence Number  

7
C
Do Gooder (Partner)
18 days ago
L
Hero (Customer)
ludovic.rougeanHero (Customer)
asked in Finance (Financials)

100,000 lines limitation

I completely agree with the previous proposals, but here is a slightly "dirtier" solution. It is possible to change the maximum number in the user profile whatever number, in example below to 200 000 rows. However, this will prevent the user from accessing Options since an error message is displayed in the client informing that the value is invalid. My recommendations is to only use this if migration jobs or external files are not an option. Error example: 

6
Peshala Gamage
Hero (Employee)
2 years ago
L
Do Gooder (Customer)
llvspgDo Gooder (Customer)
asked in Distribution (CRM, Commerce)

Exporting IFS data to Excel

I have created a quick report and added CHR(9) in the select, for exampleselect CHR(9)||customer_no from &AO.customer_order_line,  this will also solve another issue when long numbers for examlple “1020019393400100” are formatted in excel to 1,02002E+15

7
A
Do Gooder (Partner)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings