Solved

Outstanding Sales

  • 29 August 2021
  • 7 replies
  • 244 views

Userlevel 5
Badge +8

Hi Folks,

 

I have a question that why following invoiced/closed customer orders are appearing in the Outstanding Sales window.

 

 

 

I have query into customer invoice, and it is on PaidPosted status as below.

 

 

Revenue related postings also there.

 

As per the page help it is not possible to show customer orders which has already revenue posted.

 

 

icon

Best answer by Rangi Wijewardana 30 August 2021, 12:31

View original

This topic has been closed for comments

7 replies

Userlevel 7
Badge +18

This window shows all sales, even the fully invoiced. The documentation says:

“These can be identified by querying for those customer order lines for which cost of sold goods have been posted but the sales postings from invoice still is pending.”

You need to query to see the ones not yet invoiced. For example: “Sales Posted Date” is empty.

Userlevel 5
Badge +7

Outstanding Sales window:

  • This window has no connection to the concept of ‘Sales Outstanding’ which is measure relating to collection of outstanding receivables. So payments for the invoices are of no concern here.
  • This window shows all the sales transactions relating to customer orders. Entry in this window is made when the customer order is delivered (valid delivery). That is when the cost of goods sold are accounted ( i.e. Dr. COGS -M24 and Cr. Inventory-M1)
  • The date when the delivery is made is set as the ‘COGS Posted Date’.  
  • The date when the invoice is created is set as the ‘Sales Posted Date’. (Note: No impact from the Voucher Date)
  • Here it could be that the invoice is already created (not printed) for customer orders or customer orders still without any invoices.
  • If you want to query the outstanding sales as at 2021 7 in Outstanding Sales window, then you should enter COGS Posted Date  less or equal to 31-07-2021 with Sales Posted Date NULL or higher than the 31-07-2021
  • For these sales entries for which there no invoices created or invoice is created after the COGS Posted Date period, you can create an interim voucher to post the sales as an interim entry (created with the last date of the selected period and reversed on the first day of the next period). This can be done for past periods and not for the current/ongoing period or the future periods.
  • If you are creating an interim sales voucher for the period 2021 7, system will pick all the sales transactions in above window with the ‘COGS Posted Date’ equal or earlier than the 31-07-2021 and ‘Sales Posted Date’ later than the 31-07-2021 or NULL (validity of the delivery is also checked).
Userlevel 5
Badge +8

Outstanding Sales window:

  • This window has no connection to the concept of ‘Sales Outstanding’ which is measure relating to collection of outstanding receivables. So payments for the invoices are of no concern here.
  • This window shows all the sales transactions relating to customer orders. Entry in this window is made when the customer order is delivered (valid delivery). That is when the cost of goods sold are accounted ( i.e. Dr. COGS -M24 and Cr. Inventory-M1)
  • The date when the delivery is made is set as the ‘COGS Posted Date’.  
  • The date when the invoice is created is set as the ‘Sales Posted Date’. (Note: No impact from the Voucher Date)
  • Here it could be that the invoice is already created (not printed) for customer orders or customer orders still without any invoices.
  • If you want to query the outstanding sales as at 2021 7 in Outstanding Sales window, then you should enter COGS Posted Date  less or equal to 31-07-2021 with Sales Posted Date NULL or higher than the 31-07-2021
  • For these sales entries for which there no invoices created or invoice is created after the COGS Posted Date period, you can create an interim voucher to post the sales as an interim entry (created with the last date of the selected period and reversed on the first day of the next period). This can be done for past periods and not for the current/ongoing period or the future periods.
  • If you are creating an interim sales voucher for the period 2021 7, system will pick all the sales transactions in above window with the ‘COGS Posted Date’ equal or earlier than the 31-07-2021 and ‘Sales Posted Date’ later than the 31-07-2021 or NULL (validity of the delivery is also checked).

Hi @Rangi Wijewardana,

 

Thank you so much for the detailed explanation. do you know of a way to add a posting entry to an account for orders that have been delivered but not invoiced ? (If you can show me the steps that would be much helpful)

 

Best Regards,

Thakshila

Userlevel 5
Badge +7

You can define postings M24 and M1 in Posting Controls window with the relevant code part, control type and account. When the delivery is made, system creates inventory transaction History record with relevant posting control, amount and account ( ex: OESHIP.) to record the cost of goods sold.

When you Print the invoice for relevant customer order delivery, system create customer invoice postings separately   with defined accounts (Posting  M28/M30, IP2, IP4)to record the sales revenue .

Userlevel 5
Badge +8

Hi @Rangi Wijewardana,

 

As you mentioned earlier Outstanding Sales window should  include invoice is already created (not printed) for customer orders or customer orders still without any invoices. But the above invoice is already paid posted  and  it’s COGS Posted date and Sales Posted Date is same. Why this sales order still appearing in this window?

 

How these transactions clear from this window?

 

Best Regards,

Thakshila

Userlevel 5
Badge +7

Hi Thakshila,

If you deliver and invoice the order on same date then COGS posted date and Sales Posted date would be same.

Sorry for the confusion. I wanted to express that you may use this window to analyse sales.

Until you invoice the delivery by printing invoice/sending invoice, sales Posted date is NULL, but Preliminary invoice is visible here although it is not yet printed.

Even the sales with printed invoices are shown on this overview window to support analysis and you cannot remove those.

  • If an order is delivered in July ,invoice is printed/customer is invoiced in August ,then COGS posted date is in July and sales posted date is in August .
  • If you want to analyse outstanding sales today for July ,
    • this is an outstanding sale as at 31-07-2021 although it was invoiced in August
  • If you want to analyse outstanding sales today for August
    • this is not an outstanding sale for August   since order has been invoiced 

 

 

Userlevel 5
Badge +8

Hi Thakshila,

If you deliver and invoice the order on same date then COGS posted date and Sales Posted date would be same.

Sorry for the confusion. I wanted to express that you may use this window to analyse sales.

Until you invoice the delivery by printing invoice/sending invoice, sales Posted date is NULL, but Preliminary invoice is visible here although it is not yet printed.

Even the sales with printed invoices are shown on this overview window to support analysis and you cannot remove those.

  • If an order is delivered in July ,invoice is printed/customer is invoiced in August ,then COGS posted date is in July and sales posted date is in August .
  • If you want to analyse outstanding sales today for July ,
    • this is an outstanding sale as at 31-07-2021 although it was invoiced in August
  • If you want to analyse outstanding sales today for August
    • this is not an outstanding sale for August   since order has been invoiced 

 

 

Thank you so much for the clarification.

 

Best Regards,

Thakshila