Hi Wagner,While cursor gives you great advantage of manipulating data row-by-row, I would avoid using it within the SBO_SP_TransactionNotification due to potential performance issues and locks.Cursors can significantly slow down operations because th...
Hi Harmony,SAP Business One mainly focuses on a scenario when invoices are generated per customer with a certain recurrence. This is what the template-based recurrent transaction function is intended for; which although does not suit your needs.Your ...
Hi Harmony,Please have a look at the template-based Recurrent Transaction functionality, it should help.If not, you may need a custom solution that can be tailored to your needs using SDK.
Hi Vikram,If you wish to follow the changelog of the Price List itself, i.e. Price List name, Authorization Group, etc., these changes are stored in OPLN/APLN tables (Price Lists).If you wish to see the changes for an item price within a price list, ...
Hi Tobias,You can retrieve the object code based on the series as follows:SELECT "ObjectCode" FROM NNM1 WHERE "Series" = $[$88.0.0]The rest should be a matter of technicality. Based on the Object Code you can further append either the respective data...