cancel
Showing results for 
Search instead for 
Did you mean: 

FSCM CM: How transaction date in SD objects

Adriano_Martins
Explorer
0 Kudos
123

Hi experts, 

I'd like to know how transaction date is calculated in SD objects. 

I thought it was the same of MM objetcts, I mean shipping/invoicing date + payment terms in days, however, I have some cases wher it was calculated  differently  date than expected.

Eg: 

correct one:

Shipping date (EDATU): 30.04.2024  - Pay.terms in days (ZTAG1):  45

Transaction date = 30.04.2024 + 45 = 14.06.2024

 

wrong one:

Shipping date (EDATU): 26.12.2024  - Pay.terms in days (ZTAG1):  45

Transaction date = 07.01.2025

Expected: 26.12.2024 + 45 = 09.02.2025

same order type, same payment terms different results.

 

Thanks in advance.

 

Att

RL 

 

Obs: in som

 

 

 

 

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Vibha_Tiwary
Product and Topic Expert
Product and Topic Expert
0 Kudos

In general, Sales order date (fqm_flow-transaction date) should be Billing date plus Payment term days. Here, the payment history for cash discount payments is also taken into account. See Note 24883 - CMF: Determination of value/planning date

Adriano_Martins
Explorer
0 Kudos
Dear Vibha, thanks for your explanations?
Adriano_Martins
Explorer
0 Kudos
Does this note also refer to the transaction date calculation for sales orders? I mean the history of payments could impact the calculation of transaction date for sales order too? Is there same customize to disregard payment history and always consider the shipping/billing date? As we can do to fill the planning date (fdtag) in finance documents?
Vibha_Tiwary
Product and Topic Expert
Product and Topic Expert
0 Kudos

Yes, this note refers to the transaction date (fqm_flow-transaction_date) calculation for sales orders. And yes, it considers the Payment history as well. Please see if you can use the BAdi BADI_FQM_FLOW_ADJUST_CORE to customize the date in table FQM_FLOW.