Sunday, December 13, 2009

Cant Create Reservation on Non Working Day

Posted by Aries Wandari

Dear All,
Saya tidak bisa melakukan reservasi SAP 201 (withdraw stocl from Sparepart Room Warehouse) di hari Sabtu dan Minggu.
Bisa dijelaskan?
Trims
imamsn
-------
Dear pak Imam SN,
    Untuk bisa melakukan reservation di sabtu minggu, clear option "Check against cal." checkbox.
image

Tuesday, December 8, 2009

Problem on Create Payment Proposal List

Posted by Aries Wandari

          Accounting staff try to create PPL for vendor 500011. At FBL1N there are overdue item for this vendor, but when she try to create PPL, no list generated. This problem occur sometimes, usually when user try it again later, it back to normal. But this time, the problem is persist. The payment identification is Y1011.
Overdue item on FBL1N
image
----
Answer:
We need to check whether PPL already created prior to this vendor.  It will need to delete that before you can run for this newly created PPL. For the next time when you experience the same issue, please follow steps below:
a. Go to transaction code: SE16; Enter table REGUH and execute.
b. From the list of the fields, key in vendor code. In this example; it will be 500011. This will show all the payment related to this vendor.
c. In each completed transactions, you should see 2 records with the same Run date and Identification. So, from here, it is clearly showed that PPL for Identification Y1011 has been run but not the payment. Need to delete this proposal if you want to generate the new one.
image

          LSMW will produce error if text data transported have carriage return character. We have to replace it with another character. But, how to search that character on text. I’m using ms excell to search and replace the character. On the search/replace window, hold down alt and type 013, release alt key. Carriage return key will be found/replaced. For line feeds character, type 010.
In excell, long text with carriage return will go across the screen. To view them as multiple line, go to Format Cells menu, tab Alignment, tick the Wrap text check box.
image

Monday, December 7, 2009

LSMW Error because of Invalid Character

Posted by Aries Wandari

          One of audit result of Store Department is, they need to make mass modification of material short text. LSMW do the changes. But there error “BDC_INSERT, Transaction code . is invalid”. Its because the data exported contain invalid (carriage return) character. Carriage return character accidentally added from excell file that is exported to txt.
- Trial Data Step
The data contain two material number, the first contain enter character.
clip_image002
- Display Read Data Step (shows ok)
clip_image004
- Display Converted Data
Failed when reading enter character, its become three lines data exported.
clip_image006
- Error generated on Create Batch Input Session
clip_image008

          User asking for material can be used to create ‘health insurance’ purchase requisition. To choose the material, first I need to know this ‘health insurance’ things go to what cost element. Finance dept tell that this goes to account 775431 - Hospitalization Claim. TCode OBYC show that we dont have material with valuation class and the account pair. It mean we need to create new material with valuation class which is go to correct cost element.  Create new valuation class, configure automatic posting, and do trial.
1. Create new Valuation Class 3051
clip_image002
2. Configure automatic posting at OBYC.
- Account 775431 for Offsetting entry for inventory posting (P/L).
- Account 300116 for GR/IR clearing account (Balance).
clip_image004
clip_image006
3. Set tax for account 775431.
clip_image008
4. Trial
     4.1. Create material with val class 3051 (1600000520).
     4.2. Create PR 1600001450
     4.3. Create PO 4200000014
     4.4. GR process 5000004580
     4.5. Invoicing process 5100002900
5. Confirmation from finance that the posting of above trial is correct.

Note:
1. GBB: Offsetting entry for inventory posting
- AUA : for order settlement
- AUF: for goods receipts for orders (without account assignment) and for order settlement if AUA (mentioned above) is not maintained
- AUI: Subsequent adjustment of actual price from cost center directly to material (with account assignment)
- BSA: for initial entry of stock balances
- INV: for expenditure/income from inventory differences
- VAX: for goods issues for sales orders without account assignment object (the account is not a cost element)
- VAY: for goods issues for sales orders with account assignment object (account is a cost element)
- VBO: for consumption from stock of material provided to vendor
- VBR: for internal goods issues (for example, for cost center)
- VKA: for sales order account assignment (for example, for individual purchase order)
- VKP: for project account assignment (for example, for individual PO)
- VNG: for scrapping/destruction
- VQP: for sample withdrawals without account assignment
- VQY: for sample withdrawals with account assignment
2. BSX: Inventory posting
3. PRD: price differences
4. UMB: Gain/loss from revaluation
5. WRX: GR/IR clearing account

Me and Futsal Team

Posted by Aries Wandari

Professional appearence with traditional skill.. hehehe…