This will create the custom pane with title Pricelist Import. Save the below code section into a txt file and when in SYSPRO if you click on the drop down arrow (on the top right of any pane) you can select Customized Pane > Import Customized Pane and specify this txt file you have saved. There are 2 ways you can make use of this: in a custom pane within SYSPRO (no licensing requirements then) or if your customer is licensed for the respective business object you could write an external program to post updates using the business object.īelow is a custom pane I created sometime ago that updates prices of items based on an excel spreadsheet. Have a look here for more info regarding business objects: SYSPRO Business Object Library If this needs to be done in bulk (as your question seems to refer) then this would be best done by posting an update using one of the SYSPRO "business objects". Further, updating it directly in the database would also get rid of any possible audit trail. there is more often than not more than 1 place where a field is updated and/or there is an additional flag that is also changed. ![]() While it is relatively simple to breakdown and track what data is stored where etc. ![]() ![]() It's not advisable to update the SYSPRO database directly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |