how to give whether that payment is related to supplier or payroll in DMEE Structre

[Former Member]

Hi Experts,

I have created DMEE structure for BACS file(export file to bank), my client want to using same DMEE to run the APP and Payroll. how to give the condition in DMEE strctre to extract the actual data whether the payment is related to supplier or payroll.

I think, client is using APP(F110) for supplier payment and run the payroll form HR side. Please advise on how to give teh condition to pick the correct vaule(Supplier or Payroll)

Regards,

Anji Reddy.

[Former Member · Accepted solution]

Hi Anji,

You could look at using the payment origin to differentiate between the payroll and supplier payments.

For example, add a condition to DMEE node/atom:

      - when payment origin = FI-AP (Account Payable) = give value XXX   

      - when payment origin = HR -PY (Payroll) = give value XXX

Hope this helps.

Jack

[Former Member · Accepted solution]

Hi Jack,

Thank very much for your helpful information.

I have given as below but I am unable to activate the belwo condition, I got the error like

Error in conditions for node : constant FI-AP has incorrect format

Agr1          Agr2             T   O    Agr2-1    Agr2-2   T   0

FPAYH     DORIGIN     2    =     FI-AP                   1

Could you please help me to configure this issues.

Regards,

Anji

[Former Member · Accepted solution]

Hi Anji,

Try the value with the apostrophes , like this: 'FI-AP'

Cheers,

Jack

[former_member194797 · Accepted solution]

Hi,

For a constant the type (after DORIGIN) should be 1 and not 2.

[Former Member · Accepted solution]

Hi Jack,

Thank you very  much for helping on this.

Now I have given the condition as you said, i did not get any get any error while activating the DMEE Engine.

I have done the testing from FI side, it is showing correct value, I did not check from HR side whether it is picking correct values or not.

Any way thank you again for helping on this.

Regards,

Anji

[former_member229024]

Hi Anji,

For vendor or payroll info, there must be some common DMEE nodes and some not. Identify the unique data ( in structures FPAYH, FPAYP, FPAYHX or tables REGUP,REGUH..) and use that value to make a condition, Use this condition to differentiate , payroll  or vendor data.

Alternatively ,you can copy the differing main nodes - customize and put condition on them.

Cheers,

[Former Member]

in addition to above message, if it is supplier payment, that filed should show 15 in the file

if it employee payment (payroll), that filed should show 20 in the file.

Regards,

Anji