While creating the invoice, the Material Information under Customer Details is different. So, the Invoice must contain the Material Information as per the Customer details in SAP.
Bot has been created to Auto login to SAP and extract data like, Sales area (Customer account number, Sales organisation, Distribution channel), Material description, Customer material description, Status are automatically for any customer specific transaction, including invoice generation.
Customer Material Info Record – VD51.
Challenge is to create listing/exclusion of the material for particular customer based on validity.(Valid from date to valid to date)
Bot is designed to create listing of material for an individual customer that it will restrict the material which are not listed for a particular validity. So that it is easier to process sales order for particular customer.
Material Listing-VB01
To display the Customer balances after report execution, in local currency.
Bot has been created to Auto login to SAP and insert customer account number as well as company to respective input fields and extract balance data and store in spreadsheet. After execution of report bot will extract customer’s credit/debit calculated balance in local currency and store against individual customer.
Display Customer balances-F.23
Asset master records are to be created in SAP with description, inventory number, Business area, Profit center, Vendor account, Leasing type, Depreciation area. It is tedious task and consumes lot many hours to create record.
Bot is designed to create assets in SAP ERP. End user provides the data in excel format. Bot reads the data from excel and creates master record in SAP in no time.
Create Asset-AS01
To extract asset number, sub number, company code from SAP and generate report on Asset Values. And the user has to send this report to concerned authority in mail as attachment. This is a manual tedious task.
Bot is designed to extract asset values, Bot will enter asset number, sub number, company code and hits on asset values. It will provide proper report format of asset with necessary details. Bot sends automated email to the concerned authorities with Asset Value Report as an attachment. This Bot displays Assets in the SAP system and updates its description in the Spreadsheet, send mail to concern person.
Display Asset-AS03
There are cases where business temporary or permanent discontinue / deactivate the product for further production / sales / procurement.
There may be cases where material and material groups are stopped from business, and need to update the master for blocking material for further sales / inventory transactions
Bot is designed to disable material, Bot will enter material number, Sales area to deactivate the material, and there is a choice to disable material either plant wise or sales area wise.
Material Deletion –MM06