Personal Folder

Dear IT
Mohon bantuannya untuk create new term of payment.  Di term of payment utk LC yang terakhir ada Z032 : LC 180 days, create baru, Z033 : LC 365 days.
Go to OBB8.

We can create new payment term by copying existing. Click copy.

Insert new desired Payment Term code, Sales Text, Own Explanation, and No. of Days.

Last step is trying new payment term in transaction to make sure that the configuration is o.k.

User experience “Enter G/L Account No” error when creating PR.

This error related to gl account automatic posting, thus related to material valuation class.
Go to Display Material MM03 > Accounting 1 tab to see material valuation class.

Go to OMWB to see G/L Accounts in MM Account Determination (Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Configure Automatic Posting > G/L Accounts)
Configuration shows that the valuation class only has one gl account configuration, that is account balance. While the P&L account is not configured yet.
300116     Receipt Credit A/C (GR/IR) - Services              Balance
           3090 Services Expenses          
                WRX GR/IR clearing account

Compare with valuation class that has balance and P&L gl account pair.
300116     Receipt Credit A/C (GR/IR) - Services              Balance
    2060 Stationeries/Supplies/Pri
        WRX GR/IR clearing account
780000 Stationeries/Supplies/Printing/Photocopy P&L
    2060 Stationeries/Supplies/Pri
        GBB Offsetting entry for inventory posting
        VBR Consumption for Internal Goods Issues
        VBR Consumption for Internal Goods Issues

I should ask accounting to config P&L account for this automatic posting then, since this things is their authority.

     Our SAP system now maintain two company. Since both using same smartforms, we have to modify it. Today I have to modify procurement manager name. When we print to Company A, it shows Mr A, when we print to Company B it will shows company B. The node shows that the element is using SAP standard text. So I just have to add new SAP standard text (tcode: SO10, as SE78 to input graphics) to Company B and add condition to the node. Not a big deal.
     Test part at PTD (development environment) shows o.k. But after transport it to PTQ (quality environment), the item is just blank. Try to debug it in PTD everything is fine. But in PTQ it still blank. After minutes work around, it just a silly mistake. I forgot to create the standard text in PTQ also. Standard text (and graphics) is not automatically transported when we transport the smartforms. And ofcourse, I have to add it manually at PTP (production environment).

Todays job is uploading PO that has been already GR by store. How come doing Good Receipt without PO? Hehehe.. this early phase of SAP implementation is not perfect yet, we have to do 'back door' things to keep the plant running and money in balance.

Meanwhile, our Sales and Distribution key users and IT who guard this module is in holiday (ups, it is me who take the job on Saturday). Warehouse and sales team start asking about Sales Quotation, Sales Order, Delivery, Credit Limit Check, Finish Goods Stock Balance, Consignment, etc etc.... Gotta hardly remember SD things one year past.

Dear Team, We need your fully support  since period is open today (1 month late ) and very tight target (only 2 days). The real problem usually occur on first posting activities.
Pak Ezal, please standby for Transport Request from us.
Pak Joko/Pak Hilal/Pak Farid, please come to Curug on Thursday & Friday (6-7 August) and assist the user to post transactions.
Thank you for your valuable support.
Thanks & regard

----------

First SAP open period for our newly joined company…………. &%$*&$%^$#

Dear IT Team,

Please add Mr. Suryana and Mr. Sapendi as new buyer on the SAP system, and revoke Mr. Alen and Mr. Roesman since both are rolled to another department.

Thank you

SPRO > SAP Ref IMG (F5) > Material Master > Purchasing > Create or Maintain
Purchaisng groups

Don’t forget to add new Purchasing Group to user roles (current screenshot gives * mark, shows that the user has access to all purchasing group).

Dear Farid,
Thanks for your documents. But for the vendor master list, can we have similar format with the same fields as the file attached? The attachment is the vendor master list for TPM. We would like to have similar format including vendor bank account number field for our testing purposes. Thanks for your help.
Best regards,

Internal Audit Dept


Requested field are:
Vendor Account Number
Name 1
Name 2
Name 3
Name 4
Street 4
Street 5
City
PostalCode
Region
Telephone 1
Fax Number
Creation Date
Central Deletion Flag for Master Record
Central posting block
Centrally imposed purchasing block
Bank Account Number
Email

Here the step:
Go to SQVI > Select Basis Mode

Go to data source to create table relationship.



At table LFA1:
Vendor Account Number
Name 1
Name 2
Name 3
Name 4
City
PostalCode
Region
Central Deletion Flag for Master Record
Central posting block
Centrally imposed purchasing block

At table ADRC:
Street 4
Street 5

At table LFB1:
Creation Date
Company Code

At table ADR6:
Email Address

At table LFBK:
Bank Account Number


For email address, I found the table from this article, since at the technical information of the field it point to a structure, not direct point to original table.
http://husnie.wordpress.com/2007/11/08/finding-email-address-customer-and-vendor-master-on-sap/
You need to activated SQL trace and change email on master to find where email address is stored. Here i share the result of tracing using SQL trace of email addess Customer and Vendor master.
For Vendor :
select adr6-addrnumber (email)
from table adr6 join table lfa1 with key adr6-addrnumber = lfa1-adrnr