cancel
Showing results for 
Search instead for 
Did you mean: 

Issue In posting date and Due Date

Former Member
0 Kudos

Hello All,

my client is creating a GRPO and manually changing the Posting, And doc date. Then by using Copy to utility he is creating A/P Invoices

There system automatically shows the Posting date, Document Date as of current date(That is what system behavior is ). But now he wants that system should pick all his dates from Base doc i.e GRPO

So i want to know that is this possible through some query or FMS

if yes then please suggest me for the same

Regards,

Bhushan

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer this thread:

http://scn.sap.com/thread/3565995

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi Nagarajan

I had applied your solution but it is showing this error and u had mentioned there that we need to check Document Settings..what to check over there can u please explain me

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '$38.10.number'. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement '' (SWEI) (s) could not be prepared.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

I don't have $38.10.number in my query. Where did you get this field?

please follow below steps:

1. Run above query in generator. Sure it gives an error message and ignore this message.

2. save it under query manager

3. Assign this FMS at AP invoice posting date and set auto refresh when customer vendor refer is changed.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

HI,

Thank you nagarajan its working absolutely fine

Thank you so much for your help.

Regards,

Bhushan

Answers (0)