Category Archives: Templates Development

The new template will initiate concurrent requests defined in a excel sheet. This is very usefull for unit tests, where you want to run the same report with different parameters, over and over again between development updates, until the report … Continue reading →

This is the story of how to update the item category set on pricelist modifiers. In order to do that you must inactivate all modifiers, change the pointer to the new category set and create a new complete set of modifiers … Continue reading →

The API script has been updated. It will now handle both ‘in’ and ‘in/out’ arguments. The F load_fa_adjustments template is build using the api.sql scripts.

Qualifiers on header level can be create in one API call but to create a qualifier on modifier level, you need to have a second API call, using the return values from the first API: DECLARE – copyright 2008 – … Continue reading →

In 11.5.10 the INV_LOC_WMS_PUB.CREATE_LOCATOR API fails. As far as I can see, it is the key flex field validation that newer succeeds, and I can not find any insert statements in the API package – I am putting this one … Continue reading →

The custome load has just been verified on the Vision Release 12 database. The Load_customer_v207.xls has 5 rows that load: organization account account relations addresses business purposes Only the customer data sheet and the ‘created by module’ on the mapping sheet … Continue reading →

The Load Pricelist Modifiers template has been updated. The plsql will handle sheet value inputs – that will fill the ID’s for API. In order to load line qualifiers, the modifier line must exist, so a second API call was … Continue reading →