Issue For Production

[Former Member]

Dear All Users,

I want to create a Journal Entry same as in 'Issue For Production'. How can I do that ?

Plz help me.

[ANKIT_CHAUHAN · Accepted solution]

Hi Amit,

Edy is right. For creating a journal Entry for Issue for Production, you will have to Credit your Inventory Account & Debit to your WIP Account.

Else describe your scenario.

Hope it helps...

Thanks

[edy_simon]

Hi Amit,

Can you explain your question?

Issue for production is crediting your inventory account and debiting the WIP account.

Regards

Edy

[Former Member]

Hi,

  &

thanks for the reply. I want to create a JE using DIAPI object but how can I find the inventory account and WIP account against each item. I am not able to find it.

Thanks

[edy_simon]

Hi Amit,

If you are not using Advance GL Account Determination in SBO9, you can try this query

SELECT (CASE glmethod   WHEN 'L' THEN t1.WipAcct  WHEN 'W' THEN t2.WipAcct  WHEN 'C' THEN t3.WipAcct END) WIPAcctCode,
          (CASE glmethod   WHEN 'L' THEN t1.BalInvntAc  WHEN 'W' THEN t2.BalInvntAc  WHEN 'C' THEN t3.BalInvntAc END) InvntAcctCode  
FROM oitm t0  
INNER JOIN oitw t1 ON t0.itemcode=t1.itemcode  
LEFT JOIN owhs t2 ON t1.whscode=t2.whscode  
LEFT JOIN oitb t3 ON t0.itmsgrpcod=t3.itmsgrpcod 
WHERE T0.ItemCode = @ItemCode AND T1.WhsCode = @WhsCode

If you are using Advance GL Determination, the acct will be getting from OACP, AACP and OGAR tables.

I dont know if DI API provide a method to determine the account directly.

Regards
Edy

[Former Member]

Hi ,

Please tell me whether I can not use the above written query by you, if we are using Advance GL Determination. Plz give me the query for that also.

Regards

[edy_simon]

Hi Amit,

Are you using Advance GL Determination ?

Which SBO version are you using ?

If you are using Advance GL Determination, it is very difficult to use simple query to get the correct account code.

We will need to depend on any SAP provided SP/DI object to get this account - which sadly- I havent found one to yet.

Regards

Edy