Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Nightmare with libs

Hi,

 

I'm trying to store some QVD in a different location and I could not do it.

I defined a connection and by code I mapped the connection, too

Screenshot_3.png

 

the load and store script:

NSTransactions:
LOAD 
CREATED_FROM_ID,
TRANDATE,
TRANSACTION_EXTID,
TRANSACTION_ID,
TRANSACTION_TYPE,
//BASE_AMOUNT,
ENTITY_ID,
If(Left([TRANSACTION_EXTID], 3)='FV0',
Replace([TRANSACTION_EXTID], 'FV', 'PV'),
Replace([TRANSACTION_EXTID], 'FV', 'PR')) as SalesId,
XBASEAMT1+XBASEAMT2+XBASEAMT3+XBASEAMT4 as Bruto_Fra;
SQL SELECT 
CREATED_FROM_ID,
TRANDATE,
//BASE_AMOUNT,
TRANSACTION_EXTID,
TRANSACTION_ID,
TRANSACTION_TYPE,
ENTITY_ID,
XBASEAMT1,XBASEAMT2,XBASEAMT3,XBASEAMT4
FROM "ULABOX, S_L_".Administrator.TRANSACTIONS
Where TRANSACTION_TYPE='Invoice'or TRANSACTION_TYPE='Sales Order'or TRANSACTION_TYPE='Inventory Adjustment';
STORE NSTransactions INTO $(VStore)NSTransactions.qvd (qvd);

and the error:

Screenshot_5.png

Thank's for your help

Eduard

 

 

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Please note the correct folder name, it has (ebox_ecabanas) part

View solution in original post

1 Reply
Clever_Anjos
Employee
Employee

Please note the correct folder name, it has (ebox_ecabanas) part