Sales order link with Customer Advance received - F-29

[former_member214904]

Dear Expats

We have one requirement from client end that they are receiving advance from customer for Advance sales.

Advance sales - sales order info need to link with the advance received entry.

Here is no input field for giving this sales order info.

The field Order is specify for CO - Order not sales order.

Pls. give your urgent feedback.

Regards

Tarek H Chy

[former_member200703 · Accepted solution]

Dear Tarek

pleas check the field status variant in FS00 for this account related to Customer D-payment .. open tab Create /bank/interest and double click on Field status group and check on Additional account assignments if the sales order field set to be suppress or required or optional

you can change the status of this field

Spro-financial accounting New-financial accounting global setting-ledger-field-define field status variants and change the variant group appeared FS00 ..

also check the posting key field status variant in T-code OB41 whether suppress or required or optional and change it as same as field status group.

Regards

Mahmoud El nady

[former_member214904 · Accepted solution]

Dear Mahmoud EI nady

Thanks for your reply

We have make sales order optional for field status group G005 and G067

One assign for Bank and another assign for customer.

But still no field is available in the T Code F-29 for giving input of sales order.

Regards

Tarek H Chy

[former_member200703 · Accepted solution]

Hi

Dd you check OB41 under the posting Key 09 which is used for Customer D-payment.( test it on QAS first ). ?

please check and feed me back..

Regards

Mahmoud El Nady

[former_member214904 · Accepted solution]

Dear Mahmoud EI Nady

In field status group - sales order is optional.

After that when we are selecting the sales order for giving input below message is giving.

Regards

Tarek H Chy

[former_member214904 · Accepted solution]

Dear Mahmoud EI Nady

in advance entry is

Bank                Dr                                 (GL is Asset)

Customer/Advance from Customer   Cr.  (GL is Liability)

There is no issue with Cost Element.

Regards

Tarek H Chy

[former_member200703 · Accepted solution]

Dear Tarek

i could understand what you mean by " no issue with cost element "? do you mean that you maintained cost element for customer D-PMT as below screen

please feed back.

Regards

Mahmoud El Nady

[former_member214904 · Accepted solution]

Dear Mahmoud EI Nady

Thanks for your reply.

Bank                Dr                                 (GL is Asset)

Customer/Advance from Customer   Cr.  (GL is Liability)

There is no issue with Cost Element.

Means - GL is liability so that i can't create cost element for this liability GL account.

Yes i have got your screen shot. There is no GL account assign for my company.

Pls. give the feedback.

Regards

Tarek H Chy

[former_member200703 · Accepted solution]

Dear Tarek

your are correct the customer d-payment is an liability account but the system need and cost element " means that system need an revenue account that he can allow you to post the D-PMT

please see the below message

you may see the last two words he mentioned in the help that he needs this element just for "technical reasons"

so insert an revenue element account .

test this on QAS..

Regards

Mahmoud El Nady

[kamalkumar_biswas2]

Hi Tarek

     I am following this thread and really interesting..

     1. What you have done for populating SO field..it's all right and can input your SO

     2. If you enter a SO which is MTO scenario , will give the requirement error for default CE

        because SO is linked to CO area and system will not allow posting without CE

     3. But if your SO is not a MTO scenario it will allow to post

      This is the logic

[former_member183378]

Hello Tarek,

Check the field status settings of the relevant posting key - 19 once. Please keep the sales order field as either option/required as per your requirement but should not be in suppress status. In the above screenshot is related to posting key 09 and not for 19.

Please check this once and revert us for any issues.

Thanks & Regards,

Lakshmi S

[former_member214904]

Dear Lakshmi

Thanks for reply.

Posting key 19 also same. - Sales order optional active.

Regards

Tarek H Chy

[former_member198650]

Hi Tarek,

First check the field status group you have maintained for the customer advance and change the field status "Sale order" as optional which is in additional account assignments for the group in OB14.

Regards,

Mukthar

[former_member214904]

Dear Expats

At last we have solved this issue.

Now during T Code F-29 execution Sales order option is active.

Regards

Tarek H Chy

[kamalkumar_biswas2]

Hi Tarek

   R u also able to assign SO with MTO scenario without CE ? If so please share..

[former_member214904]

Dear Kamal

Thanks.

No i am unable to put Sales order number in the input field of Order. This order field only used for CO order.

Also default the cost element.

Only able to put sales order number in the Sales doc field.

Regards

Tarek H Chy