Projects - EBS (MOSC)

MOSC Banner

Unable to Transfer the amount from one task to another task.

sarran-1987192
sarran-1987192 Posts: 18 Newbie

Comments

  • Dina Rotem
    Dina Rotem Posts: 782 Gold Trophy
    Hi

    Some of the transaction sources do not allow adjustments in Projects, in such case you may need to go back and make the adjustment in the source system, and interface back to Projects.

    Be sure you are importing a negative EI for the wrong task, and a new positive EI for the new task.

     Dina

  • Hi

    Some of the transaction sources do not allow adjustments in Projects, in such case you may need to go back and make the adjustment in the source system, and interface back to Projects.

    Be sure you are importing a negative EI for the wrong task, and a new positive EI for the new task.

     Dina

     Hi Dina,

    The source transaction is from Inventory module from where an item was issued to a wrong task.

    Now  I want to change this amount from the wrong task to the correct task in Projects Module iteself.

    You  mean to say that I have no other alternative except to go to the inventory, give return and again issue to the correct task?

    Is there any other easy way out to follow ?

    regards,

    Martin / Chandroo...,

  • Hi

    Some of the transaction sources do not allow adjustments in Projects, in such case you may need to go back and make the adjustment in the source system, and interface back to Projects.

    Be sure you are importing a negative EI for the wrong task, and a new positive EI for the new task.

     Dina

     Hi Dina,

    Thanks for the update.

    I did the following in the Transcation source set up in Projects  Module :-

    Enable the Check box  "Allow Adjustments" for the transaction source Inventory Misc

    Now I tried to transfer the amount from one task to another task

    The amount from the Old task got reduced (both quantity and Amount) through a negative line

    However, in the new task the line got added only with the quantity and not the amount.

    The amount field is blank.

    Kindly advise whether I have to run any concurrent program to get back the cost in the new task

    Thanks and regards,

    Martin & Chandroo...

  • kompella
    kompella Posts: 21 Green Ribbon
     Hi Dina,

    Thanks for the update.

    I did the following in the Transcation source set up in Projects  Module :-

    Enable the Check box  "Allow Adjustments" for the transaction source Inventory Misc

    Now I tried to transfer the amount from one task to another task

    The amount from the Old task got reduced (both quantity and Amount) through a negative line

    However, in the new task the line got added only with the quantity and not the amount.

    The amount field is blank.

    Kindly advise whether I have to run any concurrent program to get back the cost in the new task

    Thanks and regards,

    Martin & Chandroo...

    Hi Sarran,

    For cost and accounting to be populated you need to run the PRC; Distribute Usage and Miscellaneous costs program. Ensure you have the auto accounting setup for inventory transactions.

    Thanks,

    Venkata 

  • Hi Sarran,

    For cost and accounting to be populated you need to run the PRC; Distribute Usage and Miscellaneous costs program. Ensure you have the auto accounting setup for inventory transactions.

    Thanks,

    Venkata 

    Hi Venkata,

    I ran the report  PRC; Distribute Usage and Miscellaneous costs program.

    But the report shows the task has been rejected with the reason "Invalid Accounting flexfield.

    Regards,

    Martin.  

  • user8252332
    user8252332 Posts: 1 Newbie
    edited Aug 20, 2009 8:09AM
    Hi Venkata,

    I ran the report  PRC; Distribute Usage and Miscellaneous costs program.

    But the report shows the task has been rejected with the reason "Invalid Accounting flexfield.

    Regards,

    Martin.  

     Hi Martin,
    You are getting the exception as the auto accounting(AA) rules for "Usage and Miscellaneous costs" has not been defined. Please design and build the AA rules first and try to run the  PRC; Distribute Usage and Miscellaneous costs program.

    Regards,

    Ravi.
  •  Hi Martin,
    You are getting the exception as the auto accounting(AA) rules for "Usage and Miscellaneous costs" has not been defined. Please design and build the AA rules first and try to run the  PRC; Distribute Usage and Miscellaneous costs program.

    Regards,

    Ravi.
     Martin,      Since you are using Inventory Misc, I assume that you are not in PJM world.Such transactions, though come as GL accounted, when adjusted in PA, must be accounted for. When you reverse the original transaction, the new adjusted transaction on the source copies details from the original transaction and since that was costed and GL Accounted, hence you see all details.

    The new ones need to be accounted in Projects. In Projects, you have processes for Labor, Burden and Usage/Misc (for everything else including Inventory Misc). You will have to Cost the new transaction of the target project/Task.

    -Amar
  •  Martin,      Since you are using Inventory Misc, I assume that you are not in PJM world.Such transactions, though come as GL accounted, when adjusted in PA, must be accounted for. When you reverse the original transaction, the new adjusted transaction on the source copies details from the original transaction and since that was costed and GL Accounted, hence you see all details.

    The new ones need to be accounted in Projects. In Projects, you have processes for Labor, Burden and Usage/Misc (for everything else including Inventory Misc). You will have to Cost the new transaction of the target project/Task.

    -Amar
     

    Hi Amar,

    Thanks for the information.

    Yes you are right. we are using Inventory (Misc) for importing transactions from inventory.

    Firstly, I would like to inform you that we are not using Auto Accounting Rule in Projects.

    My issue is I am able to do the transfer from one task to another. The value gets reduced from the old task.

    But in the new task it is not getting updated in the Proj Functional Cost. However, I find the same value in Raw cost rate.

    How to cost the new task which has been transferred. Do I have to do any set ups for getting the cost in
    the new task.

    This issue comes not in inventory alone. I am also facing the same issue for the transactions from Payables
    source too.


    Thanks and regards,

    Martin.

  • Dina Rotem
    Dina Rotem Posts: 782 Gold Trophy
     

    Hi Amar,

    Thanks for the information.

    Yes you are right. we are using Inventory (Misc) for importing transactions from inventory.

    Firstly, I would like to inform you that we are not using Auto Accounting Rule in Projects.

    My issue is I am able to do the transfer from one task to another. The value gets reduced from the old task.

    But in the new task it is not getting updated in the Proj Functional Cost. However, I find the same value in Raw cost rate.

    How to cost the new task which has been transferred. Do I have to do any set ups for getting the cost in
    the new task.

    This issue comes not in inventory alone. I am also facing the same issue for the transactions from Payables
    source too.


    Thanks and regards,

    Martin.

    Hi

    You must have Auto Accounting rules setup for the type of transactions you are adjusting.

    Although the original transactions came in to Projects  as accounted, the new EI created after the transfer do not have any CDL, until the accounting CCID is sucessfully created.

    Therefore, if you have not done it yet, I suggest you setup AA rules for -

    -  Inventory Cost Debit and Credit 

    - Supplier Invoices Adjustments

    Dina

  • Hi

    You must have Auto Accounting rules setup for the type of transactions you are adjusting.

    Although the original transactions came in to Projects  as accounted, the new EI created after the transfer do not have any CDL, until the accounting CCID is sucessfully created.

    Therefore, if you have not done it yet, I suggest you setup AA rules for -

    -  Inventory Cost Debit and Credit 

    - Supplier Invoices Adjustments

    Dina

    I have a related question: When transferring costs from one project to the other, we had an anomaly where we ran PRC:Dist Usage & Misce Costs and created accounting in October for the positive amounts - the new project being charged. Then the next month we ran PRC: Distr Supplier Cost Adjustments and ran create accounting with an error for the negative side of the transfer saying that October was closed so we couldn't successfully create these accounting entries.

    Several questions:

    1. Is it a fact that for transfers of costs originating from Supplier invoices we need to run both PRC Distribution processes?

    2. How could we have closed October when only half (positive side) of transfer journas were ther without the negative side? - why didnt' we get prompted to sweep to November and get told we could not close October because of open transactions?

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center