Need a solution

[pvinod_kumar]

Am having 2 Gl codes for 2 Gl Codes

1. A100023456- Bank charges

2. A100078901-Bank Charges For POS Transaction

We had done normal gl determination , warehouse wise

As of now when we do any type of incoming payment,in payment means Bank charges is hitting and JE posting to (1.A100023456- Bank charge ) commealy.

When any incoming payment is made for any POS transction we had a UDF in incoming payment document to make it as Transction Based on POS

But at the same time Bank Charges for such marked transaction(POS) should be hit automatically to (2.A100078901-Bank Charges For POS Transaction)

How can make this possible

Is it possible via SPT, if so can any provide me the SPT in SQL

Regards

Vinod

[jitin_chawla]

You can check the option of having a Formatted Search on the Bank Charges field based on UDF field value (POS Payment) upon change the new G/L Account is updated.

regards,

Jitin

[pvinod_kumar]

Hi Jitin

Can u help me with the fms query

Am not expert in technical

Reg