Sitemap

Amicuk Programming Answers

COGS Posting at the time of Invoicing

-0001-11-30   Views:0

Advertisement

Hello Experts, We have a requirement wherein the COGS Posting should happen at the time of Invoicing. Our requirement is as below. At the time of Post Goods Issue Stock in Transit A/c Dr      Finished Goods A/c   Cr At the time of Invoicing we are ex

Hello Experts,
We have a requirement wherein the COGS Posting should happen at the time of Invoicing.
Our requirement is as below.
At the time of Post Goods Issue
Stock in Transit A/c Dr
     Finished Goods A/c   Cr
At the time of Invoicing we are expecting the below 2 entries
COGS A/c                   Dr
      Stock in Transit A/c     Cr
Customer A/c               Dr
          Revenues
We would like to know how to achieve the 2 the above mentioned 2 entries at the time of Invoicing.
Best Regards
Balaji Kancherla

The replay answer
Advertisement
Hi Balaji,
I can give you below direction...
1. Go to OBYC and enter GL Account Goods in Transit for key GBB VAX. So whenever you post PGI, system will post GL Account Goods in Transit.
2. You will have to add two condition typs into your pricing procedure..
ZGDS:Goods in transit (GL Account - Goods in transit)
COGS:Cost of Goods Sold. (GL Accounts COGS)
Importantly, you will have to attach Calculation Routine which will bring the amount posted to Goods in transit at the time of PGI.
Regards,
Chintan Joshi

Go to See the other 4 answers

COGS Posting at the time of Invoicing

Category:DefaultRelease time:-0001-11-30Views:130

Hello Experts, We have a requirement wherein the COGS Posting should happen at the time of Invoicing. Our requirement is as below. At the time of Post Goods Issue Stock in Transit A/c Dr      Finished Goods A/c   Cr At the time of Invoicing we are ex[More]

COGS in Accounting document of the Invoice

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, Our client requirement is that they want to capture the Cost from Material Master u2013 Standard cost (Condition Type in pricing procedure: VPRS) in the accounting document that is generated automatically when the Billing document is created.[More]

Delivery & Invoice: Material Document Posting

Category:DefaultRelease time:2015-10-11Views:130

Hi MM Gurus Our customer doesn't like Sales Order DO posting Cost of goods sold associated with Post goods issue material document. Reason , It could be couple of month before invoice is due & hence COGS entry will sit in P/L without accompaning entr[More]

Others expenses to COPA

Category:DefaultRelease time:-0001-11-30Views:130

I am little confused how to proceed for the following: Our client want to have profitablity report product wise/ region wise, etc.  I know that the revenue part and COGS will come from the SD invoice.  But I am confused about some other expenses whic[More]

Third party cycle

Category:DefaultRelease time:-0001-11-30Views:130

Dear All, As per my knowledge , third party cycle is defined as inspite of providing goods directly to customer , organization do it by introducing a third party called vendor who directly supplies to customer and produces invoice of same to organiza[More]

Query for details of  Sale order , Invoice and COGS

Category:DefaultRelease time:2015-10-11Views:130

I Need the report cointing following based on month & Business partner Sale order, Sale Amount, Due date, Invoice Amount, Last Invoice date, COGS amountHi Anantha, Please check below link and modify according to your requirement. Sales Order Query fo[More]

Recognition of COS/COGS Account if the process is A/P Reserve Invoice

Category:DefaultRelease time:2015-10-11Views:130

hi there, i am trying to post an A/R Reserve Invoice of non-inventoriable item because it's Advance payment to Supplier scenario. would you know on what transaction can i create to recognize the COS/COGS Account of it? i believe if my process is : 1.[More]

COGS BU not refresh base on BU in AR Invoice row

Category:DefaultRelease time:-0001-11-30Views:130

Hi!      When i choose one item and filled in BU in Ar invoice by row at the same time COGS BU also refresh and get value Of BU. After, i would like to change BU again but COGS BU not catch the value of BU like the first time. and then i create a que[More]

COGS for occasional Sales orders (Delivery / AR Invoice)

Category:DefaultRelease time:-0001-11-30Views:130

Currently the account determination for ALL items is set by Item group / Item.  There is a requirement for less than 1% of all item Sales Orders / AR Invoices to be processed with a different COGS account to the automatic determination. (this circums[More]

Third Party Order Delivery Costs(COGS in Purchasing)

Category:DefaultRelease time:2015-10-11Views:130

Hello MM/SD Gurus, We have a Scenario where in its a 3rd Party Order direct shipment Process where the Shipping is done by a Logistics Vendor! So->PR>PO>Inbound Del->GR->IR>Goods Issue-->Customer Invoice. Now the Issue we have is Deli[More]

Third party sale scenario: COGS not allowed as automatically posted.

Category:DefaultRelease time:2015-10-11Views:130

Dear Gurus, I have come across this error during execution of third party sale scenario. When the user enters a PO with reference to PR which is in reference to SO, one error pops up which says COGS cannot be automatically posted only. When I deselec[More]

Hot
I recently purchased an Epson Artisan 800 printer and I would like to be able to print from Aperture. Unfortunately, I have been unable to do so, in spite of multiple conversations with the Epson support group. I am able to print from other applicati [More]
No matter what document I open, print dialog never appear and I cannot print any document. I tried also to install older version of acroread but still no luck. I found also this settings tab quite strange like something is missing. Can anyone help me [More]
          Hello all,           I am looking for any option to update Receiving_routing_id in the table PO_LINE_LOCATIONS_ALL except the base table update( since it is not supported ).           So far I have explored following options.           1. U [More]
Hello I am trying to assign a standard_SAP_deep_structure to DATA SOURCE (dataSource) of Adobe Interactive Form UI Element of my_view. System is activating fine. But, when i open the Form and its assoiated interface in SFP transaction (or dbl clickin [More]
I'm starting on a client/server implementation. The client will be the entire GUI for the database. How would I communicate over sockets with this? Would string commands to stdIn do? What's the most flexible implementation?I think sockets is a very l [More]
I have downloaded itune 10.5.2 .11but could not complete installation on my window Vista PC, telling me that it can not be completed because a programme needed can not be run and to check for solution by contacting installation package vender. I then [More]
We have replaced the computer that was having this Error 1014:1014 with a new computer . Now with the new PC it has seen the same error with adobe reader . Its running windows 7 Pro 64-bit Fresh install of windows 7 pro . What is the cause of this is [More]
Hi,                   I've created 2 pages in my script.In the first page i've useed BOX command & also a Standard Text for the column headings in the Main window.When the first page is overflown,obviously it is displaying the remaining records in th [More]
Hi I was wondering if I can change my email for my BlackBerry I'd on my Q5? Its because my email was hacked so I have to close it. Anyways hoping I can change it. ThanxHello, To change your BBID, follow the steps in the KB article below: http://www.b [More]
Hello ! I have situation where depending on several conditions I construct a query step by step . This is the code :(Article has 2 relationship with F1 and F2) Dim list1 As IEnumerable(Of Article)         list1 = From t In context.Articles.Include("F [More]