on 07-03-2014 8:32 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.